QuickBooks CRM integration: sync quotes, invoices and payments

Most small businesses run sales in one place and the books in another. The salesperson closes the job in the CRM, then someone retypes the customer and the invoice into QuickBooks, and later someone else asks the salesperson whether the customer has paid. Every handoff is a chance for a typo, a missed invoice or an awkward call to a customer who paid last week.

A QuickBooks CRM integration removes that double entry. This guide explains what should sync and in which direction, how to set it up, and the pitfalls that catch most teams. It focuses on QuickBooks Online; QuickBooks Desktop is a different product and works differently.

Why connect your CRM and QuickBooks

Sales and accounting need the same facts for different reasons:

• Sales needs to know what’s been invoiced and paid, so reps don’t chase paid customers and can see who’s overdue before quoting the next job.
• Accounting needs accurate customers and invoices to keep the books, file taxes and reconcile the bank.

Without an integration, someone bridges the gap by hand. A contractor’s office manager might spend Friday afternoons copying the week’s invoices into QuickBooks, then checking the bank feed and updating a spreadsheet so the owner knows who still owes money. An integration does that continuously.

What syncs and in which direction

Not everything needs to sync. Focus on the records both teams care about:

Record	Created in	Syncs to	Why
Customers	CRM	QuickBooks Online	So invoices attach to the right customer in your books
Quotes	CRM	Stays in the CRM	Quotes are sales documents; accounting needs invoices
Invoices	CRM (from accepted quotes)	QuickBooks Online	So revenue and receivables are in the books without retyping
Payments recorded in the CRM	CRM	QuickBooks Online	So the books reflect cash received
Payments recorded in QuickBooks	QuickBooks Online	CRM	So invoice balances in the CRM stay correct

The last row is the one that makes the difference day to day. Bookkeepers often record payments in QuickBooks as they reconcile the bank. If those payments flow back to the CRM, the invoice balance updates and overdue reminders stop on their own.

A worked example

Say a fencing contractor wins a $6,000 job. Here’s how the records move:

1. The customer accepts the quote online in the CRM, and the deal is marked won.
2. The quote is converted to a $6,000 invoice with a 30% deposit due on acceptance. The customer and invoice sync to QuickBooks Online.
3. The customer pays the $1,800 deposit by check at the site visit. The salesperson records it in the CRM, and it syncs to QuickBooks.
4. Three weeks later the customer pays the $4,200 balance by bank transfer. The bookkeeper records it in QuickBooks while reconciling the bank, and it syncs back to the CRM.
5. The invoice shows as paid in both systems. Nobody typed the customer, the invoice or either payment twice.

One source of truth per record

The golden rule of any sync is that each record has one owner:

• Customers and invoices: create them in the CRM. Editing a synced invoice in two places invites conflicts.
• Payments: can be recorded in either system, but each individual payment should be recorded once.
• Chart of accounts, bank reconciliation, payroll, taxes: stay in QuickBooks. Your CRM doesn’t need them.

Setup steps

Every integration has its own screens, but the process is similar:

1. Clean up customers first. Look for duplicates in both systems (“Bob’s Plumbing” and “Bobs Plumbing LLC”). Merge or archive them before you connect. In QuickBooks Online, Intuit’s help notes that merging customers “is permanent and can’t be undone”, and that neither customer can have sub-customers, so double-check before merging.
2. Agree on naming. Decide how customer names are written: company name for businesses, “Last, First” or “First Last” for individuals. Consistency prevents new duplicates.
3. Match your tax setup. Make sure the tax rates you use on quotes in the CRM match how sales tax is set up in QuickBooks, and ask your accountant to confirm.
4. Decide where payments get recorded. For example: checks and bank transfers in QuickBooks during reconciliation; cash on site in the CRM by the tech.
5. Connect and authorize. Sign in to QuickBooks Online from your CRM’s integration settings and choose the company to connect.
6. Test with a few records. Create a test customer and invoice, record a partial payment, and confirm everything appears correctly in both systems.
7. Write it down. A one-page “who records what, where” note for the team saves months of confusion.

Avoiding double entry

The point of the integration is that nobody types the same thing twice. That only works if people trust the sync and stop their old habits.

• Stop creating invoices directly in QuickBooks for customers who came through the CRM, unless your process says otherwise.
• Don’t re-record payments in the CRM that the bookkeeper already recorded in QuickBooks; wait for them to sync back.
• Make changes at the source. If an invoice needs correcting, correct it where it was created.
• Record payments promptly. Intuit’s own help notes that until a payment is recorded, “the invoice stays open and remains unpaid on your reports”. The same goes for the CRM.

Common pitfalls

Pitfall	What happens	How to avoid it
Duplicate customers	Invoices split across two customer records; balances look wrong	Clean up before connecting; search before creating new customers
Payment recorded twice	Customer appears to have overpaid; books overstate cash	One place per payment; let the sync carry it across
Editing synced invoices in both systems	The two versions drift apart	Edit at the source only
Tax mismatch	Totals differ by a few dollars between systems	Align tax rates before you connect
Deleting instead of voiding	History disappears; Intuit notes deleting a transaction can’t be reversed	Void or credit instead of deleting, following your accountant’s advice
Expecting Desktop support	The integration won’t connect	Confirm you’re on QuickBooks Online
Grouped deposits	One bank deposit covers several payments	Use QuickBooks’ Undeposited Funds to group payments into a single deposit

On that last point, Intuit’s help article on recording invoice payments explains that you can deposit a payment to Undeposited Funds when you need to group it with other payments into one bank deposit, which keeps reconciliation clean when a bank lumps several checks together.

Partial payments and deposits

Many jobs are paid in pieces: a deposit when the quote is accepted, a progress payment and a final balance. Both systems should treat these as separate payments against the same invoice, with the balance carried forward.

Note one QuickBooks Online detail: when you record a partial payment against an invoice, Intuit says QuickBooks applies it to the first line item and then to later lines, and that order can’t be changed. That matters only if you report by line item, but it’s worth knowing before your accountant asks.

For the sales side of this, including due dates, payment terms and reminder cadences, see our guide to invoicing in your CRM. If you’re moving to a new CRM at the same time, read how to switch CRMs without losing data first.

How Exa helps

Exa’s QuickBooks Online integration syncs customers, invoices and payments to QuickBooks Online. Payments recorded in QuickBooks sync back to Exa and update the invoice balance, so overdue tracking and the billing snapshot stay accurate. QuickBooks Desktop and Xero are not supported.

The sync covers customers, invoices and payments. Quotes are created in Exa, where customers accept them online, and an accepted quote converts to an invoice in one click. You can record full or partial payments in Exa, but Exa doesn’t process card or ACH payments. Exa’s live duplicate detection and merge help keep customer records clean before they ever reach your books; see our guide to duplicate records.

Final thoughts

A QuickBooks CRM integration is less about technology and more about agreement: which system owns which record, who records payments where, and what the team stops doing by hand. Clean up customers first, test with a few invoices, write down the rules, and let the sync handle the rest. Sales sees what’s been paid, accounting gets accurate books, and nobody retypes an invoice again.