Using the Sage MTD Adapter you can import VAT Returns from a spreadsheet or your software then submit them to HMRC.

Once you have brought your figures into the Sage MTD Adapter, if required, you can adjust these figures by exporting to excel, make any changes and importing back in.

The Export to Excel option is only available to Accountants and Bookkeepers.

1. In the Sage MTD Adapter, click Export to Excel.
2. Enter a File name then browse to the folder where you want to save this file, and click Save.
   
   Excel automatically opens with your VAT Return figures.
   
   
3. In the Adjustment column, make the required changes:
   • To increase the value on a box enter a positive value.
   • To decrease the value on a box enter a negative value.
4. Click File and click Save, then click File and Close.
5. In the Sage MTD Adapter, click New.
6. From the Application drop-down click Excel.
7. Browse to the file created in step 2 and click Open.
8. In the Company list select the company and click Choose Company.
9. In the Select VAT Periods window, select the required period and click OK.