Vatable income total doesn't match sales

[AntParker]

Hi there.
Each quarter I double check that the total sales on my VAT return (from which the 12% flat rate vat is calculated) match the sales for that same period and until now it always has. This quarter there’s approx £466 difference and I can’t see why. I say approximately as the Vat return rounds it to the nearest pound so don’t know exactly which makes it hard to search for. Can anyone suggest why there may be an anomaly or how to find it?
Many thanks,
Ant.

[ian_roberts]

First question - are you on cash accounting? When there’s discrepancies between your P&L or dashboard sales totals and the vat return it’s usually because those sales totals are always accrual based (calculated off the date of each invoice) but you’re on cash accounting for VAT (so the return calculated off the date of each payment).

[AntParker]

Hi Ian. I use accrual accounting. Until now it has always matched exactly but this time it’s different. I’ll have another look through and see if I can see what’s different to usual.
Many Thanks,
Ant.

[QFSteve]

Hello @AntParker

I have taken a look at the account linked to your email.

I would reccomend taking a look at the export of your vat return or drilling down on the boxes on the return to see what invoices are included.

It seems some invoices have been created as a result of bank tagging prior to the return period
These tagging events (and the invoice creation) took place on 24/07/2024 which you can see in either your recent events or the event log.

Here is an example I took at random which has been included in the return.

[AntParker]

Thanks Steve.
I’ll have a look through and see if I can find out which are tagged incorrectly.