How To Use Spreadsheets To Submit VAT For Making Tax Digital

Making Tax Digital (MTD) for VAT officially came into force on 1st April 2019. However, for many the first MTD for VAT return isn’t required until 7th August 2019 – and this is only for those…

5 Minute Read

Last Updated: 28th June 2022

Making Tax Digital (MTD) for VAT officially came into force on 1st April 2019. However, for many the first MTD for VAT return isn’t required until 7th August 2019 – and this is only for those whose first VAT period ended 30th June 2019.

You’ll need to know about VAT for MTD if your turnover is over the current VAT registration threshold (£85,000 for 2019/20). Otherwise, you risk being penalised.

An introduction to VAT for MTD

A basic summary of this first phase of MTD is that it makes submitting VAT an entirely digital experience – and through HMRC’s very specific path. Instead of paper returns or using the government’s tools, bookkeeping or bridging software is required.

Whilst spreadsheets were not technically in HMRC’s ‘digital vision’, they ultimately decided (after much lobbying) that they will be allowed for MTD VAT record-keeping. For some, this makes getting to grips with digital filing much easier.

However, there’s a catch: a compatible bridging tool is necessary to file in the correct format. We explain what this software is, along with how exactly you can go about using spreadsheets to submit VAT, below.

What are the benefits of using spreadsheets for VAT?

You can take advantage of MTD spreadsheets in a number of ways.

Familiarity

Spreadsheets allow you to maintain your current processes. MTD is a big change, and using a familiar tool can ease you in.

Flexibility

They also accommodate your needs – whether you’re an accountant filing for multiple clients using specific formulae or a business owner doing your own taxes. They make VAT calculations much more straightforward, and you can pull these through to HMRC compliantly via bridging software.

Simple transfer

 As your current practices can continue, the transfer of information through bridging software is incredibly simple.

How do you use spreadsheets for filing VAT returns?

Using spreadsheets to submit VAT is simple – you just employ their functionalities as you currently do. All HMRC require is digital VAT records and calculation in your spreadsheet – the information is then passed to the bridging software digitally and onwards to HMRC.

These tools quite literally ‘bridge the gap’ between your spreadsheets and HMRC.

You’ll need to input the same type of data as you have for previous returns, such as:

  • Time of supply (tax point)
  • Value of supply (net excluding point)
  • Rate of VAT you charged

You should also share information about your business. For example:

  • Business name
  • Main business address
  • Your VAT registration number
  • Details of any VAT accounting systems you use

After this is entered, you’ll just need to make sure you use bridging software that’s on HMRC’s approved list of suppliers, like GoSimpleVAT.

Why is it important to follow VAT for MTD?

It’s a good idea to submit your VAT digitally, whether or not you’re legally obliged to. As well as avoiding potential penalisations later on, it offers a number of benefits.

Preparation

If your turnover doesn’t currently exceed the VAT threshold, you could voluntarily register anyway and choose to file returns digitally.

On top of this, whilst you may not need to submit electronically right now, you might have to do so for other tax returns in the future. There are plans for both Income and Corporation Tax to be brought into the new digital age, potentially from as early as 2021.

Making Tax Digital advantages

Along with getting ahead, you may also take this as an opportunity to review and potentially streamline your accounting. This will minimise the time spent on your VAT returns, making all processes significantly more efficient and simpler.

You’ll find it easier to keep on top of your record-keeping, giving you a better picture of your finances. You can then understand how you’re performing and make data-driven decisions based on this.

Staying on top of MTD for VAT

So long as you choose compatible tools, and also submit your VAT returns on time, then you’ll be able to maintain HMRC’s digital path compliantly and with ease. Make sure you know when your first quarterly period was from 1st April 2019, and the deadline to file digitally by.

As spreadsheets are so simple and offer numerous benefits, using bridging software like GoSimpleVAT is ideal. It’ll help you avoid any penalties and take advantage of the digitalisation of tax.

Our tools digitally link to HMRC so you can submit MTD for VAT returns. You can also import your reports from any spreadsheet or PDF, and we provide peace of mind with our industry-leading data security.

There are easy-to-understand dashboards too, and our software can be accessed from your mobile. Discover more about GoSimpleVAT by getting in touch with our team today.

Last updated on 25th July 2019.

Our One year to go! Prepare for Making Tax Digital for VAT now to avoid penalties article may be of interest

Trusted by over 15,000 subscribers

You don't need to be an expert to complete your self assessment tax return.

Start your free trial

Blog content is for information purposes and over time may become outdated, although we do strive to keep it current. It's written to help you understand your Tax's and is not to be relied upon as professional accounting, tax and legal advice due to differences in everyone's circumstances. For additional help please contact our support team or HMRC.

DOING YOUR TAX RETURN HAS NEVER BEEN SO EASY.

Start your Self Assessment tax return today for free.

Sign up Now

How much tax does a landlord need to pay? 10 key questions answered…

18 May 2023

The UK has more than 2.7m unincorporated landlords and each year they report to HMRC rental property income worth some £41bn. Unincorporated landlords are…
READ MORE >

How to claim a tax rebate when you’re a sole trader

04 May 2023

Even if it’s only a few quid, finding out that you’re in line for a tax rebate because you’ve paid too much tax is…
READ MORE >

21 expenses you can claim as a private residential landlord

02 May 2023

Being a landlord can be costly. There are so many things to buy and expenses to pay, while repairs and maintenance work can really…
READ MORE >

How GoSimpleTax Works

01.
Register

Simply register for free with your full name and email address.

02.
Select Your Income

Select the income you receive and follow the hints and tips for potential tax savings.

03.
Validate Your Information

Validate your personal information and submit directly to HMRC to get confirmation in just seconds.

ipad

Work Anywhere, With Any Device

Gone are the days of fretting over a calculator surrounded by scraps of paper at the eleventh hour.

GoSimpleTax’s tax return software uses the information you upload in real time to calculate your income and expenditure, working out the tax you owe and sending you helpful notifications when there’s the possibility of a mistake.

Start your free trial

"The software is intuitive and proved very easy to navigate. I found the whole process refreshingly simple. I saved a lot of money too!"

Steve J.

Ordained Presbyter

"Easy to use and value for money. Everything you need to do your tax."

Gordon J.

Self Employed

"It fills in all the forms and sends them to the Inland Revenue. Not expensive either. Takes the stress out of doing your tax return online."

Ross G.

Team Rector

Start your free trial