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

Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Next »

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 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 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

  • No labels