How do I stop payments from a previous VAT period showing on my VAT detail report?
Hi,
I'm preparing my VAT return and noticed that Quickbooks is incorrectly calculating my VAT due on sales - it's off by quite a significant amount. After some investigation I can't see any duplicate transactions and all transactions have been recorded with the correct VAT codes. However I have run my VAT audit report and there are loads of payments showing on there that were actually received in previous VAT periods - it seems like they are being recorded on the day the invoice was paid off instead of the days the individual payments were actually made. I have it set to cash basis.
The screenshot attached is an example of this problem - it's showing three payments made on 3/11, when in fact only one of those payments was made that day - the other two were actually made in the October and September before (the invoice was paid in stages). This is correctly dated on the invoice payments, so I'm not sure what's going on. The same thing is happening with almost all my invoices.
How can I fix this?!
Thank
