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 to ensure proper syncing.
Once connected, NetSuite will appear as "Active" on your Integrations page. You can also disconnect the integration directly from your Integrations page at any time.
Syncing 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 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.
You can do this in a few different places:
- 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.
- You sync incoming and outgoing transactions from your Accounting page.
- Once a transaction has been reviewed and the GL code selected, click the “Mark as ready” action icon.
- After marking any transactions that are ready, select “Sync to NetSuite” in the top right to sync the transactions to your NetSuite account.
- You can also update in bulk by utilizing the checkboxes on the left side of each transaction. Select the transaction(s) you want to action, then choose either “Mark as Ready” or “Edit GL Code” from the action bar that pops up at the bottom. For even quicker bulk actions, try holding the shift button and selecting a transaction to also select all the transactions above it.
See our guide on categorizing your transactions from the Accounting page for more information.
Accounting record details
The type of accounting record created, the timing of the sync, and the data included will vary with each transaction type.
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. If you’re still having issues after that, contact us at help@mercury.com for assistance.
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, IO payments and Treasury transactions.
Why can’t I categorize transfers, IO payments, and Treasury?
Transfers and IO payments are categorized automatically by our system and/or NetSuite. Treasury transactions are not yet available in the integration, but are coming soon.
Are Treasury transactions included in the bank feed sync?
No, most Treasury transactions are currently unable to be synced to your NetSuite bank feed, but a CSV download is available.
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.
Can I edit a GL code on the Transactions page?
Yes, you can edit a transaction’s GL code, notes, and attachments on the Transactions page.