Customer overpaid invoice

[MarshaKronk]

Hi,

I have a customer that has overpaid an invoice (they have paid the invoice amount in three payments, the total of which is $4000 overpaid). I have followed the post below and my invoice is now 'closed'. 

https://community.myob.com/t5/MYOB-Essentials-Accounting/Customer-overpaid-invoice/m-p/354974#M10610

The payments from the customer are unallocated and I followed the instructions and... recorded the full payment against the invoice via Sales > Take Payments, the system would automatically create a customer return of the overpaid amount  You can then go to Sales > Process Customer Return > Refund to customer to issue the refund. 

However the problem i have is that now the invoice looks to be closed and i have the payments made by the customer sitting unallocated - how do i allocate them to the invoice?

Cheers,

Marsha

[Steven_M]

Hi @MarshaKronk 

It sounds like you need to go to Banking>>Bank transactions>>Navigate to the required bank transaction and select the Match option. Within here you can select the relevant transaction(s) that make up that bank transaction before selecting the Save option.

However, should you require further assistance with this topic do let us know. Knowing exactly what has occurred in real life would be handy. For example, has the customer paid multiple times for the same invoice i.e. 3 x $100 OR have they just overpaid it i.e. instead of $100 they have paid $150?

[MarshaKronk]

Hi Steven,

Thanks for your reply…

I invoiced the customer for $53,717.17 and they paid ($20,000, $20,000 and $17,737.17) = $57,717.17

Which is $4000 overpaid.

So I refunded the $4000 to them.

Then I went to sort out the invoice and ended up following the steps as above (but i did do some 'fiddling' and may have something going on in the background that i don't know about!)

So yes i have gone to the Unallocated Transactions tab and there was a match for the refund of $4000 which i selected but the three deposit amounts of $20000, $20000 and $17717.17 don't have any available transactions to select against....

Cheers,

Marsha

[Steven_M]

Hi @MarshaKronk 

While your case is similar to the example you have linked it is a little different. The linked example is about if you have received the full payment in one massive payment. Your case is slightly different as you have multiple payments and one of them was effectively the overpayment. 

The way I would handle that situation is:

1. Process one payment for $20,000
2. Process another payment for $20,000
3. Process another payment for the $17,737.17  (which is treated as that overpayment).
4. The above step would have created a customer return, to which you can process to generate that refund transaction.

What this will do is create three deposits transactions in the Bank account in MYOB Essentials to which you can match with the three deposits bank transactions that have come through. It will also create a withdrawal (the refund transaction) to which you can match to the required bank transaction.

[MarshaKronk · Accepted solution]

Thank you - i deleted the "Take up Payment' entry and i think the Customer Return entry must have still been operating?

Anyway i was then able to allocate the four payments/refund against the invoice

Thanks for your help.

Cheers,

Marsha