Submit your UK VAT Return from Excel

Explore solutions for Making Tax Digital
Designed for accounting firms and small businesses

Submit your UK VAT Return from Excel

Explore solutions for Making Tax Digital
Designed for accounting firms and small businesses

Are you still using Excel?

Get ready for Making Tax Digital with DataDear!

Choose one of the following options:

Option 1: HMRC Direct

Image

Direct with HMRC

Easily submit your VAT return with a few clicks to HMRC.

Submit from Excel

Map your workbook or use a sample template & push directly from Excel.

Use it for FREE

Integration with HMRC is completely FREE - no hidden fees or charges.

Learn more

Option 2: Xero Accounting

Image

Post data into Xero

Post receive and spend bank transactions from Excel into Xero.

Validated Transactions

Transactions posted to Xero accounting are validated on posting.

Review not Redo

Designed for accountants to share with their clients.

Learn more

Option 3: QuickBooks Online

Image

Post data into QuickBooks

Post receive and spend journal entries from Excel into QuickBooks.

Validated Transactions

Transactions posted to QuickBooks accounting are validated on posting.

Review not Redo

Designed for accountants to share with their clients.

Coming Soon

Used by 3,000+ accountants & bookkeepers worldwide

⭐⭐⭐⭐⭐

Rated 5 stars on the Xero marketplace


ONE-CLICK INTEGRATION

You are a click away from connecting your service to DataDear Excel Add-In.

2-WAY COMMUNICATION

You can pull from and push data directly from your Excel.

TABLES & REPORTS

DataDear fully utlizes the full integration giving you access to all tables & reports.

DATA CLOUD

Your data remains securely stored.

Making Tax Digital in the UK

Get set for digital returns

HMRC have set out their intentions to become one of the most advanced tax authorities in the world by enhancing the customer experience whilst also closing the tax gap. They aim to do this through the Making Tax Digital initiative, which will transform how HMRC deal with their customers.

So what does this mean for VAT registered businesses?

HMRC There are three key digital components to Making Tax Digital for VAT (MTDfV):

1. Digital records

Although this does not mean businesses will have to store each invoice and receipt digitally, the transaction data will need to be stored digitally. This includes an AP and AR transactional listing and a digital VAT account from which the VAT return is prepared.

2. Digital links

VAT returns must have digital links to digital records – spreadsheets can remain, but they will need ‘digital links’ to source systems. HMRC has announced a soft landing period of 12 months, however digital links will be mandatory from April 2020.

3. Digital submission

At present, most businesses submit their VAT returns through manually re-keying into HMRC’s online portal. This will no longer be permitted once Making Tax Digital comes into force and instead, VAT return submissions must be done digitally via HMRC’s Making Tax Digital API. Digital submission of VAT returns will be required for most businesses for periods starting on or after 1 April 2019.

Image

Who does it affect?

Making Tax Digital (MTD) covers both individuals and businesses across a number of taxes. For businesses over the VAT registration threshold, VAT is the first tax selected for digitalisation in the UK. This will take effect from 1 April 2019 for most businesses. For Income Tax and Corporate Tax, MTD will not be mandated until April 2020 at the earliest.

Myth busters

DataDear is a powerful Excel toolbar connected to &

Connect your Xero Accounting and QuickBooks Online to your spreadsheet to refresh and push data directly from Excel