Skip to Content
Menu
This question has been flagged
3 Replies
8942 Views

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

Odoo Accounting | Create Customer Invoice and Register Full Payment
Learn how to effectively use the Register Full Payment feature in Odoo for customer invoices. This step-by-step guide covers everything you need to know, including configuring journals, selecting payment methods, handling recipient bank accounts, setting payment dates, and more. Discover how to manage full payments with manual, batch deposit, and SEPA direct debit options for a streamlined accounting process.
https://youtu.be/xMXAbPUuejI

Odoo Accounting | How to Register Partial Payments in Odoo | Handling Payment Differences in Odoo
This video covers every step in detail, from adjusting payment amounts to managing payment differences effectively. Whether you're keeping invoices open for future payments or marking them as fully paid with write-offs, we've got you covered. Discover how to view payment details, update amounts due, and manage unreconciled payments seamlessly.
https://youtu.be/-6Hlb2LFEZQ

Odoo Accounting | Manual Invoice Payments and Payment Matching
Learn how to manually record invoice payments and match payments to multiple invoices in Odoo. In this step-by-step tutorial, we walk you through handling bulk payments, filling out payment forms, and distributing payments across invoices. Perfect for businesses managing customer payments efficiently in Odoo.
https://youtu.be/lyNbqwbAzUU

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

Hello Ray,

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

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

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.

Best Answer

Hi, I can't see the pencil icon. 

Avatar
Discard
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
Related Posts Replies Views Activity
1
Oct 20
3756
0
Mar 15
2740
0
Jan 25
445
0
Jun 22
1693
0
Nov 17
2008