Well, this question has been asked quite a few times by new users of Sage. Are you one of them? Have you just discovered an issue of customer overpayment? Are you not sure how to record and refundit in Sage? Don’t worry! Recording and refunding of overpayments is fairly simple in Sage. Just go through this blog. Here, we would provide a systematic approach to record and refund customer overpayment in Sage.
Read Also-: Can sage 50 Import and Upload Existing Data
Stepsto Record and Refund customer overpayment in Sage
Please follow the below-mentioned steps-
Total Time: 15 minutes
Step I- Record the overpaid Receipt
🔷 Click on the Receipts window to open it
🔷 Select on the Receipt tab
🔷 if Enter Deposits has not been checked, select it in order to enable the Deposit Amount field
🔷 choose the correct Customer ID
🔷 go to the Amount Received column and enter the amount due to be paid against the invoice(s)
Please Note: The Amount Received cannot be more than the invoice total
Now enter the amount of overpayment into the Deposit Amount field. This amount will get recorded into the Prepaid Sales or Deposit account.
Click on Process
Step II- Record the Refund against the overpayment
🔷 Navigate to the Receipts window
🔷 Create a second receipt.
🔷 Now, choose the customer ID
🔷 Click on the Paid By Cheque tab
🔷 click on the Deposit To drop-down list and select the appropriate bank account
🔷 You will see the credit line marked in red. Here, fill in the Amount Received as a positive number. You will see the total will appear in negative
🔷 Click on Process
🔷 Now click Yes to proceed
Step III: Print the Refund Check
Please Note- proceed with this step only when you are printing a check from the software. You may ignore this step if checks are written by hand.
🔷 Navigate to the Payments window
🔷 Click on the Make Other Payment tab
🔷 choose By Cheque
🔷 click on the From drop-down list and select the appropriate bank account
🔷 Enter the correct Cheque No.
🔷 In To the Order of box, fill in the customer’s name
🔷 press TAB
🔷 click on Continue
🔷 now, choose an account
🔷 fill in the refund Amount
🔷 Please enter the Invoice/Ref.
🔷 add a Comment, if needed
🔷 Print the check. please make sure not to select POST
🔷 After the check gets printed, close the window to discard this transaction
Processing Customer Refunds in Sage 50 Accounting
Final Words :
It is quite important to keep a proper record of payments/overpayments in Sage. This way, you can keep your account well-documented and balanced. Hope this blog would help you learn how to record and refund customer overpayment in Sage. Hope it would facilitate better handling of your accounts. If you are still facing any difficulties in carrying out the above-mentioned steps, you may speak to some authorized Sage experts, anytime you want.
👉 Frequently Asked Questions
Can I apply the overpayment to other outstanding invoices of the customer?
Yes. The overpayment can also be applied to other outstanding invoices for the concerned customer, if you do not want to refund. To do so, enter the overpayment amount into the Amount Received column for the particular invoice(s). Next, enter the credit amount in the same column on the credit line.
What is a journal entry in Sage for a refund?
When you issue a refund in Sage, you make a refund double entry. This means, you need to adjust two separate accounts in your records. Firstly, record a debit to the “sales returns and allowances” account in a journal entry for the refund or allowance amount. A debit would increase this account.
How to record an overpayment to a supplier in Sage?
You will need to post a supplier overpayment. To do this, go to Suppliers and then to Supplier payment . Now, fill in the Bank account Ref, the Payee , the Date and type in the overpayment value. Click Save . Next, you will receive a message asking if you would like to post this as an unallocated payment on account. Click Yes to proceed.