Our QuickBooks Online integration allows you to sync transaction details and automatically create accounting records in QuickBooks by assigning GL (General Ledger) codes to transactions directly from your Mercury dashboard.
Connecting to QuickBooks
- Go to Settings > Integrations and click Connect to QuickBooks.
- In Step 1, select Connect and follow the QuickBooks guide for how to connect your Mercury account to QuickBooks to connect your bank feed transactions. If you’ve already done this, skip to Step 2.
- In Step 2, select Enable next to "Sync accounting details".
Once connected, QuickBooks will appear as "Active" on your Integrations page. You can also disconnect the integration directly from your Integrations page at any time.
If you’re connected to QuickBooks but don’t see the ability to add GL codes, go to your Integrations page and select Manage next to QuickBooks. Find Sync accounting details and make sure the feature is enabled.
Applying QuickBooks GL codes
Once you connect to QuickBooks, Mercury will automatically pull in your QuickBooks GL codes so you can add them to transactions and create and sync the associated accounting records to QuickBooks.
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.
- Sync any 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.
- Select Sync to QuickBooks in the top right to sync the ready transactions to your QuickBooks 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.
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
Is the integration with QuickBooks free to use?
Yes! Our QuickBooks integration is free to use. Learn more about pricing.
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 QuickBooks to a transaction, will those changes be reflected in my Mercury account?
No, the connection is a one-way sync. Transaction information is passed from Mercury to QuickBooks, and any changes in QuickBooks 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.
If I don’t want to categorize my payments in Mercury, can I turn off this feature?
Yes. If you don’t want to categorize transactions but you still want to automatically import transactions to QuickBooks via the bank feed, go to your Integrations settings and select Manage next to QuickBooks. Toggle Disconnect next to Sync accounting details to turn off the category sync while keeping the rest of the connection active.
What QuickBooks plans does this integration work with?
Categorizing and syncing payments is only available for the QuickBooks Online Essentials tier or higher. We also don’t currently support QuickBooks Desktop. Learn more about QuickBooks plan options
Our QuickBooks Online integration allows you to sync transaction details and automatically create accounting records in QuickBooks by assigning GL (General Ledger) codes to transactions directly from your Mercury dashboard.