Self assessment records for a UK sole trader cover all sales and income, all business expenses, and proof such as receipts and bank statements. Keep them for at least five years after the 31 January deadline for that tax year. A spreadsheet built from your bank statements can total income and costs for each 6 April to 5 April year.
Which self assessment records does HMRC expect from a sole trader?
HMRC expects a sole trader to keep records of all sales and income and all business expenses, plus records of personal income. The GOV.UK page on what records to keep if you're self-employed adds VAT records if you are registered and PAYE records if you employ people.
The list is short, but each line is broad. "All sales and income" means every invoice paid, every cash sale and every payout from a platform, not just the payments that arrived by bank transfer. "All business expenses" means each cost you plan to claim, with something that shows what it was.
For a sole trader with no staff and no VAT registration, the working set usually looks like this:
- Sales records. Invoices issued, till rolls or platform sales reports.
- Income received. Bank statement rows showing payments in, plus a note of any cash taken.
- Expense proof. Receipts for goods and stock, supplier invoices and bills.
- Bank and card statements for every account the business uses.
- Personal income records, such as a P60 from a job, savings interest or rental income, because the return covers all of it.
The same GOV.UK page lists the kinds of proof HMRC accepts. Bank statements and chequebook stubs are on that list, next to receipts for goods and stock. So statements are a recognised record, not a second-best substitute.
Where bank statements fit among self assessment records
Bank statements are the backbone of most sole traders' self assessment records, because they show every payment in and out with a date and an amount. They are not complete on their own. A row shows that £38 went to a supplier, but not whether it bought stock or a birthday present. Receipts and invoices fill that gap.
Statements do two jobs well. First, they catch income you might forget: a client who paid late, a refund from a supplier, a platform payout. Second, they put a firm date on each transaction, which matters when you split the year.
They also have blind spots:
- Cash. Money taken in cash and spent in cash never touches the account. Keep a separate cash book.
- Purpose. Descriptions such as "CARD PAYMENT AMAZON" say nothing about what was bought.
- Mixed accounts. If business and personal spending share one account, the statement mixes them and you must sort them.
The practical rule: use the statement as the list of everything that happened, then attach a receipt, invoice or note to each row you claim as a business cost.
Self assessment records across the 6 April to 5 April tax year
The UK tax year runs from 6 April to 5 April, so bank statements almost never line up with it. Each return covers one tax year, so its totals must too. The statement covering late March to late April has to be split at 5 April by the date on each row.
Most monthly statements close on a date set by the bank, such as the 20th. The statement that runs from 21 March to 20 April holds rows from two tax years. Sending the whole statement to one year moves about two weeks of income and costs into the wrong return.
The fix is mechanical once the rows are in a spreadsheet. Add a Tax year column that labels each row by its date:
=IF(A2>=DATE(YEAR(A2),4,6), YEAR(A2)&"-"&(YEAR(A2)+1), (YEAR(A2)-1)&"-"&YEAR(A2))
A row dated 4 April 2026 reads 2025-2026. A row dated 6 April 2026 reads 2026-2027. Totals then come from SUMIFS on that column, and statement dates stop mattering.
Note which accounting method your business uses, because it decides which date counts. If you record money when it arrives and leaves, the bank row date is the one to use. If you record invoices when you issue them, the invoice date may put a sale in an earlier year than the payment.
How long must self assessment records be kept?
Keep self assessment records for at least five years after the 31 January submission deadline for the relevant tax year. GOV.UK gives an example on its page about how long to keep your records: a 2022 to 2023 return sent online by 31 January 2024 means keeping records until at least the end of January 2029.
Worked forward for a current year:
| Tax year | Online deadline | Keep records until at least |
|---|---|---|
| 2024 to 2025 | 31 January 2026 | End of January 2031 |
| 2025 to 2026 | 31 January 2027 | End of January 2032 |
| 2026 to 2027 | 31 January 2028 | End of January 2033 |
There is one exception on the same page. If you send a return more than four years after the deadline, you keep the records for 15 months after you send it.
Statements are the record most likely to vanish before the period ends. Banks limit how far back online statements go, and a closed account may have no online access at all. Download each month's statement as a PDF and file it by tax year. Storage is cheap; asking a bank for a six-year-old statement is not always possible.
A free self assessment records spreadsheet that totals income and costs
A free spreadsheet can turn bank statement rows into the two totals a self assessment return needs: income and allowable costs, grouped by category. It needs three tabs: Rows for the statement data, Categories for the expense headings you use, and Summary for the totals by tax year. Any spreadsheet program handles it.
The layout:
| Tab | Columns | Filled by |
|---|---|---|
| Rows | Date, Description, Paid in, Paid out, Tax year, Type, Category, Proof | Statement, then you |
| Categories | Category name, notes on what belongs in it | You, once |
| Summary | Category, total for the selected tax year | Formulas |
"Type" takes one of three values: Business income, Business cost or Personal. "Proof" holds a receipt file name or invoice number, so every claimed cost points to its evidence.
Here is an example quarter for an invented freelance photographer. Every row and amount is made up.
| Date | Description | Paid in (£) | Paid out (£) | Type | Category |
|---|---|---|---|---|---|
| 08/04/2026 | FPS NORTHGATE STUDIOS | 950.00 | Business income | Sales | |
| 15/04/2026 | CARD WEX PHOTO VIDEO | 189.00 | Business cost | Equipment | |
| 02/05/2026 | TESCO STORES 2231 | 64.20 | Personal | ||
| 19/05/2026 | FPS HALE & CO | 600.00 | Business income | Sales | |
| 28/05/2026 | DD ADOBE SYSTEMS | 19.97 | Business cost | Software | |
| 11/06/2026 | CARD TRAINLINE | 42.50 | Business cost | Travel | |
| 30/06/2026 | ACCOUNT FEE | 8.00 | Business cost | Bank charges |
In this example, the quarter's business income is £1,550.00 and its business costs are £259.47. The supermarket row stays in the sheet, labelled Personal, so the statement and the sheet still agree row for row.
The Summary tab uses one formula per category, for instance =SUMIFS(Rows!D:D, Rows!E:E, "2026-2027", Rows!F:F, "Business cost", Rows!G:G, A2). Change the tax year text and the whole tab recalculates.
If your only copy of Excel is on a work laptop, check what the licence allows before using it for your own books. Using work Microsoft Office for personal use explains the limits and the free alternatives.
Self assessment records mistake: personal spending in the business totals
The costliest records mistake is letting personal spending reach the business cost total. It happens easily in a shared account: a supermarket shop, a family phone bill or a personal subscription gets tagged as a business cost. Each one understates profit, and an HMRC check will find it row by row.
Some rows need a closer look because they can go either way:
- Bank charges. A fee on an account used for the business can be a business cost; a fee on a personal account is not. Whether bank fees are tax deductible explains the split, from a US angle, and the business-versus-personal logic carries across.
- Phone and broadband. Only the business share belongs in the total. Note how you worked out the share.
- Equipment used at home. A camera bought for jobs and holidays needs a record of the business use.
The opposite mistake costs money too: a real business cost left out because the receipt was lost or the row was never tagged. In the UK, HMRC has its own process for changing a return after it is sent. The US version of the same problem, finding missed costs in old statements, is covered in amending a tax return for missed deductions, and its advice on weighing the refund against the effort applies here too.
Self assessment records under Making Tax Digital for Income Tax
Making Tax Digital for Income Tax changes how some sole traders keep and send their self assessment records. GOV.UK's Making Tax Digital eligibility guidance says sole traders and landlords with qualifying income over £50,000 in 2024 to 2025 should have started using it from 6 April 2026.
The threshold then falls in stages:
| Qualifying income in tax year | Over | Start using Making Tax Digital from |
|---|---|---|
| 2024 to 2025 | £50,000 | 6 April 2026 |
| 2025 to 2026 | £30,000 | 6 April 2027 |
| 2026 to 2027 | £20,000 | 6 April 2028 |
If your income is near one of those lines, the habits in this post still apply. A sheet with every statement row, each one labelled with a tax year, a type and a category, is the raw material any compatible software will need. HMRC's guidance on qualifying income and on the software you must use sits on separate GOV.UK pages; check them before the date that applies to you.
When your bank only provides PDF statements, the spreadsheet needs the rows typed or converted first. CheapBankConvert is being built to turn a statement PDF into CSV or Excel rows, paid once per document, with the first 2 pages previewed free. It has not opened yet; get started to be emailed when it does.