Real-Time Compilation Services for E-commerce Businesses in Canada (2026)
How online sellers can keep live, reconciled books and receive compiled financial statements they can show a lender, investor or marketplace, with the sales tax and risk management controls that protect against financial risk and business risk.
1. What Real-Time Compilation Means
Traditional compilation looks backward. A business collects its records after year end, hands them to an accountant, and gets financial statements months after the period closed. For a retailer on a shelf, that may be tolerable. For an online store, where ad costs change daily and inventory commitments are made weeks ahead, it is far too late.
Real-time compilation closes that gap. It combines two things: near-real-time bookkeeping, where sales, fees, refunds, payouts, ad spend and shipping data are pulled into the accounting file daily or weekly, and a formal compilation engagement, where an accountant uses that reconciled data to prepare financial statements. In practice, "real-time" means current and reconciled rather than literally instantaneous.
Custom CPA delivers this through our core accounting and tax services, with specialized services for complex setups and CFO advisory services when you need help acting on the numbers.
Selling Online and Unsure Your Books Match Your Payouts?
Talk to a Custom CPA advisor about live reconciliation and compiled financial statements.
2. E-commerce in Canada: A Snapshot
Statistics Canada reported that e-commerce was 5.7% of Canadian retail trade in November 2025, or about $4.0 billion of $70.4 billion in seasonally adjusted retail sales. The share has moved within a fairly narrow band since the pandemic.
Source: Statistics Canada figures as compiled in a published summary. Other forecasters report 12% to 13%, but they use a broader definition and should not be compared directly.
3. Compilation vs. Review vs. Audit
Canadian accountants provide three levels of service on financial statements. Under the compilation standard (CSRS 4200), the accountant helps management prepare the statements and does not express assurance. The table compares the levels.
| Service | Assurance level | What the accountant does | Typical user |
|---|---|---|---|
| Compilation | None | Assists management in preparing the statements from information provided | Small online stores; internal use; some lenders |
| Review | Limited assurance | Inquiry and analytical procedures | Growing sellers; banks and investors that ask for it |
| Audit | Reasonable assurance | Detailed testing of evidence | Larger companies; regulated or investor-required situations |
Because a compilation provides no assurance, readers still rely on management's information. That is why the quality of the underlying bookkeeping, and not just the report, determines whether the numbers are useful.
4. Real-Time vs. Traditional Compilation
| Feature | Traditional | Real-time |
|---|---|---|
| Data timing | Gathered after year end | Imported daily or weekly |
| Reconciliation | Annual clean-up | Weekly payout and bank matching |
| Statements | Annual | Monthly or quarterly, plus annual |
| Sales tax | Calculated at filing time | Tracked by transaction and jurisdiction |
| Decision value | Historical record | Guides ad spend, inventory and pricing |
5. The Data Flow: Platforms to Ledger
An online seller typically has five to eight systems producing financial data. The table shows what each contributes and what usually goes wrong.
| Source | Data it provides | Common issue |
|---|---|---|
| Store platform (Shopify, WooCommerce) | Orders, tax collected, discounts | Order totals do not equal deposits |
| Marketplace (Amazon, Etsy) | Settlement reports | Fees, reserves and advertising netted from payouts |
| Payment processor (Stripe, PayPal) | Payouts, fees, chargebacks | Timing differences between sale and deposit |
| Ad platforms | Spend by channel | Billed on card or deducted, coded inconsistently |
| Shipping tools and carriers | Postage, labels, returns shipping | Charges not matched to orders |
| Inventory or warehouse system | Stock on hand, purchase costs | Counts differ from the ledger |
Shipping is often the largest controllable cost after product. For a look at how logistics firms handle their own finance, see how a transportation company automates financial processes with a CFO; the same process-first thinking applies to your carriers and fulfillment partners.
6. Reconciling Payouts, Fees and Refunds
The most common error in an online store's books is recording the deposit as the sale. A payout is a net figure that may bundle many orders, minus fees, refunds, chargebacks, reserves and sometimes advertising charges. If the deposit is booked as revenue, sales, expenses and sales tax are all misstated.
- Import the settlement or payout detail from each platform, not just the bank deposit.
- Record gross sales, tax collected, discounts and refunds as separate lines.
- Record platform and processing fees as expenses, not as reductions of revenue.
- Match the net payout to the bank deposit and clear any difference.
- Track chargebacks and reserves as receivables or liabilities until settled.
Illustrative: How a $1,000 Order Can Become a Smaller Deposit
Round-number illustration, not a benchmark. Actual refund rates, fees and ad charges vary widely by platform and product.
7. GST/HST and PST for Online Sellers
Sales tax is where e-commerce bookkeeping meets compliance. The rules below are general, and the details depend on what you sell, where you ship and which platforms you use.
| Topic | General rule | Bookkeeping implication |
|---|---|---|
| GST/HST small supplier threshold | Registration generally required once taxable revenue exceeds $30,000 over four consecutive calendar quarters | Track a rolling total; many sellers register earlier to claim input tax credits |
| Platform rules (from July 1, 2021) | Distribution platform operators may have to register, collect and remit GST/HST on certain sales by third-party vendors, including goods in Canadian fulfillment warehouses | Know which sales the platform taxed and which you must tax yourself |
| Non-resident sellers | Foreign sellers of digital products or goods in Canadian warehouses may have to register | Relevant if you source from or sell for non-resident partners |
| Provincial sales tax | Rules vary by province; Saskatchewan can treat an out-of-province seller as a vendor when goods are acquired for use in the province | Track sales by ship-to province |
8. Inventory and Cost of Goods Sold
Inventory is often the largest asset on an online seller's balance sheet and the largest drain on cash. Real-time compilation keeps three numbers aligned: units on hand, the cost recorded in the ledger, and the cost of goods sold released as orders ship.
- Landed cost: include freight, duties and brokerage in product cost, not only the supplier invoice.
- Returns and write-downs: record unsellable returns and slow-moving stock when they happen.
- Count cycles: compare physical counts to the system regularly.
- Supplier terms: match purchase orders, receipts and invoices.
If you also make your own products, the planning questions overlap with manufacturing; our guide to business plan services for food processing companies shows how yield, packaging and working capital are modelled for a producer.
9. A Weekly, Monthly and Annual Cadence
What Gets Done, and How Often
Bar length shows relative frequency of the task, not effort. Filing frequencies depend on your reporting period.
Want Weekly Reconciliation Without Hiring a Full-Time Bookkeeper?
Custom CPA sets up the feeds, controls and reporting, then runs the cadence with you.
10. Risk Management: Financial Risk and Business Risk
Good risk management starts by separating the two kinds of exposure an online store faces. Financial risk is about money: margin, cash, tax and funding. Business risk is about whether you can keep operating and selling: platforms, suppliers and ad channels. For the broader framework, see our guide to financial risk management for businesses.
| Risk | Type | Control that real-time data enables |
|---|---|---|
| Ad spend outrunning margin | Financial risk | Weekly contribution margin after ads, shipping and fees |
| Cash tied up in inventory | Financial risk | Inventory days and purchase commitments against the cash forecast |
| Unremitted or misapplied sales tax | Financial risk | Tax collected tracked by transaction and province |
| Refund and chargeback spikes | Financial risk | Weekly refund rate and dispute tracking |
| Dependence on one platform or marketplace | Business risk | Revenue by channel, with a target mix |
| Account suspension or payout reserve | Business risk | Cash buffer and monitoring of held funds |
| Single supplier or long lead times | Business risk | Backup suppliers and reorder-point planning |
| Rising customer acquisition cost | Business risk | Acquisition cost tracked against customer lifetime margin |
Marketing is a major driver of both kinds of risk. Our guide on how to develop a marketing strategy for a business plan explains how to tie spend to measurable targets.
11. KPIs Worth Tracking
- Gross margin and contribution margin after shipping, fees and advertising.
- Average order value and repeat purchase rate.
- Customer acquisition cost by channel.
- Refund and chargeback rate.
- Inventory days and stock-out frequency.
- Cash conversion: days from paying suppliers to receiving payouts.
- Revenue by channel, to monitor platform dependence.
12. Using Compiled Statements with Lenders and Investors
Compiled statements are useful for internal management and for many lending conversations, but they carry no assurance. Some lenders accept them for smaller facilities, while others ask for a review or audit as the amount grows. Ask your lender or investor what level they need before the request becomes urgent, and keep supporting schedules for sales, inventory and sales tax ready. Clean, reconciled books also make a business plan more credible; our business planning and financial modeling work builds forecasts from the same data.
13. Tax, Planning and CFO Support
Current records make tax filing easier and reduce missed deductions. Software subscriptions, platform fees, shipping, advertising, home-office costs and inventory each have their own treatment, so see our guide where tax professionals share top deductions. If you are buying vehicles, warehouse equipment or energy-saving upgrades, read about the new tax incentive for green businesses before you decide on timing.
Many online sellers hit a cash crunch between buying stock and collecting payouts. A part-time CFO can build the forecast and set the controls; the cash discipline is the same as in our guide to a fractional CFO optimizing cash flow for a construction company.
14. Getting-Started Checklist
- List every platform, processor, ad account and shipping tool that touches money.
- Connect each to the accounting file and test one full payout cycle.
- Set up separate accounts for gross sales, refunds, fees, advertising and shipping.
- Confirm GST/HST registration status and provincial sales tax obligations.
- Agree the reconciliation day each week and who signs off.
- Value inventory at landed cost and schedule regular counts.
- Agree the level of assurance your lender or investor needs.
- Review the risk register monthly.
15. Frequently Asked Questions
What is real-time compilation for an e-commerce business?
It combines near-real-time bookkeeping with a formal compilation engagement. Sales, fees, refunds, payouts, ad spend, shipping and inventory data flow from your platforms into the accounting file daily or weekly, are reconciled, and are used to prepare financial statements. In a compilation, the accountant helps management prepare the statements but provides no assurance.
What is the difference between a compilation, a review and an audit in Canada?
A compilation assists management in preparing statements and gives no assurance. A review provides limited assurance through inquiry and analytical procedures. An audit provides reasonable assurance through detailed testing of evidence. Compilation costs less and is faster, while lenders, investors or regulators sometimes require a review or audit.
Do e-commerce sellers need to charge GST/HST and PST in Canada?
GST/HST registration is generally required once taxable revenue exceeds $30,000 over four consecutive calendar quarters, and many sellers register earlier to claim input tax credits. Provincial sales tax rules differ, and marketplace platforms may collect tax on some sales. Confirm your obligations with the CRA, the provincial authority and a qualified tax professional.
How do I reconcile Shopify or Amazon payouts with my accounting records?
A payout is a net amount bundling many orders with fees, refunds, chargebacks and reserves. Import the settlement or payout detail, record gross sales, tax, fees and refunds as separate lines, and match the net deposit to the bank statement. Doing this weekly keeps differences small and traceable.
How does real-time compilation help with risk management for an online store?
Current, reconciled data shows financial risk early, such as margin squeezed by ad costs, cash tied up in inventory, refund spikes and payout reserves. It also exposes business risk, such as dependence on one platform, supplier or ad channel, and unfiled sales tax. Decisions are made on this month's results rather than last year's.
16. Final Thoughts
Real-time compilation gives an online seller what a store owner gets by looking at a shelf: a current view of what is selling, what it costs and what is left. It does this by reconciling platform payouts weekly, tracking sales tax by transaction, valuing inventory properly, and turning the result into compiled statements that lenders can read. Built on reliable data, risk management stops being a year-end exercise and becomes part of how you run the store, with financial risk and business risk visible while there is still time to act.
Ready for Live Books and Compiled Statements for Your Online Store?
Book a conversation with Custom CPA about real-time compilation, sales tax and risk management.
