Bookkeeping · 14 Nov 2026 · 10 min read

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.

NoRekey
NoRekey editorial team

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

  1. Gather every account for 6 April 2025 to 5 April 2026. Monthly statements usually mean both April 2025 and April 2026.
  2. Fill Transactions with money in positive and money out negative, one row per line.
  3. Categorise, and use Review rather than guessing.
  4. Clear the unclassified count, then match total movement to the bank balances.
  5. 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 →
More from the blog