Hi TR6-87,
How we practice here, we dont instantly assign payment into Exp.Invoice right after our customers made payment..
We draw Bank Statement at end of each month (day 25-30) and compare it with our internal record..
Then only after that we key in payments to Exp.Invoice and then issue Statement to our customers..
Hopefully this might help
Thanks