Begin Setup
To begin setting up your QuickBooks integration, go to Reconciliation in the left hand navigation bar. Click "Accounting" and then select "Setup Quickbooks."
You will be redirected to QuickBooks, where you grant access to Modern Treasury. If you are not an admin for your QuickBooks account, you may not be able to give access. In that case, ask one of your colleagues to do this step.
Once you have granted access, you will be redirected back to Modern Treasury. We have two setup steps for you to do, although if you are busy, you can complete them later.
Step 1: Mapping Bank Accounts
On this page, you will see a list of the bank accounts you have connected to Modern Treasury through your bank. Next to each account is a dropdown with a list of all the bank accounts in QuickBooks.
To match the Modern Treasury account, simply select the corresponding QuickBooks account in the dropdown. This is required in order to sync payments that originate from your bank account. Additionally, if you are doing internal transfers between your bank accounts, you need to match both the sending and receiving bank accounts.
Step 2: Mapping Counterparties
This page lets you map your Modern Treasury counterparties to your vendors and customers in QuickBooks. You'll notice that we give two ways for you to do this:
Automatic Matching
Every customer, vendor, and employee in QuickBooks has a unique name. This means that when we see a customer with a name like "John Smith", we can say with certainty that there is no other "John Smith" customer, vendor, or employee.
Since many of your Modern Treasury counterparties likely have the same name as how you entered them in QuickBooks, you can use the Automatically Match button on this page to link them together. It will only tie them together when their names match exactly. In cases where they don't match automatically, you will sync them individually.
Sync Individually
All of your unsynced counterparties are displayed in this section. Only 25 are shown at a time, but you can navigate between pages on the bottom right.
For every unsynced counterparty, you have three options available to you:
1. Create a new record in QuickBooks for them. You can create them as either a vendor or a customer. This is recommended when you have a new counterparty that is not in QuickBooks yet.
2. Match to an existing record in QuickBooks. You can search the dropdown, which contains all of your customers and vendors from QuickBooks. This is helpful when you have a different name for your counterparty in QuickBooks.
3. You can skip any counterparty that you don't want to sync.
Viewing Synced Counterparties
If you want to view which counterparties have been synced to QuickBooks, you can
click over to the Synced Counterparties view.
From here, you can click a link to view the synced record in QuickBooks. Sometimes there is intermittent behavior where the link doesn't work the first time. If that occurs, try clicking it again.
You can also delete the sync. Note that this doesn't delete the customer or vendor in QuickBooks. Instead, it just removes the association between the counterparty and the record in QuickBooks.
Managing QuickBooks on an ongoing basis
Once your account is connected to QuickBooks, you will have a dashboard accessible on your Accounting Settings page. From here, you can update any bank account or counterparty mappings at a later point. Additionally, you will visit your accounting dashboard to begin syncing your payment orders to QuickBooks.