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 and click Connect to NetSuite.
- 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.
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 internal transfers and Treasury transactions.
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?
No. Once you assign a GL code from your Transactions page the GL code cannot be edited further in Mercury. Any changes must be made directly in NetSuite.
When do transactions sync to NetSuite, and what kind of an accounting record is created?
- Bill pay (only applicable if a GL code is selected when processing the bill)
- Syncs first upon scheduling, and again upon payment.
- When scheduled, an unpaid bill entity is created in NetSuite and categorized with the associated expense based on your selection.
- When the bill is paid the bill is automatically marked as paid in NetSuite.
- Send money (only applicable if a GL code is selected when processing the payment)
- Syncs first upon scheduling, and again upon payment.
- When scheduled, a journal entry is created in NetSuite and categorized with the associated expense based on your selection.
- When the money is sent a journal entry is created to record the payment.
- Credit and debit card
- Syncs from the Accounting page after being marked as ready and pressing “Sync to NetSuite”.
- Recorded as an expense in NetSuite.
- Other transactions on the transactions page
- These sync immediately upon selecting the GL code.
- Outgoing transactions are recorded as an expense in NetSuite, incoming transactions are recorded as a bank deposit.
What information is included in the sync when I categorize a Mercury transaction?
- For bills - GL code, due date, payment date, amount, note, memo
- For regular payments - GL code, attachment, payment date, amount, note, memo
- For credit or debit card transactions - GL code, attachment, amount, creation date, note, memo