Reporting - VAT reconciliation report for South Africa
Please add a VAT Reconciliation Report for South African Xero Orgs.
There is currently no report that allows users to determine which transactions in the VAT Control Account have been posted to which VAT periods and which returns they fall under. Late claims are not indicated anywhere except in the transaction detail within each VAT201, so the Control Account needs to be reconciled externally in excel.
This is particularly an issue when a conversion from another accounting software has taken place and there are opening balances to reconcile. Or if conversion took place mid VAT period.
It would be useful for this report to include a column for the posting date (or 'last edited' date) for each transaction and the user that raised (or last edited) for audit trail.
Jessica Salmon
shared this idea
-
nishimoto sonkirven
commented
A VAT Reconciliation Report for South African Xero Orgs would be highly beneficial, as it would allow users to easily match transactions in the VAT Control Account to their respective VAT periods and returns, eliminating the need for external Excel reconciliations—especially important after conversions from other accounting software or mid-VAT period changes. Including columns for the posting date (or “last edited” date) and the user responsible for creating or editing the transaction would provide a clear audit trail and simplify identifying late claims, which currently can only be found within individual VAT201 transaction details. This enhancement would greatly improve accuracy, efficiency, and compliance for businesses; for related insights, visit https://tocalifesworld.com/.