| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Odoo Apps Dependencies |
•
Invoicing (account)
• Discuss (mail) |
| Lines of code | 1055 |
| Technical Name |
bank_stmt_omax |
| License | OPL-1 |
| Website | https://www.omaxinformatics.com |
| Versions | 13.0 14.0 15.0 16.0 17.0 18.0 19.0 |
Bank Statement & Reconciliation
OMAX INFORMATICS
Overview
This module brings powerful bank statement reconciliation features to the Odoo Community Edition by extends the functionality of the Accounting module by providing a dedicated menu to manage statements more efficiently. It allows users to easily create or import bank statements (using .xlsx or .xls) files, then match them with existing payments or journal entries, and generate detailed PDF report for better tracking and auditing. It streamlines financial processes and ensures accurate alignment between bank transactions and accounting records.
This functionality is not available by default in Odoo 15 Community Edition. The module extends the Accounting app to provide enhanced bank statement and reconciliation features.
Features
- Import Bank Statements custom feature. Users can upload .xlsx or .xls files and import multiple bank statements at once.
- Allows Users to match payments and journal entries (accounting records like invoices/Bills) with each bank statement line. Separate options like Match with Customer/Vendor, Match with Payments and Manual Operations.
- Supports reconciliation for Partial transactions.
- Supports multi currency transactions.
- Auto Calculate Ending Balance base on Transaction records.
- Bank Statement Detailed report in PDF format.
How It Works
Import .xlsx File Interface.
Same excel file available in bank_stmt_omax/document/ so, you can modify and use it.
Import Bank Statement Menu.
Path : Invoicing -> Accounting -> Bank Statement -> Import Bank Statement.
Import Bank Statement Wizard
Bank Statements List View.
Bank Statement menu path: Invoicing -> Accounting -> Bank Statement -> Bank Statements
Bank/2025/0001 : a new bank statement is created.
Users can also manually create bank statements and statement lines.
Imported Bank Statement - Bank/2025/0001
Users can reconcile or match payments using two options:
1. Reconcile button on the statement.
2. Reconcile button on individual statement lines.
1. Reconcile from Bank Statement.
Reconciliation Wizard Overview
Clicking the Reconcile button on a bank statement opens a wizard to process each unreconciled statement line. Within the wizard:
- Match with Customer/Vendor: Match the statement line with existing journal entries (e.g., invoices or bills) for the selected partner.
- Match with Payments: Match the statement line with customer or vendor payments for the selected partner.
- Manual Operations: Create a manual journal entry if no matches are found or use for Bank Fee, Bank Interenst other charges etc.
After selecting or entering the appropriate records:
- Click "Reconcile" to confirm reconciliation for the current line.
- Click "Next" to move to the next unreconciled line.
Reconciled lines are automatically skipped in the wizard for a focused workflow.
2. Reconcile from Bank Statement Line.
Statement Line Reconciliation Wizard
When the user clicks the Reconcile button on a statement line, a wizard opens displaying the line’s details. Within the wizard:
- Match with Customer/Vendor: Match the statement line with existing journal entries (e.g., invoices or bills) for the selected partner.
- Match with Payments: Match the statement line with customer or vendor payments for the selected partner.
- Manual Operations: Create a manual journal entry if no matches are found or use for Bank Fee, Bank Interenst other charges etc.
After selecting or creating the appropriate entries, clicking Reconcile in the wizard finalizes the reconciliation for that line.
Reconciliation process for Statement Lines.
Transaction 1 :
Partner = Lumber Inc
Label = INV/2025/00006
Amount = $ 750
Click the Reconcile button in a statement line to open the Statement Line Reconciliation wizard.
Existing Customer Invoice INV/2025/00006 before reconcile.
In the Match with Customer/Vendor tab, click Add Items to view all journal entries for the selected partner. Users can select and add lines to the tab.
Balance info : The statement line includes a Balance field. When users add lines in the Match with Customer/Vendor, Match with Payments, or Manual Operations tabs, the corresponding amounts are automatically deducted from the balance.
Users can reconcile the selected journal entries and statement lines by clicking the Reconcile button.
Once a statement line is reconciled, it's status will change to Reconciled, and a Revert button will appear to undo the reconciliation if needed.
After reconciliation
, the invoice INV/2025/00006 is marked as Paid, and the Amount Due becomes 0.
Users can view the line details by clicking the View button on the line.
Transaction 2 :
Partner = Deco Addict
Label = First 10000 $ of invoice INV/2025/00004
Amount = $ 10,000.00
Existing Customer Invoice INV/2025/00006 before reconcile.
Let's start the Reconciliation process.
Users can select and add lines in to the Match with Customer/Vendor tab.
Balance = $ 9,250.00 Equation(Inv Amount $ 19,250.00 - Statement Amount $ 10,000.00)
Users can reconcile the selected journal entries and statement lines by clicking the Reconcile button.
Once a statement line is reconciled, it's status will change to Reconciled.
Invoice INV/2025/00006 is Partial paid after reconciliation, with an Amount Due of $ 9,250.
Transaction 3 :
Partner = Azure Interior
Label = PBNK1/2025/00003 of INV/2025/00007
Amount = $ 2,549.00
In this Transaction Invoice has payment and no amount due so we can match with Payments.
Existing Customer Invoice INV/2025/00007 before reconcile.
Invoice In Payment state and no Amount Due
Existing Payment PBNK1/2025/00003 before reconcile.
Payment In Progress state.
Let's start the Reconciliation process.
Users can select and add lines in to the Match with Payments tab.
Users can match the selected Payment and Statement lines by clicking the Reconcile button.
Once a statement line is reconciled, it's status will change to Reconciled.
The state of invoice INV/2025/00007 changes from In Payment to Paid after reconciliation.
The state of payment PBNK1/2025/00003 changes from In Process to Paid after reconciliation.
Transaction 4 :
Partner = Deco Addict
Label = INV/2025/00004 and INV/2025/00003
Amount = $ 51,000.00
Transaction Detail:
INV/2025/00004 :- Total amount: $19,250.00. Already paid $10,000.00 via bank statement, so the amount due is $9,250.00.
INV/2025/00003 :- Amount Due: $41,750.00.
The total payment amount can be matched with both invoices:
$ 51,000.00 = $ 9,250.00 (INV/2025/00004) + $ 41,750.00 (INV/2025/00003)
Existing Customer Invoice INV/2025/00003 before reconcile.
Existing Customer Invoice INV/2025/00004 before reconcile.
Invoice in Partial state and $ 9,250.00 Amount Due.
Let's start the Reconciliation process.
Users can select and add lines in to the Match with Customer/Vendor tab.
Users can reconcile the selected journal entries and statement lines by clicking the Reconcile button.
Once a statement line is reconciled, it's status will change to Reconciled.
After reconciliation, the invoice INV/2025/00003 is marked as Paid, and the Amount Due becomes 0.
The state of invoice INV/2025/00004 changes from Partial to Paid and the Amount Due becomes 0 after reconciliation.
Transaction 5 :
Partner = Gemini Furniture
Label = Prepayment (Customer)
Amount = $ 1,200.00
It's Advance Customer Payment so, we can match with Payments.
Existing Payment PBNK1/2025/00002 before reconcile.
Payment In Progress state.
Let's start the Reconciliation process.
Users can select and add lines in to the Match with Payments tab.
Users can match the selected Payment and Statement lines by clicking the Reconcile button.
Once a statement line is reconciled, it's status will change to Reconciled.
The state of payment PBNK1/2025/00002 changes from In Process to Paid after reconciliation.
Transaction 6 :
Partner = Gemini Furniture
Label = Bank Fee
Amount = $ -32.28
This is a Bank Fee entry, so we'll handle it using Manual Operations.
Let's start the Reconciliation process.
Users can add manual details in to the Manual Operations tab.
Users can Reconcile the Manual Operation line and Statement lines by clicking the Reconcile button.
Once a statement line is reconciled, it's status will change to Reconciled.
New Journal Entry BNK1/2025/00020 is created and posted for the statement line after reconciliation.
Transaction 7 :
Partner = OpenWood
Label = BILL/2025/11/0001
Amount = $ -6,000.00
Existing Vendor bill BILL/2025/11/0001 before reconcile.
Let's start the Reconciliation process.
Users can select and add lines in to the Match with Customer/Vendor tab.
Users can reconcile the selected journal entries and Statement lines by clicking the Reconcile button.
Once a statement line is reconciled, it's status will change to Reconciled.
After reconciliation, the Vendor bill BILL/2025/11/0001 is marked as Paid, and the Amount Due becomes 0.
Transaction 8 :
Partner = Ready Mat
Label = BILL/2025/10/0002
Amount = $ -1,000.00
Existing Vendor bill BILL/2025/10/0002 before reconcile.
Let's start the Reconciliation process.
Users can select and add lines in to the Match with Customer/Vendor tab.
Balance = $ -800.00 Equation(Bill Amount $ -1,800.00 - Statement Amount $ -1,000.00)
Users can reconcile the selected journal entries and Statement lines by clicking the Reconcile button.
Once a statement line is reconciled, it's status will change to Reconciled.
Bill BILL/2025/10/0002 is Partial paid after reconciliation, with an Amount Due of $800.
Transaction 9 :
Partner = The Jackson Group
Label = Advance for next order
Amount = $ -10,000.00
It's Advance Vendor Payment so, we can match with Payments.
Existing Payment PBNK1/2025/00004 before reconcile.
Let's start the Reconciliation process.
Users can select and add lines in to the Match with Payments tab.
Users can match the selected payments and Statement lines by clicking the Reconcile button.
Once a statement line is reconciled, it's status will change to Reconciled.
The state of payment PBNK1/2025/00004 changes from In Process to Paid after reconciliation.
Transaction 10 :
Label = Last Year Interest
Amount = $ 1000.00
This is a Bank Interest entry, so we'll handle it using Manual Operation.
Let's start the Reconciliation process.
Users can add manual details in line to the Manual Operations tab.
Users can Reconcile the Manual Operation line and Statement lines by clicking the Reconcile button.
Once a statement line is reconciled, it's status will change to Reconciled.
New Journal Entry BNK1/2025/00018 is created and posted for the statement line after reconciliation
Validate Button After All Lines Reconciled
When all lines are reconciled, the Validate button becomes visible.
Statement Record Validated
When the user clicks Validate, the state changes to Validated, and the record becomes read-only.
Statement Report menu.
Bank/2025/0001 : When you click the Statement Report menu, a detailed PDF report is downloaded.
Statement Report
Report shows your bank statement summary along with all reconciled journal entries — including the date, account, partner, invoice reference, and debit/credit details.
This helps you clearly see which transactions were matched and how they impact your balances.
Free Support
Get In Touch
OMAX INFORMATICS
| Our Odoo Services |
| For support, query and question contact us. |
Thank you for visiting
Odoo Proprietary License v1.0 This software and associated files (the "Software") may only be used (executed, modified, executed after modifications) if you have purchased a valid license from the authors, typically via Odoo Apps, or if you have received a written agreement from the authors of the Software (see the COPYRIGHT file). You may develop Odoo modules that use the Software as a library (typically by depending on it, importing it and using its resources), but without copying any source code or material from the Software. You may distribute those modules under the license of your choice, provided that this license is compatible with the terms of the Odoo Proprietary License (For example: LGPL, MIT, or proprietary licenses similar to this one). It is forbidden to publish, distribute, sublicense, or sell copies of the Software or modified copies of the Software. The above copyright notice and this permission notice must be included in all copies or substantial portions of the Software. THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.
Please log in to comment on this module