On Sage money received has been allocated to the incorrect customer invoice and to make things worse it turns out that the money received was actually a payment on account and no invoice has actually been issued. They are also on cash accounting for VAT and this transaction has been included in a VAT Return so cant just be deleted. Apologies for the rubbish explanation but here are some figures that might make a bit more sense!
Customer A invoice - £10,000
Deposit received from customer B incorrectly allocated against A's invoice - £5,000
VAT paid £833.33
I need to "move" the £5,000 from Customer A to Customer B and show this as a payment on account in B.
So I need to find a way to reverse out the money received and the VAT as the way they do it (which I know is incorrect but its the first Ive heard of it) may mean they pay the VAT twice because of invoicing the job on completion despite receiving an deposit.
Any ideas? Im thoroughly confused trying to work it all out on Sage with all my scribbles of credit notes, temporary invoices etc so thought someone may be able to help!