QuickBooks integration

A QuickBooks integration connects the other systems your business runs on, such as a CRM, an online store, a payment processor or a booking and job management system, to QuickBooks Online, so customers, invoices, payments and items move across on their own instead of being retyped by someone in the office. It is for owners, office managers and bookkeepers who are tired of copying invoices from one screen to another and chasing totals that never quite match. We plan which system owns which data, map your products and services to the items and accounts your accountant set up, map the GST/HST and QST tax codes your accountant chose, handle deposits, partial payments and credit notes, test with sample transactions and set up alerts when a sync fails. Canada Create is a Toronto agency with an office at 126 Willowdale Avenue, serving businesses across Canada. We do the technical setup; we do not do bookkeeping, accounting or tax advice.

Contents

• What a QuickBooks integration does for the office
• Which systems usually connect to QuickBooks Online
• Deciding the source of truth for customers, items and prices
• Mapping products and services to the items and accounts already set up
• Sales tax codes and more than one currency
• Payments, deposits, partial payments and credit notes
• Testing with sample transactions before going live
• Error alerts, a monthly sync check and documentation
• Working alongside your accountant or bookkeeper
• Record keeping, privacy and consent rules
• How a QuickBooks integration project runs
• What drives the cost of an integration
• Choosing someone to connect your books
• Your next step

What a QuickBooks integration does for the office

In many small businesses the same sale is entered three times. A rep closes a deal in the CRM, the office manager types the customer and the invoice into QuickBooks Online, and the bookkeeper later matches the payment that landed in the bank. Every retyping is a chance for a misspelled company name, a wrong tax code or a missing line, and month end turns into a hunt for the difference between what sales says was sold and what the books say was invoiced.

What changes once the systems talk

• A new customer created in the CRM or the online store appears in QuickBooks Online with the right name, billing address and tax settings.
• An approved quote or a completed job becomes a draft or final invoice, with the correct items, quantities and tax codes.
• Payments taken online or at the counter are recorded against the right invoice, so open balances are accurate.
• Sales reps or service managers can see whether a customer has paid without asking accounting.
• The bookkeeper spends time reviewing and reconciling instead of keying entries.

What it does not do

An integration moves data according to rules. It does not decide how a sale should be recorded, which account revenue goes to or how a transaction is taxed. Those decisions belong to your CPA or bookkeeper, and the integration is built to follow them.

Which systems usually connect to QuickBooks Online

The right connection depends on where your sales start. Most integrations we plan fall into a few patterns.

Common patterns

• CRM to QuickBooks Online: won deals or signed quotes creating customers and invoices, and invoice status flowing back so reps see who owes what.
• Online store to QuickBooks Online: orders recorded as sales, with products, shipping charges, discounts and tax kept on separate lines rather than lumped into one total.
• Payment processor to QuickBooks Online: card and online payments matched to invoices, with processing fees and payouts recorded the way your bookkeeper wants.
• Booking or job management system to QuickBooks Online: completed appointments, service calls or jobs turning into invoices with labour and materials separated.
• Custom forms and portals: a deposit request, a membership sign up or a wholesale order form on your website creating the right records.

Some of these links exist as ready made connectors, others need a custom build through the QuickBooks Online interface for developers. Ready made connectors are quicker to switch on but often record sales in a way your accountant did not choose, for example one summary entry per day instead of one invoice per order. We review what each option actually writes into the books before recommending it. For integrations between systems in general, beyond accounting, see our page on connecting your CRM, website and business tools.

Deciding the source of truth for customers, items and prices

Before anything is connected, every piece of shared data needs one home. When two systems both think they own the customer list, a correction made in one gets overwritten by the other overnight, and nobody knows which address is right.

Decisions we write down with you

• Customers: created in the CRM or store and pushed to QuickBooks Online, or created by accounting and copied to sales tools.
• Items and prices: maintained in the store or the CRM price book, with QuickBooks Online receiving them, or the other way around.
• Invoices: created in QuickBooks Online from a trigger in another system, or created elsewhere and copied in.
• Payment status: almost always owned by the books, then shared back to sales and service tools.
• Matching rules: how a customer in one system is recognized in the other, so a second record is not created for the same company with a slightly different name.

These choices go into a one page data ownership note that your office and your bookkeeper sign off. It sounds simple, but it prevents most of the duplicate customers and mismatched totals we see when an old sync is reviewed.

Mapping products and services to the items and accounts already set up

QuickBooks Online uses items for the products and services you sell, and each item points to income and, for stock items, inventory and cost accounts. Your accountant or bookkeeper designed that structure. The integration has to respect it.

What item mapping involves

• Listing every product, service, fee and shipping charge that appears in your CRM, store or job system.
• Matching each one to an existing QuickBooks Online item, or flagging it for your bookkeeper to create.
• Deciding how variations are handled: whether ten sizes of the same product share one item or need their own.
• Handling discounts, coupons, tips, gift cards, rush fees and delivery charges so each lands on the line your accountant expects.
• Keeping the map up to date when you add a new service or product line.

We never change your chart of accounts or create accounts on our own. When the mapping reveals a gap, we bring the question to your bookkeeper and build what they decide.

Sales tax codes and more than one currency

Tax codes are where many syncs go wrong quietly. A store that charges HST in Ontario, GST alone in Alberta and GST plus QST in Quebec has to send the right code with every line, or the sales tax reports in QuickBooks Online stop matching what customers paid.

GST/HST and QST in the sync

• Your accountant decides the tax treatment of each item and each type of customer, including any exempt or zero rated sales.
• We map those decisions so the integration sends the correct GST/HST or QST code for the customer’s location and the item sold.
• We check that tax amounts calculated in the other system agree with what QuickBooks Online records, including rounding on multi line invoices.
• Exempt customers, such as some resellers or organizations with an exemption your accountant has accepted, are flagged so their invoices carry the right code.

Selling or buying in another currency

If you invoice some customers in another currency, QuickBooks Online has a multicurrency setting that changes how customers, invoices and bank accounts are handled across the whole company file. Whether to switch it on is a decision for your accountant, made before the integration is built, because it is not a setting to switch back and forth. Once it is decided, we make sure each customer and invoice carries the right currency through the sync.

Payments, deposits, partial payments and credit notes

Invoices are the easy part. Money moving in pieces is where totals stop matching.

The cases we plan for

• Deposits: a contractor taking a deposit before work starts, or a caterer taking one when an event is booked, recorded so it is applied to the final invoice rather than counted twice.
• Partial payments: a customer paying an invoice in instalments, each one applied to the right invoice and leaving the correct balance open.
• Processor payouts: online payments arriving in the bank as one combined deposit after fees, matched in the way your bookkeeper prefers.
• Returns and credit notes: a returned item or a service credit creating a credit note in QuickBooks Online linked to the original sale, so revenue and tax are corrected.
• Write offs and adjustments: left to your bookkeeper, with the integration designed not to interfere.

Each case gets a written rule, and each rule gets a test before launch.

Testing with sample transactions before going live

We do not switch a sync on and hope. Before go live, we run sample transactions through every pattern your business uses and compare what lands in QuickBooks Online with what should land there, line by line.

Typical test transactions

• A new customer from Ontario buying two items, one taxable and one exempt.
• A Quebec customer whose invoice must carry GST and QST.
• An order with a discount code and a shipping charge.
• A job invoiced with a deposit already paid.
• An invoice paid in two instalments.
• A partial return creating a credit note.
• A customer whose name differs slightly between systems, to confirm no duplicate is created.

Where possible, tests run in a separate sandbox company or on clearly marked test records your bookkeeper removes afterwards. Your bookkeeper reviews the results before we connect the live company.

Error alerts, a monthly sync check and documentation

Every integration fails sometimes: an item gets renamed, a password changes, a customer record is missing a required field. The danger is a failure nobody notices for weeks.

What we set up

• Alerts sent to a named person in your office when a record fails to sync, with enough detail to know what went wrong.
• A monthly sync check comparing counts and totals between the source system and QuickBooks Online, so small gaps are caught before month end.
• Plain written documentation of what syncs, in which direction, how often, the mapping rules and what to do when an alert arrives.
• A short handover session for the office manager and bookkeeper.

Access to the integration and to QuickBooks Online itself is given by role and kept to the people who need it. For ongoing care of the website side of an integration, including updates and security, see our website maintenance and security plans.

Working alongside your accountant or bookkeeper

The integrations that hold up over time are planned with the person who keeps the books. We treat your accountant or bookkeeper as the owner of every accounting decision and ourselves as the people who make the systems follow those decisions.

What we ask of them

• Confirmation of the items, accounts and tax codes the integration should use.
• How processor fees, payouts and deposits should be recorded.
• Whether invoices should arrive as drafts for review or as final documents.
• Sign off on the test results before the live company is connected.

If your firm is an accounting practice looking for its own client management system, that is a different service; our page on CRM for accounting firms covers it. Bookkeepers wanting a site for their own practice may also find website design for bookkeepers useful.

Record keeping, privacy and consent rules

Connecting financial systems carries responsibilities, and we state them plainly so they are planned for.

Accounting decisions and records

Canada Create does not provide accounting, bookkeeping or tax advice. Your chart of accounts, the tax treatment of your sales and how transactions are recorded are decisions for your CPA or bookkeeper. The CRA generally expects businesses to keep their books and records for six years, so an integration should never delete or overwrite history, and any change to an existing sync is made with that in mind.

Financial and customer data

Invoices, payment details and customer contacts are personal and confidential information. PIPEDA sets general rules for how businesses collect, use and protect it. We give the integration and each user the least access needed, never send financial or customer data into analytics or advertising tools and keep test exports deleted after use. If invoices or receipts trigger emails, CASL applies to commercial messages to businesses as well as consumers: any marketing message needs consent or a documented business relationship, clear sender identification and an unsubscribe option. This is a marketing observation, not legal advice.

How a QuickBooks integration project runs

It starts with a free review of the systems you use today, how a sale moves from first contact to payment and where the retyping happens. We ask to include your bookkeeper in that conversation when possible.

From review to a running sync

• A written proposal describing the connections, the data ownership decisions and our fees in writing.
• Mapping of items, accounts and tax codes, confirmed by your bookkeeper.
• Build or configuration of the integration, followed by sample transaction testing.
• Go live on an agreed date, usually at the start of a period so reconciliation is clean.
• Alerts, documentation and, if you choose, a monthly sync check with a short report.

Your QuickBooks Online subscription, the other systems and any connector apps stay in your business’s name, paid directly to each vendor. Our logins are separate users you can remove at any time.

What drives the cost of an integration

Integration fees are quoted in writing after the free review, because a single store sending orders into the books is a very different job from a CRM, a job system and a payment processor all writing to the same company file. Software subscriptions and any connector app fees are paid to their vendors and shown separately.

What changes the scope

• How many systems connect, and whether ready made connectors fit or a custom build is needed.
• How many products, services and price variations need mapping.
• Tax complexity: sales in several provinces, exempt customers or invoices in another currency.
• Payment patterns such as deposits, instalments, processor payouts and returns.
• Whether existing duplicates and mismatched records must be cleaned before the sync starts.
• Whether you want a monthly sync check and support after launch.

Choosing someone to connect your books

A sync that writes wrong entries into your books is worse than no sync at all, so ask careful questions before anyone connects to your company file.

• Who owns the accounts? The answer should be you. Your company file in QuickBooks Online and any connector app belong to the business, and the primary admin should be the owner or the bookkeeper, never an outside contractor.
• Will you work with our bookkeeper, and who decides how transactions are recorded?
• How will you handle deposits, partial payments and credit notes?
• How will GST/HST and QST codes be mapped for customers in different provinces?
• What test transactions will you run, and who reviews them?
• Who receives the alert when a sync fails, and what do they do next?
• Do you claim any special status with Intuit? An honest answer is clear and checkable.

Connecting accounting is often one part of a wider setup. Our CRM services for Toronto businesses cover the sales side, automated sales follow up handles reminders on quotes, and custom CRM development suits work a standard pipeline cannot hold. If an online store is part of the picture, our ecommerce website builds are planned with the accounting connection in mind. Companies whose stock, purchasing and production have outgrown accounting software may also want to read about our ERP consulting service.

Your next step

Book a free QuickBooks integration review. Tell us which systems hold your customers, orders and payments, roughly how many invoices you send a month and where totals stop matching, and we will tell you which connections make sense and what the work involves. Call (416) 273-9030, Monday to Friday, 9 am to 6 pm, and Saturday, 10 am to 2 pm. After hours, our 24/7 AI agent answers the toll-free line, +1 (800) 808-9235, and we’ll follow up the next business morning. You can also reach us through our contact page. We reply within one business day. Our office is at 126 Willowdale Avenue, Suite 3, Toronto, and you can learn who we are before you call. QuickBooks is a trademark of Intuit Inc.; Canada Create is an independent agency and is not affiliated with Intuit.