How to Register bank statements manually in Odoo

The Most Popular Extension Builder for Magento 2

With a big catalog of 224+ extensions for your online store

Odoo is a comprehensive, open-source business software platform that offers a range of functionalities, including accounting and finance management. One of the key features of Odoo accounting is the ability to reconcile bank statements with the company’s financial records. This helps ensure accuracy and completeness in the financial reporting of a business.

In many cases, bank statements can be imported into Odoo automatically. However, there may be instances where you need to manually register bank statements, especially if the statements are not in a format that Odoo can automatically recognize. This manual process can be time-consuming, but it is essential for ensuring the accuracy of financial reports.

We will explore How to Register bank statements manually in Odoo. By the end of this tutorial, you will have a comprehensive understanding of how to register bank statements manually in Odoo. So, let’s get started!

Table of Contents

Why should we register bank statements manually in Odoo?

Registering bank statements manually in Odoo is a critical step in keeping accurate financial records and tracking financial transactions. The system can correctly match transactions recorded in the bank statement to transactions recorded in the system by manually registering bank statements. This aids in the prevention of errors and anomalies, ensuring that the financial statements produced by the system are accurate and reliable.

Furthermore, manual bank statement registration provides greater control and visibility over the financial transactions recorded in the system. This is especially important for firms that need to keep a careful eye on their cash flow, budget, and expenses. In summary, manually registering bank statements in Odoo is a key step in maintaining accurate and dependable financial records, which is required for successful financial management and control.

How to Register bank statements manually in Odoo

Step 1. Create bank statements

The first step in registering bank statements manually in Odoo is to create bank statements. To do this, navigate to the Accounting module, select Bank Statements, and click on the Create button. A new bank statement will be created, and you will be taken to the form view.

A bank statement form

In this form view, you will be prompted to fill out several important fields that are essential for the proper reconciliation of your bank accounts. It’s important to understand the purpose of each field and to make sure that you fill out all required fields accurately.

  • Bank Account: this is where you select the bank account for which you are registering a statement. This is important because you may have multiple bank accounts in your system, and you want to make sure that you are registering the statement for the correct account.
  • Statement Name: this is where you give your bank statement a unique name. This name is used to identify the statement within your Odoo system and can be helpful in searching for a specific statement later.
  • Starting Balance: this is where you enter the balance of your bank account before the transactions in the statement period. This amount should match the balance shown on your bank statement.
  • Ending Balance: this is where you enter the balance of your bank account after all transactions in the statement period. This amount should also match the balance shown on your bank statement.

By filling out all of these fields accurately, you are setting the foundation for a successful manual reconciliation of your bank statements in Odoo. So, make sure to take your time and double-check your entries before moving on to the next step.

Step 2. Fill out Partner field for reconciliation

Once you have created your bank statements, the next step is to fill out the Partner field for reconciliation. This field is used to match the bank transactions with the corresponding financial records in Odoo.

To fill out the Partner field, navigate to the Transactions tab of your bank statement. In this tab, you will see a list of all transactions for the selected bank account. For each transaction, you will need to select the corresponding Partner from the drop-down menu.

In some cases, the Partner field may already be filled out automatically. This happens when the transaction is linked to an invoice or a payment in Odoo. However, if the Partner field is blank, you will need to manually select the correct Partner.

Fill Partner field

To do this, click on the transaction you want to reconcile and select the More button. From the drop-down menu, select Match with Existing Partner. A pop-up window will appear, allowing you to search for the Partner you want to reconcile with.

Once you have selected the correct Partner, click on the Match button. The Partner field will be filled out automatically, and the transaction will be reconciled. Repeat this process for each transaction in your bank statement. Once you are done, click the Save button to finalize the process.


In conclusion, manually registering bank statements in Odoo is a crucial step for keeping track of your financial transactions and ensuring that your books are up-to-date. By following the steps outlined above, you are able to create bank statements and fill out the required fields for reconciliation. Regularly reconciling your bank statements will help you to identify any discrepancies or errors in your financial data, which can be corrected promptly to maintain the accuracy of your records.

By taking the time to manually register your bank statements in Odoo, you can improve your financial management and keep your business on track. Whether you’re a small business owner or managing a large corporation, the process is straightforward and can be done in just a few minutes.

That concludes our tutorial on How to Register bank statements manually in Odoo. We hope that you will find this guide useful and that you can refer to it when you need to.

Increase sales,
not your workload

Simple, powerful tools to grow your business. Easy to use, quick to master and all at an affordable price.

Get Started
avada marketing automation

Explore Our Products:


Stay in the know

Get special offers on the latest news from Mageplaza.

Earn $10 in reward now!

Earn $10 in reward now!

go up