Skip to main content

Can you use Excel for Making Tax Digital?

Are you self-employed or a landlord ? Do you run a business that uses digital spreadsheets to keep track of your tax records? Yes?

Then you might be wondering if you can use Excel for making tax digital (MTD)?

Let’s find out!

Making Tax Digital Recap

MTD is being rolled out by HMRC to help businesses, the self-employed and landlords get their tax right and to move all their records online. The first part of MTD came into full effect in April 2022 for all VAT-registered businesses. It’ll soon apply to Income Tax (2026) and Corporation Tax (approx 2026) too.

If you run a small business or work for yourself, you might already be used to using HMRC’s online service to complete Self Assessment or to pay VAT . Like many companies and sole traders, you also might use spreadsheets to keep track of your tax and earnings.

As part of the government’s plan to switch to a fully digital tax service, VAT-registered businesses and individuals who pay Income Tax will have to submit these records to HMRC using a certain type of software. This means that the method that many people currently use to submit VAT returns and/or Self Assessment tax returns will no longer be valid!

Our Making Tax Digital (MTD) software for landlords and sole-traders with built-in accountant support is now live. First month for free!

  • Accountant-led onboarding & support

  • Simple-to-use software

  • Affordable pricing options – from £24.99/month

Learn more

Why do I need to use MTD-compatible software?

It’s the law – and you can’t just keep sending paper records to complete your taxes when MTD comes into effect. This is because you have to make sure that the accounting software you use is able to connect directly to HMRC.

So, unless you’re ‘ exempt ,’ the new rules apply to all VAT-registered businesses. And they’ll also apply to sole traders and landlords when MTD for Income Tax comes into effect in 2026 for sole-traders and landlords earning more than £50,000 and 2027 for those earning between £30,000 and £50,000.

If you do not comply with these changes, you will face strict penalties .

Can you use Excel for making tax digital?

Whether or not you can use Excel for making tax digital depends on whether MTD applies to you for VAT or Income Tax.

📈 Income Tax

If you’re self-employed or a landlord and want to use Excel for MTD, then it’s not compatible. This is because Excel does not have the ability to submit updates and submissions to HMRC directly, as required. Instead, you have to use one of the HMRC recognised types of accounting software. You can view the full approved list on HMRC’s website here.

If you still really want to keep using Excel to keep track of your income and expenses, then you can, but just be aware that you’ll need to still use MTD-compatible software to actually submit this information to HMRC.

💼 VAT

If you run a VAT-registered business, then the good news is yes! You can keep using Excel, but you’ll need to find a type of ‘bridging software’ that can connect it to HMRC systems using ‘digital links.’

The value added tax (VAT) rates in the 2025/26 tax year 👇

Tax rate

What the rate applies to

Standard rate

20%

Most goods and services

Reduced rate

5%

Goods and services like children’s car seats and home energy

Zero rate

0%

Goods and services like most food, books and children’s clothes

*Businesses earning more than £90,000 in a tax year must register for VAT. See here for more

These ‘digital links’ allow data to move between one programme and another – giving businesses who don’t want to use full MTD software an ​​interim solution for complying with the new changes.

MTD for ITSA made easy.

We’ll help with a fully compliant service designed to keep your digital filing on track.

Learn more

Need Making Tax Digital help?

If you’re confused by the upcoming MTD changes, and the type of software you need to use, then don’t worry. Get in touch with us for some simple, one-off tax advice from one of our accredited accountants. You can learn more here .

Related Articles

What is the daily self-employed food allowance?

Did you know that if you’re self-employed you might be able to claim back some of the money you spend on food? The self-employed food allowance can be claimed as a business expense on your Self Assessment tax return. But you can’t just claim everything you eat.

Nov 19, 2026 - by Finlay Sheikh

What does Making Tax Digital (MTD) mean?

Making Tax Digital , or MTD, is HMRC’s plan to move the UK tax system online. Instead of filing one tax return at the end of the year, you’ll keep digital records and send regular updates to HMRC throughout the year using approved software . It’s a big shift, but the goal is to make tax simpler, more accurate, and less stressful in the long run.

MTD has been rolling out in stages since 2019. The next major milestone, Making Tax Digital for Income Tax ,  is now live, starting with the 2026/27 tax year. If you’re self-employed or a landlord , this change is likely to affect you.

Nov 19, 2026 - by Lisa Brommer

What does Making Tax Digital mean for self-employed?

Making Tax Digital for Income Tax is changing how self-employed individuals report their income to HMRC from April 2026. If your qualifying income exceeds £50,000, you’ll need to keep digital records and submit quarterly updates using MakingTax Digital software. This guide explains who’s affected, when the changes start, and what you need to do to prepare.

Nov 19, 2026 - by Finlay Sheikh

Tax sorted by a real accountant

Taxfix pairs you with a UK-based, qualified accountant who prepares and files your Self Assessment, so you don’t have to work out the rules yourself. Answer a few simple questions, and we’ll handle the rest, with your return filed right or we fix it at no extra cost.