What Is QuickBooks Setup for Canadian Ecommerce Sellers?
QuickBooks setup is the process of configuring QuickBooks Online so it matches how your Canadian ecommerce business actually operates — the right chart of accounts, the right currency settings, and a proper connection to Amazon and Shopify through A2X.This is for you if you are opening a new QuickBooks file, migrating from another system, or fixing a file that was set up without Canadian requirements in mind. It applies whether you sell on Amazon.ca, Amazon.com, Shopify, or all three.
Why Proper QuickBooks Setup Matters
A correct setup saves you from rebuilding your books later. Every transaction that flows in after setup depends on the accounts and settings you choose on day one. It also determines whether your GST/HST filings are accurate, and whether your reports are actually usable for decisions instead of just numbers on a screen.
The mistake Multi-currency gets enabled six months into using QuickBooks, after hundreds of transactions already exist in a single-currency file. | The fix Multi-currency is turned on before the first transaction is ever entered, so every record stays consistent from day one. |
That first scenario is not rare. It usually means reconciling two incompatible sections of the same file, which is close to starting over rather than patching the gap.
Step-by-Step Guide to QuickBooks Setup
Step 1: Choose the Right QuickBooks Online Plan
Pick a plan that supports multi-currency if you sell in both CAD and USD. This feature is not available on every tier, so confirm it before you commit. Most growing Amazon and Shopify sellers need at least the Plus plan.
Step 2: Build a Canadian Ecommerce Chart of Accounts
Set up separate accounts for product revenue, shipping income, Amazon fees, Shopify fees, refunds, cost of goods sold, and inventory. Add GST/HST payable and GST/HST recoverable as their own liability accounts, separate from everything else. Keep the chart of accounts lean — ten to fifteen well-organized accounts give clearer reports than fifty overlapping ones. Name each account clearly, such as “Amazon Referral Fees” rather than a generic “Fees.”
Step 3: Turn On Multi-Currency
If you sell in USD and bank in CAD, or the reverse, enable multi-currency in QuickBooks Online settings before you enter a single transaction. Set your home currency to CAD if your business is Canadian-registered, then leave it unchanged. This setting cannot be turned off once transactions exist.
Step 4: Connect A2X for Amazon and Shopify
Link your Amazon Seller Central and Shopify accounts to A2X, then connect A2X to QuickBooks. A2X breaks every settlement and payout into revenue, fees, refunds, and tax, and posts each piece to the matching account automatically.
Step 5: Map GST/HST Accounts Correctly
Inside A2X and QuickBooks, confirm that tax collected on sales posts to GST/HST payable, not to revenue. Confirm that tax paid on business purchases posts to GST/HST recoverable. This mapping is the step most sellers get wrong on a self-managed setup.
Step 6: Test With a Sample Transaction
Before going live, run one real settlement or payout through the system. Check that revenue, fees, refunds, and tax all land in the correct accounts. Fix any mapping errors now, while there is only one transaction to correct. Once your file is live, our guide to
Amazon FBA bookkeeping covers what monthly reconciliation looks like from here.
Practical Tips for Better Results
Set up your chart of accounts before you connect A2X, not after. Changing account structure once transactions are flowing creates reclassification work you can avoid entirely.
- Do not enable multi-currency after transactions already exist — QuickBooks cannot retroactively fix this
- Do not use a US-focused chart of accounts template with no GST/HST accounts
- Do not connect A2X before your chart of accounts is ready to receive data
- Do not skip the test transaction step and find mapping errors months later
| Next step• Setting this up correctly the first time is worth more than the hours it takes. Thelonex configures QuickBooks Online for Canadian Amazon and Shopify sellers in two to three business days, fully mapped for GST/HST and multi-currency from the start. Book a free consultation to get it done right. |
Conclusion
QuickBooks setup for Canadian Amazon and Shopify sellers is not complicated, but it has to be done in the right order: chart of accounts, currency settings, A2X connection, then GST/HST mapping. Skip a step, and you inherit cleanup work later. Get it right once, and your books stay clean with minimal effort every month after.
Next step Thelonex is a QuickBooks Online ProAdvisor certified bookkeeping firm built exclusively for Amazon and Shopify sellers. Setup is done in two to three business days, plans start at $199/month, and every client gets a dedicated account manager. To get your QuickBooks file set up correctly.
Book a Free Consultation |