Connecting Shopify and QuickBooks: existing apps, their limits and custom work
A sale at midnight, and the next morning, someone copies it into the books. There’s a calmer way to keep your accounts.
5 min readTo connect Shopify and QuickBooks, a sync app is often enough: it sends sales, taxes, fees and refunds to your books. A custom integration becomes useful when taxes get complex, when you also sell to businesses, or when several systems need to share the same data.
Copying store sales into the books costs hours each month and hides errors until year end. Connecting the two tools settles it once and for all. See also our page on Shopify, QuickBooks and ERP integrations.
What has to move from one tool to the other
| Information | Why it matters |
|---|---|
| Sales | Revenue, by day or by order |
| Taxes | GST and QST in Quebec, HST elsewhere: each sale at the right rate |
| Payment fees | What Shopify keeps before paying you |
| Payouts | The amount actually received in the bank, to reconcile |
| Refunds and exchanges | So sales aren’t overstated |
| Gift cards | A liability to the customer until they’re used |
Detail or summary
Some apps send every order; others send a summary per day or per payout. A summary keeps the books readable and reconciles easily with bank deposits. Order-level detail is useful when you invoice businesses or track specific customers in QuickBooks.
Where apps stop
- Taxes across provinces split incorrectly.
- B2B sales with payment terms poorly reflected.
- Fees, partial refunds or gift cards misclassified.
- No connection to a third tool: inventory, warehouse, project management.
When these limits cost more hours in corrections than they save, a custom integration is justified.
A connection on your terms
It follows your rules rather than a generic app’s: your accounts, your categories, your business customers, your systems. It’s monitored: if there’s an error, someone is alerted. And it evolves with the business, instead of forcing it to change its bookkeeping habits.
Four checks, with your accountant
- [ ] Ask your accountant how they want to receive sales.
- [ ] List the store’s taxes, currencies and types of sales.
- [ ] Test the app on a real month, refunds included.
- [ ] Check reconciliation against bank deposits.
FAQ
Do we need an integration if the store sells little? Not always. But once data entry takes more than an hour a month, an app pays for itself quickly.
Can inventory be connected too? Yes, but that’s a separate sync, often with an inventory tool or an ERP.
Will my accountant have to change how they work? No, if the integration is set up with them from the start.
A sale should be entered only once. Tell us what your team still copies by hand.