Overpayments against a sale can be refunded to the customer or converted into customer credit, which can then be used against future invoices. 

NOTE: This method can also be used in order to refund VAT that has accidentally been charged to customers. 


Table of Contents:

Convert overpayment into a customer credit or a refund

[back to top]

In our example, a customer has made an overpayment of $400 on a sale of $2140. Here is how to either refund the overpayment amount directly to a customer, or convert it into a credit to use against future invoices. 

NOTE: You will need to create a refund service item in your inventory in order to issue the refund. Do this before continuing. See Create a refund service item for more information. 

  1. Go to the Invoice tab of the sale that has been overpaid. 
  2. Under Payment, enter the exact invoice amount, not including the overpayment. 
  3. Save the sale order.
  4. Create a sale credit note for the customer. (Sales → New →Sale Credit Note). Add the refund service item to the sale credit note and the value of the overpayment to the price. Quantity is 1.
  5. Authorise the sale credit note. This will cause the Refund section to appear. 
  6. Select Customer Credit to open a popup window where you can enter the value of the overpayment. Save for it to be added to the Refund section. The customer credit can now be used against other invoices. See Use Customer Credits for more information.
  7. If you want to refund the customer directly, simply click Refund instead of customer credit in step 6. 

Create a refund service item

[back to top]

You will need to create a service  item in your inventory for refunds to create credit note sales that are not linked to a specific product or service sold by your organisation.

  1. Navigate to Inventory → New → Product/Service.
  2. Create a Service or non-inventory item called Refund and Save your changes.

Overpayments in Xero

[back to top]

If using Xero, all overpayments must be handled in Xero, not through DEAR. DEAR cannot send overpayments to Xero. Attempting to handle overpayments in DEAR will cause synchronisation issues. 

  1. If a payment has already been added in Xero, undo it, and leave it as a draft invoice. If no payment is applied in Xero this step can be skipped. 
  2. In DEAR, do not apply a payment to the invoice. Authorise the invoice in DEAR without adding a payment then sync to Xero. 
  3. Next, you will need to add the payment, including overpayment, in Xero. 
  4. The amount equal to the invoice will sync to DEAR and close out the invoice in DEAR. Xero will convert the overpayment into a credit which can be applied to in any related Xero invoice in future.

Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.