Refund from supplier for over payment

Question: Hi wavelet, previously we overpaid rm100 to supplier and we already keyed it as an overpayment under this supplier. However, the supplier is refunded the overpayment to us. Please get us a solution for the case above on how to key in this refund rm100 so that it can offset the overpaid in this supplier account.

Step-by-step guide

If Payment Voucher has open balance:

Payment Voucher Journal
GLCodeDebitCredit
Bank 1000.00
accPayable1000.00 
  1. Create a Credit Memo with GLCode 'overPayment' - it can be any other GLCode as well, so long it is the same as step 2
    1. Credit Memo Journal
      GLCodeDebitCredit
      accPayable 100.00
      overPayment100.00 
  2. Create a Receipt Voucher (under Finance module) - use GLCode 'overPayment'. This is to record the refund.
    1. Receipt Voucher Journal
      GLCodeDebitCredit
      Bank 100 
      overPayment 100.00
  3. Use credit memo from step 1 to settle with the Payment Voucher

If Payment Voucher does not have open balance / Create Payment Voucher was used with 'overPayment' glcode

Payment Voucher Journal
GLCodeDebitCredit
Bank 1000.00
accPayable900 
overPayment100 
  1. Check Payment Voucher to find out what GL Code was used.
  2. Create a Receipt Voucher (under Finance module) - use GLCode 'overPayment'. This is to record the refund.
    1. Receipt Voucher Journal
      GLCodeDebitCredit
      Bank 100 
      overPayment 100.00

 

Private & Confidential