Making Tax Digital for VAT : Exporting VAT data into MS Excel from Bookkeeping solutions - Quick Start Guide

Introduction

Making Tax Digital for VAT introduces the requirement for VAT registered businesses with taxable turnover above the VAT registration threshold to keep records in digital form and file their VAT returns via functional compatible software.

Our priority is to support Advisors, and their Clients, by delivering a VAT filing solution that allows you to maintain your current VAT processes as closely as possible. Advisors have significant legacy calculations and formulas within spreadsheets today that make the recurring task of completing a VAT return for specific clients more efficient.

This quick start guide documents how to export VAT data from Bookkeeping solutions into MS Excel and the preparation for submitting the return through CCH OneClick - Making Tax Digital.

Bookkeeping solutions include:

• Xero
• QuickBooks
• Exact
• Sage One
• CCH Practice management

Exporting VAT Data from Xero

1. From the 'Reports' menu select 'Vat Return'.
   
2. Click on 'Export' in the bottom right of the screen
   
3. Select 'Excel'.
   
4. Save to a location.

Exporting VAT Data from QuickBooks

1. From the menu bar, select 'Taxes'.

2. Click on 'View reports'.

3. Select either VAT 100 or VAT 101 report.

4. Click on the icon

5. Select 'Export to Excel'.

6. Save the file to a location.

Exporting VAT Data from Exact

1. Go to Financials > Taxes > Reports > VAT overview.

2. Click on
and select 'Export: Excel'.
3. Save the file.
 

Exporting VAT Data from Sage One

1. From the menu bar, select Reporting, VAT Returns.
2. Click on 'Create VAT Return'.
   
3. Enter the relevant date ranges.
   
4. Click on 'Calculate'.
   
5. If previous have not been included and you are required to include them, make sure the bullet is selected for 'Now - include them on this return'.
6. Click on 'Continue'.
7. Select 'Detailed Report' to export into a CSV file.
   
8. Select 'CSV'.
9. To open the file click on 'VAT Return Detailed below.
   
10. Save the file as type .xls to a location.

Exporting VAT Data from CCH Practice Management

1. From 'Smart Reports', select period end.
2. Select 'Accruals Basis' or 'Cash basis'.
   
3. To run the report double-click or click on 'Run' (F5)
   in the tool bar.
4. Filter the correct period.
5. 

   Note: there are various options to export the data into Excel however, for the purpose of VAT reporting the method shown below is best practice.

6. Type in the period i.e. January.
   
7. Click on 'OK'.
8. Click on Export to left of the window.
   
9. Save the file.
10.