VAT Reconciliation Report - Auto-populate and drill down into figures
An updated, functional VAT reconciliation report.
The existing VAT reconciliation report isn't particularly useful. It has to be populated manually and the figures that do populate automatically can't be drilled down into. Not helpful.
VAT reconciliation aren't really a problem for us as we can use the Detailed Account Transactions report to identify the transactions posted directly to the VAT account i.e. transactions that have a category of VAT, whether it be a VAT payment, VAT on imports or just simply a miscoding by the client. Essentially it highlights those transactions that will affect the VAT ledger balance but won't necessarily appear on a VAT return.
However, the Detailed Account Transactions report is being retired in July and I fear we'll have no way of identifying these transactions. I've contacted Xero support and they weren't aware of the report being used in this way and don't currently have plans to replace this report.
I feel there are 3 options here:
Don't retire a functional report,
Retire a functional report but replace it with a new version, or,
Create a functional VAT reconciliation report that highlights the differences between the VAT ledger balance and total VAT returns less total payments.
![](https://secure.gravatar.com/avatar/76bae7a02bba9cabd0d6bd6d847734cc?size=40&default=https%3A%2F%2Fassets.uvcdn.com%2Fpkg%2Fadmin%2Ficons%2Fuser_70-6bcf9e08938533adb9bac95c3e487cb2a6d4a32f890ca6fdc82e3072e0ea0368.png)
-
Marcia Nkogatse commented
How do we prepopulate the VAT transaction on the Xero VAT Reconciliation
-
David Waterfield commented
I'm not sure anyone at xero knows what to do to produce a meaningful reconciliation
-
Mitchell Ewer commented
It is ridiculous that this doesnt work!
-
Kelly O'Leary commented
A revised VAT reconciliation report, the old version is out of date and with the introduction of MTD for VAT it no longer works. Would love it to pre-populate payments made etc. It would also be great to be able to include this for review packs from HQ