Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:

CRM
e-Commerce
Financeiro
Inventário
PoS
Projeto
MRP

All apps

Todas as publicações Pessoas Emblemas

Marcadores (Ver tudo)

odoo accounting v14 pos v15

Sobre este fórum

Ajuda

Best way to partially pay down multiple Customer Invoices with a single check payment?

customer payment partial split

3 Respostas

11459 Visualizações

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.

Sehrish

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

Ray Carnes (ray)

Melhor resposta

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:

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.

Yeison X

Hi, I can't see the pencil icon.

jbarnhart@minespress.com

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.

Está gostando da discussão? Não fique apenas lendo, participe!

Crie uma conta hoje mesmo para aproveitar os recursos exclusivos e interagir com nossa incrível comunidade!

Publicações relacionadas	Respostas	Visualizações
I have received a partial payment for two Customer Invoices. How can I apply it? Resolvido customer payment invoices partial v13	1 out. 20	5067
How to get partial payment in a variable? payment partial	0 mar. 15	4005
Best Practice: Record a Customer Payment from an Unknown Customer and still reconcile our Bank Statement in a timely mannner? Resolvido customer payment unknown	1 jun. 25	1053
Payment / Invoicing invoice customer payment	0 jan. 25	1646
One payment received for multiple customers customer multiple payment	0 jun. 22	2977

Esta pergunta foi sinalizada

Está gostando da discussão? Não fique apenas lendo, participe!