How does the Abacus & NetSuite Integration work?
Abacus has a seamless integration with NetSuite for both reimbursable expenses and corporate card expenses. Once the integration is set up, it will eliminate time-consuming, manual data entry.
How does the sync work for reimbursable expenses (Cash Mode)?
- Abacus processes reimbursements via batched ACH transfers.
- When we kick off the ACH transfer, we push a Vendor Bill & Vendor Bill Payment into NetSuite of the same transfer amount for easy reconciliation
- We use a Bill and Bill Payment to make it efficient for you to reconcile to the periodic bank debits, while still giving you the full line item granularity for each expense that you need to properly roll up to the income statement, e.g. Account, Class, etc. A Bill can only have one Vendor, so Abacus is the Vendor because we're responsible for the reimbursements.
Here's what the Bills will look like in NetSuite:
When you click to view the Bill, it will include line-item level detail for each expense that's included in the bill. Most importantly, each expense will already be booked to the correct Expense Account. Not shown in this screenshot are values for Department, Class, Customer, and Location, but these are also fields that you can map from Abacus!
And here's the Bill Payment:
How does the sync work for reimbursable expenses (Accrual Mode)?
Coming soon! If you're interested in the NetSuite integration and operate on an accrual basis, we'd love to hear from you. Please get in touch with email@example.com.
How does the sync work for corporate card expenses?
You have the option to sync corporate card transactions as either 1) Journal Entries or 2) Credit Card Transactions. You can determine this in the Accounting Sync tab in your Settings.
Here's what a Journal Entry will look like:
And here's how you'd locate and view a Corporate Card Transaction in NetSuite. Navigate to your list of Corporate Card transactions:
View the transactions in a list:
The details of the Corporate Card transaction look like this:
Adding additional information to your NetSuite sync
In addition to Expense Account, you can also sync over information for Class, Location, and Department. Please refer to the related articles (below) on Team and Expense fields to learn more!