I am preparing for MTG, by running out the Vat return, but I cannot reconcile it to the Purchase and Sales tax account for the period.
It worked in the first quarter that I tried (12/18 - 2/19). However, in the second quarter (3/19 - 5/19), the Vat return included transactions from the previous quarter. I have set the Vat start date as 1/12/18. It does not seem to have taken all transactions from the previous quarter, and when I run the NL accounts for the full 6 month period, the NL figures are significantly higher than the Vat return.
How do I ensure that the Vat return only includes the current quarter transactions?