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 Digital Vat Submission
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.
...
6. To make sense of the data take note of these data types:
VAT INPUTS Calculations:
VATRecalimedOnInputs-All
All = All transactions included in the Inputs submission.VATRecalimedOnInputs-GB0100085 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 is calculated as: the SUM of the VATRecalimedOnInputs-All type MINUS the SUM of what is in the VAT Account, the VATRecalimedOnInputs-GB0100085 type. NET = VATRecalimedOnInputs-All - VATRecalimedOnInputs-GB0100085Inputs =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.