Connect Your CRM to QuickBooks: A Step by Step Setup Walkthrough

The handoff between sales and accounting is where small A&E firms lose hours every week. A lead becomes a project. A project becomes a contract. A contract becomes invoices. Somewhere in the middle, someone retypes everything into QuickBooks because the systems do not talk.

This walkthrough closes that gap. We step through how to connect a CRM to QuickBooks Online so that a won deal becomes a customer record automatically, and an issued invoice in your firm management tool flows into your books without a second entry.

Before you start: the 5 prerequisites

1. QuickBooks Online Plus or Advanced. Self Employed and Simple Start cannot run a class based project chart of accounts.
2. Admin access on both QuickBooks and your CRM.
3. A finalized chart of accounts. Reorganizing accounts after the integration is live is painful.
4. A single source of truth for customer names. Decide whether QuickBooks or the CRM owns the canonical name. Pick one.
5. A test environment if your CRM offers a sandbox. Worth the half hour to set up.

Step 1: Map your records before connecting

The single most common integration failure is connecting first and mapping later. Spend an hour upfront documenting the record types and how they correspond.

• CRM Account maps to QuickBooks Customer.
• CRM Contact maps to QuickBooks Customer Contact.
• CRM Opportunity maps to QuickBooks Project (sub customer).
• CRM Project Phase maps to QuickBooks Class or Sub Project.
• CRM Invoice maps to QuickBooks Invoice.

Write that mapping in a one page document. Every team member who touches either system reads it before the connection is live.

Step 2: Authenticate and authorize

In your CRM or firm management tool, find the QuickBooks integration in settings. The flow is the same across most major tools.

1. Click connect QuickBooks. You will be redirected to Intuit.
2. Sign in with the QuickBooks account that has admin rights.
3. Select the company file you want to connect to. Confirm the right one.
4. Review the requested permissions. The minimum needed is read and write to customers, projects, invoices, and items.
5. Approve. You will be redirected back to your CRM with a connected status.

If the auth fails

Nine times out of ten the failure is one of three things: the user is not an Intuit admin, the company file selected is the wrong one, or the user has multiple QuickBooks Online subscriptions and picked the wrong tenant. Sign out completely and retry to be sure.

Step 3: Configure sync rules

Most integrations let you choose how aggressively to sync. The right answer for an A&E firm is usually one way for customers and two way for invoices.

• Customers and projects: Push from CRM to QuickBooks only. Sales owns the canonical record.
• Invoices: Push from CRM to QuickBooks when issued. Pull payment status back from QuickBooks.
• Items and services: Push from QuickBooks to CRM. Accounting owns the chart of services.

Two way sync sounds appealing but it almost always creates duplicate or conflicting records. Pick one direction per record type and stick to it.

Step 4: Test with three records

Before you flip the switch on real data, run three test records through the loop.

1. Create a fake lead in the CRM, mark it won, and confirm it appears as a customer in QuickBooks within five minutes.
2. Issue a test invoice from the CRM and confirm it lands in QuickBooks with the correct customer, line items, and class.
3. Mark the test invoice paid in QuickBooks and confirm the CRM updates the status.

If any of those three steps fail or duplicate records, stop and fix the mapping before continuing.

Step 5: Backfill carefully

If you have historical data in the CRM that did not sync, do not push it all at once. Filter to only the open and active records, push them, then verify in batches of 25. Closed and archived data is best left where it is.

Common gotchas

• Duplicate customers. Caused by name format differences. ABC LLC versus ABC, LLC versus ABC Inc are three different records to QuickBooks. Standardize before sync.
• Tax codes mismatched. Especially for firms with multistate work. Confirm your tax codes line up before invoices flow.
• Service items not aligned. If your CRM uses "Schematic Design Fee" and QuickBooks uses "SD Fee," sync errors flood the log. Pick one name.
• Closed accounting period. Pushing an invoice into a closed period in QuickBooks fails silently in some integrations. Watch the date.

What good looks like 30 days in

You should be able to look at any project in your CRM and see the linked customer, project, and invoices in QuickBooks. Bookkeepers should not be retyping anything that originated in the CRM. The team should trust both systems enough that nobody asks "which one is right" about the same customer record.

If that is not where you are after 30 days, the issue is almost always the original mapping. Revisit step one.

Beyond the basics

Once the integration is steady, the next layer is connecting project profitability back into QuickBooks for class based reporting. That turns your books into a real management tool, not just a tax filing tool. But do not start there. Get the lead to invoice loop clean first.