Catch-up bookkeeping
How Do I Reconstruct Business Expenses from Old Bank Statements?
Reviewed 12 September 2026
Short answer
Short answer
Collect statements for every business account and any personal account used for business costs. Convert each account into a complete transaction table, reconcile it to the source PDFs, then apply consistent merchant rules to identify likely expenses. Keep transfers, refunds and uncertain items separate, attach available receipts, and let your accountant decide final deductibility and tax treatment.
The first goal is a complete record, not a perfect category on every row. Missing transactions are harder to correct than visible uncertainty.
Rebuild the evidence before classifying it
Do not begin by searching only for familiar suppliers. First reconstruct the full account history so transfers, refunds, fees and personal spending remain visible in context.
Rule-based categories can group repeat merchants and calculate useful first-pass totals. They are preparation for review, not tax advice or proof that an expense is deductible.
Step by step
- 01
Define the period and accounts
List business accounts, cards and personal accounts that may contain business spending.
- 02
Build complete transaction tables
Convert, combine and reconcile each account before filtering anything out.
- 03
Apply cautious categories
Group known recurring merchants and leave uncertain descriptions uncategorised.
- 04
Add evidence and review
Match receipts where available and give unresolved items to your accountant.
Checks before you rely on the spreadsheet
- The full account history is retained.
- Transfers and refunds are not treated as ordinary expenses.
- Uncertain items remain visible.
- An accountant reviews final tax treatment.
Questions people ask
Can bank statements replace receipts?
A bank transaction can show that money moved, but it may not prove what was purchased or its tax treatment. Ask your accountant what supporting evidence is required.
Can Excel automatically find business expenses?
It can apply merchant lookups and keyword rules, but unfamiliar or ambiguous transactions still need human review.
Should I delete personal transactions from the spreadsheet?
No. Keep the complete history and flag personal rows so the reconstruction remains traceable.