Solution Properties
Solution ID:
200427112523939
Last Modified Date:
Wed Aug 06 10:21:54 UTC 2025
Taxonomy Path:
Case category//How do I...//setting up
Author:
[email protected]
Sage MTD Adapter - import VAT Returns from Microsoft Excel
Description

Using the Sage MTD Adapter it's easy to import VAT Returns from a spreadsheet then submit them to HMRC.

TIP: To make things simple, you can create a blank Excel template as a starting point. To do this, within the MTD Adapter click Tools and select Generate blank Excel template.  Read more >


You can also import VAT Returns from TASBooks, Sage 50 Accounts or Sage 200.

 CAUTION: This feature is only available with a Sage 50 Client Manager licence for accountants. 

Cause
Resolution

 NOTE: Your submission to HMRC must be for one VAT Registration number and one VAT Period only. Once you select your companies, any discrepancies are highlighted under Selected companies.

  1. Open the Sage MTD Adapter.
  2. Under Application, in the drop-down choose Excel.
  3. Browse to the required Excel spreadsheet and click Open.
  4. Under Company, click the company you want to submit for then click Choose Company.
  5. In the Select VAT Periods window, click the VAT period you want to submit, then click OK.
  6. Repeat steps 2 to 5 for each company you want to include in your submission.

    The VAT Return section now shows the combined VAT figures ready to Submit your VAT Return using the Sage MTD Adaptor.
[BCB:184:Emma Footer CB:ECB]

 

 

 

[BCB:19:UK - Sales message :ECB]

 

Steps to duplicate
Related Solutions