If your accountant has asked for a year of statements, a single workbook with one tab per account, plus a cover note, serves them better than a folder of forty loose PDFs. Set aside an hour, work account by account, and prove each tab with a simple balance check before you send anything.
What does the workbook look like?
Create one file with these tabs: an Index tab listing every account, then one tab per account, then a Flags tab for anything odd. On each account tab use the same five columns so your accountant can read any tab the same way:
- A: Date
- B: Description, exactly as the statement shows it
- C: Money in
- D: Money out
- E: Balance after the transaction, if your statement prints it
Do not add your own categories yet unless your accountant asked for them. The aim is a faithful copy of the statements, not an interpretation of them.
How do I prove a tab is correct?
Put the year's opening balance in cell G1 and the printed closing balance in G2. Then in G3 use this formula:
=G1+SUM(C2:C500)-SUM(D2:D500)
In G4 type =G3-G2. If the answer is 0, the rows add up to the statements. If not, you have a missing, duplicated or mistyped row.
Worked example with made-up numbers: opening balance £1,500.00. Money in across the year totals £28,400.00 and money out totals £27,150.00. Then 1,500.00 + 28,400.00 - 27,150.00 = £2,750.00. If the final statement says £2,725.00, the sheet is £25.00 too high, and you should look for one payment of £25.00 that is missing from the Money out column.
Which months are easiest to miss?
Quiet months. An account used for a single direct debit generates a statement that looks too boring to download. That is the one that turns up missing. Tick every account against every month on the Index tab, using a small grid with accounts down the side and twelve months across. A blank cell is a task.
| Account | Apr | May | Jun | Jul |
|---|---|---|---|---|
| Current account | Yes | Yes | Yes | Yes |
| Savings | Yes | Yes | Missing | Yes |
| Credit card | Yes | Yes | Yes | Yes |
What should go on the Flags tab?
- Transfers between your own accounts, so they are not mistaken for income or spending
- Refunds, with the original payment's date if you remember it
- Payments made for someone else that you were repaid for
- Large one-off items such as a deposit, a gift or a sale of something you owned
- Anything you cannot explain, listed honestly with the date and amount
Your accountant will be much faster with ten honest lines than with a spreadsheet that looks perfect but hides a puzzle.
Should I mention tax or VAT matters in the notes?
Only as questions. Rules, limits and dates change, so ask your accountant what they need rather than deciding yourself what counts or what to leave out. Your job is to hand over complete, accurate records; theirs is to apply the current position.
SpendixAI is aimed at India and INR, not sterling accounts, but its structure is a good model: each transaction stays tied to the account it came from, and rows are reviewed before saving.
One more habit pays off in the second year. Keep a plain text note called How I did this, with the date you downloaded each statement and anything you had to ask the bank for. Next January you will copy the same steps instead of reinventing them, and if your accountant changes, the new one can see how the pack was built.
Last five minutes
- Check every tab shows 0 in the balance difference cell.
- Make sure the Index grid has no blank months.
- Read the Flags tab out loud to see whether it makes sense to a stranger.
- Send the workbook and the PDF folder together, with a two-line cover note.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

