Custom accounting
This article refers to a feature that might not be available in your current Brex plan. If you'd like to learn more about this feature and how to unlock additional capabilities in Brex's upgraded plans, please have your account or card admin reach out to Brex Support by clicking on Support in your dashboard.
Brex’s custom accounting feature lets you create fields and field values within Brex that can be leveraged for mapping purposes — including GL account, department, class, vendor, project, etc. You can then export transactions into a CSV file and import them into your accounting software.
Benefits
When a direct integration to your accounting software is not available, the custom accounting integration makes it easy for account and card admins to create custom fields and add values to those fields to mimic your chart of accounts. Custom fields can be leveraged in a series of mapping rules to auto-categorize all transactions in the Brex dashboard — saving hours of manual labor each month. These transactions can then be exported to a CSV file with each custom field as its own column that can then be imported to your accounting software.
Connecting your ERP
For Essentials Essentials
Step 1: Click Accounting > Get Started > Continue. Step 2: At the bottom, select I don’t use any of these > Start. Step 3: Upload your GL accounts by CSV, or enter GL accounts manually.
- If uploading by CSV, please ensure you download a CSV template, paste in your GL accounts, and upload the completed CSV.
- To enter manually, copy and paste, or type your GL accounts with new lines between them.
Step 4: After GL accounts are uploaded, click Continue, and confirm your GL accounts. You can add and make any edits to GL accounts from here. Select Create your GL accounts to continue. You can add or edit GL accounts at any time. Step 5: Click finish and you’ll be brought to the accounting tab.
For Premium and Enterprise Premium Enterprise
Step 1: Click Accounting > Get Started > Continue.
Step 2: At the bottom, select I don’t use any of these > Start.
Step 3: Upload your GL accounts by CSV, or enter GL accounts manually.
- If uploading by CSV, please ensure you download a CSV template, paste in your GL accounts, and upload the completed CSV.
- To enter manually, copy and paste, or type your GL accounts with new lines between them.
Step 4: After the GL accounts are uploaded, click Continue and confirm your GL accounts. You can add and edit GL accounts from here. Select Create your GL accounts to continue.
- You can add or edit GL accounts at any time.
Step 5: Click finish and you’ll be prompted to fill out general ledger details. Make selections for all required fields and click continue.
Step 6: Next, you will be prompted to create other accounting fields. You can either do this later or click continue to add more.
Step 7: Enter your preferred field name and select your field type:
- List allows you to enter a list of values that will appear in a dropdown.
- Checkbox will allow users to select Yes or No.
- Freeform allows users to type up to 1,000 characters in the field.
Step 8: If you selected List, enter the values that you want to appear in the dropdown for this field, each on its own line.
Step 9: Select whether you’d like to allow employees to see and edit this field on their expenses.
Step 10: Click Continue.
Step 11: Review the field and click Create Fields if finished. If you would like to add more fields, click Add field and repeat steps 7-10.
Those fields can now be leveraged when creating your series of mapping rules in the Mappings tab and when creating a Custom rule. You can also edit this field or add values to fields at any time by selecting the field in the Accounts fields tab.