Skip to Content
Odoo Menu
  • Sign in
  • Try it free
  • Apps
    Finance
    • Accounting
    • Invoicing
    • Expenses
    • Spreadsheet (BI)
    • Documents
    • Sign
    Sales
    • CRM
    • Sales
    • POS Shop
    • POS Restaurant
    • Subscriptions
    • Rental
    Websites
    • Website Builder
    • eCommerce
    • Blog
    • Forum
    • Live Chat
    • eLearning
    Supply Chain
    • Inventory
    • Manufacturing
    • PLM
    • Purchase
    • Maintenance
    • Quality
    Human Resources
    • Employees
    • Recruitment
    • Time Off
    • Appraisals
    • Referrals
    • Fleet
    Marketing
    • Social Marketing
    • Email Marketing
    • SMS Marketing
    • Events
    • Marketing Automation
    • Surveys
    Services
    • Project
    • Timesheets
    • Field Service
    • Helpdesk
    • Planning
    • Appointments
    Productivity
    • Discuss
    • Approvals
    • IoT
    • VoIP
    • Knowledge
    • WhatsApp
    Third party apps Odoo Studio Odoo Cloud Platform
  • Industries
    Retail
    • Book Store
    • Clothing Store
    • Furniture Store
    • Grocery Store
    • Hardware Store
    • Toy Store
    Food & Hospitality
    • Bar and Pub
    • Restaurant
    • Fast Food
    • Guest House
    • Beverage Distributor
    • Hotel
    Real Estate
    • Real Estate Agency
    • Architecture Firm
    • Construction
    • Estate Management
    • Gardening
    • Property Owner Association
    Consulting
    • Accounting Firm
    • Odoo Partner
    • Marketing Agency
    • Law firm
    • Talent Acquisition
    • Audit & Certification
    Manufacturing
    • Textile
    • Metal
    • Furnitures
    • Food
    • Brewery
    • Corporate Gifts
    Health & Fitness
    • Sports Club
    • Eyewear Store
    • Fitness Center
    • Wellness Practitioners
    • Pharmacy
    • Hair Salon
    Trades
    • Handyman
    • IT Hardware & Support
    • Solar Energy Systems
    • Shoe Maker
    • Cleaning Services
    • HVAC Services
    Others
    • Nonprofit Organization
    • Environmental Agency
    • Billboard Rental
    • Photography
    • Bike Leasing
    • Software Reseller
    Browse all Industries
  • Community
    Learn
    • Tutorials
    • Documentation
    • Certifications
    • Training
    • Blog
    • Podcast
    Empower Education
    • Education Program
    • Scale Up! Business Game
    • Visit Odoo
    Get the Software
    • Download
    • Compare Editions
    • Releases
    Collaborate
    • Github
    • Forum
    • Events
    • Translations
    • Become a Partner
    • Services for Partners
    • Register your Accounting Firm
    Get Services
    • Find a Partner
    • Find an Accountant
    • Meet an advisor
    • Implementation Services
    • Customer References
    • Support
    • Upgrades
    Github Youtube Twitter Linkedin Instagram Facebook Spotify
    +1 (650) 691-3277
    Get a demo
  • Pricing
  • Help

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

  • CRM
  • e-Commerce
  • Accounting
  • Inventory
  • PoS
  • Project
  • MRP
All apps
You need to be registered to interact with the community.
All Posts People Badges
Tags (View all)
odoo accounting v14 pos v15
About this forum
You need to be registered to interact with the community.
All Posts People Badges
Tags (View all)
odoo accounting v14 pos v15
About this forum
Help

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

Subscribe

Get notified when there's activity on this post

This question has been flagged
customerpaymentpartialsplit
3 Replies
11756 Views
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. 

1
Avatar
Discard
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

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:


3
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. 

0
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.

-1
Avatar
Discard
Enjoying the discussion? Don't just read, join in!

Create an account today to enjoy exclusive features and engage with our awesome community!

Sign up
Related Posts Replies Views Activity
I have received a partial payment for two Customer Invoices. How can I apply it? Solved
customer payment invoices partial v13
Avatar
Avatar
1
Oct 20
5175
How to get partial payment in a variable?
payment partial
Avatar
0
Mar 15
4149
Best Practice: Record a Customer Payment from an Unknown Customer and still reconcile our Bank Statement in a timely mannner? Solved
customer payment unknown
Avatar
Avatar
1
Jun 25
1180
Payment / Invoicing
invoice customer payment
Avatar
0
Jan 25
1761
One payment received for multiple customers
customer multiple payment
Avatar
0
Jun 22
3110
Community
  • Tutorials
  • Documentation
  • Forum
Open Source
  • Download
  • Github
  • Runbot
  • Translations
Services
  • Odoo.sh Hosting
  • Support
  • Upgrade
  • Custom Developments
  • Education
  • Find an Accountant
  • Find a Partner
  • Become a Partner
About us
  • Our company
  • Brand Assets
  • Contact us
  • Jobs
  • Events
  • Podcast
  • Blog
  • Customers
  • Legal • Privacy
  • Security
الْعَرَبيّة Català 简体中文 繁體中文 (台灣) Čeština Dansk Nederlands English Suomi Français Deutsch हिंदी Bahasa Indonesia Italiano 日本語 한국어 (KR) Lietuvių kalba Język polski Português (BR) română русский язык Slovenský jazyk slovenščina Español (América Latina) Español ภาษาไทย Türkçe українська Tiếng Việt

Odoo is a suite of open source business apps that cover all your company needs: CRM, eCommerce, accounting, inventory, point of sale, project management, etc.

Odoo's unique value proposition is to be at the same time very easy to use and fully integrated.

Website made with

Odoo Experience on YouTube

1. Use the live chat to ask your questions.
2. The operator answers within a few minutes.

Live support on Youtube
Watch now