We sort your Self Assessment for you. £149, all in.

Fast, effortless and 100% online.  Learn more

We sort your Self Assessment for you. £149, all in.

Can you use Excel for Making Tax Digital?

  • 3 min read
  • Last updated 22 Jul 2022

Are you self-employed or a landlord? D 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 (2024) and Corporation Tax (approx 2026) too.

Making tax digital deadline

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!

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 2024. 

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, such as:

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.’

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.

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.

TaxScouts Newsletter

Want regular tips from us?

Sign up for important updates, deadline reminders and basic tax hacks sent straight to your inbox.

Category
TaxScouts Newsletter

Want regular tips from us?

Sign up for important updates, deadline reminders and basic tax hacks sent straight to your inbox.

Category