Last checked against GOV.UK: 16 November 2026
What HMRC says
HMRC’s guidance is that if you use spreadsheets for your records, you can continue to use them, but you will also need software that links to your spreadsheets. That second piece is usually called bridging software.
So the set-up has two parts:
| Part | Job | Example |
|---|---|---|
| Your spreadsheet | Holds the digital records: every sale and expense with its date, amount and category. Adds them up. | Your own workbook, or a ready-made one such as QuarterKit |
| Bridging software | Reads the totals from your spreadsheet and sends them to HMRC. Must be HMRC-recognised. | Chosen from HMRC’s software finder |
What your spreadsheet must contain
For each item of self-employment or property income and each expense:
- the amount,
- the date you received the income or incurred the expense, and
- the category. See the full list.
Two helpful easements: retailers can record one figure for each day’s gross takings instead of every sale, and if your turnover is under £90,000 you may only need to mark each item as income or expense.
The rule that catches people out: digital links
Once a figure is in your digital records, it has to travel to HMRC digitally. You must not retype it or copy and paste it from one program into another.
What counts as a digital link:
- formulas that link one cell or sheet to another,
- importing or uploading a spreadsheet or a CSV file into your bridging software,
- emailing the spreadsheet to your accountant, or moving it on a USB stick,
- automated transfers between programs.
What does not: reading a total off the screen and typing it into another program, or copy-and-paste between programs.
Choosing bridging software
HMRC does not recommend products, but every product in its software finder has been through its recognition process. When you compare them, ask:
- Does it work with my own spreadsheet, or only with the supplier’s template? Some let you point to the cells holding your totals; others ask you to use their layout or import a file.
- Does it cover what I need? Self-employment, UK property, or both. Quarterly updates only, or the year-end tax return as well.
- What does it cost per year, and is there a free tier or trial? Prices and limits change often, so check the supplier’s own site.
- Does it run where I work? Some are Excel add-ins for Windows only; others run in a browser and work with Google Sheets.
Try the free trial with real figures before your first deadline, not the night before it.
Spreadsheet or full accounting software?
| Spreadsheet + bridging | Full accounting software | |
|---|---|---|
| Cost | Low. A one-off template plus a bridging tool. | Usually a monthly subscription; some free tiers. |
| Learning curve | Small if you already use spreadsheets. | New system to learn. |
| Bank feeds, invoicing, receipt capture | No. | Yes, in most. |
| Best for | Simple affairs, low transaction numbers, people who like to see the workings. | Busy businesses, VAT-registered traders, people who want automation. |
Neither is the “right” answer. If you have forty transactions a month and already keep a tidy spreadsheet, there is no rule that says you must switch.
Sources
A spreadsheet that is ready for the bridge
QuarterKit workbooks hold every record HMRC asks for and calculate each update’s totals by formula on a single sheet.
See the kitsThis guide is general information, not tax advice.