How to map Abacus Categories to your General Ledger (GL) Codes for CSV export
*NetSuite and Intacct Integrations are available only for customers on the Professional Plan. Please get in touch with firstname.lastname@example.org to learn more.
If you use another Accounting platform, we suggest using our .csv data export to make the month-end reconciliation easy. We know that one of the hardest parts is making sure your expenses are first properly categorized before importing them into your accounting platform.
On Abacus, we give you a robust set of default expense Categories that you can fully customize to add new Categories and sub-Categories. First make sure that you've customized your set of Categories to reflect your company's needs and are simple and clear for your Employees. Learn how to do that here: Adding a custom category or subcategory
Once you do that, you're ready to sync your Abacus Expense Categories to your GL Codes. Here is how to do this one-time mapping:
Step 1: Enable manual mapping
Go to our Accounting Sync options in the Company Settings and enable the "Manually Map Categories" option:
Step 2: Map your category list to your accounts
Go to your Categories Settings to do the one-time mapping and enter in your GL Codes.
Hit Save, and you're done! Now when you export your .csv file, you will have a column for the Abacus category and the GL code.
Step 3: Map other custom fields (Class, Department, Location, etc.) to the corresponding accounting fields
In addition to mapping Categories to your Chart of Accounts, you can create custom Team and Expense fields and map these to an additional accounting field like Class, Department, Location, etc.
To associate information with an employee's profile, create a Team Field. Team fields are things like Office Location, Department, Group, and Employee ID.
To associate information with each expense, add an Expense Field. Examples include: Project, Event, and Client.
Learn more about how to map these fields to an accounting field here.