🇬🇧 UK

Can I use Excel for personal tax records in the UK?

Looking for US rules? → US money answers

GlobalPublished 6 October 2026 · Written by BuyMeWhiskey Editorial Team · How we check facts

Yes, an Excel spreadsheet can be useful for personal tax record-keeping, but if Making Tax Digital for Income Tax applies to you, spreadsheets alone are not enough to meet the full submission requirement. You may need compatible bridging or accounting software.

Next question: How do I contact HMRC about a tax refund? →

Check HMRC’s current software guidance before relying on a spreadsheet for Making Tax Digital submissions.

HMRC Making Tax Digital software guidance

Run your own numbers: UK take-home pay calculator 2026/27.

A spreadsheet can remain part of the record-keeping process

Excel is useful for organising income, expenses, mileage, invoices and supporting notes. HMRC’s Making Tax Digital guidance does not say every record must be created inside a full accounting package. Instead, the rules focus on creating and storing digital records in software that works with Making Tax Digital for Income Tax when the rules apply.

That creates an important distinction: a spreadsheet can be the place where the underlying business figures live, but you may still need compatible software to send the required information to HMRC.

Making Tax Digital changes the technical requirement

HMRC’s guidance says some sole traders and landlords must use compatible software from 6 April 2026 to report relevant income through Making Tax Digital for Income Tax. The software needs to create digital records, send quarterly updates and ultimately support the tax return submission.

If you keep your records in Excel, HMRC describes a “bridging software” model in which compatible software connects to the spreadsheet. The important point is the digital link: relevant records should move between systems through an appropriate digital process rather than being repeatedly retyped.

A formula link is different from typing the same number twice

HMRC gives examples of digital links, including linked spreadsheet cells, data imports and other electronic transfers. It also warns against manually moving post-submission records by copying and pasting them into another system.

That means a spreadsheet can be designed as part of a compliant workflow, but a simple “I have an Excel total” is not the same thing as having a digital connection from records into the submission software.

What if MTD does not apply to you?

You can still use Excel as a practical record system. You should keep the original supporting documents or copies that you relied on for the tax return, such as invoices and bank statements. HMRC’s record-keeping guidance distinguishes the digital records used for MTD from the wider documents a taxpayer may need to retain.

For a straightforward employee tax return, a spreadsheet can be a simple way to track figures that are not already supplied through forms or online services. For a sole trader, property business or mixed-income case, the spreadsheet should be built around the categories you actually need to report.

A useful tax spreadsheet has a clear audit trail

Give each transaction a date and description.
Use separate columns for gross income, allowable expense and tax category.
Keep an invoice or receipt reference where appropriate.
Do not overwrite original figures without retaining a correction trail.
Reconcile totals against bank statements regularly.

A good workbook is more than a calculator. It should help you explain where a number came from when you revisit the return months later.

Common Excel mistakes

Hard-coded totals are a frequent problem because a changed transaction can leave the summary wrong. Mixing personal and business expenditure in one uncategorised column also makes later review difficult. Another weakness is relying on one giant formula rather than using small, checkable columns for income and expense categories.

If several people or systems work on the records, document the file structure. A spreadsheet that only its creator understands is harder to maintain when an accountant or agent needs to review it.

A simple workflow

You could keep one sheet for income, one for expenses, one for adjustments and one summary sheet. Use formulas so the summary pulls from the detailed sheets. If MTD applies, connect the spreadsheet to HMRC-compatible bridging software and confirm that the software is recognised for the filing you need.

When a spreadsheet stops being the sensible tool

If you have many transactions, stock, payroll, multiple bank accounts or complicated VAT issues, dedicated accounting software may save more time than a large workbook. HMRC provides a software finder for MTD-compatible products, so the choice does not have to be based on a random online recommendation.

Worked example

Illustrative example: A sole trader records £24,000 of sales and £6,500 of allowable business expenses in an Excel workbook. The workbook calculates estimated trading profit as £24,000 − £6,500 = £17,500.

The spreadsheet can show the transactions behind each total, with dates and references to invoices or receipts. If the sole trader is within Making Tax Digital for Income Tax, the spreadsheet alone would not complete the filing job. HMRC says compatible software must create the relevant digital records and send the required updates, although spreadsheet records can be connected through suitable software.

The numbers are illustrative and do not calculate the final tax bill because allowances, other income and the detailed tax rules would still need to be considered.

Can I file my tax return directly from Excel?#

Not by using an ordinary spreadsheet alone where Making Tax Digital for Income Tax applies. HMRC says compatible software is needed to submit the relevant updates and tax return, although bridging software can connect to spreadsheet records. The useful spreadsheet question is not whether Excel can calculate a number, but whether the records and submission process meet the rules that apply to you.

Does HMRC allow Excel for self-employed records?#

Yes, Excel can be part of the record-keeping workflow. The key issue under MTD is whether your records are maintained digitally and linked into compatible software in the way HMRC requires. A spreadsheet is most useful when each total can be traced back to dated transactions and supporting records.

What is bridging software?#

Bridging software connects records kept in a spreadsheet or another system to HMRC-compatible filing software. HMRC describes this as one way to continue using spreadsheet records while meeting the digital submission requirement. Making Tax Digital is about the connected digital process, not simply the visual appearance of the workbook.

Do I have to keep receipts if I use Excel?#

Yes. A spreadsheet does not replace underlying evidence. HMRC says you should continue keeping original records or supporting documents, such as bank statements and invoices, used to prepare the tax return. Bridging software changes how the records reach HMRC; it does not remove the need for accurate source data.

Can I use one Excel sheet for all my tax information?#

You can, but separating transaction detail from summary calculations usually makes errors easier to spot. A clear workbook structure also helps another person understand where a reported number came from. A clear workbook structure also makes an accountant’s review easier if another person later needs to inspect the figures.

How do I choose software for Making Tax Digital?#

HMRC provides a software-finder tool for products that meet the relevant MTD requirements. Compare the features you actually need, including digital record creation, quarterly updates and tax-return submission. The right software choice depends on the records, obligations and filing method that actually apply to you.

Keep reading

Next question →How do I contact HMRC about a tax refund?

Sources

Figures were checked against these sources before publication. If a rule changes, we update the page and show the new date.

General information, not personal financial advice. Rules depend on your circumstances; check the official source or speak to a regulated adviser before acting.