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 here.
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:
VATRecalimedOnInputs-All
= All transactions included in the Inputs submissionVATRecalimedOnInputs-GB0100085 (the GB010085 portion will reflect your productions VAT account code)
= The transactions in your VAT account that are included in the Inputs submissionNet 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-GB0100085