Does this sound like you?
Before the software picks and the tax rules, a quick reality check. If two or more of these describe you right now, this guide was written for you.
- You opened your Shopify, Etsy, or Amazon dashboard this morning and felt good about the revenue number, but you actually have no idea what your profit was.
- Your money sits in five places at once — Stripe, PayPal, Shopify Payments, your bank, and unsold inventory — and you can't tell what's actually yours.
- You crossed $30,000 in revenue and you're not sure if you should have registered for GST/HST by now.
- You spend 2+ hours every Sunday night categorising transactions in a spreadsheet and you hate it.
- Your accountant asked for your books at tax time and you panicked.
- You've heard the phrase "profitable but broke" and you're worried it's about to describe you.
- You sell on more than one platform and the numbers never reconcile.
- You bought a $4,000 laptop for the business and you have no idea if you can claim the GST back.
If any of those land, you are exactly the size of online seller this guide is for. The rest of it is the plain-language version of the conversation we have with new e-commerce clients every week.
What is e-commerce bookkeeping?
E-commerce bookkeeping is the systematic recording of every transaction in your online business — sales, fees, refunds, inventory, shipping, payment processor deposits, and tax. It is different from traditional small-business bookkeeping because your money flows through 3–5 platforms before it reaches your bank account, and your revenue is not the same as your cash.
Done well, it gives you a single number for monthly profit, a clean GST/HST filing, and an answer to the question every online seller asks: which products actually make money? Done badly — and most online sellers do it badly at first — it produces a Shopify dashboard that looks great while your bank account quietly shrinks.
Why your online store books matter more than you think
Your accounting is not paperwork for tax time. It is your business dashboard. You need to know whether that hero product is actually profitable after fees. You need to see which marketing channel brings buyers, not just clicks. You need to understand cash flow, because making sales and having cash are two different things.
Most online sellers do not realise they are flying blind. They see revenue numbers from Shopify and think they know how the business is doing. They do not. They do not see where the leaks happen — processor fees, marketing waste, slow-moving inventory, returns. They cannot answer simple questions like "did I make more money this month than last?"
Good bookkeeping gives you that clarity. It shows you the real picture. It lets you make decisions based on facts, not guesses.
The three numbers every online seller must track
Revenue, expenses, profit. Simple math; most online sellers miss the details.
- Revenue is not just sales. It includes taxes you collected from customers (which are not yours), shipping fees, and gross sales before refunds. Net revenue = gross sales minus refunds minus sales tax collected.
- Expenses are everything you spend to keep the business running: inventory, shipping supplies, payment processor fees, marketing, software subscriptions, warehouse, returns processing.
- Profit is what is actually left. A $50,000 revenue month sounds great until you realise expenses were $48,000. Now you made $2,000. That changes how you feel about the month.
Good bookkeeping breaks this down so you see what is real. You will know exactly which products are money-makers and which are drains.
Cash flow vs profit: why your bank account feels confused
Here is where online sellers get tripped up. You can be profitable and broke at the same time. It happens because of timing.
You buy $10,000 of inventory today. You sell it across the next three months. Your profit spreads across three months. Your cash went out today. You can show $15,000 in profit on paper while $3,000 sits in the bank — because the rest is on a pallet in your basement.
Good bookkeeping shows you both numbers: profit for business decisions, cash flow for survival decisions. In BC, plenty of online sellers have grown revenue to six figures while feeling constantly cash-strapped because nobody explained this difference.
Setting up the right accounting system from day one
You have four options. Spreadsheets. Free software (Wave). Paid software (QuickBooks Online, Xero). Or hire someone.
Most online sellers start with spreadsheets because it feels cheaper. They hit a wall around $50,000–$100,000 in revenue. Suddenly they cannot manage multiple payment processors, inventory changes, and tax obligations in a spreadsheet. Now they need to migrate — and migration with messy data is expensive.
E-commerce-aware accounting software is worth the investment from day one. It pulls data from your payment processors automatically. It tracks inventory. It calculates GST/HST. It generates reports that actually make sense. QuickBooks Online for a small BC online business runs about $30–$50/month. That is less than one chargeback fee. The software pays for itself in time saved.
Start with the right system now. Switching later costs time and creates messy data.
How to handle payment processors in your books
When a customer buys from your store, the money does not appear in your bank account instantly. It flows through a payment processor first. Stripe, PayPal, Shopify Payments, Square — they all take a percentage. They also hold money temporarily before payout.
Typical 2026 Canadian rates:
- Stripe (Canada): 2.9% + $0.30 per domestic card transaction
- PayPal (Canada): 2.9% + $0.30 per transaction
- Shopify Payments: 2.4–2.9% depending on your Shopify plan, no per-transaction fee on most plans
- Square: 2.65% for in-person, 2.9% + $0.30 online
Across 10,000 transactions, those fees are thousands of dollars. They are legitimate business expenses. They need to go on your books — not ignored or treated as a year-end surprise.
Good bookkeeping captures these automatically. Your accounting software integrates with your processors. You see gross sales, fees deducted, refunds, and the net deposit hitting your bank account. No surprises.
GST, HST, and PST for Canadian online sellers
Canadian online sellers have specific tax obligations. They are the single most common compliance gap we see in BC e-commerce.
- GST/HST: Mandatory once you cross $30,000 in worldwide taxable revenue across any single calendar quarter or four rolling quarters. You collect from customers, hold it in trust, and remit to the CRA. You can also claim back GST/HST on business purchases (input tax credits).
- BC PST (7%): Required if you sell or lease taxable goods in BC. PST is filed separately through eTaxBC, not the CRA. You CANNOT claim back PST you paid on inputs.
- Marketplace tax: Amazon, Etsy, and eBay collect and remit GST/HST on your behalf for most Canadian sales. Shopify does NOT — you handle GST/HST yourself.
If you do not track sales tax separately, you create chaos. You think you made $50,000, but $5,000 of that is tax you owe the CRA. You spend the money. Then the bill arrives.
Your bookkeeping system must separate tax collected from actual revenue. It must track input tax credits. It must generate reports showing exactly what you owe CRA and eTaxBC each filing period. Getting this wrong is expensive.
Red flags that your current bookkeeping is not working
- If two or more of these describe you, your system is broken — and the fix is not complicated:You spend more than 2–3 hours per month on bookkeeping.
- You cannot tell us your monthly profit without doing manual math.
- You cannot answer questions about your business without checking multiple spreadsheets.
- Your accountant says your records are a mess at tax time.
- You've missed a payment processor reconciliation or been surprised by a Stripe holdback.
- You cannot accurately track inventory costs.
- You have no idea which products are profitable after fees.
- You sell on 2+ platforms and the numbers never reconcile.
Most online sellers hit one of these problems between $50,000 and $100,000 in revenue. That is when spreadsheets stop scaling. The fix: automated bookkeeping. Software that talks to your payment processors. Reports you can actually read. Someone who understands e-commerce accounting.
Your first steps: this week, this month, this quarter
This week
- Open a separate business bank account if you have not already. Stop mixing personal and business money.
- Sign up for QuickBooks Online or Wave. Both work for e-commerce sellers.
- Spend two hours setting up basic chart-of-accounts categories.
This month
- Connect your payment processors to your accounting software (Stripe, Shopify Payments, PayPal).
- Set up GST/HST tracking with separate sub-accounts for tax collected and tax paid.
- Get organised about receipts. Use Dext, Hubdoc, or your software's built-in scanner.
This quarter
- Run a full profit-and-loss review. Look at your numbers.
- Ask yourself: what is working? What is leaking?
- If you cannot read your reports, book a call with a bookkeeper who understands e-commerce oe Book a call with us to discuss your requirements and we will help you manage your book
Frequently asked questions about e-commerce bookkeeping
What is e-commerce bookkeeping?
E-commerce bookkeeping is the systematic tracking of every transaction in your online business — sales, fees, refunds, inventory, shipping, payment processor deposits, and sales tax. It is more complex than traditional small-business bookkeeping because money flows through 3–5 platforms before it reaches your bank.
How much does e-commerce bookkeeping software cost in Canada?
Free options like Wave cover basic e-commerce. Paid software (QuickBooks Online, Xero) starts around $30/month for the entry tier and runs to $80/month for Advanced. Most BC online sellers under $1M in revenue land on QuickBooks Online Essentials or Plus.
Do I need to register for GST/HST as an online seller?
Yes, once you cross $30,000 in worldwide taxable revenue over any single calendar quarter or the previous four rolling quarters. Below that, registration is voluntary — and often worth doing if you sell to other businesses or have major equipment purchases to recover GST on.
Does Shopify file my sales tax?
No. Shopify provides reports but does not file or remit GST/HST or PST for you. You file. Marketplaces like Amazon, Etsy, and eBay DO collect and remit GST/HST on most Canadian sales on your behalf — but you are still responsible for your own books.
How do I do bookkeeping for a Shopify store?
Connect Shopify to QuickBooks Online or Xero through an integration like A2X or Synder. The integration imports your daily sales, fees, refunds, and payouts as journal entries that match your bank deposits. You then reconcile monthly. This is the cleanest workflow for stores doing $5,000+/month.
Should I do my own e-commerce bookkeeping?
Up to roughly $5,000/month in revenue and one sales channel, DIY is fine if you set up the right software. Beyond that — multi-channel selling, inventory tracking, GST/HST registration, or 50+ transactions a month — the cost of professional bookkeeping is usually less than the cost of decisions made on bad data.
What is the difference between profit and cash flow?
Profit is what your business earned after expenses. Cash flow is when the money actually moves. You can have $15,000 in monthly profit but only $3,000 in the bank because the rest is tied up in inventory. Both numbers matter. Profit tells you whether the business model works. Cash flow tells you whether you can pay rent next month.
How often should I do e-commerce bookkeeping?
Reconcile payment processor payouts and bank deposits weekly. Categorise transactions weekly or use a daily auto-categorisation rule. Run a monthly profit-and-loss review on the 5th of the following month. Year-end review starts in mid-November, not December 31.
When to talk to us
If two or more of these describe your e-commerce business, professional bookkeeping is almost always cheaper than DIY:
- Revenue is over $5,000/month and growing.
- You sell on more than one platform (Shopify + Amazon, Etsy + Shopify, etc.).
- You crossed $30,000 in revenue and have not registered for GST/HST.
- You spend 5+ hours a month on books and the numbers still feel off.
- You don't know which SKUs are actually profitable.
- Tax season makes your stomach drop.
- You have inventory that has not been counted since you started.
Fluent Book runs monthly bookkeeping for Canadian e-commerce sellers across BC and the rest of the country. Multi-channel reconciliation, GST/HST and PST filing, inventory tracking, payment processor integration, and year-end handoff to your accountant — all in. Honest pricing. No surprises. No judgement if you are behind.
Book a 30-minute call at fluentbook.ca and we will scope what you actually need.