Before you start setting up your QuickBooks integration, read how the QuickBooks integration works with Scoro and what can be synced. Once you've covered these basics, follow the step-by-step guide below to set up your integration and learn how Scoro and QuickBooks work together once they're connected.
Note!
- The QuickBooks integration is available in Pro and Ultimate packages and works only with the QuickBooks online version.
- For historic data migration please contact our Support Team.
Connecting QuickBooks with Scoro
To connect your QuickBooks account with Scoro, go to Settings > Site settings > Integrations, switch on and click on QuickBooks.
Note! The connection between QuickBooks and Scoro accounts cannot be activated, if there are unmatched currencies between the systems.
Click on the button Connect to QuickBooks.
If you are already logged in to QuickBooks, select the organization and authorize the integration. If not, you will be prompted to log in to QuickBooks first. In your QuickBooks account, you will need to authorize Scoro in order to access information in QuickBooks. To do this, select the company you want to link and then click the blue Authorize button.
Note! Chart of accounts and tax rates are pulled automatically from QuickBooks when a connection is successfully established. It is not possible to modify taxes and finance accounts in Scoro if the QuickBooks integration is active. Documents that are created with old tax rates will not be synced before tax rates are updated.
Configuring the connection
After connecting Scoro and QuickBooks, you need to configure how the information is shared between the two systems. Use the Enable/Disable checkbox before each category to choose which data to include in the synchronization.
Products
- Products can be synchronized in both directions but only one way at a time.
- Products are always synchronized between two systems when they are attached to a synchronized bill or an invoice, even if the products category is not enabled.
Contacts
- Contacts can be synchronized in both directions but only one way at a time.
- When synchronization direction From Scoro is selected, all companies and persons that are on the suppliers or clients list in Scoro are imported to QuickBooks as customers or vendors. If a contact is listed as a client and a supplier, the (v) will be included in the vendor's name in QuickBooks.
- If a customer or a vendor is an individual in QuickBooks, it will be synchronized to Scoro as a person.
- When you sync a new contact from Scoro to QuickBooks, Scoro will send the contact over with the currency you've defined in the client profile. If you have not assigned any client profile to the contact, Scoro will use the site’s default currency when syncing the contact to QuickBooks. Once the currency has been set in QuickBooks, it can no longer be changed.
- Contacts are always synchronized between two systems when they are attached to an invoice or a bill. Even, if the Contacts category is disabled.
Projects
- Projects can be synchronized only from QuickBooks to Scoro.
- New QuickBooks projects can be matched with already existing projects in Scoro
- When matching QuickBooks projects with existing Scoro projects:
- Project names in both systems have to match
- Clients in both systems have to match (if the clients don’t match, a new contact is created to Scoro)
Invoices
- Invoices can be synchronized in both directions but only one way at a time.
- Credit notes created from sales invoices are part of the invoices synchronization.
- When syncing projects with invoices, don’t add multiple projects to one invoice, because QuickBooks doesn’t support adding multiple projects to one invoice. If multiple projects are added to an invoice in Scoro, the invoice won’t be connected to any of the projects in QuickBooks.
Receipts
- Payments can be synchronized in both directions but only one way at a time.
Bills
- Bills can be synchronized in both directions but only one way at a time.
- When syncing projects with bills, you can use projects on each line.
Classes
- QuickBooks Classes can be synchronized only from QuickBooks to Scoro.
- To sync classes with Scoro, class tracking has to be turned on in QuickBooks and they must be tracked per document line.
Type and date
The first row below categories sets the synchronization type:
- Automatic – data will be automatically synced with five-minute intervals.
- Manual – sync needs to be activated manually. There are two ways for manual sync.
- Sync all objects by clicking “Synchronize now” button from integration settings
- Sending a single object over manually
- It is also possible to move objects manually one by one using the QuickBooks actions button in Scoro that can be found for each document in the document view. This functionality is available for:
- Invoices – can be sent until the payment is attached
- Bills – can be sent until the payment is attached
- Contacts
- Receipts (can be pulled from invoice or bill) – can be pulled until the sales document is fully received
- It is also possible to move objects manually one by one using the QuickBooks actions button in Scoro that can be found for each document in the document view. This functionality is available for:
Next set a date for each active category. All objects created or modified after this date will be included in the sync. The start date cannot be earlier than the first time QuickBooks was connected to Scoro. If you need to sync older data, please contact our Support Team for historical data sync. The date will be disabled after the initial sync.
Advanced filtering
Instead of transferring all invoices, bills, and contacts between Scoro and QuickBooks, create bookmarks for specific items to be pushed from Scoro to the other system.
Note! There are two filters that are not suitable for bookmark-based syncing between Scoro and QuickBooks and will be overwritten when these filters are added:
-
Users - the filter selection will be ignored and ‘All users’ will be used
-
'Status' for invoices - will be ignored and 'All receipt statuses' will be used
If you use an automatic sync, then the integration will sync only the bookmarked documents to QuickBooks. And the rest of the documents, out of the bookmark, will not be synced.
If you use manual sync, then you must trigger the system to sync the bookmarked documents, either through the Synchronize now button from the settings panel:
Or from the document list view, by selecting all bookmarked documents and using the QuickBooks action button:
Default accounts
Default income account
Set default income account for new products synchronized from Scoro to QuickBooks. It is possible to overwrite the default value on a product card in Scoro and define the expense account, if required.
Default expense account
Default expense account is added to synchronized bill line if no product is added.
Click Save to complete the setup process.