Skip to main content

How do I integrate QuickBooks with Partner Center?

The QuickBooks integration in Partner Center syncs contacts and companies with the Partner Center CRM in both directions, and adds 3 automation triggers. To set it up, go to Administration → Integrations, click the QuickBooks card, and click Add Connection.

How do contacts and companies sync?​

QuickBooks does not store companies as separate records. Partner Center uses the Company name on each QuickBooks customer to create and update CRM companies.

  • If a QuickBooks customer has a company name, Partner Center creates or updates a CRM company with the name, phone number, and billing address from QuickBooks.
  • Contacts with the same company name share one CRM company, and each contact is linked to it.
  • If a company can't be synced, the contact still syncs without the company.
  • Invoices, payments, and sales receipts from QuickBooks come into the CRM as activities.

A contact links once a QuickBooks sync writes a QuickBooks Customer ID onto it. A company links once a sync writes a QuickBooks Company Name onto it. Contacts and companies you create in the CRM aren't created in QuickBooks. They link once a matching QuickBooks customer syncs.

What syncs back to QuickBooks​

Changes you make in the CRM to a linked contact or company sync back to QuickBooks:

  • Contacts: name, email, phone, mobile, and address.
  • Companies: name.

Sync back is on by default, controlled by the Sync back to QuickBooks Online setting in the connection settings. Turn it off to stop CRM edits from reaching QuickBooks.

The sync doesn't:

  • Create new customers in QuickBooks from the CRM.
  • Create or send invoices, estimates, or payments in QuickBooks.
  • Sync deletions in either direction.
note

If QuickBooks has a value for a field, it replaces the CRM value on every sync. If the QuickBooks field is blank, the CRM value is kept.

Contacts match to a QuickBooks customer by email, then phone, then QuickBooks Customer ID. Companies match only on the QuickBooks Company Name field. Renaming a linked company in the CRM renames every active QuickBooks customer that had the old name. Inactive QuickBooks customers are never updated from the CRM.

tip

Before a bulk cleanup of CRM data, turn off Sync back to QuickBooks Online, remove duplicate contacts, and never edit or clear the QuickBooks Customer ID field. Otherwise, CRM edits can overwrite the wrong QuickBooks customer.

How do I set up the QuickBooks integration?​

You can set up a connection with QuickBooks by navigating to the Integrations page of Partner Center.

  • Click Administration → Integrations to navigate to the Integrations page.
  • Find QuickBooks Online on the Integrations page (use the search box or the Accounting & Finance section) and select it.
Partner Center Integrations page with QuickBooks Online listed
  • You'll be taken to the QuickBooks marketing page, which provides information on what QuickBooks is and the possibilities an integration with QuickBooks provides. Click Add Connection.
QuickBooks Marketing Page
  • This provides you with a Pre-Connect Form popup where you can define the data you want to synchronize between QuickBooks and the Partner Center CRM. The syncing options available are:
    • Contact Data
    • Invoice Data
    • Sales Receipt Data
    • Payment Data

Click Continue after choosing the options that apply.

QuickBooks Pre-Connect Form
  • This leads to a single sign-on page where you can sign in to your QuickBooks account and provide permissions to establish the connection.
  • Upon successful connection, you'll be automatically redirected to the Integrations page, where QuickBooks shows as connected.
  • QuickBooks then shows a green check on the Integrations page, and the integration's own page shows the established connection, as shown below:
QuickBooks Online integration page showing a connected account
  • Selecting QuickBooks Online on the Integrations page brings you to the Connection Settings page where you may specify what data to sync or choose to disconnect the integration.
QuickBooks Connection Settings
info

After the initial connection with QuickBooks, all contacts in QuickBooks are synced with the Partner Center CRM. You can opt out of this by deselecting the Sync Customer Data option on the form during the initial connection.

How do I choose which data syncs?​

You can choose the data that you want to sync between QuickBooks and Partner Center CRM:

  1. Contact Data
  2. Invoice Data
  3. Sales Receipt Data
  4. Payment Data

Ensure that there is an active connection with QuickBooks: QuickBooks Online should show a green check on the Integrations page and should not be listed under Needs attention.

  • Selecting QuickBooks Online on the Integrations page takes you to the Connection Settings page. Here, you can specify what data is to be synced.
QuickBooks Connection Settings Page

What happens when I create an invoice in QuickBooks?​

Consider, for example, a contact in Partner Center named Amy. Amy's contact profile in Partner Center shows no recent activities recorded.

Contact Profile Before Integration

You create an invoice for Amy in QuickBooks.

QuickBooks Invoice

A note is created on Amy's contact profile in Partner Center with details from QuickBooks, including Invoice Number, Contact Name, and Invoice amount.

Contact Note

Frequently asked questions​

Is the QuickBooks integration a two-way sync?

Yes, for linked contacts and companies. QuickBooks data syncs to the Partner Center CRM, and edits you make to a linked contact or company in the CRM sync back to QuickBooks.

What happens if I change the same field in both QuickBooks and the CRM?

QuickBooks wins. When QuickBooks has a value for a field, it replaces the CRM value on every sync. If the QuickBooks field is blank, the CRM value is kept.

Will a contact I add in the CRM show up in QuickBooks?

No. Only a contact already linked to a QuickBooks customer syncs back. Contacts and companies you create in the CRM link only once a matching QuickBooks customer syncs.

What data can I sync from QuickBooks?

You can sync Contact Data, Invoice Data, Sales Receipt Data, and Payment Data. Choose the options on the Pre-Connect Form when you connect, and change them later on the Connection Settings page.

What happens in the CRM when I create an invoice in QuickBooks?

A note is created on the contact's profile in Partner Center with details from QuickBooks, including the invoice number, contact name, and invoice amount.

Can I stop all QuickBooks contacts from syncing when I first connect?

Yes. After the initial connection, all QuickBooks contacts sync to the Partner Center CRM unless you deselect the Sync Customer Data option on the form during the initial connection.

How do I disconnect QuickBooks?

Open the QuickBooks integration from the Integrations page to reach Connection Settings. From there, you can choose to disconnect the integration.