With one client it so happens that the customer does not pay the full invoice amount.
For example the Sales Invoice is of the value 88.90. But the customer pays 85.00.
In such case the SI show partially paid. Instead the client want to close this SI as the remaining payment is never going to come.
How to handle this situation in such a way that there is no outstanding for the customer and the ledger should show as settled/fully paid in Customer Ledger Summary report?
Can we configure ERPNext to automatically close such SIs if the outstanding amount is less than or equal to 5?
in invoice reference table put the allocated amount 88.90
3.You will see a button to Write off the difference amount now
4.Click on it
5.Save
6.You will see the Under Deduction section Write-off 3.90 has been added
7.By this way Sales invoice will be treated as fully paid
I’d suggest a Journal Entry rather than a Payment Entry.
EDIT: I think I misunderstood the goal. If the intent is to write off the balance at the same time the original payment entry is being input, Payment Entry is good. If the write-off is meant to come later, it’s better to use a Write-Off entry JE.
The exact accounting details will depend on both how the sales invoice was booked and how the company handles these things, but usually you’d want:
a 3.90 debit to your Write-off account
a 3.90 credit to your Accounts Receivable account
You set the Sales invoice as the reference in the credit account line, or you can use the Payment Reconciliation tool after the JE is submitted.
@peterg I value your input and expertise. I’m curious why you’d avoid using the payment entry method described here.
My thoughts would be to use payment entry with a dedicated account in the deductions table. This is where we handle credit card merchant fees. Rather than merchant fee, a write-off account could be used.
If Payment Entry is easier for people, that’s fine too. It just seems like the wrong representation to my mind.
The Journal Entry is designed for this kind of manual correction. Using a Payment Entry without a payment just to access the write-off button feels unnecessary.
This would be done in one step. The under payment amount becomes the ”full payment” in a single Payment Entry with the written-off in one transaction rather than payment entry + journal entry.
Ah, got it, I think I misread. I thought OP was asking how to do this after an incomplete payment had been made and booked, and that the proposal was to make a second payment just to use the write-off button.
If the goal is to write off the balance at the time that the initial payment is made, payment entry is a good fit.
I all too often forget to click the pencil icon to see all the available options/fields in child tables.
With these instructions, I was able to go back to some old invoices that were underpaid due to some odd bug or rounding issue (still haven’t determined why, but it seems to be limited to one customer).
I wasn’t sure how the journal entry would allocate towards the sales invoice and mark it paid.