Self Assessment Expenses Excel - Free Template

1. Open the Expenses Log and add each business cost as soon as you pay it. Use the same format for every entry so the records stay consistent.
2. Enter the tax year, supplier, description and business purpose. If you paid VAT, split the net, VAT and gross amounts so the total is clear.
3. Choose the category that best fits the expense, such as travel, office supplies or motor costs. That makes year-end review much quicker.
4. Mark whether the item is allowable. If the cost was partly personal, keep the note clear so you know what to leave out of the claim.
5. Check the Summary sheet to see totals by category and the overall spend. Use it before you complete your return or review cash flow.
6. Read the Instructions sheet before you start, then keep the workbook as your working record for the year. Replace messy receipt piles with one system.

This workbook is for the people who have to prove business spend at the point when the tax return is due, not at some idealised month-end. A sole trader with £48,000 of turnover, a landlord with repairs to track, or a contractor with mixed travel and subsistence can all use it to keep the evidence straight.

It also suits the bookkeeper who wants a simple client file for the 31 January online filing deadline, or the business owner who just wants one list of deductible costs instead of a shoebox of receipts. Image 1 shows the Expenses Log with columns for date, supplier, description, category and business purpose, which is exactly what you need when you are checking what can go on the return.

At the point you need the figures

The pressure usually comes in January, when you have 10 months of paper receipts and a bank feed that only tells half the story. If you spent £640 on train fares, £215 on software and £180 on postage, the log lets you separate those lines quickly instead of rebuilding the year from memory.

Built for real small-business use

A tradesperson with four invoices out a week may only have 30 to 50 expense lines in a quarter, while an online seller can have hundreds of small purchases. The sheet is plain enough for both: you enter the cost once, then the summary gives you a usable total without any extra bookkeeping software.

HMRC expects you to keep records that support the figures in your Self Assessment return. For the self-employed, keep the records for at least 5 years after the 31 January deadline for that tax year; for companies, the record-keeping period is 6 years.

The tax year runs from 6 April to 5 April, so a cost dated 28/03/2026 belongs in the 2025/26 tax year, not 2026/27. If you are VAT-registered, the spreadsheet also helps you keep the net and VAT split tidy: standard rate VAT is 20%, reduced rate 5%, and zero rate 0%, with quarterly returns under Making Tax Digital for most businesses.

What to keep for each line

You need enough detail to show what the cost was for and why it was business-related. The sheet’s Business Purpose, Notes and Allowable? fields cover the practical basics: for example, £74.80 for station fares to a client meeting is easier to support than a bare bank entry with no description.

Why the split matters

If you buy £120 of items including VAT and £100 is allowable, the taxable cost you claim is the net amount, not the card total. That matters in a year with 60 or 70 expense lines, because a few wrong gross entries can distort the profit figure by several hundred pounds before you notice.

The usual problem is not missing a grand gesture of a mistake. It is 20 small items entered badly: a £14 lunch treated as fully allowable, petrol with no business note, or a receipt posted twice because it was paid by card and then copied into a spreadsheet again.

Wrong totals and lost claims

If you leave VAT and net mixed together, you can overstate expenses and then overclaim tax relief. On £3,000 of mixed spending, a simple 20% VAT confusion can shift the figures by £500, which is enough to change what you owe and create work when the return is reviewed.

Private items slip through easily

Mixed-use costs are where people go wrong. A phone bill of £48 a month with only 70% business use should not be treated like a full business charge, and a private supermarket run coded as travel is exactly the sort of line that causes trouble when you check the figures before filing.

Missing descriptions waste hours

A receipt with no description means you are guessing later. If you have 150 lines at year end and 25 of them just say miscellaneous, you can easily lose half a day trying to remember what each item was for, which is poor bookkeeping and poor cash flow control.

The 150 lines at year end are much easier to sort when travel is separated properly, and the mileage claim Excel template HMRC keeps business journeys clear before they end up mixed with general expenses.

The best way to use this sheet is to attach it to one fixed routine. Most sole traders do best by updating it once a week, or straight after the bank reconciliation, rather than waiting for a quarterly panic before the HMRC deadline.

Three habits that keep it alive

• Add receipts every Friday, before you close the week.
• Match the log to your bank statement or card statement once a month.
• Use the same category names every time, so your summary stays tidy.
• Keep a photo of the receipt with the line in the workbook if you need the detail later.

If you are entering 40 expenses a month, that is usually 10 minutes at a time if you do it regularly. If you leave it for a year, the same work can turn into several hours of sorting and checking, which is why a small fixed routine beats a big annual tidy-up.

When a spreadsheet is no longer enough

Once you are handling VAT returns, payroll, stock or several users at once, you may need proper bookkeeping software. For one person or a small team with simple expenses, though, this workbook is usually quicker, cheaper and easier to control than a full system.

Several users at once and VAT returns often mean cash movements matter as much as expense tracking, so the cash flow forecast Excel template UK fits neatly alongside this workbook for a clearer view of what comes in and goes out.