@Malinda278 i would record the payment as it was provided to you and let the open balance sit until the remaining balance is paid. it sounds like they did in fact underpay in this scenario if the total of the invoices was 50K and they only paid 45K. if it was an overpayment, you could let that sit on the customers account as a credit but it doesn’t seem like that would apply in this case.
Hello Iqra is there anyway of just leaving the unpaid bit unallocated do you think or do you have to leave all of it on the system as it was paid an completely unapplied?
Thanks Malinda
Hi @Malinda278 were you able to find a solution? Thank you!
Hello,
There is an option on the customer profile for Statement Type, or Statement Format with the choices.
1. Open Item: Lists all details of open and partially paid and partially applied invoices, memos, and payments)
- Balance Forward: this statement format rolls open, unpaid balance from prior period documents forward in one lump sum. You will see only unpaid amount from prior period and won’t be able to see the details of unpaid items on the statement report.
I think the Balance Forward statement format is what you are looking for.
When entering the short payment, you may leave it unapplied on the customer’s account. AR Aging reports will show open invoice details and unapplied payment.
When entering the short payment, you may apply/pay in full and leave the balance on one invoice. Or you may distribute unpaid balance proportionally across all invoices. Either way the bank reconciliation will correctly show the payment and bank account can be correctly reconciled.
I don’t recommend crediting the original invoice balances and introducing a new debit memo for the unpaid balance because doing so makes the customer history more difficult to understand. Your customer will see strange new document on the statement and may question it.
I hope this helps you.
Hi, People left the solution already, just interested what is the purpose you don’t want to use partial payment against one invoice? Can I ask?
We have the same issue and need an answer as well. Our Customers will take deductions not related to the Invoice(s) they’re paying. Therefore we want to pay all the Invoices and leave an open amount with a reference for what it’s for to be reconciled later.
We have the same issue and need an answer as well. Our Customers will take deductions not related to the Invoice(s) they’re paying. Therefore we want to pay all the Invoices and leave an open amount with a reference for what it’s for to be reconciled later.
Same here - we just had a customer take some made up credits on their cheque and not sure how to best handle this situation. I don’t want to leave any of the invoices they fully paid as short paid but at same time I need the payment amount to match the cheque for our bank account reconciliation