Get Started Get Started

Setup the QuickBooks Online Integration

Before you start - in order to use the full featureset of the QuickBooks integration, your Oncord plan must include the Commerce and Marketing features.

An easy way to determine whether you have this plan enabled is to look for the "Commerce" and "Marketing" links located in the sidebar of your Oncord Dashboard.

Upgrading your plan is a easy and normally instant, simply review our pricing page, and then contact us.

Logging in to your QuickBooks Online account before enabling the integration will also make the below steps easier.

If you don't already have a QuickBooks Online account, you can sign up for one on the Intuit website: https://quickbooks.intuit.com/

What Data is Synchronised?

The QuickBooks integration works by synchronising the following data:

From Oncord From QuickBooks Online
Contacts
  • Only contacts with sales are pushed into QuickBooks.
  • Changing a contact's details within any part of Oncord will also update them in QuickBooks.
  • Deleting a contact will not remove them from QuickBooks.
Contacts
  • Only QuickBooks customers pulled into Oncord.
  • Any change to the contact details of customers will be reflected in Oncord.
  • Deleting a contact will not remove them from Oncord.
Sales
  • All sales created within Oncord are pushed to QuickBooks.
  • Changing the particulars of a sale will update the sale within QuickBooks.
  • Deleting a sale will only delete the invoice in QuickBooks if sale was originally created from Oncord.
Invoices
  • All invoices are pulled into Oncord.
  • This allows you to target and trigger marketing campaigns based on QuickBooks sales data.
  • Changes to invoices in QuickBooks will be reflected in Oncord
  • Deleting an invoice in QuickBooks will not remove the invoice from Oncord.
Receipts
  • Depending on the Payment Method Configuration, receipts will create payments in Oncord.
  • Deleting a receipt will only delete the payment in QuickBooks if receipt was originally created from Oncord.
Payments
  • Depending on the Payment Method Configuration, receipts will create payments in Oncord.
  • This allows for direct deposit payments to be easily reconciled from the bank feed.
  • Deletion of payments will not delete in Oncord.

When Does it Sync?

You can choose to enable or disable automatic synchronisation within the QuickBooks App integration page (Go to Settings > Apps > "Configuration" link under the QuickBooks App).

Oncord will batch-sync with QuickBooks two minutes after an update takes place within Oncord.

For instance, if you updated a contact's e-mail address at 2:00pm, and then an invoice is created at 2:03pm. Both changes would be reflected at 2:04pm within QuickBooks.

If no updates take place within Oncord, a scheduled sync will take place after 12 hours to download data from QuickBooks.

Enable the QuickBooks Online Integration

Login to your dashboard and select the "Settings" icon located at the bottom of the left-hand menu, and then select the "Apps" page.

Click the "Enable" button in the QuickBooks Online integration box. A pop-up dialog will redirect you to allow Oncord to access QuickBooks.

After clicking the "Connect to QuickBooks" button, you will be redirected to QuickBooks and presented with the below page which will allow you to give Oncord API access to QuickBooks. Select the company you would like to synchronise with and click the "Next" button. You will be redirected back to Oncord QuickBooks integration configuration page.


Configuration

You will be presented with configuration options the first time you manually synchronise QuickBooks and Oncord. Check the options carefully and configure the integration appropriately.

Important: Map Deposit Accounts for Payment Methods:
Synchronisation also occurs between "Payments" in QuickBooks, to "Receipts" in Oncord. This area defines the mapping between the two systems.

  • For direct deposit accounts, you should select the bank account that customers pay into.

Synchronise

To perform the first manual synchronisation, click the "Synchronise" button in the QuickBooks Online box displayed on the Integrations page.

If you'd like to configure the integration again, click the "Configuration" link for QuickBooks on the Integrations.

Reconnecting QuickBooks

If you’d like to re-connect Oncord and your QuickBooks account, you can reconnect by going to Oncord apps page and click the "Configuration" button in the QuickBooks Online box. You will be presented with the below screen.



You will usually reconnect to QuickBooks if the connected account has been deauthorized to access your QuickBooks Online company and you need to authenticate a new account to maintain the connection between Oncord and QuickBooks.