Custom rules can be created for NetSuite, QuickBooks, and Xero, and will allow you to map transactions to a particular category based on different criteria. Options include the merchant, department, amount, date range, and more.
Account admins, card admins, and bookkeepers can create custom rules by following the steps below.
Step 1: Click Integrations on the left side of your Brex dashboard.
Step 2: Click Manage under your active integration.
Step 3: To the right of Custom Rules, click Add rule.
Step 4: A menu will pop up on the right side of the screen with the Edit Rule filter fields.
Here, you have the ability to set the parameters of your rule such as a transaction date range, specific categories/merchants, and dollar amount. Scroll down to set the mapping outputs for your given accounting or ERP software. Edit the rule parameters and mapping outputs to align with your desired outcome for your custom rule.
Note: As you change the filter fields, the transactions in the review section will update automatically.
Step 5: Once you have programmed your rule, click Save changes at the bottom.
You’ll be asked to nickname the rule in case you need to edit it in the future. Previously posted transactions that fall within the parameters of your new rule will be mapped accordingly (this may take a few minutes to update).
Custom rules can help you auto-code your transactions and decrease the amount of manual categorizations you have to make when closing the books. They’re similar to mappings, which are used to auto-code transactions that share one similar expense field. Custom rules can go beyond simple one-to-one mappings–they can auto-code transactions that share two or more similar expense fields.
Here’s an example of a custom rule that filters transactions with two expense fields in order to auto-code a GL account field:
Brex category: Advertising & marketing + Merchant: Meta > GL account: 6010 Advertising
Custom rules can be created by combining any expense field values, including these:
Merchant
Category
Department
Business entity
Employee
Budget
Date range
Expense amount
Memos (text match)
Custom fields
Create a custom rule
Account admins, card admins, and bookkeepers can create custom rules by following these steps:
Step 1: Go to Accounting > Manage custom rules and click New rule.
Step 2: Fill out the two sections of the custom rule detail pane.
For transactions that contain - Use these fields to filter the transactions you want to apply the rule to.
Categorize these fields - Set the accounting field value you want to auto-code.
Step 3: Click Create and apply rule.
Custom rules will apply to all transactions that have not yet been exported. In the event of a conflict between a custom rule and a mapping, custom rules will override mappings. In the event of a conflict between two custom rules, we’ll ask you to choose which rule to apply.
Custom rule suggestions
Based on our accounting data, we may suggest custom rules for you to consider creating. For example, if you frequently assign a certain GL account to transactions that share common expense fields, we may suggest that as a custom rule.
Suggestions can be found at Accounting > Transactions to prepare by clicking Suggestions.
In the details panel, you can review the custom rule and either accept or reject it. You can also revise the custom rule before accepting it.