Self-employed expenses spreadsheet UK: SA103 boxes for every bank statement line
A free workbook and a full table mapping everyday UK bank statement lines to SA103 expense categories, with SA103F and SA103S boxes checked for 2025/26.
A self-employed expenses spreadsheet for the UK should sort each bank statement line into the SA103 expense categories, keep the evidence beside it and hold transfers and personal spending apart. For 2025/26 the boxes come from HMRC's SA103F and SA103S pages, and the online filing deadline is 31 January 2027.
Download the UK self-employed expenses organiser (.xlsx). It has three sheets: Instructions, Transactions and Summary. The Summary totals each category against its SA103F and SA103S box, and also shows Transfer, Personal, Review, unclassified rows and total movement. It doesn't calculate tax or decide what you may claim.
HMRC labels these forms by the year the tax year ends, so the 2025/26 pages are the SA103S 2026 and SA103F 2026. Box numbers differ between the two, and they can change from year to year, so check the form for the year you're filing.
SA103S or SA103F: which one applies?
The short form is for turnover under £90,000, or what would have been under £90,000 over a full year. You need the full form if turnover reaches £90,000, if your accounting period ended before 31 March 2026 or wasn't 12 months long, if you changed accounting basis, or if your affairs are otherwise more complicated.
Below £90,000, both forms let you enter one total for expenses, in box 20 on the SA103S or box 31 on the SA103F. You still need records behind that figure, so the spreadsheet does the same job either way.
The forms treat non-allowable costs differently. The SA103F has a second column, boxes 32 to 45, for disallowable amounts included in the main figures. The SA103S has no such column: enter allowable costs only, or if you enter the full cost, put the disallowable part in box 27.
SA103 expense categories and box numbers
These are the expense lines on the 2025/26 forms, with the short working names the workbook uses.
| Working category | SA103F box | SA103S box |
|---|---|---|
| Income (turnover) | 15 | 9 |
| Goods bought for resale or used | 17 | 11 |
| Construction subcontractors | 18 | No box of its own |
| Wages and staff costs | 19 | 13 |
| Car, van and travel | 20 | 12 |
| Rent, rates, power and insurance | 21 | 14 |
| Repairs and maintenance | 22 | 15 |
| Phone and office costs | 23 | 18 |
| Advertising | 24 | 19 |
| Loan interest | 25 | 17 |
| Bank and card charges | 26 | 17 |
| Accountancy and legal | 28 | 16 |
| Other business expenses | 30 | 19 |
SA103F boxes 27 (bad debts) and 29 (depreciation) are for traditional accounting only and never start as a bank line, so they aren't categories here. The SA103S merges several lines, and box 19 is its catch-all. If you're a construction business on the short form, ask your accountant where subcontractor payments should go, because the notes don't say.
Bank statement lines mapped to SA103 boxes
Here's how everyday lines usually fall, drawn from the SA103F notes and helpsheet HS222. Treat it as a filing guide rather than a ruling on your own costs: the box tells you where a cost goes if it's allowable, not whether it is.
| Bank statement line | SA103F | SA103S | Watch for |
|---|---|---|---|
| Customer payment, card or platform payout | 15 | 9 | Turnover is before expenses, so gross up net payouts |
| Stock, raw materials | 17 | 11 | Goods for private use are disallowable |
| Fuel, if you're a taxi driver or haulier | 17 | 11 | Not box 20, per the SA103F notes |
| Building subcontractor | 18 | None | May need the Construction Industry Scheme |
| Staff pay, employer's National Insurance, agency fees | 19 | 13 | Never your own drawings or National Insurance |
| Train, bus, air or taxi fare, hotel | 20 | 12 | Not travel between home and business |
| Fuel, car insurance, servicing, road tax, parking | 20 | 12 | Business share only |
| Meal on an overnight business trip | 20 | 12 | Other meals are disallowable |
| Parking fine, speeding fine | 20 and 35 | Leave out | Disallowable: if in box 20, repeat in box 35 |
| Workshop rent, business rates, electricity | 21 | 14 | At home, business share or flat rate only |
| Repair to premises or equipment | 22 | 15 | Improvements are disallowable |
| Mobile, broadband, postage, stationery, software subscription | 23 | 18 | Business share only |
| Advertising, mailshots, website costs | 24 | 19 | |
| Client lunch or hospitality | 24 and 39 | Leave out | Disallowable: if in box 24, repeat in box 39 |
| Business loan interest | 25 | 17 | Interest only, never the repayment |
| Bank, overdraft or credit card charge, hire purchase interest | 26 | 17 | Not capital repayments |
| Card processor fee on its own line | 26 or 30 | 17 or 19 | Notes don't name processors, so agree it with your accountant |
| Accountant, solicitor, indemnity insurance | 28 | 16 | GOV.UK excludes preparing your Self Assessment return |
| Trade journal, professional subscription | 30 | 19 | Clubs, charities, ordinary clothing are disallowable |
| Laptop, printer | 23 or 49 | 18 or 23 | Depends on accounting basis, see below |
| Tools | 22 or 49 | 15 or 23 | Depends on accounting basis |
| Van | 20 or 49 | 12 or 23 | Depends on accounting basis |
| Car | 50, 51 or 52.1 | 25 or 24.1 | Capital allowances on either basis |
| Loan repayment, your drawings, tax payments | None | None | Not expenses |
| Transfer to savings, payment to your own card | None | None | Mark as Transfer, match both sides |
| Groceries, other personal spending | None | None | Mark as Personal |
The bank line is rarely the whole story. A phone bill needs its private share taken out, a platform payout needs its fee report and a mortgage payment on business premises needs splitting.
The example rows in the workbook
The file ships with fictional 2025/26 rows so you can see the Summary work.
| Date | Description | Amount | Category | SA103F / SA103S |
|---|---|---|---|---|
| 2025-04-14 | Client invoice 201 | 3,200.00 | Income | 15 / 9 |
| 2025-05-02 | Stock supplier | -640.00 | Goods bought for resale or used | 17 / 11 |
| 2025-06-11 | Train to client site | -86.50 | Car, van and travel | 20 / 12 |
| 2025-07-01 | Phone bill | -38.00 | Phone and office costs | 23 / 18 |
| 2025-08-19 | Accountant's fee | -180.00 | Accountancy and legal | 28 / 16 |
| 2025-09-03 | Bank charge | -12.00 | Bank and card charges | 26 / 17 |
| 2025-10-20 | Transfer to savings | -500.00 | Transfer | None |
| 2025-11-05 | Weekly groceries | -65.00 | Personal | None |
| 2026-01-12 | Laptop | -899.00 | Review | Depends on basis |
The Summary shows income of 3,200.00, grouped expenses of 956.50, review items of 899.00, transfers of 500.00 and personal spending of 65.00. Total movement is 779.50, which should match the change in the bank balance over the same rows. That's a completeness check, and it isn't a claim that 1,855.50 is deductible.
Why the laptop sits in Review: capital allowances and cash basis
A laptop isn't a box expense under every basis, which is why the example holds it back.
Cash basis is the standard method for sole traders. Under it, equipment you keep and use in the business is a normal allowable expense rather than a capital allowance. HS222 lists equipment under office costs and tools under repairs, so a laptop lands in box 23 or 18. Cars are the main exception: for their purchase cost, capital allowances are the only route.
Under traditional accounting, which you tick in box 10 of the SA103F or box 8 of the SA103S, the cost of equipment stays out of the expense boxes altogether. You claim capital allowances instead, usually the Annual Investment Allowance in box 49 or box 23, reduced for any private use. Depreciation in your accounts is never allowable. Selling the item later can bring a balancing charge, in box 59 or box 26.
Either way the laptop needs the basis, a business-use percentage and an invoice, so Review is the honest place for it until someone decides. Mark who decides in Notes.
Travel and mileage on the 2025/26 return
GOV.UK's travel list includes fuel, parking, vehicle tax, breakdown cover, public transport, hotels and meals on overnight business trips. It excludes non-business travel, fines and travel between home and work.
The rate trap this year: flat-rate mileage for cars and vans rose to 55p for the first 10,000 miles from 6 April 2026. The rate before that date, which is the one for this return, is 45p, then 25p, with motorcycles at 24p. If you use the flat rate, fuel, insurance, servicing and repairs are already covered, so don't claim those bank lines too. Train fares and parking go on top. You can't use it for a vehicle you've claimed capital allowances on or expensed, and once you choose it you stay on it for that vehicle.
Simplified expenses have no bank line
Flat rates are worked out from your own logs, so they never appear on a statement. Add them as a manual row and keep the log as evidence. Besides mileage, working from home is £10 a month for 25 to 50 hours, £18 for 51 to 100 and £26 for 101 or more. It excludes phone and internet, which you claim by working out the business share. The amount goes in box 21 or box 14. If you live at your business premises, a different flat rate takes off private use. HMRC's checker compares flat rates with actual costs.
The £1,000 trading allowance
Gross trading income of £1,000 or less is generally tax-free and may not need reporting. Above that you can deduct up to £1,000 instead of expenses, in box 16.1 of the SA103F or box 10.1 of the SA103S. Claim it and you can't deduct expenses or capital allowances for that income, it can't create a loss, and it isn't available for receipts from a connected party. The organiser's expense total is the figure you'd weigh it against.
Build your self-employed expenses spreadsheet from bank statements
- Gather every account for 6 April 2025 to 5 April 2026. Monthly statements usually mean both April 2025 and April 2026.
- Fill Transactions with money in positive and money out negative, one row per line.
- Categorise, and use Review rather than guessing.
- Clear the unclassified count, then match total movement to the bank balances.
- Hand the Summary and evidence to your accountant, or enter the totals yourself by 31 January 2027, which is also the payment deadline. The paper deadline has passed.
Have the 2025/26 statements as PDFs? Convert one statement free, no account needed, up to 10 pages, and paste the rows into Transactions. NoRekey checks the rows against the statement's opening and closing balances, which proves the arithmetic. It doesn't prove dates or descriptions, and categories stay your decision.
If MTD reaches you in April 2027, it uses the same income and expense categories as Self Assessment, so this habit carries over.
Frequently asked questions
Do I have to fill in every expense box on the SA103?
Not if your turnover was below £90,000. Both forms let you enter a single total: box 20 on the SA103S or box 31 on the SA103F. You still need records behind the figure and may need to show them to HMRC. Above £90,000 you fill in the individual SA103F boxes.
Which SA103 box do bank charges go in?
On the 2025/26 SA103F, bank, overdraft and credit card charges go in box 26, and interest on bank and other business loans goes in box 25. The SA103S combines both in box 17. Repayments of the amount you borrowed aren't an expense on either form, so split loan payments first.
Where does a laptop go on the SA103?
It depends on your accounting basis. On cash basis, HS222 treats equipment as an allowable expense under office costs, which is box 23 on the SA103F or box 18 on the SA103S. On traditional accounting it stays out of expenses, and capital allowances go in box 49 or box 23.
What mileage rate applies to my 2025/26 tax return?
GOV.UK shows 45p a mile for cars and goods vehicles for the first 10,000 business miles before 6 April 2026, then 25p, and 24p for motorcycles. The 55p first-tier rate applies to 2026/27 onwards. You can't use flat rates for a vehicle you've already claimed capital allowances on or expensed.
Can I claim the trading allowance and expenses together?
No. If you claim the £1,000 trading allowance, in box 16.1 of the SA103F or box 10.1 of the SA103S, you can't also deduct allowable expenses or capital allowances for that income. You choose one method. Whichever you use, HMRC still expects you to keep records of what you received.
Statements in, clean books out.
NoRekey converts bank statement PDFs to CSV, Excel, OFX and QFX — every conversion balance-checked. Free to try.
Convert a statement free →Self Assessment records checklist 2025/26: bank statements and supporting documents
Gather the records for your 2025/26 UK return before 31 January 2027: statements, income evidence, expense receipts and a clear list of what is missing.
How to separate business and personal transactions in Excel
Sort a mixed bank account into business, personal, transfer and review rows without losing the statement balance or guessing tax deductibility.
How to categorise bank transactions in Excel
Use a reviewed payee lookup, an exceptions queue and a category summary to organise converted bank transactions without changing the source evidence.