If you’re running an online store — whether on Shopify, Amazon, Etsy, or WooCommerce — chances are your bookkeeping is either a mess or an afterthought. You’re not alone. Ecommerce bookkeeping is one of the most misunderstood areas of small business finance, and getting it wrong can cost you thousands at tax time — not just in penalties and missed deductions, but in poor business decisions made from ambiguous financial numbers and inaccurate reports. Messy books don’t just hurt at filing time; they leave you flying blind all year long.
This guide breaks down everything Canadian ecommerce sellers need to know about keeping clean books.
Why Ecommerce Bookkeeping Is Different
Traditional bookkeeping assumes simple transactions: customer pays, money hits bank, done. Ecommerce is messier:
- Sales happen across multiple platforms with different payout schedules
- Platform fees, refunds, and chargebacks are deducted before you even see the money
- You may be selling to customers in different provinces — or different countries
- Inventory can span warehouses, your home, and third-party fulfillment centres like Amazon FBA
- Payment processors like Stripe, PayPal, and Shopify Payments hold funds and release them on their own schedule
If you’re just recording what hits your bank account, you’re already doing it wrong.
Ecommerce Bookkeeping Requires More Than Just Accounting Knowledge
Here’s something most sellers don’t realize until they’re deep in it: ecommerce bookkeeping requires not only dexterity and sound proficiency in accounting, but also advanced Excel and data analysis skills. It is genuinely incomplete without either one.
Excel is your friend here whether you like it or not. You will be expected to pull scores of different reports — multiple times and across different periods — just to extract useful insight. Sales by platform, refunds by SKU, fees by month, inventory movement by quarter — the data is all there, but it doesn’t organize itself. You need to know how to work with it: pivot tables, VLOOKUPs, conditional formatting, and multi-sheet reconciliations are not optional extras in this domain, they are the job.
If you’re not used to this level of drill-down analysis, chances are you need to be looking for outside help. A bookkeeper who only understands debits and credits but can’t navigate a raw Shopify or Amazon data export is only half-equipped for ecommerce work.
The Big Ecommerce Bookkeeping Challenges
1. Platform Payouts Are Not Your Revenue
This is the most common mistake. When Shopify or Amazon deposits money into your account, that deposit is not your gross revenue — it’s your revenue minus fees, refunds, and other deductions.
What you need to record:
- Gross sales (the full amount the customer paid)
- Platform fees separately (Shopify subscription, Amazon referral fees, etc.)
- Refunds and returns separately
- Payment processing fees (Stripe, PayPal, etc.)
Recording only the deposit understates your revenue and misrepresents your expenses.
2. GST/HST Gets Complicated Fast
In Canada, your GST/HST obligations depend on where your customer is located, not where you are.
- Selling to an Alberta customer? 5% GST
- Selling to an Ontario customer? 13% HST
- Selling to a BC customer? 12% HST
- Selling to a customer in the US or internationally? Generally zero-rated (0%)
If you’re registered for GST/HST and selling across provinces, you need to track the tax collected by province — not just lump it all together.
Registration threshold: Once your worldwide taxable sales exceed $30,000 in a calendar year (or four consecutive quarters), you must register for GST/HST. Many ecommerce sellers hit this faster than they expect.
3. Inventory Tracking
Inventory is an asset, not an expense — until it’s sold. That means you can’t just expense your entire inventory purchase the moment you buy it.
Cost of Goods Sold (COGS) formula:
Opening Inventory + Purchases − Closing Inventory = COGS
Accurate inventory records are essential for:
- Correct profit calculation
- Accurate tax filing
- Knowing if your business is actually making money
For Amazon FBA sellers, this gets extra complicated because Amazon is holding your inventory and fees can include storage, fulfillment, and disposal charges — all of which need to be categorized correctly.
4. Multi-Currency Transactions
Selling in USD, GBP, or EUR? CRA requires you to report everything in Canadian dollars using the exchange rate at the time of the transaction (or you can use the Bank of Canada annual average rate for simplicity).
Ignoring currency conversion is a common audit trigger.
5. Month-End Reconciliation Is Harder Than It Looks
Month-end reconciliation in ecommerce is not a simple bank match. One of the most persistent headaches is distinguishing orders placed in one month from those placed in another — especially when payment is captured at a different time than the order date, or when refunds cross month boundaries.
This can only be done accurately by pulling and cross-referencing Excel reports from your platform — order exports, settlement reports, refund logs — and mapping them period by period. A single month-end close might require pulling five or six different reports, combining them in Excel, and reconciling line by line to make sure revenue, fees, and refunds are booked in the right period. If your bookkeeper isn’t doing this, your monthly financials are likely off in ways you won’t notice until tax time.
6. Payment Processor Timing
Stripe, PayPal, and Shopify Payments don’t pay you instantly. There are holds, rolling reserves, and payout delays. This creates a difference between when a sale happens and when cash hits your account — known as timing differences.
Your books need to reflect the sale date, not the deposit date.
Key Accounts to Set Up in Your Chart of Accounts
| Account | What Goes Here |
| Sales Revenue | Gross sales across all platforms |
| Returns & Allowances | Refunds issued to customers |
| Platform Fees | Shopify, Amazon, Etsy, eBay fees |
| Payment Processing Fees | Stripe, PayPal, Square fees |
| Cost of Goods Sold | Cost of inventory sold |
| Shipping Expense | Postage, courier costs |
| Advertising | Facebook Ads, Google Ads, influencer costs |
| Inventory Asset | Value of unsold inventory on hand |
| GST/HST Payable | Tax collected, owing to CRA |
| GST/HST Recoverable | Input tax credits (ITCs) you can claim back |
Tools That Work Well for Ecommerce Bookkeeping
- QuickBooks Online — integrates with Shopify, Amazon, PayPal
- Xero — popular with ecommerce sellers, strong multi-currency support
- A2X — specialized app that summarizes platform payouts properly before pushing to QBO or Xero (highly recommended for Amazon and Shopify sellers)
- Dext (formerly Receipt Bank) — for capturing receipts and supplier invoices
The biggest mistake sellers make is connecting Shopify directly to QuickBooks without A2X or a similar tool — the data comes in messy and requires significant cleanup.
What You Can Deduct as an Ecommerce Seller
As a Canadian ecommerce business, you can deduct:
- Cost of goods sold — your product costs
- Platform and marketplace fees — Amazon, Shopify, Etsy subscriptions and commissions
- Shipping and packaging — postage, boxes, tape, labels
- Advertising — paid ads, influencer fees, promoted listings
- Home office — if you run the business from home (proportional square footage)
- Phone and internet — business use portion
- Software subscriptions — your ecommerce tools, bookkeeping software
- Bank and payment processing fees
- Professional fees — bookkeeper, accountant fees (yes, this one too!)
Common Mistakes That Cost Ecommerce Sellers Money
- Recording deposits as revenue instead of gross sales
- Not tracking inventory properly — leads to wrong COGS and wrong profit
- Missing GST/HST registration once the $30,000 threshold is hit
- Not reconciling platform statements — Amazon and Shopify settlements should be reconciled monthly
- Mixing personal and business expenses — always use a dedicated business account and card
- Ignoring input tax credits (ITCs) — you can claim GST/HST back on business purchases
When Should You Hire an Ecommerce Bookkeeper?
If any of these apply to you, it’s time:
- You’re spending more than 2-3 hours a month on bookkeeping
- You have no idea what your actual profit margin is
- Tax season is a scramble every year
- You’re selling on more than one platform
- Your revenue has crossed or is approaching $30,000
A good ecommerce bookkeeper pays for itself — in tax savings, cleaner financials, and your time back.
Final Thoughts
Ecommerce bookkeepers don’t just do data entry — they also understand how platforms pay out, how Canadian tax rules apply to online sales, and how to track inventory and fees correctly. Getting this right from the start means better decisions, fewer CRA surprises, and a business that actually knows if it’s profitable.
If you’re an online seller in Edmonton or anywhere in Alberta and need help getting your books cleaned up or set up properly, Markham Bookkeeping specializes in exactly this. Reach out for a free consultation.
