Bookkeeping for Online Sellers
Online selling produces more accounting per dollar than almost anything else, for one reason: nothing arrives as a single clean payment. A day's sales reach the bank days later, in a batch, net of fees, with tax inside them and refunds from a different week deducted. Every reporting problem in the sector starts there.
What's included
- Each sales channel reconciled to its own settlement report, so revenue is gross sales and the payout is a bank line rather than the revenue figure
- Processing fees, marketplace commissions and chargebacks recorded as the expenses they are instead of being netted invisibly into sales
- Inventory costed so that cost of sales lands in the month the sale did, which is the adjustment that makes a monthly margin figure mean anything
- Stock purchases carried as inventory rather than expensed on arrival, with the balance reconciled to a count
- Refunds and returns matched back to the period of the original sale rather than treated as a cost of the month they clear in
- Shipping charged to the customer and shipping paid to the carrier kept as separate lines, because they move independently and the difference is a real margin
- Sales tax collected separated from revenue at the point the day is recorded, for Canadian sellers, including where a marketplace collected it on your behalf
- Sales in another currency translated consistently, with the gain or loss on settlement visible rather than buried in revenue
Who it's for
- Sellers whose revenue figure is whatever the processor deposited
- Businesses selling on more than one channel with no per-channel margin
- Owners carrying stock who have never had cost of sales land in the month the sale did
How it runs
The actual sequence, start to finish.
- 01
Map every way money arrives
Each storefront, marketplace and processor, with its settlement cycle, its fee structure and whether it collects tax on your behalf. That list decides how the accounts get built, and a file built without it is one where no single figure can be traced to a source.
- 02
Settle the inventory method
How stock is valued and when it becomes cost of sales, decided and written down. This is the one choice that moves gross margin most, and changing it later means restating what was already reported, so it is worth getting right before the first month closes.
- 03
Reconcile each channel to its own payouts
Gross sales, fees, refunds and the deposit, per channel, every month. Netting channels together hides both the fee rates and the timing, and it is the reason most sellers cannot say which channel actually makes money.
- 04
Close monthly with margin by channel
Statements with revenue gross, cost of sales in the right month, and the fee load visible per channel. That is the reporting that answers where to spend the next advertising dollar, which is the question the business actually has.
What it costs
Priced by monthly transaction volume, then scoped for how many channels and processors settle separately and whether stock is carried, because those drive the reconciliation work rather than the revenue figure. A single storefront and a seller on three marketplaces in two currencies are different engagements.
Questions about bookkeeping for online sellers
Our sales never match our deposits. Is something wrong?
Almost certainly not. The two differ by fees, by refunds from earlier periods and by settlement timing, and all three are supposed to be there. The job is to explain the gap rather than remove it, and to notice any part of it that nothing accounts for.
Do we really need inventory tracked properly?
If you carry stock, yes, because without it the profit figure is wrong in the line that matters most. Purchases expensed on arrival make a restocking month look terrible and the month you sell the stock look excellent, and neither is the business. If you drop-ship and hold nothing, this is genuinely not your problem.
A marketplace collects the sales tax for us. Does that change anything?
It changes the bookkeeping rather than removing it: the tax is still inside the amounts flowing through, and it still has to be separated so your own return is built on figures the books support. Whether and where you need to be registered is a question for whoever files your returns, and for a Canadian business we would put it to our associated CPA rather than answer it ourselves.
Can you tell us which channel is actually profitable?
That is the main thing this is for. It needs revenue recorded gross, the fee load attributed per channel and cost of sales landing in the right month. With those three in place the answer comes out of the monthly statements rather than out of a spreadsheet somebody rebuilds each quarter.
We sell in US dollars from Canada. How is that handled?
Sales get translated on a consistent basis and the difference between the rate at the sale and the rate at settlement is recorded as what it is, rather than left inside revenue. It is a small adjustment that stops exchange movement reading as sales growth.
Who files our returns?
We file GST/HST from your own books for Canadian businesses, and simple personal returns. Corporate, trust and partnership returns are done by our associated CPA. US federal and state returns are prepared and filed by our associated US CPA in your state, from the file we prepare.
More questions answered on the FAQ page.
Often paired with
Bookkeeping
Monthly reconciliation, coded transactions, and financial statements, every month.
Financial Reporting
Custom KPI dashboards and reporting beyond the standard monthly statements.
Bookkeeping for Retail and Personal Services
The commercial lease that does not match your bank statement, and card settlement that arrives late and net of fees.
Running one of these systems
Shopify POS Bookkeeping
The accounting under a till: why the day's sales and the day's deposit are never the same number, where the processing fees went, and what the gift card balance actually is.
Stripe Bookkeeping
The accounting under a Stripe account: gross charges and net payouts kept apart, fees recorded as the expense they are, and the balance sitting at Stripe recognised as money you hold outside the bank.
Ready to talk about bookkeeping for online sellers?
A free 20-minute consultation, no obligation.