It starts innocently: you skip a month of bookkeeping during a busy launch. Then Q4 hits. Suddenly it's the new year, your CPA wants numbers, and you have 8, 12, sometimes 24 months of unreconciled everything. First: this is the most common situation in e-commerce, not a personal failure. Second: it's fixable with a system.
The playbook, month by month
- Gather the raw material: bank and card statements, channel settlement reports (Amazon, Shopify, TikTok Shop), payment processor exports, loan agreements. Everything downloadable — no shoeboxes needed.
- Rebuild oldest first: import and categorize each month's bank activity, then post that month's settlements properly (sales, fees, refunds split — not deposits as revenue). Historical settlement imports via A2X make this dramatically faster.
- Hunt the classics: duplicate transactions from double-connected feeds, transfers booked as income, owner spending mixed in, sales tax booked as revenue. In one recent cleanup these added up to ~$63,000 of double-counted revenue — tax nearly paid on income that never existed.
- Reconcile every account to its statement — the step that separates "looks done" from "is done".
- Close each month as you finish it, then hand the file to your tax preparer with a summary of judgment calls.
What a cleanup should cost
Specialists price e-commerce cleanups flat per month of backlog (roughly $400–$2,000/month depending on volume and channels), quoted up front after a diagnostic — beware open-ended hourly quotes on messy books. Delivered in weekly batches, a year of backlog typically takes 2–4 weeks of calendar time.
Timing: October–December is cleanup season for a reason — clean books before January mean your tax return is built on facts, deductions aren't lost in the mess, and you start the year with a monthly close instead of another backlog.