Table of Contents
- Why Bookkeeping Mistakes Hit E-Commerce Sellers Harder
- Mixing Personal and Business Finances
- Not Reconciling Platform Payouts Against Bank Deposits
- Ignoring Hidden Platform Fees and Payment Processor Deductions
- Misclassifying Cost of Goods Sold vs Operating Expenses
- Poor Inventory Tracking and Valuation
- Missing Multi-Province Sales Tax Obligations
- Failing to Account for Returns, Refunds, and Chargebacks
- Manual Spreadsheets vs Month-End Accounting Integration
- Frequently Asked Questions
- Stop Losing Money — Get Your Books Fixed
Why Bookkeeping Mistakes Hit E-Commerce Sellers Harder
E-commerce bookkeeping mistakes in Canada are not just an inconvenience — they directly erode your profits, inflate your tax bill, and increase your risk of a CRA audit. Unlike a traditional brick-and-mortar business with a single point of sale and one bank deposit per day, online sellers deal with multiple sales platforms, several payment processors, complex shipping cost structures, hidden platform fees, and multi-province sales tax rules — all generating thousands of micro-transactions every month.
Research suggests that up to 86% of small e-commerce sellers find bookkeeping challenging, and the average cost of a single tax filing error is around $1,700. Multiply that across several years of uncorrected mistakes and the financial damage can reach tens of thousands of dollars — money that should have stayed in your business.
Whether you sell on Shopify, Amazon, Faire, TikTok Shop, or a combination of platforms, this guide breaks down the most common and costly ecommerce bookkeeping mistakes Canadian online sellers make, what each one costs you, and how to fix them. If you would rather have a professional handle your books from the start, BBA Tax’s e-commerce accounting services are built specifically for multi-platform Canadian sellers.
Mistake #1: Mixing Personal and Business Finances
This is the most fundamental bookkeeping mistake and the one that causes the most downstream problems. When you pay for inventory on a personal credit card, deposit Shopify payouts into your personal chequing account, or use the same PayPal account for business and personal purchases, every financial statement you produce is contaminated.
What it costs you: Your accountant spends hours separating personal from business transactions at year-end, increasing your accounting fees by $500 to $2,000 or more. Worse, the CRA views comingled accounts as a sign of poor recordkeeping and it significantly increases your audit risk. If audited, you will need to justify every transaction — and personal purchases mixed in with business expenses can result in disallowed deductions and penalties.
How to fix it: Open a dedicated business bank account and a separate business credit card. Route all platform payouts — from Shopify, Amazon, Faire, Stripe, PayPal, Square, and Wise — into the business account. Pay all business expenses from that account. This single change simplifies everything else on this list. For a detailed walkthrough, see our guide on how to separate personal and business expenses.
Mistake #2: Not Reconciling Platform Payouts Against Bank Deposits
This is the mistake that separates e-commerce bookkeeping from traditional small business bookkeeping. When you sell a product on Shopify for $100, the $100 does not land in your bank account. Shopify deducts payment processing fees (typically 2.4% to 2.9% plus $0.30 per transaction), and the net payout — say $96.80 — arrives in your bank two to three business days later. If you use third-party processors like Stripe, PayPal, Affirm, or Klarna, each one takes its own cut before depositing funds.
Many sellers record the bank deposit amount as their revenue, which understates gross sales and hides the true cost of payment processing. Others record the gross sale amount but never account for the processor fees, resulting in a bank balance that never matches the books.
What it costs you: Inaccurate revenue figures, incorrect GST/HST calculations, missed deductions on processing fees, and financial statements that do not reflect reality. Over a year with $200,000 in sales, unreconciled processing fees alone could mean $5,000 to $6,000 in missed deductions.
How to fix it: At month-end, pull settlement reports from each platform and payment processor — Shopify, Amazon Seller Central, Faire, TikTok Shop, Stripe, PayPal, Square, Affirm, Klarna, Wise — and reconcile them against your bank deposits. The gross sales, platform fees, processing fees, and net payout should all be recorded as separate line items in QuickBooks. At BBA Tax, this month-end reconciliation process is exactly how we handle e-commerce bookkeeping for our clients — ensuring every dollar matches.
Mistake #3: Ignoring Hidden Platform Fees and Payment Processor Deductions
E-commerce platforms are filled with fees that many sellers never realize they are paying — and therefore never deduct on their tax returns. These hidden costs are buried in settlement reports, deducted before payouts, or charged separately on monthly statements.
Here are the most commonly missed fees across the major platforms and processors:
| Platform / Processor | Hidden or Overlooked Fees | Typical Annual Cost (on $200K revenue) |
|---|---|---|
| Shopify | Transaction fees, app subscriptions, Shopify Payments processing, theme purchases | $3,000 – $6,000 |
| Amazon Seller Central | Referral fees (8-15%), FBA fulfillment fees, FBA storage fees, advertising (PPC) fees | $25,000 – $45,000 |
| Faire | Commission on first orders (25%), commission on reorders (15%), payment processing | $8,000 – $20,000 |
| TikTok Shop | Commission fees (varies), advertising spend, payment processing | $2,000 – $10,000 |
| Stripe | Per-transaction fees (2.9% + $0.30), currency conversion fees, dispute fees | $5,800 – $6,200 |
| PayPal | Transaction fees (2.9% + $0.30), currency conversion, chargeback fees ($20 each) | $5,800 – $6,200 |
| Affirm / Klarna | Merchant fees on BNPL transactions (typically 2-8% per transaction) | $1,000 – $5,000 |
| Square | Per-transaction fees (2.65%), hardware lease fees, software subscription | $5,300 – $5,800 |
| Wise | Currency conversion fees, transfer fees | $500 – $2,000 |
What it costs you: Every one of these fees is a deductible business expense. If you are not tracking and categorizing them, you are overpaying on income tax and missing GST/HST input tax credits. On $200,000 in revenue, untracked platform and processor fees could easily represent $10,000 or more in missed deductions.
How to fix it: Download detailed settlement and fee reports from every platform and processor monthly. Your accountant should categorize each fee type separately in QuickBooks — platform commissions, processing fees, advertising fees, storage fees — rather than lumping everything together. This gives you accurate profitability data by channel and maximizes your deductions.
Mistake #4: Misclassifying Cost of Goods Sold vs Operating Expenses
Cost of goods sold (COGS) and operating expenses are both deductible, but they appear in different places on your financial statements and affect your gross profit margin differently. Many e-commerce sellers lump everything together, which distorts their profitability analysis and raises questions during audits.
COGS includes the direct costs of acquiring or producing products: wholesale purchase prices, raw materials, manufacturing costs, import duties, customs brokerage, inbound shipping, and per-unit packaging materials. Operating expenses include everything else: Shopify subscription fees, advertising, office supplies, accounting fees, insurance, and general overhead.
What it costs you: Misclassification does not change your total deductions, but it makes your gross margin appear either artificially high or artificially low. If your reported gross margin is significantly different from industry norms, it can trigger CRA scrutiny. It also makes it impossible for you to accurately assess which products are profitable and which are losing money.
How to fix it: Set up a proper chart of accounts in QuickBooks with clear separation between COGS categories and operating expense categories. Amazon FBA fulfillment fees are COGS. Your Shopify subscription is an operating expense. Packaging used for individual shipments is COGS. Your Canva subscription is an operating expense. If you are unsure how to classify a specific cost, consult with an accountant who specializes in e-commerce.
Mistake #5: Poor Inventory Tracking and Valuation
Inventory is often the largest asset on an e-commerce seller’s balance sheet, yet many sellers have no real system for tracking it. They do not know the exact cost of each unit, they do not account for inventory shrinkage or damage, and they do not perform regular inventory counts to verify that their books match reality.
What it costs you: Inaccurate inventory valuation directly affects your COGS calculation, which affects your reported profit. Overvalued inventory means understated COGS, which means you report higher profit and pay more tax than necessary. The CRA requires you to use a consistent valuation method (FIFO or weighted average) and can reassess your tax if they find your inventory records are unreliable.
How to fix it: Choose an inventory valuation method and stick with it. Track all incoming inventory at the true landed cost — including product price, shipping, duties, and customs fees. If you sell on multiple platforms (Shopify, Amazon FBA, Faire), make sure inventory counts are reconciled across all channels. For sellers using Amazon FBA, download monthly inventory reports and reconcile them against your accounting records. Inventory storage fees charged by Amazon or third-party warehouses should also be tracked and deducted.
Mistake #6: Missing Multi-Province Sales Tax Obligations
Canada’s sales tax system is complex enough for a traditional business. For e-commerce sellers shipping to customers in every province, it becomes a minefield. Many sellers either do not register for GST/HST when they should, charge the wrong provincial rate, or fail to account for marketplace facilitator rules on platforms like Amazon.
What it costs you: Failing to register for GST/HST when required results in retroactive assessments — you owe the CRA tax on past sales that you never collected from customers. Charging the wrong rate can result in both over-collection (which creates a liability to customers) and under-collection (which you owe out of pocket). Penalties for late or incorrect filing start at 1% of the amount owing plus 0.25% per month.
How to fix it: Track your cumulative taxable revenue across all platforms. Register for GST/HST before you hit the $30,000 threshold. Configure your Shopify tax settings correctly for every province. If you also sell on Amazon (marketplace facilitator) and Faire (wholesale/B2B), understand the different reporting requirements for each channel. For a complete walkthrough, read our guide on GST/HST for Shopify stores in Canada. BBA Tax handles GST/HST filing for e-commerce clients across all provinces.
Mistake #7: Failing to Account for Returns, Refunds, and Chargebacks
E-commerce return rates typically run between 15% and 30% depending on the product category. Each return affects multiple parts of your books: revenue decreases, inventory increases (if the product is restocked), shipping costs may not be recoverable, and the payment processor often keeps its original transaction fee. Chargebacks from Stripe, PayPal, or Affirm add another layer — with dispute fees of $15 to $25 per incident on top of the reversed payment.
What it costs you: If returns are not tracked separately, your revenue figures are overstated, your COGS is incorrect (because returned inventory is back in stock but not reflected in your books), and your tax liability is higher than it should be. On $200,000 in sales with a 20% return rate, that is $40,000 in refunds that must be properly accounted for.
How to fix it: Record returns, refunds, and chargebacks as separate line items — not just as negative revenue entries mixed in with regular sales. Track the reason for each return (defective, wrong item, customer preference) to identify patterns. Reconcile refund totals from each platform against your actual bank account refund transactions. Chargeback fees from payment processors should be categorized as a separate expense in QuickBooks.
Manual Spreadsheets vs Month-End Accounting Integration
Many e-commerce sellers start with manual spreadsheets to track their finances. While this might work for the first few months, it quickly becomes unsustainable as transaction volume grows. A single Amazon settlement report can contain thousands of line items. Manually entering Shopify payouts, Stripe fees, Faire commissions, and PayPal deposits into a spreadsheet every month is not just tedious — it is a guarantee of errors.
At BBA Tax, we take a practical approach that does not require expensive API integrations or complex software setups. At the end of each month, we pull your sales data, settlement reports, and fee breakdowns from each platform — Shopify, Amazon, Faire, TikTok Shop — along with payout reports from your payment processors like Stripe, PayPal, Square, Affirm, Klarna, and Wise. We reconcile everything and enter it into QuickBooks Online so that your revenue, fees, COGS, and net deposits all match. The result is clean, accurate financial statements delivered monthly — not a year-end scramble.
| Approach | Pros | Cons |
|---|---|---|
| Manual spreadsheets | Low upfront cost, full control | Error-prone, time-consuming, unsustainable at scale, no real-time visibility |
| Fully automated API tools (A2X, Dext Commerce) | Real-time sync, less manual work | Monthly subscription costs ($50-$200+/mo), requires setup and monitoring, can miscategorize transactions |
| Month-end accounting integration (BBA Tax approach) | Accurate, verified data in QBO, professional oversight, catches errors before they compound | Not real-time (monthly cycle), requires working with an accountant |
The right approach depends on your volume, complexity, and budget. For most Canadian e-commerce sellers doing $50,000 to $500,000 in annual revenue across one to three platforms, month-end accounting integration with a dedicated e-commerce accountant offers the best balance of accuracy, cost, and peace of mind.
Frequently Asked Questions
How often should I reconcile my e-commerce books?
Monthly is the minimum. Waiting until year-end to reconcile a full year of transactions across multiple platforms is extremely difficult and expensive. Monthly reconciliation catches errors early and gives you up-to-date financial visibility to make business decisions.
Can I do my own e-commerce bookkeeping or do I need an accountant?
You can do it yourself if you have a single platform, low transaction volume, and a strong understanding of accounting principles. Once you sell on multiple platforms (Shopify, Amazon, Faire), use several payment processors (Stripe, PayPal, Affirm), and need to file GST/HST across multiple provinces, the complexity usually justifies working with a professional.
What is the difference between a payout and revenue?
Revenue is the total amount your customers paid for your products. A payout is the net amount that lands in your bank account after the platform and payment processor deduct their fees. Your books should record both — the gross revenue and the fees — not just the payout amount.
Are Amazon FBA storage fees deductible?
Yes. Amazon FBA storage fees, fulfillment fees, referral fees, and advertising (PPC) fees are all deductible business expenses. They are also eligible for GST/HST input tax credits if you are registered. Make sure your accountant is extracting these from your Amazon settlement reports and recording them separately in your books.
How does BBA Tax handle multi-platform bookkeeping?
We gather settlement reports and sales data from each of your platforms at month-end — Shopify, Amazon, Faire, TikTok Shop — along with payout data from Stripe, PayPal, Square, Affirm, Klarna, and Wise. We reconcile all of it against your bank deposits and enter the verified data into QuickBooks Online. The result is clean books with accurate revenue, fees, COGS, and tax figures — ready for GST/HST filing and year-end tax preparation.
What happens if I have years of messy books?
It is never too late to get organized. BBA Tax offers catch-up bookkeeping services where we reconstruct your financial records from bank statements, platform reports, and whatever documentation you have. The sooner you clean up your books, the lower your risk of CRA penalties and the more deductions you can recover.
Do buy-now-pay-later platforms like Affirm and Klarna affect my bookkeeping?
Yes. When a customer uses Affirm or Klarna at checkout, the BNPL platform pays you the full purchase price (minus their merchant fee) and then collects installments from the customer. You need to record the full sale as revenue and the BNPL merchant fee as a separate expense. The fee is deductible and also eligible for GST/HST input tax credits.
Stop Losing Money — Get Your Books Fixed
Every mistake on this list has a direct cost — either in overpaid taxes, missed deductions, CRA penalties, or simply the time and stress of wrestling with messy books. The good news is that every one of these mistakes is fixable, and the sooner you address them, the more money stays in your business.
At BBA Tax, we work with e-commerce sellers across Canada who sell on Shopify, Amazon, Faire, TikTok Shop, and other platforms. We handle monthly bookkeeping with proper month-end reconciliation into QuickBooks, GST/HST filing across all provinces, corporate tax preparation, and CRA audit defense. Whether you need to clean up years of messy records or set up proper systems from day one, we have you covered.
📞 Contact BBA Tax today for a free consultation and find out how much cleaner books could save your e-commerce business.
