QuickBooks Desktop sync setup guide
This guide will walk you through setting up the sync with QuickBooks Desktop.
Tip: Back up your QuickBooks company file before proceeding.
Table of Contents
- Pre setup requirements
- Install sync dashboard
- Connect the sync
- Sync preferences
- Enable 2-way bill sync
- Accounting preferences
Pre setup requirements
- Make sure anyone with shared access to the QuickBooks file to be synced is logged out
- QuickBooks needs to be in single-user mode
- Select File, if Switch to Multi-user Mode is available, the file is already in single-user mode.
- Exit QuickBooks
- QuickBooks Admin login credentials - this is required to connect the sync
- Cashflow360℠ user in Administrator, Accountant or custom role with Sync permission
- Administrator rights to install programs to computer or server
Install sync dashboard
The sync dashboard needs to be downloaded and installed in the same location/drive as the QuickBooks program to sync between Cashflow360 and QuickBooks Desktop.
The QuickBooks company file doesn't need to be located in the same location to sync.
Notes:
- The sync dashboard requires Microsoft .NET framework 4.6 to be enabled to run properly. If on .NET framework 4.7 or later, 4.6 may still need to be manually enabled.
- The sync dashboard has been verified to be compatible with QuickBooks Desktop 2014 and later, but may still work with older versions.
QuickBooks program installed on local computer
- Download the Quickbooks Desktop sync dashboard (~1.2 MB)
- Open the .exe file
- Select Next
- Select the drive that the QuickBooks program is installed on
- Select Install
- Select Next to confirm installation completion
- A shortcut will be created on your desktop
- A shortcut will be created on your desktop
QuickBooks program installed on Server or Hosted Server
Instructions on the installation of the sync dashboard will need to be provided to your I.T. administrator or hosting provider administrator so that the sync dashboard can be installed on your behalf.
Connect the Sync
Open the Bill.com sync dashboard from the shortcut added to the desktop
Open QuickBooks and log in to the company file as Admin and in single user mode
In the profile editor box, select Next
Sync dashboard will auto detect the file path of the QuickBooks company file that is open, select Next
-
In QuickBooks, on the Application Certificate, select Yes, always; allow access even if QuickBooks isn't running
- If there are multiple users on the company file, next to Login as: select Admin
- If there are multiple users on the company file, next to Login as: select Admin
Select Continue
Select Done to confirm access
-
Enter Bill.com login credentials or sync token
- If using a Bill.com powered solution through a bank/financial institution, the sync token will be required to connect the sync
- In Cashflow360, select settings
- Select Tokens under Sync
- Select New
- Name will auto-populate (this is a one-time use object)
- Name will auto-populate (this is a one-time use object)
- Select Save
- The token will be generated (also a one time use object)
- The token will be generated (also a one time use object)
- Write down or copy & paste the username and token, before navigating away from this page, as it is only shared one time
- On the Sync Dashboard:
- Email = Token Name
- Password = Token
- If using a Bill.com powered solution through a bank/financial institution, the sync token will be required to connect the sync
Select the Cashflow360 Organization name to sync to
In the sync profiles box, select the profile to sync
Select Sync
The sync is now connected.
The sync brings everything needed for payables and/or receivables from QuickBooks into Cashflow360: accounts, vendors, customers, items, departments (classes), jobs (customer: jobs), and your book balance.
The first sync might take a while, depending on the size of the QuickBooks company file. Future syncs will be much faster, and the QuickBooks company file won't need to be open.
Sync preferences
After the first sync completes, fill out sync preferences. Some fields will be pre-filled, review to make sure the correct accounts have been selected.
- In the One last thing box, select Ok or the X to close the box.
- Close the browser window that opens automatically.
- Select Settings
- Select Preferences under Sync
- On the Sync preferences page, select the checkbox to move transactions to QuickBooks Pro/Premier.
- Select the QuickBooks accounts to use (we filled the list with your QuickBooks Chart of Accounts during the first sync) for the following settings: *Accounts Payable *Unallocated Expenses *Default bank account in accounting system *GL accounts for any bank accounts already added to Cashflow360
- Select Save
The sync setup is now complete.
Enable 2-way bill sync
By default, our integration with QuickBooks Desktop only supports bill creation and edits in Cashflow360, which then syncs over to QuickBooks Desktop. If you would like bill creation and edits in QuickBooks Desktop to also sync to Cashflow360, you'll need to enable 2-way bill sync.
Note: This setting can't be disabled once enabled
To enable, users with the Sync with Accounting System permission will:
- Select Settings
- Select Preferences under Sync
- Select Edit
- Select the box next to Sync bills from QuickBooks desktop to BDC
- Select Yes to confirm
- Select Save
Accounting preferences
To set additional preferences for reporting and tracking:
- Select Settings
- Under Accounting, select Preferences
- Select Edit
- Set preferences
- Classes in QuickBooks are called Departments in Cashflow360
- Locations don't sync with QuickBooks Desktop
- Select Save
ACCOUNT SETUP View all