Why E-Commerce Bookkeeping in Canada Is Genuinely Complex
A physical store sells to whoever walks in the door and collects the same provincial tax rate every time. An e-commerce store ships to customers across every province, handles multiple payment processors, manages inventory that may be split across a fulfilment centre and a home warehouse, and receives net payouts from platforms that have already deducted their own fees. Each of those layers creates a bookkeeping task that general bookkeepers frequently get wrong:
- Multi-province tax collection: The GST/HST rate depends on where the customer is located — not where the seller is. An Ontario seller charges 13% to Ontario buyers, 5% to Alberta buyers, and 15% to Nova Scotia buyers. Platforms like Shopify can calculate and collect the correct rate automatically, but the bookkeeping must capture and reconcile the total tax collected across all rates in a single GST/HST return
- Net payout problem: Shopify, Amazon, and Etsy pay out net of their fees. Recording only the net deposit understates gross revenue, misses the fee expense, and produces incorrect HST/GST liability figures. Every platform payout must be grossed up before it hits the books
- Inventory COGS: E-commerce businesses typically buy inventory in batches and sell units over time. The cost of goods sold must be calculated correctly — using either weighted average or FIFO — and matched to revenue in the same period. This is especially important for CRA because understated COGS inflates taxable income and generates overpayments; overstated COGS understates it and creates audit risk
- Multiple payment processors: Most Canadian e-commerce stores use Shopify Payments, Stripe, PayPal, Interac e-Transfer, and sometimes Afterpay or Sezzle. Each processor has its own settlement timing, fee structure, and reconciliation cycle. A single month may have five separate reconciliation streams feeding into one bank account
- Cross-border US sales: Sales to US customers are zero-rated exports for Canadian GST/HST — no Canadian tax collected. But once a seller reaches US state economic nexus thresholds (typically US$100,000 or 200 transactions per state), they may need to collect and remit US state sales tax separately. Tracking state-by-state US sales is a bookkeeping responsibility that many Canadian sellers ignore until they receive a US state notice
- Returns and chargebacks: E-commerce return rates can reach 15–25% in some product categories. Each return must reverse the revenue, the COGS, and the HST/GST. Chargebacks also require recording the gross reversal, the chargeback fee, and the updated tax position. Neither Shopify's reports nor bank statements automate this correctly
GST/HST for Canadian E-Commerce — Province-by-Province at a Glance
For a Canadian e-commerce seller registered for GST/HST, the rate charged to the customer depends on the customer's shipping province — not the seller's province:
| Customer Province | Rate Charged | Type | Bookkeeping Note |
|---|---|---|---|
| Ontario | 13% | HST | Combined in single CRA filing |
| British Columbia | 5% GST + 7% PST = 12% | Separate | BC PST may require separate BC registration if seller is in BC |
| Alberta | 5% | GST only | No provincial component — lowest rate |
| Quebec | 5% GST + 9.975% QST = 14.975% | Separate | QST collected separately; filed with Revenu Québec above QST threshold |
| Nova Scotia | 15% | HST | Combined in single CRA filing |
| New Brunswick | 15% | HST | Combined in single CRA filing |
| PEI | 15% | HST | Combined in single CRA filing |
| Newfoundland & Labrador | 15% | HST | Combined in single CRA filing |
| Manitoba | 5% GST + 7% RST | Separate | Manitoba RST may require separate registration |
| Saskatchewan | 5% GST + 6% PST | Separate | SK PST may require separate registration |
| US customers | 0% | Zero-rated export | No Canadian GST/HST — but US nexus obligations may apply |
| International (other) | 0% | Zero-rated export | No Canadian GST/HST charged |
The common error: treating all sales as if the seller's province rate applies everywhere. An Ontario seller charging 13% on Alberta orders is collecting and remitting tax the customer did not owe — and cannot easily reclaim. Platform-calculated tax is only correct if the tax settings in Shopify or WooCommerce are configured correctly for every province.
Shopify Reconciliation — What "Net Payout" Actually Means
Shopify deposits a net amount to your bank account every business day or week. This net payout has already had several items deducted from your gross sales. A bookkeeper who records only the net deposit produces incorrect financials in multiple dimensions:
| What Shopify Pays Out | Correct Bookkeeping Treatment |
|---|---|
| Gross sales (revenue) | Record as full revenue — not what Shopify deposits |
| Less: GST/HST collected | Record as a liability (HST/GST payable) — not income |
| Less: Shopify Payments processing fee (2.4%–2.9%) | Record as a merchant fee expense |
| Less: Shopify transaction fee (if not using Shopify Payments) | Record as a platform fee expense |
| Less: refunds issued | Reverse the original revenue, COGS, and tax entries |
| Less: chargebacks | Reverse the original entry plus record the chargeback fee separately |
| = Net payout deposited | This is what hits your bank account — not your revenue |
The overseas CA team reconciles each Shopify payout report against the Finance Summary in your Shopify admin panel. For stores with high volume, this is done weekly rather than monthly to catch discrepancies early. The same gross-up methodology applies to Amazon Seller Central, Etsy, and any other marketplace that pays net of fees.
Amazon FBA — Additional Bookkeeping Layers
Canadian e-commerce businesses selling through Amazon FBA (Fulfillment by Amazon) face bookkeeping complexity that exceeds a standard Shopify-only store. Amazon's monthly settlement statement includes dozens of line items that each require separate coding:
- Product sales and credits: Gross product revenue — coded as income
- Amazon referral fees (8%–15%): Platform commission — coded as a selling expense
- FBA fulfillment fees: Per-unit pick/pack/ship charge — coded as fulfilment cost or COGS
- FBA storage fees: Monthly inventory storage — coded as warehouse/storage expense
- Shipping credits and charges: Some product categories carry shipping credits that must be reconciled
- Promotional rebates: Discounts Amazon applies on your behalf — reduce revenue, not an expense
- Disposal and removal fees: FBA inventory removal — coded as a cost of goods or write-off
- GST/HST collected by Amazon: Amazon collects and remits GST/HST on Canadian sales in some provinces — track carefully to avoid double-reporting
- US state sales tax (if selling to US): Amazon collects US state tax through marketplace facilitator rules — but the seller must still track their exposure and file correctly in states where Amazon's facilitation does not cover all obligations
An overseas CA firm familiar with Amazon FBA sets up a dedicated chart of accounts for FBA-specific costs and reconciles the monthly settlement statement line by line — typically a 4–6 hour task per month that most bookkeepers who are not FBA-experienced charge additional rates for.
Inventory COGS — The Most Frequently Wrong Number in E-Commerce Books
Shopify shows you inventory quantities. It does not calculate your cost of goods sold correctly for accounting purposes. The common errors:
- Recording inventory purchases as an expense at purchase: Incorrect — inventory is an asset until sold. Purchases must go to inventory on the balance sheet, then to COGS only when the unit is sold
- Using Shopify's cost-per-item field as COGS: Shopify's cost field does not include inbound freight, customs duties, or landed cost — all of which are part of COGS under CRA-compliant accounting
- Ignoring unsold inventory at year-end: Year-end inventory must be counted and valued at the lower of cost or net realisable value. Failing to capture this inflates COGS and reduces taxable income — a red flag in a CRA audit
- Not separating fulfilment costs from COGS: Third-party fulfilment (Shipbob, Amazon FBA, local 3PL) costs are sometimes coded to COGS and sometimes to operating expenses — the method must be consistent and documented
An overseas CA firm builds a proper inventory reconciliation model for your store — typically in a Google Sheet that feeds into QuickBooks or Xero — so the COGS figure in your financial statements reflects actual unit costs, landed costs, and units sold, not just what left your bank account.
Cross-Border US Sales — When You Need to Think About US Tax
Canadian e-commerce sellers shipping to US customers are zero-rated for Canadian GST/HST. But the US side introduces separate obligations:
| US Sales Volume (by state) | Likely Obligation | Bookkeeping Action |
|---|---|---|
| Under US$100,000 / 200 transactions in any state | Usually no US nexus (pre-Wayfair threshold) | Track state-by-state sales monthly to monitor approach |
| Above threshold in states like CA, NY, TX, FL | Economic nexus — may need to register and remit state sales tax | Flag for CPA; track state-by-state gross revenue separately |
| Selling on Amazon (US) | Marketplace facilitator rules — Amazon collects and remits state tax | Confirm per-state facilitation; record Amazon-remitted tax separately |
| Selling via own Shopify store to US | Shopify can collect US state tax if configured — but only if the seller has registered in those states | Review Shopify Tax settings; confirm registration before enabling collection |
The overseas bookkeeper's role is to track US sales by state so the CPA or tax advisor can assess nexus exposure — not to prepare US state returns directly. But having clean state-by-state revenue records makes the US sales tax analysis straightforward rather than a reconstruction exercise.
What Overseas E-Commerce Bookkeeping Costs
| Store Size / Volume | Monthly Hours | Local (C$45/hr avg) | Overseas (C$14/hr avg) | Annual Saving |
|---|---|---|---|---|
| Small (under C$250K, Shopify only) | 10–18 hrs | C$450–C$810 | C$140–C$252 | C$3,720–C$6,696 |
| Mid-size (C$250K–C$1M, Shopify + Amazon) | 18–35 hrs | C$810–C$1,575 | C$252–C$490 | C$6,696–C$13,020 |
| High volume (C$1M–C$3M, multi-channel FBA) | 35–60 hrs | C$1,575–C$2,700 | C$490–C$840 | C$13,020–C$22,320 |
| Enterprise (C$3M+, international, multi-currency) | 60–100 hrs | C$2,700–C$4,500 | C$840–C$1,400 | C$22,320–C$37,200 |
These figures cover platform reconciliation (Shopify, Amazon FBA, Etsy), payment processor reconciliation (Stripe, PayPal, Shopify Payments), inventory COGS tracking, GST/HST liability reconciliation, and monthly P&L with gross margin broken out by channel. Nothing extra at the overseas rate for standard e-commerce tasks.
Software Setup — What an Overseas CA Firm Uses for Canadian E-Commerce
The overseas team works in cloud-based accounting software with integrations to your platforms. No physical access is required:
- QuickBooks Online Canada: Native Canadian HST/GST tax filing, Shopify and Amazon integrations via A2X or OneSaas, supported by most Canadian CPAs at year-end
- Xero: Strong Shopify integration, multi-currency support for stores selling in USD and CAD, good for cross-border sellers
- Wave (free): Suitable for simple Shopify-only stores under C$500K with no Amazon FBA — lacks the automation that reduces bookkeeping hours at scale
- A2X: Automated Shopify and Amazon settlement reconciliation tool that grosses up net payouts and codes line items into QuickBooks or Xero — reduces reconciliation time by 70–80% for mid-to-high volume stores
- Dext / Hubdoc: Receipt and invoice capture for inventory supplier invoices — photos or emails to a capture address, auto-coded and pushed to the accounting software
- Google Sheets: Custom inventory COGS model when the platform's built-in inventory is insufficient for proper COGS calculation
Written by Sharma Jyoti, CA (ICAI) — Founder, Sharma Jyoti and Co. We are an ICAI-registered Chartered Accountant firm providing overseas bookkeeping to Canadian e-commerce businesses across Shopify, Amazon FBA, Etsy, and WooCommerce. Learn more about our firm →
Related Reading