QuickBooks Online accounting
Connect a QuickBooks Online company to an Operating company, so your invoices and credit notes go to QuickBooks and their status and payments come back.
Written By Mikko Karjalainen
Last updated 4 days ago
What the QuickBooks Online integration does
The QuickBooks Online integration connects one Operating company to one QuickBooks Online company. Operating sends your invoices and credit notes to QuickBooks, and QuickBooks sends back their status and the payments recorded against them.
Invoices in QuickBooks refer to QuickBooks' own tax codes, products and services, and customers. So the integration also brings those records into Operating and links each one to its counterpart in Operating.
The integration has three features. Each feature has its own page on the connection, where you turn it on and change its settings:
Tax rates and items: imports the company's tax codes as tax rates, and its products and services as items, which invoices pushed to QuickBooks refer to.
Clients: imports the company's customers as clients, and creates in QuickBooks the clients an invoice pushed to it needs.
Invoices and payments: creates Operating's invoices and credit notes in QuickBooks, and brings back their status and their payments. It needs the other two features to be on.
What syncs, and in which direction
Each feature's Data flow sets who writes each field of the records it syncs, as Who writes each field below explains. With the systems' defaults:
Tax rates and items: a record follows the system where it was created. A tax rate or item that Operating created from a QuickBooks record is QuickBooks' to change, so edit its details in QuickBooks.
Clients: Operating and QuickBooks both change a client's details, and the latest change wins.
Invoices: Operating writes the invoice, and QuickBooks writes its status.
A field that only QuickBooks writes is disabled in Operating. Hover over the field to see who writes it, for example "Name is written by QuickBooks · Acme Ltd. Change it there."
When QuickBooks keeps a company's list of tax rates or billable items, add new ones in QuickBooks. They arrive in Operating with the next import. In Operating, adding one for that company is disabled, with a message such as "QuickBooks · Acme Ltd keeps this company's tax rates. Add them there."
Operating imports tax codes, items and customers when you turn a feature on, and then every day. It reads the status and payments of each invoice that is not settled yet as soon as QuickBooks reports a change, and every 6 hours.
A company in the US imports no tax rates, because QuickBooks works out US sales tax itself. Its invoices go to QuickBooks without tax rates, and QuickBooks adds the tax.
Before you start
In Operating, you need:
The Manage integrations permission to connect QuickBooks, change its settings and map records. See Permission sets in Operating.
The right to edit the invoice (the Manage invoices permission) to save an invoice to QuickBooks.
An invoicing currency on the company you connect. Without it, the Invoices and payments feature shows "Set the company's invoicing currency in Operating."
In QuickBooks Online, you need:
An admin of the QuickBooks company. Only an admin can connect an app. If that person later loses the admin role, the connection stops until an admin reconnects it.
Multicurrency turned on if you invoice in a currency other than the company's home currency.
Custom transaction numbers turned off if QuickBooks is to number your invoices.
How to connect QuickBooks Online
Go to Settings > Integrations and open QuickBooks. The page lists each of your Operating companies.
Next to the company, click Connect to QuickBooks.
Sign in to QuickBooks, choose the QuickBooks company, and allow Operating's access.
Operating opens the connection's Overview tab. Nothing is imported until you turn on a feature.

You can connect each QuickBooks company to one Operating company. To invoice from several companies, connect a separate QuickBooks company for each.
What the connection's page shows
Under the connection's name, a line shows its status, such as Connected, followed by the Operating company and details of the QuickBooks company, such as its base currency and country. Click Account details to see more, such as how Operating signs in to QuickBooks.
When the status is Needs reconnecting, a notice above the tabs has a link to reconnect QuickBooks. When it is Suspended, Operating has stopped the connection and nothing is exchanged. Contact support to resume it.
The page has three tabs: Overview, Mapping and Issues. The Overview tab shows what needs you first, then the Features list. Each feature in the list shows the direction it moves data (Into Operating, Out of Operating or Both ways) and when it last synced. Click a feature to open its page.
When something needs fixing, Needs you lists it with a badge and the button that fixes it:
Stopped: a feature that is on cannot run until you fix what blocks it. The button opens the fix, such as Map records, Open settings or Reconnect.
Warning: the feature runs, but one of its checks needs a look.
Failed: the last import or push of a feature failed. Click Run now to run it again, or Open feature.
1 issue, 2 issues and so on: records that did not get through. Click Open issues to see them on the Issues tab.
When nothing needs you, the tab shows Everything's running and when the connection last synced. Before any feature is on, it shows Nothing is turned on yet.

How to set up the features
Turn the features on in two rounds, because Invoices and payments can be turned on only after its tax rates and items are mapped.
On the Overview tab, open Tax rates and items.
Turn on the feature's switch. It reads On after save until you save.
Check the feature's settings. The settings are listed below.
Click Save changes. Operating imports the tax codes and items.
Click Overview to go back, and do the same for Clients. Operating imports the customers.
Map the imported records on the Mapping tab, as the next section says.
Open Invoices and payments, turn it on, check its settings, and click Save changes.
A feature that cannot be turned on yet says why, and its readiness checks list what blocks it. For example: "3 billable items still need to be mapped."
The feature's page says why its switch cannot change now:
"Turn on Tax rates and items and Clients first; this feature uses what it imports." Invoices and payments needs the records the other two features import. Turn them on and save first. The message names only the features that are still off.
"Fix what blocks it before turning it on." A readiness check has not passed. Fix what the readiness checks list.
"Invoices and payments uses what this feature imports, so it stays on until Invoices and payments is turned off." Turn off Invoices and payments first.
"Operating has suspended this connection, so features can only be turned off." Contact support to resume the connection. Until then, you can turn a feature off but cannot change its settings.
A person without the Manage integrations permission sees You can view these settings. on a feature's page. That person can read the settings but cannot change them or turn the feature on or off.

How to map tax rates, items and clients
The Mapping tab links each record imported from QuickBooks to a record in Operating. It has a tab for each record type, such as Tax rates, Billable items and Clients, with the number of records still unmapped.
On the Mapping tab, open Tax rates.
For each record under To do, do one of these:
Click Accept to link it to the record Operating proposes.
Click Link to existing and choose the Operating record.
Click More and choose Create a new tax rate, or Ignore.
Click Commit decided tax rate mappings. Nothing changes in Operating until you commit.
Do the same on Billable items and Clients.
To decide on many records at once, select them and click Create new, Accept proposals or Ignore.
Operating proposes links where it finds a match, such as a client with the same VAT ID, invoicing email or name. Once no client is left unmapped, Operating creates a client for each new QuickBooks customer, unless it matches a client Operating already has.
Map your existing clients before you send the first invoice. Operating does not look for an existing customer when it saves a client to QuickBooks. QuickBooks refuses the new customer when another one has the same name.
Settings
Each feature's settings are on the feature's page. They show while the feature is on, and while it can be turned on. Click Save changes to save them.
What is imported:
Items to import: Items QuickBooks sells, the default, or Every item, which adds the products and services you only purchase.
Customers to import: Top-level customers, the default, or Customers, sub-customers and jobs, each as a client of its own. QuickBooks projects are never imported as clients.
A customer with an address Operating cannot store: an address in Operating needs a street line, a postal code, a city and a country. Choose Import the client without that address, the default, or Leave the client out until the address is fixed in QuickBooks.
Records made inactive or archived:
A tax code made inactive in QuickBooks: Archive it, the default, or Keep it active.
An item made inactive in QuickBooks: Archive it, the default, or Keep it active.
A customer made inactive in QuickBooks: Archive it, the default, or Keep it active.
A client archived in Operating: Make the customer inactive, the default, or Keep the customer active. With Keep the customer active, nothing is sent for an archived client.
Customers Operating creates:
Currency of a customer Operating creates: applies only while multicurrency is on in QuickBooks. A QuickBooks customer's currency never changes. Choose The currency it is invoiced in, the default, or The company's home currency.
Numbers and tax:
Tax decided by and Item for lines without one: these show their values and cannot be changed. Each line carries the tax rate mapped in Operating, except in a US company, and each line needs a billable item.
Invoice numbers come from: Operating, the default, or QuickBooks. You can change it only until the first invoice is saved to QuickBooks.
Status from QuickBooks:
An invoice posted in QuickBooks: QuickBooks posts an invoice the moment it is created. Mark it sent in Operating, the default, so its payments follow. Or Leave it for Operating to mark sent.
A document deleted in QuickBooks: Void it, the default, or Keep it. Either way, the document is not saved to QuickBooks again.
Who writes each field
Once a feature is on, its page has a Data flow section. It shows when each kind of record syncs, and who writes each field. Each field has a row with three columns:
Field: the field, such as a client's name.
Who writes it: the system or systems that set the field's value.
What happens: what this means for a record created in Operating and for one created in QuickBooks.
A field that QuickBooks does not carry shows "Not synced. QuickBooks does not carry this field."
To change who writes a field:
On the Overview tab, open the feature.
In Data flow, find the field's row.
Choose an option in Who writes it. Read What happens to check the result.
Click Save changes.
Changing the data flow needs the Manage integrations permission.
Who writes it offers these options:
Operating only: set and edited in Operating. Not read from QuickBooks or sent to it.
Operating, sent to QuickBooks: set and edited in Operating, and sent to QuickBooks.
Operating, then QuickBooks: set in Operating when created. After that, only QuickBooks' changes update it.
QuickBooks: read from QuickBooks, new and changed. Operating doesn't set it.
Where it was created: a record created in Operating is Operating's to change. A record created in QuickBooks follows QuickBooks.
Latest change wins: both change it, and each change is copied to the other. Operating asks you to confirm, because the systems overwrite each other's changes.
Custom: choose separately what Operating reads from QuickBooks, what it sends to QuickBooks and what Operating can do with the field.
An option that a field cannot take is greyed out, and the reason replaces its description:
"Not possible: QuickBooks doesn't share this field." Operating cannot read the field from QuickBooks.
"Not possible: QuickBooks doesn't take this field from another system." Operating cannot send the field to QuickBooks.
"Not possible: it can't change once created." The field is set only when the record is created.
Some fields are fixed once QuickBooks has received the first record, such as the invoice number. Their row shows a lock and a note, such as "Fixed: QuickBooks has received invoices already."
When your change gives a field a new writer and some records hold a different value, Operating shows Review how current values change with the number of records that differ. Choose one, then click Save data flow changes:
Apply now: Operating takes the new source's values on its next read, so the records match it.
Follow from now on: Operating keeps the values it has and takes only what the new source changes next.
To go back to the defaults for a kind of record, click its reset button, such as Reset clients to defaults. A kind of record that uses the defaults shows Systems' defaults.
When records sync
For each kind of record, the Data flow section has a From QuickBooks line and a To QuickBooks line. A line can hold these options:
On request: always available. Read one record with Refresh from QuickBooks on its page in Operating, or save it to QuickBooks from that page.
When QuickBooks reports a change: Operating reads a record as soon as QuickBooks reports a change.
An interval, such as Every 6 hours: Operating reads or sends the records on this schedule.
Create new clients: Operating's scheduled sending also creates the clients added in Operating. Only one connection can do this.
Tick or clear the options that have a box, then click Save changes. How often each sync runs is set by Operating. Contact support to change it.
How to send an invoice to QuickBooks
Create the invoice in Operating as usual. See How to create and send an invoice. Give every line a billable item that is mapped to a QuickBooks product or service.
Open the invoice.
Click Save to QuickBooks. It is the invoice's main action until the invoice is in QuickBooks.
When the save succeeds, Operating shows "Saved to QuickBooks." The Accounting row of the invoice then shows QuickBooks · Synced with the invoice's number in QuickBooks. Click it to open the invoice in QuickBooks.

When Operating saves an invoice:
Client: if the client is not in QuickBooks yet, Operating creates its customer first.
Posting: QuickBooks posts the invoice at once, so it is on the company's books as soon as you save it. With the default setting, Operating marks it sent.
Lines: each line goes with its product or service and its mapped tax code.
Number: the invoice keeps Operating's number, unless your settings let QuickBooks number it.
Currency: while multicurrency is on, the invoice goes to the client's customer in the invoice's currency. When the client has no customer in that currency, Operating creates one named after the first, such as "Acme GmbH (EUR)".
If you edit the invoice after you save it, the page shows "Changes not in QuickBooks yet." Click Update in QuickBooks to send the change. QuickBooks does not change a paid, voided or deposited invoice, or one in a closed period. Then Operating keeps the invoice as QuickBooks booked it and shows "QuickBooks kept it as booked, as it no longer lets it change."
To send a credit note, issue it in Operating, open it, and click Save to QuickBooks. Operating saves the invoice it credits first, if that invoice is not in QuickBooks yet. QuickBooks receives a credit memo, and Operating applies it to the invoice for as much as the invoice still owes.
How status and payments come back
QuickBooks is where the invoice is paid, and Operating follows:
Paid in QuickBooks: Operating adds each payment to the invoice, and marks the invoice paid once QuickBooks reads it paid. The invoice's Activity shows Payment received with the amount.
Payment voided or deleted in QuickBooks: Operating voids the payment on the invoice.
Voided in QuickBooks: Operating marks the invoice voided.
Deleted in QuickBooks: Operating voids the invoice, with the default setting.
Money a payment leaves unapplied, and refunds of a credit memo, are not imported.
To read an invoice's status and payments right away, open the Accounting row's menu and click Refresh from QuickBooks.
How to disconnect QuickBooks Online
Go to Settings > Integrations and open QuickBooks.
Next to the QuickBooks company, click its status, Connected, and choose Disconnect….
Click Disconnect QuickBooks to confirm.
You can also disconnect from the connection's Overview tab, under Danger zone.
Disconnecting stops every import, push and scheduled run, and Operating gives up its access to the company. Mappings and settings are kept, so connecting the same company again continues where it stopped.
If someone disconnects Operating from inside QuickBooks, the connection shows Needs reconnecting the next time it syncs. Click Reconnect to connect it again.
Common errors and how to fix them
When a save or an import fails, the invoice's or the client's page shows the message. The connection's Issues tab lists every failed record with what fixes it. After you fix the cause, click Retry on the issue, or Retry saving to QuickBooks on the invoice.
These are the messages you are most likely to see:
"The QuickBooks user who connected the company is no longer its admin. Reconnect QuickBooks as an admin." Reconnect as a QuickBooks admin.
"The QuickBooks company is read-only because its subscription has lapsed. Renew it in QuickBooks, then retry." Renew the subscription in QuickBooks.
"This account is already connected for another company." The QuickBooks company is connected to another Operating company. Disconnect it there first, or connect another QuickBooks company.
"A line has no billable item, and QuickBooks ignores the amount of such a line." Choose a billable item for each line of the invoice, then retry.
"Another customer, vendor or employee in QuickBooks already has this name. Rename one of them, then retry." When the customer is the client's, link the client to it on the Mapping tab, then retry.
"Another document in QuickBooks already has this number. Change one of the numbers, then retry." Change the number in Operating or in QuickBooks.
"The date falls in a period whose books are closed in QuickBooks. Change the date, or reopen the period in QuickBooks, then retry." Change the invoice date, or reopen the period.
"QuickBooks leaves documents unnumbered while custom transaction numbers are on in this company." Turn off custom transaction numbers in QuickBooks, then retry.
"The document is in {currency}, which QuickBooks does not use for this company." Turn on multicurrency in QuickBooks, or invoice in the home currency.
"The client's customer in QuickBooks is in {customer currency}, and this document is in {invoice currency}; QuickBooks never changes a customer's currency." Invoice the client in its customer's currency, or set Currency of a customer Operating creates to The currency it is invoiced in.
"QuickBooks will not make this customer inactive while it has an open balance." Settle or credit the customer's open invoices in QuickBooks, or make the client active again in Operating.
"A record this one refers to is inactive or missing in QuickBooks. Make it active there, or map another, then retry." Make the item, tax code or customer active in QuickBooks, or map another one.
When you click Save changes on a feature's page, Operating can refuse the save. Nothing is saved, and the message starts with the feature's name:
"… already sends this company's records. Turn off the feature that does it there first." Another connection, which the message names, already sends this company's records. Turn off that feature on the other connection, then save again.
"… already creates new clients. Turn “Create new clients” off there first, or leave it there." Only one connection can create new clients. Turn off Create new clients on the connection the message names, or leave it off here.
"A schedule that sends these records needs permission to change them. Ask someone who has it." Sending records on a schedule needs the permission to change those records, such as clients. Ask someone who has that permission to make the change.
If the scheduled sending of clients fails with "More than one connection is set to create new clients, so none creates them. Turn “Create new clients” off on all but one.", leave Create new clients on for one connection and turn it off on the others.
Related articles
Was this helpful?
More in Integrations & API
AI chat (LLM) via MCPREST APIHubSpot CRMSalesforce CRMStill need help? Ask the team