How to Manage Partial Customer & Vendor Payment Reconciliation for multiple invoices & bills in Odoo

Managing partial customer/vendor payment reconciliations across multiple invoices or bills during Bank Reconciliation in Odoo is a common and practical scenario. Here's a step-by-step guide to handle it correctly using Odoo's accounting features during bank reconciliation process:

✅ Scenario
You’ve received or paid a lump sum amount that relates to multiple invoices/bills, and some invoices are not fully paid, i.e., partial reconciliation is needed.

🧩 Steps to Manage Partial Payments During Bank Reconciliation in Odoo
1. Import or Register the Bank Statement
Go to Accounting - Bank - Bank Statements (or Bank - Reconciliation).
Import the bank feed manually or through a connected bank.
You’ll see the bank lines (payments received or made).

2. Start the Reconciliation Process
Click on "Reconcile" for the corresponding bank statement line.
Odoo will try to auto-match based on partner, reference, or amount.

3. Matching with Multiple Invoices/Bills
If the amount partially matches with multiple open invoices (customers) or multiple open bills (vendors):

👉 Use Manual Matching:
Click on “Search More” or “Manual Operations”.
Filter by Customer or Vendor name.
Select one by one open invoices/bills and set the amount to reconcile

4. Handling Partial Amounts
You will notice:
Odoo calculates how much of each invoice/bill gets paid.
You can edit the allocated amount manually if needed:
Click the “Amount” field next to each invoice line.
Adjust values so the total matched = amount in the bank line.

Odoo performs partial reconciliation automatically when the paid amount doesn’t fully cover the invoice.

5. Validate Reconciliation
Once the split is correct:
Click "Validate".

Odoo creates partial payment entries and updates the payment status of each invoice/bill accordingly (e.g., "Partially Paid").

🔄 Later Payment Matching (Residuals)
When the remaining balance is paid in another bank statement:
Odoo will suggest the same residual invoices/bills again.
You can match and complete the reconciliation.

For any accounting queries and workaround or training, please feel free to contact me OR visit us at www.techvaria.com

#odoo #odoomaintenance #odootraining #odootutorials #odoomigration #odoosupport #odoocommunity