overpayment in customera

[bcmw]

Hi all
We receive an automated payment from the bank, this payment is for invoices to more than 1 customer however i have posted the total payment amount to 1 customer, how do i reverse part of the amount out of 1 customer and post it to the correct customer
thanks for your help

[Site4]

Personally, this is one of the few occasions when I'd be inclined to go into File > Maintenance, delete the original entry and start again.

If you want to go the part-reversal route, you need an invoice on the account that has the overpayment and a credit note on the account underpaid, both for the over/under paid amount. Both invoice and credit need to be to the same sales/ purchase/ suspense nominal, e.g 9998.

As I said - F>M is probably the easiest answer here..

[bcmw]

hi site 4 thanks for advice, i thought File maintenance was the answer, to save deleting the transaction in FM i can just ammend the ammount
ta bcmw

[brucedenney]

Yes, but... the problem is you will then have 2 transactions appearing in the bank account when you come to do the reconciliation so it is not perfect.
If this is a frequent/regular thing then...

My solution is to use a spare bank account (or even petty cash)

Do a customer refund for the amount of the payment that is for the other customer to the spare bank account.
Probably the amount that is "a payment on account"
You will need to match the refund to the payment on account
Do a customer receipt from the spare bank account to the other customer.

The contra in the spare bank might need reconciling (I have it turned off on petty cash) otherwise everything should be fine