Recording Customer Discounts During Payment in ERPNext
Sometimes a customer may pay less than the invoice amount after negotiating a discount. Instead of modifying the original Sales Invoice, ERPNext allows you to record the payment, close the invoice, and account for the discount during the Payment Entry itself.
By recording the discount in the Payment Entry, the invoice is marked as fully paid while the discount amount is posted to the appropriate accounting ledger.
1. When Should You Use This Method?
This approach is useful when:
- A customer pays less than the invoice amount after receiving a settlement discount.
- You want the Sales Invoice to be shown as fully paid.
- The discount needs to be reflected separately in your accounting records.
- You want to avoid cancelling or amending the original invoice.
2. Example Scenario
Suppose:
| Invoice Amount | Amount Received | Discount Given |
|---|---|---|
| €54 | €50 | €4 |
The customer pays only €50, and the remaining €4 is treated as a discount.
3. Create a Payment Entry
Navigate to:
Accounting > Payment Entry
Create a new Payment Entry against the Sales Invoice.
4. Enter the Payment Details
Fill in the Payment Entry as follows:
- Paid Amount: €50
- Allocate Against Invoice: €54
Because the allocated amount exceeds the payment received, ERPNext automatically calculates a Difference Amount of €4.
5. Record the Discount
Scroll to the Deductions and Additional Charges section.
Add a new row with:
- The appropriate Discount Expense Account, or
- An Income Account, depending on your organization’s accounting policy.
Enter the Difference Amount of €4 against the selected account.
The difference amount is automatically adjusted, allowing the invoice to be marked as fully paid while separately recording the discount in your books.
6. Result
After submitting the Payment Entry:
- The Sales Invoice is marked as Paid.
- The customer has no outstanding balance.
- The €4 discount is posted to the selected accounting ledger.
- Your Accounts Receivable remains fully reconciled.
7. Benefits
- Closes invoices without editing the original document.
- Maintains accurate customer outstanding balances.
- Records settlement discounts separately for reporting.
- Supports proper financial reconciliation.
- Provides a complete audit trail of customer payments and discounts.