LaunchKit resource
Self-employed expense spreadsheet for UK records
An expense spreadsheet is useful only if it helps you capture real business costs while they are still easy to evidence. For UK sole traders, the goal is a clean record of what was spent, when it happened, what it related to, and where the proof is stored. This page shows how to structure that workflow without pretending a template decides tax treatment for you.
What to track in an expense spreadsheet
A practical expense record needs more than a total. Include the date, supplier, amount, payment method, category, notes, and a reference to the receipt or invoice. That gives you enough context to review the cost later and separate business spending from personal drawings. It also makes conversations with an accountant easier because the spreadsheet shows your working, not just a final number.
Do not let the spreadsheet decide tax treatment
A template can organise records, but it cannot tell you with certainty whether a cost is allowable in your circumstances. GOV.UK explains allowable expenses and the records self-employed people need to keep. Use those references, HMRC guidance, or professional advice for judgement calls. LaunchKit keeps the workflow practical: capture the transaction clearly, store proof, and avoid mixing advice with admin structure.
How financial forms and MTD workbooks differ
Financial forms are useful when you need paperwork around the transaction: invoices, quotes, receipts, job records and expense forms that can be saved or shared. An MTD workbook is more about ongoing totals and category structure. Many small businesses need both: customer-facing documents for the work itself, then a weekly record that makes income and expenses easier to review.
A simple weekly routine
Pick one weekly slot and process everything from that week. Add expenses, name the proof file, check the category, note anything uncertain, and leave unclear items flagged rather than guessed. That rhythm is quicker than a year-end catch-up and helps protect the quality of your records. It is also easier to maintain if your forms, invoices and receipts all use consistent labels.
Keep proof close to the spreadsheet row
The spreadsheet row should point back to evidence. Use a file name, receipt folder, invoice number or bank reference that makes the source document easy to find later. That habit turns the sheet from a loose list into a useful audit trail for your own review. It also helps you spot missing proof quickly, while suppliers and job details are still easy to remember.
Compare the next step
Questions before you choose
Can a spreadsheet tell me what is allowable?
No. It can organise the record, but you should check GOV.UK guidance or professional advice for whether a cost is allowable.
Should I keep receipts as well as a spreadsheet?
Yes. A spreadsheet summary is not a substitute for proof. Store receipts, invoices, bank records or other evidence alongside the record.
Which LaunchKit product should I start with?
Start with financial forms if you need invoices and expense paperwork. Start with MTD spreadsheets if your main gap is recurring record structure.