VAT Reconciliation report - Opening balances updated once filed
Currently, when we run the reconciliation report for this year, it displays an opening balance for both sales and purchases but not for the VAT account transactions. This means the report doesn't reflect the real-time status of the VAT account.
For instance, previously filed VAT returns are incorrectly showing as unfiled, and any payments or collections from prior periods are not included. Consequently, we see a significant outstanding balance that doesn't accurately represent our current position, as these transactions were processed in the previous accounting period.
Ideally, the reconciliation report should display the actual unfiled VAT on both sales and purchases, alongside the current balance of the nominal ledger, rather than just postings from the current period.
