Our NetSuite integration allows you to sync transaction details and automatically create accounting records in NetSuite by assigning NetSuite GL (General Ledger) codes to transactions directly from your Mercury dashboard.
This integration only allows transaction information to be synced from Mercury to NetSuite. Any changes in NetSuite won’t sync back to Mercury.
Connecting to NetSuite
- Go to Settings > Integrations
- Locate the NetSuite integration. Click Connect
- Follow the prompts to connect Mercury to your NetSuite account and map your Mercury accounts to NetSuite general ledger accounts
- Once connected, NetSuite will show as Active on your Integrations page, where you can manage and check the status of the integration at any time
Syncing initial Mercury bank feed to NetSuite
Once the NetSuite connection is complete your Mercury bank data will import to NetSuite automatically based on the date range you selected. Transactions will be pushed from Mercury to NetSuite and synced to your Match Bank Data page within NetSuite once a day.
Assigning NetSuite GL codes to Mercury payments
Mercury Pro customers who use NetSuite can categorize their transactions and payments before they are reconciled in NetSuite. Once you connect to NetSuite, Mercury will automatically pull in your NetSuite GL codes so you can add them to transactions.
Whenever possible, Mercury will use AI and your categorization history to pre-fill GL codes for your transactions - these suggestions will be indicated with a sparkle icon. You can always override them by clicking on the dropdown and selecting a new input. The suggestions will improve over time, the more you interact with the feature.
You also manually apply GL codes to transactions in a few different places:
- On your Accounting page, select individual or multiple transactions and pick a GL code from the dropdown
- On your Transactions page, click open a Transaction to view the details and select from the GL code dropdown
- If you’re creating a new payment manually or by uploading an invoice, select from the GL code dropdown as you’re setting up the payment details
- If you want to add a category to an upcoming payment that was already scheduled, you can view the payment details on your Payments page and select from the GL code dropdown there
See our guide on categorizing your transactions from the Accounting page for more information.
Syncing transactions to NetSuite
- On the Accounting page, review your transactions and ensure all required fields (eg. GL code, counterparty, etc) are filled in
- Select individual or multiple transactions and click on the Mark as Ready action
-
You can then push any ready transactions to NetSuite by clicking the Sync button
- This action brings any additional transaction attributes (GL codes, classes, counterparty, attachments, and/or notes) you've added in Mercury to your accounting software, and matches them to the original transaction record there
Accounting record details
The type of accounting record created, the timing of the sync, and the data included will vary with each transaction type.
| Transaction type | NetSuite record | Sync | Data included |
| Scheduled bill | Bill |
Bill Pay page If you select a GL code, your scheduled bill will sync first upon scheduling, and again once it's paid |
|
| Other payment (non-bill) | Expense |
Payments page If GL code is select, your payment will sync upon sending. |
|
| Credit and debit card spend | Expense |
Accounting page Your expense will sync upon marking as ready and clicking "Sync" on the Accounting page. |
|
| Other incoming payment | Deposit |
Accounting page Your deposit will sync upon marking as ready and clicking "Sync" on the Accounting page. |
|
| Other outgoing payment | Expense |
Accounting page Your outgoing payment will sync upon marking as ready and clicking "Sync" on the Accounting page. |
|
| Internal transfer | Transfer |
Accounting page A bank transfer is automatically created in your accounting software |
|
Frequently asked questions
What does it cost to use Mercury’s NetSuite integration?
The ability to import bank feed connections is free. You can upgrade to a paid plan to use our enriched NetSuite accounting integration to categorize transactions and create accounting records in NetSuite directly from your Mercury dashboard.
Learn more about pricing here.
Will I have to go through all the setup steps again if the connection breaks?
No. Most of these steps are only required for the initial setup. If the connection breaks, you can try to reconnect from your Integrations settings, but make sure not to delete your connection.
Can I choose which Mercury accounts I want to sync with NetSuite bank feed?
No, currently all available Mercury accounts will sync.
What types of transactions can I assign GL codes to from my Transactions page?
You can add GL codes to incoming and outgoing wires, ACH transfers, checks, and card transactions. The only transaction types currently excluded are transfers and IO payments.
Why can’t I categorize transfers and IO payments?
Transfers and IO payments are categorized automatically by our system and/or NetSuite.
If I create a recurring payment, will the same GL code be assigned automatically to all future payments?
Yes, the GL code you assign to the first payment will be automatically assigned to all future payments in the series.
If I make changes in NetSuite to a transaction, will those be reflected in my Mercury account?
No, the connection is a one-way sync. Transaction information is passed from Mercury to NetSuite, and any changes in NetSuite won’t pass back to Mercury.