An e-commerce business can make hundreds or thousands of sales without receiving a single deposit equal to the amount shown on its store dashboard. Marketplaces and payment processors deduct commissions, fulfilment fees, advertising charges, refunds, chargebacks and reserves before transferring cash. Settlement timing can also cross month-end or year-end.
If accounting is based only on deposits received, revenue, fees, taxes and receivables may all be misstated. Reliable e-commerce accounting begins by connecting platform activity to payment settlements, inventory records and the general ledger.
Why platform sales and bank deposits rarely match
A platform settlement may combine several components:
- Gross product sales.
- Discounts and promotional credits.
- Shipping income.
- GST/HST or other sales taxes collected.
- Returns and customer refunds.
- Marketplace commissions and payment-processing fees.
- Advertising, fulfilment and storage charges.
- Chargebacks, disputes and rolling reserves.
- Currency conversion and foreign-exchange differences.
The accounting process should record these components separately and use a platform or payment-clearing account to reconcile the net cash received.
A disciplined e-commerce reconciliation process
- Download or integrate detailed sales and settlement reports from every marketplace and store.
- Separate gross sales, discounts, refunds, shipping, taxes and fees.
- Match settlement batches to bank deposits.
- Investigate timing differences, reserves and unmatched transactions.
- Reconcile inventory purchases, fulfilment movements and closing stock records.
- Review GST/HST treatment by product, customer location and sales channel.
- Prepare a monthly channel-level profitability report.
Inventory changes the meaning of profit
Purchasing inventory is not the same as recognising the full cost as an expense. Businesses need a consistent method to track quantities and costs so that cost of goods sold reflects the products actually sold during the period.
Without reliable inventory information, gross margin can fluctuate for reasons unrelated to actual performance. Stock losses, damaged goods, samples, fulfilment discrepancies and obsolete items should also be identified rather than left inside a general inventory balance.
Returns and refunds need separate visibility
High sales volume can hide a growing return problem. Return rates should be monitored by platform, product and period. The accounting records should distinguish customer refunds from payment disputes, promotional discounts and inventory write-offs.
This information helps management understand whether revenue growth is translating into sustainable margin or being offset by returns, fulfilment charges and advertising costs.
GST/HST should be reconciled to the sales channels
For most Canadian businesses making taxable supplies, GST/HST registration becomes mandatory once the applicable small-supplier threshold is exceeded. E-commerce businesses may sell across provinces or through marketplaces that collect certain taxes on their behalf, so the books should identify who charged the tax, who remitted it and what remains reportable by the merchant.
Tax collected should not be treated as revenue, and input tax credits should be supported by appropriate documentation. A monthly GST/HST reconciliation reduces the risk of discovering large differences only when the return is due.
Electronic records are part of the audit trail
CRA requires businesses using Internet-based systems to retain information supporting online transactions. Depending on the process, this may include platform reports, web logs, emails, invoices, order confirmations, settlement reports and security records such as electronic signatures.
Saving only a monthly summary can be insufficient if the business cannot reproduce the underlying transaction detail. Data should be retained in a format that can be accessed, searched and reconciled later.
Reports that matter to e-commerce management
- Sales and gross margin by platform or product line.
- Marketplace and payment-processing fees as a percentage of sales.
- Advertising cost and contribution margin.
- Return, refund and chargeback rates.
- Inventory ageing and slow-moving stock.
- Cash tied up in platform reserves and unsettled balances.
- GST/HST collected, recoverable and payable.
How AccountIF supports e-commerce and retail businesses
AccountIF reconciles Shopify, Amazon and other platform activity with payment processors, bank deposits, inventory records and GST/HST working papers. We also prepare monthly financial reports that show what the business earned after fees, refunds and product costs—not simply what the sales dashboard displayed.
Selling through multiple platforms or payment gateways? AccountIF can build a reconciliation and reporting process that turns transaction data into dependable accounts.