Falling behind on your books is common, especially for online sellers. Orders keep coming in, stock needs reordering, adverts need managing and customers need answers. Bookkeeping slips to next week, then next month. Before long, there are hundreds of payouts, thousands of transactions and a tax deadline closer than anyone would like.
The good news is that e-commerce books are very recoverable. Marketplaces and payment providers keep detailed records of every sale, fee and payout. With the right order of work, months or even years of missing bookkeeping can be rebuilt accurately.
The bad news is that the wrong order of work can make things worse. Many sellers start by working through the bank feed from the oldest line, coding deposits as sales. That is the fastest way to end up with books that look complete but are badly wrong.
This guide sets out a step-by-step catch-up plan we use when rescuing online sellers’ books, from triage to a clean, reconciled set of accounts and a routine that stops you falling behind again.
Quick answer: how do you catch up on bookkeeping as an online seller?
Start with deadlines, then gather bank statements and channel reports for the whole period. Set up clearing accounts for each channel, post each channel’s payouts or settlements gross, match every deposit as a transfer, then record expenses, inventory and cost of goods sold. Reconcile each month in order and lock it before moving on.
Key takeaways
- Triage first: know your deadlines and the exact period you need to rebuild.
- Download channel reports early. Some marketplaces limit how far back you can retrieve them.
- Build the structure (clearing accounts, tracking, connector) before entering any transactions.
- Work month by month, reconciling and locking each one before starting the next.
- Never code marketplace deposits directly to sales, even when catching up fast.
What should you do before starting a bookkeeping catch-up?
Before entering a single transaction, list every upcoming deadline, define the exact period to rebuild, confirm the last reliable balance sheet, and download every bank statement and channel report for the period. This triage decides the order of work and stops you spending weeks on months that are not urgent.
1. List your deadlines
Write down every filing and payment date that applies: VAT or sales tax returns, corporation tax or income tax returns, annual accounts, payroll filings and any lender reporting. Put the earliest first. If a deadline cannot be met, speak to your accountant now, not the week before.
2. Define the period to rebuild
Find the last date your books were genuinely reliable. That is usually the end of the last period filed by an accountant, or the last month where the bank and every clearing account reconciled. Everything after that date is in scope.
3. Confirm opening balances
The catch-up starts from known balances: cash, amounts owed by each marketplace, stock, VAT or tax owed, loans and amounts owed to suppliers. If the last filed accounts exist, use their balance sheet. If not, opening balances must be rebuilt first.
4. Gather everything at the start
- ☐ Bank statements for every business account, including foreign currency accounts, for the whole period.
- ☐ Credit card statements.
- ☐ Shopify payout reports and order exports.
- ☐ Amazon settlement reports for each marketplace.
- ☐ eBay, Etsy, TikTok Shop and other marketplace payout or statement reports.
- ☐ PayPal, Stripe and other processor statements and activity reports.
- ☐ Supplier invoices and purchase orders for stock.
- ☐ Stock counts or inventory reports at the start and end of the period, if available.
- ☐ Invoices or receipts for software, advertising, freight, 3PL and other costs.
- ☐ Previous VAT or tax returns and any letters from tax authorities.
- ☐ Loan agreements and statements.
You can download your Shopify Payments payout reports to review transactions, payment fees and payouts when rebuilding your bookkeeping records.
What are the steps in an e-commerce bookkeeping catch-up?
The catch-up runs in eight steps: set up the structure, post channel activity gross, match payouts as transfers, record other bank and card transactions, add inventory and cost of goods sold, reconcile each clearing account, review tax, then lock each month. Doing them in this order means each month is finished properly before the next begins.
Steps 1–2: Set Up Your Accounts and Record Sales
- Set up the structure. Create clearing accounts for each channel and currency, a reserves account, channel tracking categories or classes, and the income and cost accounts you need. If you use a connector such as A2X or Link My Books, connect it to these accounts now. Switch off any bank rules that code marketplace deposits to sales.
- Post each channel’s activity gross. For each month, post every payout or settlement through the channel’s clearing account, split into sales, shipping, refunds, each fee type, advertising, reimbursements and tax. Use the connector where it can reach back far enough; build journals from downloaded reports where it cannot.
Steps 3–4: Match Payouts and Record Expenses
- Match every deposit as a transfer. In the bank reconciliation, match each marketplace or processor deposit as a transfer from its clearing account. Never code it to sales. If a deposit will not match, note it and move on; the cause usually appears in step 6.
- Record everything else in the bank and on cards. Supplier payments, stock purchases, freight, software, salaries, loan repayments, owner drawings and transfers between accounts. Attach receipts and invoices where you have them, and keep a list of anything unexplained.
Steps 5–6: Record Inventory and Reconcile Accounts
- Add inventory and cost of goods sold. Record stock purchases to inventory, then post cost of goods sold for each month using unit costs and units sold, tagged by channel. If perpetual records are not available, use stock counts at key dates and agree an approach with your accountant.
- Reconcile each clearing account. At each month end, the balance on each clearing account should equal what the channel owed you on that date, plus any reserves it held. Differences point to missing settlements, duplicates or mis-mapped lines. Fix them now.
Steps 7–8: Review Tax and Finalise Monthly Accounts
- Review tax. Compare VAT or sales tax in the books with the channel tax reports and any returns already filed. Check whether gross sales crossed a registration threshold in the period. Flag any differences to your accountant before filing.
- Review and lock the month. Check the profit and loss for anything unusual, clear the unexplained list as far as possible, then lock the period in your accounting software before moving on to the next month.
Why Month-by-Month Bookkeeping Matters
It is tempting to post a year of Amazon settlements in one go, then a year of bank lines, then try to reconcile everything at the end. That leaves months of differences mixed together and almost impossible to trace. Finishing each month before starting the next means every problem is found close to where it started, with only a few weeks of transactions to check.ether and almost impossible to trace. Finishing each month before starting the next means every problem is found close to where it started, with only a few weeks of transactions to check.
How long does an e-commerce bookkeeping catch-up take?
It depends far more on complexity than on the number of months. A single-channel Shopify store with one bank account can be rebuilt quickly. A multi-marketplace seller with several currencies, FBA stock, missing reports and VAT issues takes much longer. Access to complete reports and a responsive business owner are the biggest factors in speed.
What makes a catch-up faster or slower
| Factor | Faster | Slower |
|---|---|---|
| Number of channels | One or two | Four or more |
| Currencies | One | Several, with conversions in PayPal or marketplaces |
| Reports | All downloadable, connector can reach back | Missing periods, reports must be rebuilt |
| Existing books | Empty, starting from clean opening balances | Partly done with errors that must be unpicked |
| Inventory | Simple range, good purchase records | Many SKUs, no stock counts, FBA transfers |
| Tax | One registration, no thresholds crossed | Several registrations, possible missed thresholds |
| Owner availability | Questions answered within a day or two | Questions wait weeks |
An illustrative example
The phases below show how a 12-month catch-up might be organised for a seller on Shopify and Amazon UK with one currency. Your timeline will differ. Treat it as a guide to the order of work, not a quote.
| Phase | What happens | Illustrative duration |
|---|---|---|
| Triage | Deadlines, scope, opening balances, report downloads | Days 1–3 |
| Structure | Clearing accounts, tracking, connector set-up and testing | Days 3–5 |
| Rebuild | Month-by-month posting, matching and reconciliation | Weeks 2–4 |
| Inventory and tax | Cost of goods sold, VAT review, threshold check | Week 4 |
| Review | Accountant review, adjustments, period locking | Week 5 |
The tightest deadline drives the plan. If a VAT return is due in three weeks, the months in that VAT period are rebuilt first, even if older months are still open. Older months are then completed in order.
Team note: replace this illustrative example with a real anonymised client story, including the actual number of months, channels and how long the project took.
What mistakes should you avoid when catching up on bookkeeping?
The biggest catch-up mistakes are coding deposits straight to sales, working from the bank feed without channel reports, posting a whole year before reconciling anything, forcing differences into suspense or sales to make the bank balance, and filing tax returns before the rebuilt figures have been reviewed. Each creates books that look finished but are wrong.
- Coding marketplace deposits to sales. It is fast, and it is the root cause of most of the books we rescue. Sales are understated, fees disappear and tax thresholds are missed.
- Working only from the bank feed. The bank shows where money landed, not what happened. Without settlement and payout reports, sales, fees and refunds cannot be split correctly.
- Posting everything, then reconciling. Differences from many months pile up together and become almost impossible to trace.
- Forcing differences to balance. Posting unexplained amounts to suspense, sales or a general expense account just to clear the bank hides real problems, such as missing settlements or duplicate entries.
- Running two routes for the same channel. A connector switched on halfway through the catch-up, while old manual entries remain, double-counts sales for the overlapping period.
- Ignoring inventory. Without cost of goods sold, profit is overstated in months with big purchases and understated in months selling existing stock.
- Filing before review. Rebuilt figures can change tax positions. Have your accountant review the period before any return is filed or amended.
- Not keeping a list of questions. Unexplained transactions should be logged and answered in batches, not guessed at. A guess becomes a permanent error once the period is locked.
How do you stay caught up once the books are clean?
Stay caught up with a short weekly routine to match payouts and code bank transactions, and a monthly close that reconciles every clearing account, posts cost of goods sold and reviews profit by channel. With the right structure, this takes a few hours a month and prevents another backlog.
Weekly (30–60 minutes for most sellers)
- ☐ Check the connector has posted every new payout or settlement.
- ☐ Match marketplace and processor deposits as transfers from clearing accounts.
- ☐ Code other bank and card transactions and attach receipts.
- ☐ Add any unexplained items to the questions list.
Monthly close
- ☐ Reconcile every bank, card and clearing account to its statement or channel report.
- ☐ Record reserves, reimbursements and any manual channel entries.
- ☐ Post cost of goods sold by channel.
- ☐ Review VAT or sales tax and update the threshold tracker.
- ☐ Review profit by channel and explain any big movements.
- ☐ Lock the month.
Do it yourself or get help?
If your business has months or years of missing financial records, our Historical Catch-Up Bookkeeping Services can help rebuild transactions, correct errors and reconcile your accounts.
Frequently asked questions
Can I catch up on a year of bookkeeping at once?
Yes, but work through it month by month rather than all at once. Post each month’s channel activity, match payouts, record other transactions, reconcile and lock that month before starting the next. Prioritise months in any period with an upcoming tax deadline.
What if I can’t download old Amazon or Shopify reports?
Check every route first: the channel’s reports, your connector’s import, and any exports previously saved. If gaps remain, reconstruct the period from bank deposits and available order data, document the method, and agree it with your accountant.
Should I fix old mistakes or just start fresh?
If earlier periods have been filed, speak to your accountant. Often the best route is to rebuild from the last reliable balance sheet, correcting errors through the rebuilt months rather than editing filed periods directly.
Will catching up mean I owe more tax?
Sometimes. Rebuilding on a gross basis can show higher sales, a missed threshold or unclaimed costs, so tax can go up or down. Knowing the true position early gives you and your accountant more options.
Can a connector app do my catch-up for me?
It can do much of the posting if it can reach back far enough, but it cannot reconcile, investigate differences, record other costs or make judgement calls. Use it as a tool within the plan, not as the plan.
How much does catch-up bookkeeping cost?
Cost depends on channels, currencies, months, transaction volumes and the state of existing records. Ask for a scoped quote after a short review of your accounts and channel reports.
The bottom line
Being behind on your books is stressful, but it is fixable. Start with deadlines and reports, build the right structure, then rebuild month by month, reconciling and locking each one. Avoid the shortcuts that create problems later, and finish with a simple routine that keeps you current.
If you are months or years behind, or a deadline is approaching, Rescue My Books can take the catch-up off your hands and get your books accurate, reconciled and tax-ready.
