Can't find what you're looking for? Still have questions? Contact customer support (smile)

Generate a MTD VAT CSV Report

Owned by Hilary Hawkins (Deactivated)
Last updated: 21 Apr 2022 by Kai Andras
2 min read

You can generate an output of transactions that the MTD Vat Submission module is using to calculate your VAT and Net Figures. To do so follow these steps.

 

1. Go into the VAT Submission Module


2. Populate the Submission module with your VAT calculation details as described in 

 

3. Tick the Create CSV Report checkbox and then click Calculate. 

4. An Excel document will popup and populate with the transactions used to calculate your vat submission.


5. The document will be output as a .csv file. Save it as an Excel document instead so you can run excel filters over the data. The output will look like something below:

 

6. To make sense of the data take note of these data types:

VAT INPUTS Calculations:

  • VATRecalimedOnInputs-All = All transactions included in the Inputs submission.

  • VATRecalimedOnInputs-GB0100085 = (the GB010085 portion will reflect your productions VAT account code). The transactions in your VAT account that are included in the Inputs submission.

  • Net Purchases and Inputs = VATRecalimedOnInputs-All minus VATRecalimedOnInputs-GB0100085.

 

VAT OUTPUTS Calculations:

  • VATDueOnOutputs-All = All transactions included in the Outputs submission.

  • VATDueOnOutputs-GB01000850 = (the GB0100850 portion will reflect your productions VAT account code). The transactions in your VAT Sales accounts that are included in the Outputs submission.

  • Net Sales and Outputs = VATDueOnOutputs-All minus VATDueOnOutputs-GB01000850.

 

NET VAT Calculation:

  • Net VAT = VATRecalimedOnInputs-GB0100085 minus VATDueOnOutputs-GB01000850.