Sync to QuickBooks Online
Connect QuickBooks Sync, included on every paid plan, and push customers, invoices, and payments from OpsVara into QuickBooks Online.
Updated November 16, 2026
QuickBooks Sync is included on every paid OpsVara plan at no extra charge. It pushes your OpsVara billing records into QuickBooks Online automatically. The sync is one-way — OpsVara → QuickBooks — so your books follow what you actually billed, and OpsVara remains the source of truth.
What gets pushed, and when:
| Record | When it syncs |
|---|---|
| Customers | When created or edited in OpsVara, if Sync customers is on (it is off until you turn it on). A customer OpsVara created in QuickBooks is kept in step with OpsVara; a customer you linked to an existing QuickBooks record is never renamed or re-addressed by OpsVara — that record stays your bookkeeper's. With the switch off OpsVara never creates a QuickBooks customer; invoices still post to linked ones, and an invoice for an unlinked customer holds until you link them. |
| Invoices | When sent, marked paid, or voided. Drafts and rejected invoices never sync. |
| Payments | When recorded — each manual payment and each online card or bank payment posts once against the matching QuickBooks invoice, for the amount it holds, as the QuickBooks payment method of the same name (Check, Cash, Credit Card; bank payments match Bank Transfer, ACH, EFT or Direct Debit if your company has one — otherwise QuickBooks uses its default). Online payments carry the Stripe charge reference; the customer's processing fee is never posted (it is Stripe's, not your revenue). |
| Service items | Created in QuickBooks automatically the first time a service, drive & labor, billable expense, other charge, card fee, or Late Fee line needs one, named after your work types (a late-fee line is Late Fee) and booked to your default income account. |
Set it up
Make sure you're on a paid plan
QuickBooks Sync comes with every paid plan, so there is nothing to add. It is not available on trial accounts: an admin chooses a plan in Settings
Billing first, so a trial can't write into a live set of books. Connect your QuickBooks company
Open Settings
Integrations and click Connect QuickBooks. Sign in at Intuit with a QuickBooks admin login and choose the company to connect. You are returned to OpsVara with "QuickBooks connected" — and the banner Connected · setup incomplete. Connecting only authorizes OpsVara: nothing is written into QuickBooks until you click Start syncing in the last step. Pick your Default tax code
In the Sync Settings card, set Default tax code and Default income account (both required before you can start: the income account is what new service items are booked to). If your QuickBooks company uses Automated Sales Tax, the list leaves out the codes QuickBooks generates for itself (their names are long codes of letters and numbers). Codes your company made, such as TAX or NON, still show, with their QuickBooks description beside the name when it adds something (for example Tulsa 8.517% — …). If your QuickBooks company has sales tax turned off, tick This QuickBooks company doesn't charge sales tax instead of picking a tax code — every line then posts as non-taxable, and an invoice that does carry tax is flagged rather than pushed. Choose what to push with the Sync customers, Sync invoices, and Sync payments checkboxes — Sync customers starts off, and stays off unless you turn it on, so OpsVara never creates QuickBooks customers you did not ask for. If earlier invoices were already entered in QuickBooks by hand, set Only sync invoices dated on or after so a backfill cannot book them twice. Click Save Sync Settings.
Match the customers you already have
If your customers are already in OpsVara, click Match Customers to QuickBooks and link them to their QuickBooks records before anything syncs (see below). This is what keeps invoices posting to the customers already in your books instead of creating duplicates. Customers that are not in QuickBooks at all: either turn Sync customers on so OpsVara creates them, or leave it off and their invoices hold until you link them.
Click Start syncing
At the bottom of Sync Settings, click Start syncing. From that moment, new and changed invoices and payments go to QuickBooks as you work. The button stays disabled until a tax code (or the no-sales-tax tick) and an income account are saved, and the banner changes to Syncing.
Backfill with Sync Now
Click Sync Now to push what already exists. The confirmation lists exactly what it will do — how many invoices on or after your start date, and how many customers will be created in QuickBooks versus already linked — before you type "sync". Starting the sync does not push existing records; only Sync Now does.
Invoices hold until a tax code is mapped
QuickBooks requires a tax code to record the exact tax OpsVara calculated, so invoice sync holds until you pick a Default tax code. Those invoices appear under Needs Attention on the Integrations tab as waiting on you, and are pushed again overnight, or immediately when you click Sync Now.
Match Your Existing Customers to QuickBooks
When your customers already live in OpsVara, link them to the records in your books before invoices flow. On Settings
- Linked — already tied to a QuickBooks customer.
- Suggested — a QuickBooks customer has exactly the same display name (or, failing that, the same primary email). Review the suggestions, then click Link All 12 Suggested (the button shows the number, and only appears when there is at least one suggestion). Type "link" and click Link All to confirm.
- No match — click Link… to search your QuickBooks company by name and pick the right record. Use this whenever the two systems spell a name differently, such as "Smith, John" and "John Smith".
Linking writes nothing to QuickBooks. It only tells OpsVara which QuickBooks customer to post invoices and payments against.
Under the filters, one line counts the links, for example "144 OpsVara customers linked to 142 QuickBooks customers (some share one)". The two numbers differ when one QuickBooks customer is linked to more than one OpsVara customer — usually two customers with the same name and email, or links made before OpsVara stopped allowing a second one (Match Customers itself links a QuickBooks customer to one OpsVara customer only). When that happens a Shared filter appears: it lists those OpsVara customers grouped by QuickBooks customer, and each one's QuickBooks column reads Shared by 3 customers (or however many share it). A second line says how many active QuickBooks customers were checked for suggestions. When every OpsVara customer is already linked, QuickBooks is not read at all and the line says "Everyone is linked".
The list shows 50 customers at a time. Click Show More for the next 50; "Showing 50 of 320" tells you how far you are. Changing the filter starts again at 50.
Unmatched customers are created in QuickBooks on first sync
When a customer syncs with no link, OpsVara adopts an existing QuickBooks customer only when the name and the email agree (or the email alone matches). A QuickBooks customer with the same name but a different email — or no email on one side — is not guessed at: the customer is listed under Needs Attention as waiting on you until you confirm the match here or on the customer page. The same goes for an email that several of your OpsVara customers share: it suggests nothing and the push holds. These records get their own Needs Attention row (The QuickBooks customer with this email may belong to another OpsVara customer) with an Open Match Customers shortcut. Each of those customers needs its own QuickBooks customer — Match Customers links a QuickBooks customer to one OpsVara customer only. Finding nothing at all, OpsVara creates a new QuickBooks customer, so a person already in your books under a different spelling becomes a duplicate. Match first, then sync.
Keep a customer out of QuickBooks
Tick Don't sync on a row of the match list, or open the customer's page under Directories
Link or unlink from the customer page
The QuickBooks card on a customer's page shows which QuickBooks record they are linked to. Link to QuickBooks… or Change Link… opens the same search, and Unlink forgets the link (the next sync matches by name or email again, and may create a new QuickBooks customer if nothing matches).
Import Customers from QuickBooks
If some customers exist only in QuickBooks, pull just those in. On Settings
- A ticked QuickBooks customer that matches an existing OpsVara customer by name or email is linked, never overwritten — nothing you maintain in OpsVara changes.
- Everyone else you ticked is created in OpsVara with their name, contact, email, phone, and addresses.
- Rows already linked are greyed out; Show inactive reveals inactive QuickBooks customers.
- The import is quiet: it sends no portal invites, and imported customers are not pushed back to QuickBooks.
Import all… brings in every active customer in the QuickBooks company. It asks you to type "import" first, because a company that serves several markets would land in this one OpsVara account in full.
When it finishes, the panel shows a summary, and the connection card shows "Last import: N imported, M linked, K already synced."
Imported customers have no service sites yet
QuickBooks tracks who you bill, not where you work — so every imported customer arrives with no site. A customer with no site cannot be scheduled, cannot hold a job, and cannot be billed for work. Send your site list (with pool sizes or acreage if you track them) to your OpsVara contact: they import it against the customers you just brought in, so nothing is retyped and no customer is duplicated.
Match Bank Deposits to Invoices in QuickBooks
Every payment recorded in OpsVara arrives in QuickBooks already applied to its customer and invoice, so you match a bank deposit by picking the payments that were in it. OpsVara does not choose a deposit account. QuickBooks files each payment under its own default, normally Payments to deposit (Undeposited Funds), until you say which deposit it went into.
Checks and cash
Record the payment in OpsVara
Open the invoice under Sales and Billing
Invoices and click Record Payment. Set Payment Method to Check, enter the Check Number and the Date Received. One check that covers several invoices is recorded on each invoice with the same check number. Find it in QuickBooks
QuickBooks shows a payment on that customer's invoice, dated the day you received it, with the payment method (Check, Cash) and the check number as the reference number.
Make the bank deposit
In QuickBooks, create a bank deposit, pick the bank account, and tick the payments that were on that deposit slip. Each line shows the customer, the check number and the amount.
Match it in the bank feed
Save the deposit. Its total now equals the line in your bank feed, and QuickBooks offers the two as a match.
Card and bank payments made online
Each online payment posts as its own QuickBooks payment against its invoice, as Credit Card when your company has a payment method by that name, with the Stripe charge reference as the reference number. The processing fee a customer paid on top of the invoice is never posted, because it is the processor's and not your revenue.
Stripe pays out in batches, so one bank deposit usually covers several payments. Build the bank deposit from the payments in that payout, and add one line for fees so the total equals the payout. To see which charges a payout holds, open Settings
A deposit with no payment waiting in QuickBooks
The check was deposited before anyone recorded it. Record it on the invoice in OpsVara first, then match the deposit as above. Do not receive the payment in QuickBooks directly: OpsVara does not read payments back, so the invoice would stay open here and the customer would keep getting reminders.
When something doesn't sync
The Integrations tab shows a Needs Attention card whenever records are stuck. It is grouped by reason, not by record — a hundred invoices waiting on a tax code are one row, "No default tax code is set · Waiting on you 100", not a hundred rows. Each row says what the cause is, how many records it holds, and what to do about it:
- Waiting on you means the records need a setting or a decision — usually the default tax code, a same-name customer match you need to confirm, a QuickBooks customer whose email may belong to another of your customers, or a customer who is not linked while Sync customers is off.
- Failed means the push was rejected by QuickBooks — a total that did not match, an invoice number already taken, a voided invoice with synced payments.
Buttons on each row:
- Fix in Sync Settings or Open Match Customers takes you straight to the setting that clears the cause. Open Match Customers also shows on any row whose records say to confirm the match under Match Customers.
- Retry pushes every record in that row again right now, once you have fixed the cause. The button names what it retries, such as Retry 2 Invoices, Retry 1 Payment or Retry 3 Customers, and Retry 5 Records when a row holds more than one kind. (Everything open is retried overnight anyway.)
- Mark All 5 Resolved (with that row's count, or Mark 1 Resolved when the row holds one record) takes the whole row off the list once you have handled it in QuickBooks yourself — entered the credit memo, deleted the duplicate payment. It asks you to confirm first. Resolved records are not pushed again unless they change.
Expand a row to see the records themselves (invoice numbers and customer names link to their pages), with the full per-record detail such as the two amounts of a total mismatch, and a Mark Resolved for a single one. When the detail says to confirm the match under Settings → Integrations → Match Customers, click those words to open Match Customers to QuickBooks. If a later push for a resolved record fails again, it comes back on its own.
The connection card at the top summarises the same thing in one line — "12 records are waiting on you and 4 could not be pushed to QuickBooks".
While anything is listed, admins and office managers get a note naming the causes, biggest first (for example 80 — No default tax code is set; 15 — …). The note is sent again only when the count or the causes change. The same numbers night after night are not re-sent. Each new note replaces the earlier one in the bell, so you see only the newest count. Once everything is cleared, the next problem is reported even if its numbers match an old note. Turn it off per person under Settings
Each invoice, and the top of each customer page, shows a small QuickBooks chip (QuickBooks · Synced, QuickBooks · Waiting on you or QuickBooks · Failed). The QuickBooks card on each customer page shows Linked, Waiting on you or Failed, so you can check a single record without leaving it. The customer card shows the reason in full. When the reason is a customer match still to confirm, Settings → Integrations → Match Customers in the card is a link, and the chip on the invoice or customer page is one too. Each opens the Integrations tab with Match Customers to QuickBooks already open; from a customer's page, that customer is listed first and highlighted. Once a record is marked resolved, the link goes away.
If the connection banner says Reconnect Required, QuickBooks expired the authorization (this happens after roughly 100 days without sign-in). Admins and office managers are emailed the moment it happens. Click Reconnect QuickBooks — your settings and links are kept, and OpsVara catches up on the invoices and payments that changed while the connection was down. A reconnect never pushes your customer list; only Sync Now does, and it tells you the counts first.
Known limitations
- The sync is one-way. Changes made inside QuickBooks are not pulled into OpsVara. On invoices and payments OpsVara's next push overwrites them; on a linked customer's name and contact details it does not.
- Invoice and payment dates post on your company's calendar (Settings → Company → Company time zone). Leave the time zone blank and QuickBooks gets the UTC day instead, so an evening payment on the last day of a month can land in the next month's books.
- Payments post once. Removing a manual payment or applying a Stripe refund in OpsVara flags the QuickBooks payment under Needs Attention so you can adjust it by hand; other edits do not update QuickBooks. A refunded payment that has not been applied yet waits there instead of posting.
- Voiding an OpsVara invoice that already has synced payments does not void it in QuickBooks; the record shows an error asking you to resolve it with a credit memo in QuickBooks. Combining invoices voids the originals in QuickBooks too.
- Contract credit applied to an invoice is not a QuickBooks payment. The invoice syncs with its full amount and a held row asks you to record a credit memo.
- If QuickBooks computes a different total than OpsVara billed (usually a tax-code or item setup difference), the invoice shows an error with both amounts instead of a green Synced.
- Deactivating a customer in OpsVara does not deactivate them in QuickBooks.
- Invoices dated before Only sync invoices dated on or after never sync, even when voided later — they were never in QuickBooks through OpsVara.
- The integration is designed for US-based QuickBooks Online companies.
Verify it worked
After Sync Now, the Integrations tab shows "Last synced" with a fresh timestamp and no Needs Attention card. In QuickBooks Online, open Sales → Invoices and confirm an OpsVara invoice appears with the same invoice number, lines, tax, and payments. On that invoice in Sales and Billing
Frequently asked questions
Does the sync go both ways?
Ongoing sync is one-way — OpsVara pushes to QuickBooks, and edits made inside QuickBooks are not pulled back. The one exception is the on-demand customer import, which pulls your existing QuickBooks customer list into OpsVara when you click Import Customers from QuickBooks.
My customers are already in OpsVara. What happens when I turn on the sync?
Nothing is pushed by connecting, and nothing is pushed until you click Start syncing. When an invoice syncs, OpsVara uses the QuickBooks customer you linked. With no link it adopts a QuickBooks customer only when the name and the email both agree, or the email alone matches and that email belongs to just one OpsVara customer; a same-name customer with a different email, or an email several of your customers share, is held for you to confirm. Shared-email holds get their own Needs Attention row with Open Match Customers — each OpsVara customer needs its own QuickBooks customer. When nothing matches, a new QuickBooks customer is created only if Sync customers is on — it is off until you turn it on, so by default the invoice holds instead. Open Match Customers to QuickBooks first and link each customer to the right record before you start. A linked customer's name, email, phone, and address in QuickBooks are never overwritten by OpsVara — only customers OpsVara created there are kept in step.
I connected QuickBooks but nothing is syncing. Why?
Connecting only authorizes OpsVara. Syncing starts when you finish Sync Settings (a tax code or the no-sales-tax tick, plus an income account), save, and click Start syncing. Until then the Integrations tab says "Connected · setup incomplete" and Sync Now is disabled.
Can I import only some of my QuickBooks customers?
Yes. Click Import Customers from QuickBooks, search your QuickBooks company, tick the customers that belong in this OpsVara account, and click Import selected. Importing every QuickBooks customer is still possible, but it asks you to type "import" first because it brings in the whole company.
Can I keep one customer out of QuickBooks?
Yes. On the customer's page, tick Don't sync to QuickBooks in the QuickBooks card (or in the Match Customers to QuickBooks list). That customer is never pushed, and their invoices wait under Needs Attention instead of syncing.
We already entered older invoices in QuickBooks by hand. Will Sync Now double them?
Not if you set Only sync invoices dated on or after in Sync Settings. Invoices dated before that day are skipped by Sync Now and by the automatic sync.
My imported customers have no sites. How do I add them?
QuickBooks has no concept of a service location, so imported customers arrive with none. Send your site list to your OpsVara contact — they import it with a spreadsheet that attaches sites, and their vertical details like pool volume or acreage, onto the customers you already imported.
Why is an invoice waiting under Needs Attention?
Invoices wait until you pick a Default tax code and a Default income account in Sync Settings — QuickBooks needs a tax code to record the exact tax OpsVara calculated, and an income account to create service items. Pick them, save, then click Sync Now. An invoice also holds when its customer is marked Don't sync to QuickBooks, when contract credit settled it in OpsVara (record a credit memo in QuickBooks), when a same-name QuickBooks customer has a different email, when several of your customers share an email (its own Needs Attention row — The QuickBooks customer with this email may belong to another OpsVara customer), and when the customer is unlinked while Sync customers is off.
What happens if I connect a different QuickBooks company?
OpsVara clears its stored record mappings, because QuickBooks ids only mean something inside one company, and syncing stops until you redo Sync Settings and click Start syncing again. After that, records are matched into the new company by customer email and by invoice number, or created fresh.
A check deposit shows up in my bank feed. How do I know which invoices it covers?
Every payment recorded in OpsVara arrives in QuickBooks already applied to its customer and invoice, with the check number as the reference. In QuickBooks, make a bank deposit and tick the payments that were on that deposit slip — the deposit total then equals the line in your bank feed and QuickBooks offers it as a match. If no payment is waiting, the check was deposited before anyone recorded it. Record it in OpsVara first.
Can I record a customer payment in QuickBooks instead of OpsVara?
No. OpsVara does not read payments back from QuickBooks, so the invoice would stay open in OpsVara and the customer would keep getting reminders. Record the payment on the invoice in OpsVara and it reaches QuickBooks on its own.
Do payment edits or refunds sync?
No. A payment is pushed to QuickBooks once, when it is recorded. Editing or removing it later in OpsVara does not change QuickBooks — make that correction in QuickBooks directly. A removed payment or an applied refund is flagged under Needs Attention so you can fix it there.
Why is there a Needs Attention row for a shared email?
An email several of your OpsVara customers share is not guessed at. Those records get their own Needs Attention row (The QuickBooks customer with this email may belong to another OpsVara customer) with Open Match Customers. Each of those customers needs its own QuickBooks customer — Match Customers links a QuickBooks customer to one OpsVara customer only.
Why does Match Customers show more linked OpsVara customers than QuickBooks customers?
One QuickBooks customer can end up linked to more than one OpsVara customer: two of your customers with the same name and email both pick it up when they sync (usually a duplicate), or the links were made before OpsVara stopped allowing a second one. The line under the filters says so, for example "144 OpsVara customers linked to 142 QuickBooks customers (some share one)". Click Shared to see them; each one reads Shared by 2 customers (or however many share it). If one is a duplicate, archive it. Otherwise unlink all but the right customer and link each of the others to its own QuickBooks record — Match Customers links a QuickBooks customer to one OpsVara customer only.
Why didn't I get another QuickBooks email when records were still waiting?
The note is sent again only when the count or the causes change. The same numbers night after night are not re-sent. Each new note replaces the earlier one in the bell. Once everything is cleared, the next problem is reported even if its numbers match an old note. Turn it off per person under Settings → Notifications → QuickBooks sync.
Why don't I see my Automated Sales Tax codes in Default tax code?
If your QuickBooks company uses Automated Sales Tax, the list leaves out the codes QuickBooks generates for itself (their names are long codes of letters and numbers). Codes your company made, such as TAX or NON, still show, with their QuickBooks description beside the name when it adds something.