Bookkeeping for E-Commerce Businesses in Canada

Why E-Commerce Bookkeeping Is Uniquely Complex

Running an online store in Canada creates bookkeeping challenges that traditional retail never had to deal with. Revenue comes from multiple platforms. Fees are deducted before payouts hit your bank. Customers are in different provinces — each with different tax rates. You may sell in USD and get paid in CAD. Inventory moves constantly.

Most general bookkeepers aren't familiar with the integrations and workflows required for accurate e-commerce accounting. This guide covers everything Canadian online sellers need to know.

Multi-Channel Revenue: The Core Challenge

If you sell on Shopify, Amazon, Etsy, and your own website, you have four different income streams — each with its own payout schedule, fee structure, and reporting format. The mistake most e-commerce owners make is recording the net payout from each platform as revenue.

Wrong: Bank receives $4,230 from Shopify → Record $4,230 as revenue.

Correct: - Record gross sales: $5,100 - Record Shopify transaction fees as expense: -$150 - Record payment processing fees as expense: -$720 - Net payout to bank: $4,230

Recording net payouts understates your revenue and hides your true cost structure. Your P&L becomes useless for decision-making.

Platform Integrations That Save Hours

Manually entering every Shopify order into QuickBooks is not sustainable. These integrations automate the process:

A properly configured integration means your bookkeeper reviews data rather than enters it — reducing errors and saving hours every month.

Sales Tax Across Provinces

This is where Canadian e-commerce gets complicated. When you sell to customers in different provinces, the applicable tax rate depends on their location:

Key rule: Once your sales into a province exceed the registration threshold, you may need to register in that province and remit that province's sales tax. Quebec has its own QST registration separate from CRA.

Most e-commerce platforms (Shopify, Amazon) can collect the correct tax automatically — but reconciling what was collected against what you must remit to CRA (and Revenu Québec) is a bookkeeping function.

Inventory Accounting for Online Sellers

Inventory is one of the most misunderstood areas of e-commerce bookkeeping.

The Cost of Goods Sold (COGS) Formula

COGS = Opening Inventory + Purchases – Closing Inventory

You need an accurate inventory count at the start and end of each accounting period. Without this, your gross margin is wrong — and every decision based on your P&L is based on bad data.

Landed Cost

When you import products, your inventory cost isn't just the purchase price. It includes: - Product cost (in USD, converted to CAD) - Import duties and tariffs - Shipping and freight - Customs brokerage fees - Warehousing costs before sale

Recording only the invoice price understates your true COGS and overstates your gross margin.

Inventory Write-Downs

Products that become obsolete, damaged, or unsellable must be written down to their net realizable value. This is an expense in the period it occurs — not when you eventually dispose of the item.

Multi-Currency: Selling in USD

Many Canadian e-commerce businesses sell in USD and receive USD payouts. Every USD transaction must be recorded in CAD at the exchange rate on the transaction date.

At year-end, any USD balances in bank accounts or receivables must be re-valued at the December 31 exchange rate. The difference is an unrealized foreign exchange gain or loss.

QuickBooks Online and Xero both handle multi-currency automatically — but it must be set up correctly from the start. Retroactive multi-currency conversion is extremely time-consuming.

Monthly Bookkeeping Checklist for E-Commerce

Common E-Commerce Bookkeeping Mistakes

1. Recording net payouts instead of gross sales — hides your true revenue and fees 2. Missing platform fees — Shopify, Amazon, and PayPal all take cuts that must be tracked 3. Ignoring sales tax on provincial sales — especially Quebec QST obligations 4. Not tracking inventory correctly — COGS errors flow directly to profit 5. Missing the HST Input Tax Credit on inventory purchases — you're entitled to claim HST paid on goods you buy for resale 6. No foreign exchange tracking — USD transactions recorded at the wrong rate create compounding errors

How Outsource Bookkeeping Helps E-Commerce Businesses

We set up and manage the complete bookkeeping workflow for Canadian online sellers — including platform integrations, multi-channel revenue reconciliation, inventory tracking, and HST/GST compliance across provinces.

Our flat-rate $500/month plan includes everything your e-commerce business needs to maintain accurate, CPA-ready books — so you can focus on growing your store instead of managing spreadsheets.

[Book a free consultation](/contact) to discuss your store's setup.