Extra column in Aged Debtor/Creditor reports to show VAT included in balances to help reconcile VAT cash control
Idea suggested by Paul Scholes 3 years ago
For those on VAT cash accounting, the balance on the VAT cash control should equate to the VAT included in unpaid invoices less the VAT included in unpaid bills.
At the moment, to do this, I have to sit down with a bit of paper each quarter and manually calculate the VAT on every unpaid invoice and bill to make sure it equates to the balance on the VAT cash control.
So it would really help to see the VAT element listed in aged balance reports, then all I need do is take one total from another leaving me more time to find out why the figures don't reconcile.