How to Use Accounting Reconciliation Models in Odoo 18
By Braincuber Team
Published on April 16, 2026
A company deals with numerous transactions daily, from collecting payments from clients to managing various expenses. The accounting department may not always have the capacity to enter every transaction detail immediately into the system. This is where reconciliation becomes essential. This complete tutorial walks you through the powerful reconciliation capabilities of Odoo 18 Accounting, including reconciliation models, payment matching, and bank statement reconciliation.
What You'll Learn:
- Step by step guide to understanding accounting reconciliation in Odoo 18
- Beginner guide to creating and configuring reconciliation models
- Complete tutorial on the three types of reconciliation models
- How to use payment matching functionality
- Best practices for bank statement reconciliation
- Strategy for automating invoice reconciliation
- How to configure partner mapping in reconciliation models
Understanding Accounting Reconciliation
Reconciliation is the process of matching and verifying data from bank accounts with cash transactions recorded in your accounting system. This step by step guide explains why reconciliation is crucial for maintaining accurate financial records and ensuring transaction transparency. When you reconcile accounts, you can identify any discrepancies, entry errors, or missing transactions that need attention.
In practice, accounting departments often examine and verify bank statements periodically rather than in real-time. Odoo 18 Accounting simplifies this process by providing intelligent reconciliation capabilities that automatically match transactions, reducing manual work and minimizing errors. The system can link bank information with customer invoicing seamlessly.
Transaction Transparency
Ensure all financial transactions are accurately recorded and traceable through automated matching.
Time Efficiency
Automate repetitive reconciliation tasks using reconciliation models and save valuable time.
Error Detection
Quickly identify discrepancies, missing entries, and data inconsistencies before they become problems.
Financial Accuracy
Maintain accurate records that reflect true financial positions for better decision-making.
Accessing Reconciliation Models in Odoo 18
To create and manage reconciliation models in Odoo 18 Accounting, navigate to the Configuration menu. This section is located in the Banks area of the accounting module. This step by step guide walks you through accessing the reconciliation model interface where you can create new models or modify existing ones.
Open Configuration Menu
Complete tutorial: navigate to the Accounting module and click on the Configuration menu. Select Banks to find the Reconciliation Models option. This will open the reconciliation models interface where you can view and manage all existing models.
Create New Model
Step by step guide: click on Create to add a new reconciliation model. Give your model a descriptive name that indicates its purpose. You can also set the type of reconciliation model based on your requirements.
Set Model Parameters
Beginner guide: configure the criteria for matching transactions. This includes setting journal filters, amount ranges, currency matching, and partner restrictions. These parameters determine how the model matches and reconciles transactions.
Three Types of Reconciliation Models
Odoo 18 Accounting offers three distinct types of reconciliation models to handle different reconciliation scenarios. Understanding when to use each type is essential for effective automation. This section provides a complete tutorial on each model type.
| Model Type | Purpose | Use Case |
|---|---|---|
| Button to Generate Counterpart Entry | Creates counterpart entries automatically | Bank fees, interest charges |
| Rule to Suggest Counterpart Entry | Suggests matching for review | Recurring transactions |
| Rule to Match Invoices/Bills | Matches to existing invoices or bills | Customer payments, vendor payments |
Counterpart Entry Generation Model
The Button to Generate Counterpart Entry model type adds a button in the bank reconciliation view's resulting entry section. When clicked, this button creates counterpart entries according to the model's established rules. The counterpart entry's accounts, amounts, labels, and analytical distribution are all determined by the model's configuration.
Select Counterpart Entry Type
Complete tutorial: when creating a reconciliation model, select "Button to generate counterpart entry" as the model type. This will enable the counterpart entry button functionality in your bank reconciliation view.
Configure Entry Rules
Step by step guide: define the rules that determine which account should be used, what amounts should be posted, what labels to apply, and any analytical distributions needed. These rules are applied automatically when the button is clicked.
Test in Reconciliation View
Beginner guide: navigate to the bank reconciliation view and open a transaction. You should see the counterpart entry button. Click it to automatically generate entries based on your model rules. Verify the entries match your expectations.
Counterpart Suggestion Rule Model
The Rule to Suggest Counterpart Entry model is designed for recurring transactions. This model type analyzes incoming transactions and suggests matches based on criteria that must align with the transaction data. Users can review and approve suggestions before reconciliation is completed.
Use Case: Recurring Payments
This model is ideal for situations like monthly rent payments, utility bills, or subscription fees where the same transaction pattern occurs regularly. The system learns from your matching preferences over time.
Invoice and Bill Matching Model
The Rule to Match Invoices/Bills model is one of the most commonly used reconciliation models. This type automatically matches incoming payments with pre-existing invoices or bills based on specified criteria. When combined with the Auto-Validate feature, reconciliation happens completely automatically.
Select Matching Type
Complete tutorial: create a new reconciliation model and select "Rule to match invoices/bills" as the model type. This enables automatic matching between bank transactions and your outstanding invoices or bills.
Enable Automatic Validation
Step by step guide: enable the Auto-Validate option in your reconciliation model. When this is enabled, matching happens automatically without requiring manual approval. Transactions that meet all criteria are reconciled instantly.
Set Matching Criteria
Beginner guide: configure the criteria lines that determine matching. You can set parameters including journal, amount, amount type (lower, greater, between), currency, and date ranges. Multiple criteria can be combined for precise matching.
Partner Mapping Configuration
Partner mapping is a powerful feature in Odoo 18 reconciliation models that restricts the model to specific partners. This is useful when you have dedicated bank accounts for certain customers or vendors, or when you need to ensure reconciliation only applies to specific business relationships.
Configure Partner Restrictions
Complete tutorial: enable the partner restriction option in your reconciliation model. You can then select specific partners to include, such as particular customers or vendors. The model will only apply to transactions involving these selected partners.
Validate Partner Mapping
Step by step guide: test your partner-specific reconciliation model by processing transactions from the selected partners. Verify that the model correctly identifies and reconciles only the intended partner transactions.
Payment Matching Functionality
Odoo 18 provides a dedicated payment matching feature accessible through the Accounting menu under the Reconcile section. This comprehensive tool brings all journals requiring reconciliation together with intelligent filtering capabilities. Users can match payments with invoices manually or use the auto-reconcile feature for automatic matching.
Navigate to Payment Matching
Complete tutorial: go to the Accounting menu and select Reconcile. This opens the payment matching interface showing all journals that need reconciliation. Use the Account and Partner filters to narrow down transactions for matching.
Match Payments Manually
Step by step guide: expand the transaction details to view available payments and invoices. Select the payment and corresponding invoice or journal entry you want to match. Click the reconcile button to complete the manual matching process.
Enable Auto-Reconciliation
Beginner guide: click the auto-reconcile button at the top of the payment matching view. This automatically matches payments with their corresponding journal entries including invoices, bills, and other transactions based on predefined matching rules.
Bank Statement Reconciliation Process
Bank statement reconciliation ensures that the data in your bank statements corresponds to the data in your journals and general ledger. Odoo 18 simplifies this process by allowing you to import bank statements and automatically matching them with invoices and payments. The system updates invoice status from "In Payment" to "Paid" as transactions are reconciled.
Create Customer Invoice
Complete tutorial: create an invoice for your customer through the Sales module. Fill in the customer details, product lines, and pricing. Once the invoice is confirmed, it appears in the accounting records ready for payment matching.
Register Customer Payment
Step by step guide: register a payment against the invoice. Select the journal, payment method, and enter the payment date and amount. The system creates the payment record and links it to the invoice. The invoice status changes to "In Payment".
Open Bank Reconciliation View
Beginner guide: navigate to the Bank Feeds section of the Accounting dashboard. Select the Bank Reconciliation option to view all statements pending reconciliation. This shows both new and existing statements that need to be reconciled.
Import or Create Statement
Complete tutorial: you can either import a bank statement file from your bank or manually create a new statement. Importing is faster for large volumes of transactions. Manual entry works well for smaller numbers of transactions.
Match and Validate
Step by step guide: select the bank statement line and match it with the corresponding payment or invoice. Odoo automatically suggests matches based on amount, date, and partner. Click validate to complete the reconciliation.
Confirm All Transactions Reconciled
Beginner guide: after completing reconciliation, verify that all transactions show a reconciled status. The invoice status changes from "In Payment" to "Paid" once the bank statement is reconciled. You can access bank statements through the Go To Bank Statements option.
Undoing Payment Matching
Odoo 18 makes it easy to reverse reconciliation when needed. If you need to undo a payment match, simply click the Unreconcile button on the relevant transaction. This reverses the matching and allows you to重新 reconcile the transactions with different parameters or entries.
Important: Audit Trail
When you unreconcile transactions, Odoo maintains a complete audit trail of the changes. This ensures financial transparency and allows you to track all modifications to your accounting records for compliance purposes.
Best Practices for Reconciliation
Following best practices ensures efficient reconciliation processes and maintains accurate financial records. This step by step guide covers key recommendations for getting the most out of Odoo 18's reconciliation capabilities.
Regular Reconciliation
Reconcile bank statements at least weekly to catch discrepancies early. Daily reconciliation is ideal for high-volume businesses to maintain accurate cash positions.
Use Reconciliation Models
Create reconciliation models for recurring transactions like utility payments, rent, and subscription fees. This automates matching and reduces manual effort significantly.
Auto-Validate Wisely
Enable Auto-Validate only after thorough testing with manual review. Ensure matching criteria are precise to prevent incorrect automatic reconciliations.
Partner Mapping
Use partner mapping to create specialized reconciliation rules for key customers or vendors. This ensures accurate matching for your most important business relationships.
Frequently Asked Questions
What are the three types of reconciliation models in Odoo 18?
The three types are: Button to Generate Counterpart Entry (creates automatic entries), Rule to Suggest Counterpart Entry (suggests matches for recurring transactions), and Rule to Match Invoices/Bills (matches payments with existing invoices or bills).
How do I enable automatic reconciliation in Odoo 18?
Enable the Auto-Validate option in your reconciliation model configuration. When this is enabled, transactions that meet all matching criteria are automatically reconciled without requiring manual approval. Always test thoroughly before enabling in production.
How do I access bank statement reconciliation in Odoo 18?
Navigate to the Accounting module, go to the Bank Feeds section, and select Bank Reconciliation. This shows all statements pending reconciliation. You can import bank statement files or create manual statements for reconciliation.
What is partner mapping in reconciliation models?
Partner mapping restricts a reconciliation model to specific partners. Enable the partner restriction option and select the customers or vendors for whom the model should apply. This is useful for dedicated bank accounts or specialized reconciliation rules.
How do I undo a reconciliation in Odoo 18?
Click the Unreconcile button on the relevant transaction to reverse the matching. Odoo maintains a complete audit trail of all reconciliation changes, ensuring financial transparency and compliance with accounting standards.
Need Help with Odoo 18 Accounting Reconciliation?
Our Odoo experts can help you configure reconciliation models, automate payment matching, and streamline your bank reconciliation processes. From setup to optimization, we help businesses achieve accurate financial records.