How to Reconstruct Historical E-Commerce Books Before a Cleanup or Disclosure

Most bookkeeping problems can be fixed going forward: correct the chart of accounts, start reconciling payouts properly, tighten up the monthly close. A smaller number of situations cannot be fixed that way, because the problem is not the current process, it is that one or more prior periods were never recorded accurately in the first place. That is a reconstruction problem, not a bookkeeping problem, and it needs a different approach.

Reconstruction comes up most often ahead of a voluntary disclosure, a lender or buyer’s financial review, a change of bookkeeper who inherited unusable records, or a CRA request for a period that was never properly closed. This guide covers when reconstruction is the right call, what to pull from each platform, how to rebuild the numbers, and where self-cleanup should stop and professional review should start.

When a File Needs Reconstruction, Not Bookkeeping

Ordinary bookkeeping catches up a period that is a few months behind using records that exist but have not been entered yet. Reconstruction is different: it applies when the underlying record of what happened is incomplete, was never captured correctly, or exists only in fragments across platforms and bank accounts that were never reconciled to each other.

Signals that a period needs reconstruction rather than routine catch-up:

• Revenue was recorded as bank deposits only, with no link back to platform sales, fees, or tax
• GST/HST registration status, effective dates, or collected amounts for a prior period cannot be confirmed from existing books
• Inventory and cost of goods sold were never tracked, or were tracked in a way that does not tie to actual purchases and sales
• A voluntary disclosure, CRA review, lender due diligence, or acquisition process requires supportable numbers for periods where the books cannot currently support them
• The business changed bookkeepers, software, or platforms mid-period and no one reconciled the handoff

If any of these apply for a period the business needs to answer for, entering a few missing transactions will not produce a reliable result. The period needs to be rebuilt from source documents.

Reports to Pull From Every Platform

Reconstruction starts with pulling the underlying transaction-level data from every platform the business used during the period being reconstructed, not just a summary export. At minimum:

Platforms generally retain detailed transaction data for a limited window, commonly in the range of prior months rather than indefinitely, so the further back a reconstruction reaches, the more urgent it is to pull these reports before they age out of platform availability. Where reports are no longer available for download, some platforms provide historical data on request through seller support, though response times and completeness vary. Confirming what a specific platform retains and for how long should happen early, not after other steps are underway.

Rebuilding Gross Sales, Fees, Refunds, Reserves, and Payouts

With the platform detail in hand, the reconstruction proceeds settlement period by settlement period (or the equivalent payout period on non-Amazon platforms), building out gross sales, fees, refunds, reserve movements, and the resulting net payout for each period. This is the same category structure used in ordinary settlement reconciliation, applied retroactively across every period involved.

The Amazon Settlement Report Reconciliation guide and How to Read a Shopify Payouts Report both describe the category breakdown used for this step. The difference in a reconstruction is volume and consistency: instead of reconciling one current period, the same category mapping needs to be applied uniformly across every historical period being rebuilt, and each period’s ending balance needs to tie to the actual payout received, not just to an internally consistent total.

Where multiple platforms were active in the same period, the Multi-Channel Reconciliation guide covers how to bring separate channel reconstructions together into one combined view of the business for that period.

Matching Platform Activity to Bank and Card Accounts

A platform-side reconstruction is not complete until it is matched against what actually moved through the bank and card accounts. This step catches errors that a platform-only reconstruction can miss: payouts that were never deposited as expected, business expenses paid from a personal account, or platform disbursements that were split across more than one bank account without a clear record of which period each deposit relates to.

Matching works period by period: each expected payout, from the rebuilt settlement data, is traced to an actual bank deposit for the corresponding amount and approximate date. Deposits that cannot be matched to an expected payout, and expected payouts that cannot be matched to a deposit, both need to be investigated before the reconstruction is treated as complete. Unmatched items are frequently where timing errors, missing platforms, or personal-business commingling surface.

Reconstructing GST/HST Registration Timing and Tax Balances

For a period requiring reconstruction, GST/HST is often the highest-stakes piece to get right, because it determines whether tax should have been collected, whether it was, and what is now owed. Reconstruction needs to establish, for each period:

• Whether the business had crossed the CAD $30,000 small supplier threshold, and if so, on what date, using the cumulative revenue tests described in the GST/HST Registration Timing guide
• Whether the business was registered, and the actual effective date of that registration if it was
• What GST/HST was collected on sales during the period, separated by platform and by whether the platform acted as deemed supplier under CRA’s digital economy platform rules
• What returns, if any, were filed for the period, and whether the amounts reported match the reconstructed figures

Where reconstruction reveals unreported income, unremitted tax, or a registration that should have happened earlier than it did, the next step is usually a review of whether a voluntary disclosure is appropriate rather than simply amending returns. The Voluntary Disclosures guide covers CRA’s disclosure program and when it applies. The Digital Platform Reporting Rules guide covers how CRA now receives platform-reported seller data directly, which is part of why reconstructing accurate prior-period figures has become more urgent for sellers who were previously relying on the assumption that platform income was not independently visible to CRA.

Rebuilding Inventory and COGS Where Records Are Incomplete

Inventory reconstruction is generally the most labour-intensive part of a historical cleanup, because it depends on documents that are easy to lose track of: purchase orders, supplier invoices, customs paperwork, and unit-level sales data across every platform and fulfillment location used during the period.

Where full purchase records exist, COGS can be rebuilt using a consistent costing method (see the Inventory Costing Methods guide) applied retroactively to purchase and sale dates. Where purchase records are incomplete, reconstruction may need to work backward from known ending inventory counts, supplier payment history on bank statements, and landed cost estimates, which is a lower-precision approach than one built from full purchase documentation. The Inventory Reconciliation for Marketplace Sellers guide covers the reconciliation mechanics that apply once a starting inventory baseline has been established.

What Can Be Estimated vs. What Needs Source Support

Not every number in a reconstruction can be pinned to a source document, and treating estimated and documented figures the same way creates risk in a review or disclosure context.

Figures that generally need direct source support: GST/HST collected and remitted, gross sales by platform, and any figure being used in a voluntary disclosure submission. Figures that can sometimes be reasonably estimated, with the estimation method disclosed and documented: allocation of shared expenses between business and personal use in early-stage records, or COGS for a period where unit-level purchase records are genuinely unrecoverable and a reasonable costing basis is applied instead. The distinction matters because CRA review and disclosure processes evaluate the quality of support behind a number, not just the number itself.

When to Stop Self-Cleanup and Engage an Accountant

A seller can generally pull platform reports, download bank statements, and organize documents without professional help. Where self-cleanup should stop and a professional review should begin:

• The reconstruction points toward unreported income or unremitted GST/HST, where a voluntary disclosure decision needs to be made before any amended filings happen
• Multiple periods, platforms, and account types need to be reconciled against each other and the volume of unmatched items is large
• The reconstructed books will be used to support a lender application, an acquisition, or a CRA response, where the format and support standard matters as much as the numbers themselves
• Registration timing or platform tax treatment is unclear and the resolution affects a filing position

Attempting a disclosure-quality reconstruction without support, and then discovering a gap in the approach after a filing has already been made, is harder to correct than pausing before filing.

Document Checklist for a Cleanup Review

1. Platform settlement, order, and transaction reports for every platform used, covering the full period in question
2. Full bank and credit card statements for every account used by the business during the period
3. GST/HST registration confirmation and any prior returns filed
4. Supplier invoices and purchase orders for inventory bought during the period
5. Customs and import documentation for any imported inventory
6. Any prior bookkeeping file, chart of accounts, or accounting software export, even if incomplete
7. Records of any business expenses paid from a personal account
8. Prior year tax filings, including T1 or T2 returns, for cross-reference against reported business income

The Year-End Tax Document Checklist guide covers the equivalent document list for an ordinary, current-year close and is a useful comparison point for what a properly maintained period looks like once reconstruction is complete.

Scope of This Guide

This guide covers the process of reconstructing historical e-commerce financial records ahead of a bookkeeping cleanup, voluntary disclosure, or third-party review. It does not cover:

• The mechanics of the CRA Voluntary Disclosures Program itself (covered in the Voluntary Disclosures guide)
• Ordinary month-end and year-end bookkeeping processes for periods that are already reasonably current (covered in the Month-End Close Checklist and Year-End Tax Document Checklist guides)
• US sales tax or international VAT reconstruction, which follow separate jurisdictional rules
• Preparing reconstructed books specifically for a financing or acquisition review (covered in the Preparing E-Commerce Books for Financing, Acquisition, or Investor Review guide)

For sellers rebuilding multiple settlement periods across several platforms, working period by period against a consistent worksheet reduces the risk of missing a category. Download the marketplace settlement reconciliation worksheet to organize gross sales, fees, tax, and adjustments per platform per period as records are pulled. Once historical periods are rebuilt, projecting cash forward against upcoming inventory purchases and GST/HST remittances is often the next step; download the inventory and cash flow forecast template for that purpose.

Reconstructing a period of missing or unreliable records is slower and more document-intensive than ordinary bookkeeping, and the standard of support needed is higher when the output feeds a disclosure, a review, or a due diligence process. Rushing a reconstruction to close it out quickly tends to produce numbers that do not hold up if they are tested later.

Get in touch if you are facing a period of records that cannot be caught up through normal bookkeeping. An early conversation about scope and approach, before a disclosure or review deadline is close, generally produces a better result than starting the reconstruction alone and bringing in help only after a gap is found.