The instinct is to find every receipt and type them in. That is the slowest possible approach and it has a flaw that only becomes obvious at the end: when you finish, you have no idea what is missing. A pile of 180 receipts entered perfectly tells you nothing about the 40 you never had.
Work from the bank statement instead. It is the one complete, chronological record of everything that actually happened, and it converts an open-ended search into a finite list with a definite end.
Here is the order that works.
Step 1: Export, do not browse (30 minutes)
Download CSV exports for the full period from every account the business touched. Business current account, any savings account that paid an annual insurance premium, every card including the personal one you used three times in March, and any payment platform — PayPal, Stripe, Wise — that holds a balance you spent from.
Dump them all into one Google Sheet with a source column so you know which account each row came from. Sort by date.
You now have the denominator. Every business expense for the year is somewhere in this list, and nothing outside it exists.
Step 2: Strip out what is not business (45 minutes)
Add a column called Keep with three values: Yes, No, Maybe.
Work down the list quickly and do not agonise. Groceries, personal transfers, the mortgage: No. Supplier payments, software, obvious business travel: Yes. Anything genuinely ambiguous: Maybe.
Speed matters more than precision here because the Maybe pile is where the thinking happens, and you want it isolated rather than spread across the whole year. On a typical freelancer's account this pass eliminates 60 to 80 per cent of rows in under an hour.
Filter to Yes and Maybe. That is your actual workload, and it is usually a quarter of what you feared.
Step 3: Sort by amount, not by date (10 minutes)
This is the step people skip, and it is the one that saves the weekend.
Sort the remaining rows by amount, descending. Expense records follow a steep distribution: in most small businesses, the largest 20 per cent of transactions account for 70 to 80 per cent of total spending.
That means the first forty rows carry most of the money and therefore most of the tax consequence. The two hundred rows below them are coffees and parking. Both matter, but they do not deserve equal time, and if you run out of weekend you want to have spent it at the top of the list.
Step 4: Hunt the big ones properly (2-3 hours)
Take the top rows one at a time and find the real document — the invoice or receipt, not the statement line.
Where to look, in order of hit rate:
- Email search by amount. Searching your inbox for "284.00" finds invoices that a merchant-name search misses, because the merchant's trading name is often not what appears on the statement.
- Supplier portals. Software, utilities, and insurers almost always have a billing history page with downloadable PDFs going back years. This is the highest-yield source for annual charges.
- Card statements with merchant detail. Some issuers show the full merchant descriptor, which decodes the cryptic ones.
- The physical pile. Last, not first.
For each one found, capture it into your expense sheet with the image attached. Scanning the document rather than typing the figures is the faster route — Scan2Sheet reads the merchant, date, amount, and tax off the image and files the row with the image linked, which for a stack of recovered PDFs and photographs is the difference between an afternoon and an evening.
Mark the statement row as matched as you go, so you always know how much is left.
Step 5: Deal with the small ones in batches (1-2 hours)
Below roughly the top quarter, stop hunting individually. Batch by merchant instead.
Filter the remaining rows by merchant name and handle all of them at once. Fourteen transactions at the same coffee shop, nine fuel stops at the same station, six parking charges in the same car park — each group is one decision about category and treatment, applied fourteen times, rather than fourteen separate acts of remembering.
This is also where the genuinely unrecoverable receipts live. Which brings up the question everyone asks at this point.
What to do when the receipt is gone
Some documents are simply not recoverable. A thermal parking stub from eleven months ago does not exist any more in any meaningful sense.
Do not invent one, and do not silently claim as though you have it. Record what you actually have:
- The bank or card statement line, which proves the payment occurred
- What you know about the purpose, written honestly
- A flag marking the row as unsupported
Then have the conversation with your accountant about what to do with the flagged rows. Rules on claiming without full documentation vary by jurisdiction and by the type and size of expense, and a preparer can only give you the right answer if they can see which rows are affected. A filterable flag turns that into a two-minute review.
The flag also has a second use: the size of the flagged total is the honest measure of what the year's record-keeping cost you, and it is usually the most persuasive argument for changing the habit.
Step 6: The reconciliation that proves you are done (30 minutes)
Two checks.
Every Yes row is matched. Filter for Keep = Yes and matched = blank. The result should be empty. This is the check that tells you nothing was missed, and it is only possible because you started from the statement.
The Maybe pile is resolved. Each one is now Yes or No, with a reason noted for anything non-obvious. "Maybe" is not a valid state in a finished set of records.
Then run a sanity read on the category totals. A year of expenses where travel is 2 per cent and office supplies is 40 per cent is telling you about your categorisation, not your business.
If you are registered for VAT or GST
A catch-up gets materially harder when you are reclaiming tax on purchases, because a bank statement line is not sufficient evidence for a tax credit. The tax invoice is.
This changes the triage. In step three, sort by amount within the rows where you expect to reclaim tax, and hunt those first regardless of size — a missing invoice on a £400 purchase costs you the credit on that purchase, and the credit is the money you are chasing.
It also changes what the unsupported flag means. A row with no document may still be a legitimate business cost for income tax purposes while being unusable for a VAT or GST reclaim. Those are two different questions about the same row, and your sheet should be able to express both: one column for whether the expense is business, another for whether you hold a valid tax invoice.
Do not claim the tax on rows where the second column says no. The reclaim is the part most likely to be checked, and it is checked against documents.
If you are more than one year behind
The method is the same, applied one period at a time, oldest first. Two things change.
Documents get harder to recover the further back you go. Supplier portals typically retain billing history for a limited window, and email search becomes less reliable as mailboxes get archived. Prioritise the oldest year's recovery work first, because it is the one with a closing window — the recent year's documents will still be available next month.
Deadlines and penalties stack. Late filing in most jurisdictions carries escalating consequences, and the position is usually better for someone who approaches the authority than for someone who waits. This is the point at which the right move is a conversation with an accountant before, not after, the reconstruction — the sequencing of filings can matter.
Resist the urge to do all years at once in parallel. One complete year is worth more than three half-done ones, and the first complete year teaches you where your own records fail, which speeds up the rest.
What the recovered data is actually worth
It is worth quantifying, because the number is usually larger than people expect and it is the thing that changes behaviour.
Add up the business expenses you recovered in step four and five that were not previously recorded anywhere. Multiply by your marginal tax rate. That figure is the direct return on the weekend.
For a sole trader with £8,000 of previously unrecorded business costs and a marginal rate around 30%, the recovery is roughly £2,400 — which, measured against six hours of work, is a better hourly rate than most people's actual business.
There is a second number worth knowing: the total of the rows you flagged as unsupported. That is what the missing documentation cost you, and unlike the first figure, it is entirely preventable.
The realistic timeline
For a sole trader with one business account and a few hundred transactions, this is a long Saturday — roughly five to seven hours, with two of them in step four. Two accounts and a card roughly doubles step one and step two but not the rest.
What makes it a Saturday rather than a fortnight is the order: finite list first, biggest money first, batches for the tail, reconciliation at the end.
So that this does not recur
The catch-up is worth doing properly once. It is not worth doing twice, and the thing that prevents a repeat is not resolve — it is removing the step where paper has to survive a journey from a wallet to a desk.
Capture on the day, review uncategorised rows for ten minutes each week. That weekly ten minutes is roughly eight hours a year, which is about what you just spent on a single weekend, except distributed and done while you still remember what everything was for.
Put the weekly slot in the calendar before you close the sheet. That is the part that decides whether you are reading this article again next year.