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

Conciliation of invoices and pays

Subscribe

Get notified when there's activity on this post

This question has been flagged
v8invoicepaymentodoo8
1 Reply
8706 Views
Avatar
José

Hello, I have Odoo 8.

Follow this situation: a customer pays me $1000. I generate a "Customer payment" in "Accounting -> Customer payments". Then, the same customer, buys me two invoices of $100 each one. I want to set the two invoices paid and that the client has $800 of balance.

What is the best way to do this? Thanks!    

0
Avatar
Discard
Avatar
Zbik
Best Answer

The first way ->

a) menu Accounting/Periodic Processing/Reconcilation/Manual Reconcilation

b) menu Accounting/Payment Follow-up/Reconcile Invoices & Payments  (module account_followup must be installed)

The second way -> Customer view -> Jurnals Items -> check selected -> More -> Reconcile Entries

You select entries with the same account number (one debit and one credit). If Credit != Debit  you click on button Partial reconcile in next step (or Reconcile with Write-Off if expected is to divide the payment for parts). How to select correct Account number? -  this account has ... type = Receivable ... and has checked ... Allow Reconciliation = 1

The third way  -> menu Accounting/Bank and Cash/Bank Statements.

Create new bank Statement, insert new payment and reconcile with selected invoices or other entries

The fourth way -> install and use module account_voucher + The first way or/and The second way


PS. Invoice is Paid if all corresponding account move lines are reconciled, see method test_paid() in account_invoice.py


2
Avatar
Discard
José
Author

First way: I don't have menu "Payment follow-up" inside Accounting tab. Need I to install any other module? I have "account_accountant" module. Second way: I do this, but what entries I have to select? I have two entries for each transaction, one in the debit and one in the credit. And then, have I to do a partial conciliation or a reconciliation cancellation? Thanks!

Zbik

Another way. Answer updated.

José
Author

The reconciliation with bank statements works for cash pays?

Zbik

In menu Bank and Cash you have both: Bank Statements and Cash Registers, works similar.

José
Author

Queston 2) In the "other way", in the most cases credit != debit. So I do a partial reconcile. But the entries are still there! Only Odoo adds a "Ref of conciliation" which is a code like "A1, A2, etc". How works this? And the invoices are still "Open", not "Paid".

Zbik

Ref of conciliation ... see my answer: https://www.odoo.com/forum/help-1/question/please-what-is-the-link-between-vouchers-and-invoices-in-the-tables-75860#answer-75861

José
Author

Ok, moves with the same reconcile_id.name are reconciled, but still I can see there in the "Manual reconciliation" with the filter "unreconciled" and the invoice are still "open". I only want to set invoice -> "paid" in the most simple way when the payment is before the invoice...

Zbik

Answer updated. I reconcilation is full and ok, invoice sate = Paid.

José
Author

I have the module account_voucher. The partial reconciliation, is not a full reconciliation? I know that the invoice is paid if I do a "reconciliation with cancellation" but if I do a partial reconciliation, why not?

Zbik

When you select Partial Reconcile invoice is not "Piad", only value "to pay" = 0. Your needs are waiting "Reconcile with Write-Off".

José
Author

Ok. I am searching a way to automatically set the invoices paid if the customer has "balance ($)" > "total invoice ($)" and decrease the balance. Is there any way? Thanks you a lot for the patient!

Zbik

The third way

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
How to make invoice status to paid in v8
v8 invoice payment
Avatar
Avatar
1
Mar 15
4007
Odoo 8 : report - follow-up invoice due date
invoice payment track odoo8
Avatar
0
Nov 16
3452
v8: Customers unable to see the Payment button on their Invoices - I've installed installed payment_paypal and payment_transfer
v8 invoice qweb payment
Avatar
0
Mar 16
5799
How do I mark a "partial" invoice as paid, for real? Solved
invoice payment
Avatar
1
Nov 25
2516
How to create a payment for an invoice from python code in odoo15
invoice payment
Avatar
Avatar
1
Oct 25
6252
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