This question has been flagged
3 Replies
6306 Views
customerpaymentpartialsplit
Avatar
Community Question

I invoiced my customer two Invoices:

  • Invoice 1 for $400
  • Invoice 2 for $500.


I received a Customer Payment for $700.


They will be short paying each Invoice by $100, so $300 to pay down the first Invoice and the $400 left over to pay down the second Invoice.

What are my options for recording this in Odoo properly?

It seems like Odoo will always choose how to allocate the payment, leaving the first Invoice fully paid and the second Invoice open with a remaining balance of $300.

I was shown how to record two payments instead of one but my finance person is asking for another option as our Customers do not always tell us which Invoices they intend to pay until we follow up later and some orders are returned after a monthly payment is sent but before it is applied so splitting the payment into pieces when we don't know what those pieces will be until later won't work. 

Avatar
Discard
Avatar
Ray Carnes (ray)
Best Answer

You have two options:


1) If you are syncing with your bank at least daily and can wait until the bank clears the check:

DO NOT enter the check (or other) payment at all, wait until it shows up as a bank statement line.

Then, do this during bank reconciliation:



A. Click the first Invoice (worth $400) to start matching it with the $700 check #12345 shown on the bank statement.



B. Click the Pencil icon to edit the amount of the payment you WISH TO APPLY to $300.



C. Click the next Invoice, verify the amount you WISH TO APPLY is correct (Odoo will auto-calculate it in this case) and click VALIDATE.



2) If not:

Do not enter the check (or other) payment as a PAYMENT but as a CREDIT NOTE:



Note: If you have more than one bank account Outstanding account, be sure to use the correct one.


The Journal Entry created by the Credit Note will look something like:


A Customer Payment would create an identical Journal Entry - debiting the outstanding account and crediting AR.


Then, do this during bank reconciliation: 



A. Click the first Invoice (worth $400) to start matching it with the $700 check #12345 shown on the bank statement. 



B. Click the Pencil icon to edit the amount of the payment you WISH TO APPLY to $300. 



C. Click the next Invoice, verify the amount you WISH TO APPLY is correct (Odoo will auto-calculate it in this case).



D. Click the Credit Note via the Customer/Vendor Matching tab (the AR part) to add it to the reconciliation.



E. Click the Credit Note via the Miscellaneous Matching tab (the cash part) to add it to the reconcilation.



F. Click VALIDATE.



Customer Invoices after either approach:



Customer Aging after either approach:


Credit Note after the second approach:


Avatar
Discard
Balagopal R

Hello Ray,

Can you show the partner ledger after this allocation?
It will show multiple payment records there

Ray Carnes (ray)

The Partner Ledger will show one entry for each Invoice, one entry for each Credit and one entry for each Payment.

Ray Carnes (ray)

For Odoo 16, no credit Note is needed. Reconcile the Statement Line with the Payment AND both the Invoices (editing the amounts as needed) and then balance the entry with a debit to AR. The additional step introduced is the reconciliation of the balancing debit with the credit from the original payment which will still show on the Aged Partner Balance until reconciled. Prior to reconciliation, the summary balance is correct but the details show the original payment (negative) and the debit from the balancing entry (positive). Reconcile both detailed entries to have them both drop off the report.

Avatar
Yeison X
Best Answer

Hi, I can't see the pencil icon. 

Avatar
Discard
Avatar
jbarnhart@minespress.com
Best Answer

Or, who cares how the customer wants to do it. Pay the oldest invoice in full, and apply the rest to the other invoice. Either way, they owe you the same amount of money.

Avatar
Discard