Enable Dark Mode!
configure-reconciliation-models-and-reconcile-bank-statements-with-ease.jpg
By: Sree

Configure Reconciliation Models and Reconcile Bank Statements with Ease

Functional Odoo 14 Accounting

What is bank account reconciliation?

A business will be dealing with a lot of transactions every day. The amount collected from the customer using the invoice is paid. However, the accounts wing of the business may not be able to enter all transaction details and amounts in the bank account the moment the transaction takes place. Usually, the account statements are examined and verified at the end of a week. The process of cross-matching the bank account details with the cash transaction details is termed the reconciliation process. This process helps the accounts wing to easily track any errors in entries. Reconciliation helps to assure transparency in transactions. You can ensure accuracy in transactions with this.

Odoo Accounting has special features to make reconciliation easy. So when the process is completed and any changes are noticed, the system automates the reconciliation process. Odoo 14 Accounting module offers support for creating reconciliation models to speed up the process. 

With this accounting tool, we will be able to link the customer invoices with bank statements. 

When do we reconcile an account? We reconcile an account when all the bank accounts are created and imported properly. Reconciliation will help you to ensure that all your journal entries are properly added to the bank statement. It is to complete this task on a fast track basis that we introduce a reconciliation process. As we have to deal with recurring reconciliation processes we can create and use reconciliation models for the quick completion of the task.

To create a reconciliation model we can go to the Configuration menu in Odoo 14 Accounting.

Here, you can find a reconciliation model under the Banks section.


configure-reconciliation-models-and-reconcile-bank-statements-with-ease


Reconciliation Models

Here we can find an already created Reconciliation model. Let us open it to check what it contains.


configure-reconciliation-models-and-reconcile-bank-statements-with-ease


Odoo enables the user to name the reconciliation model.

We can also create the type of reconciliation model. 

Using this form, we can create three different types of reconciliation models. They are

- Match existing invoices/bills.

- Manually create a write-off on clicked button

- Suggest counterpart values 

We have created the model with invoice matching rules

We can also use the Auto-validate option. On enabling this Auto Validation option the reconciliation will become automated.

What we have here now is Conditions on Bank Statement lines.

Here, we have to select the journal, the nature of the amount, the amount etc. We can also enable the same currency matching and amount matching options.


configure-reconciliation-models-and-reconcile-bank-statements-with-ease


Another option we have is partner mapping

We can restrict the partners to the option to restrict this reconciliation model to a particular partner.

Restrict partner: This option can be used to select only a particular type of partner like consultants, vendors, etc.

Reconciliation

Once we finish the configuration of Reconciliation models we can go ahead with the reconciliation process.

For this, we have to move to the Accounting menu and select the Reconciliation option. This can be found under Actions 


configure-reconciliation-models-and-reconcile-bank-statements-with-ease


Clicking on Reconciliation we get the list of accounts to be reconciled.


configure-reconciliation-models-and-reconcile-bank-statements-with-ease


Getting the details of the invoices and payments is made easy here. We can also find the button. This button will help us complete the reconciliation task. 

This process will help us to match the payment or invoice with the account. It will assure that the data given in the bank statement are equal to that in the journal including general ledger.

We have two different methods for completing the process called reconciliation.

Reconcile from Invoices

Let us see how.

For this, we can first create an invoice.


configure-reconciliation-models-and-reconcile-bank-statements-with-ease


Here we can enter the customer name, invoice date, and due date. We can also include it in the journal.

Besides, we have to fill in the details in the invoice lines.

Here, we have to add a product, product label, account, and analytical account. We can also add quantity, unit of measures, price of the product, and the tax details.

Once an invoice is created we have to confirm the invoice.

Then we have to REGISTER PAYMENT


configure-reconciliation-models-and-reconcile-bank-statements-with-ease


When you register the payment you get a new window


configure-reconciliation-models-and-reconcile-bank-statements-with-ease


We can enter the journal name

Payment way and add payment methods. We can also add the amount and payment date here. Then create the payment and we can find that the process is over.


configure-reconciliation-models-and-reconcile-bank-statements-with-ease


This is the page that we get on creating the payment. Here, we have a ribbon on the invoice INPAYMENT


configure-reconciliation-models-and-reconcile-bank-statements-with-ease


In the invoice page we can find the amount due and the paid date

Near Paid On date we can find an icon. This icon will help us to view that the invoice has been reconciled automatically.


configure-reconciliation-models-and-reconcile-bank-statements-with-ease


Now if we want to unreconcile it we can click the UNRECONCILE button. 

Bank statement reconciliation case

This is another method for reconciliation. As we have already discussed invoice reconciliation we can also check reconciliation using a bank statement. To perform this we have to create a new bank statement. WE can do this by importing bank statements also.

For this we have to go to the bank feed section in the Accounting dashboard

Click on the Bank Reconciliation and you can view the statements pending reconciliation.


configure-reconciliation-models-and-reconcile-bank-statements-with-ease


Either create a new statement or use the existing one


configure-reconciliation-models-and-reconcile-bank-statements-with-ease


We can find the reconciliation option here


configure-reconciliation-models-and-reconcile-bank-statements-with-ease


A Reconcile button will help you to perform your task.


configure-reconciliation-models-and-reconcile-bank-statements-with-ease


Here we can find all statements pending reconciliation. We can validate such statements


configure-reconciliation-models-and-reconcile-bank-statements-with-ease


Once we validate we can view that all transactions have been reconciled.


configure-reconciliation-models-and-reconcile-bank-statements-with-ease


Then clicking on this we can find that we have completed the reconciliation of all transactions.


configure-reconciliation-models-and-reconcile-bank-statements-with-ease


If we want we can view the bank statement again using the GO TO BANK STATEMENTS button


configure-reconciliation-models-and-reconcile-bank-statements-with-ease


These are the reconciliation methods used in Odoo 14 Accounting. This process helps us to assure transparency in our bank statements and avoid mismatching of statistics.

Doubts are meant to be clarified and we Cybrosians are here to help you. Find our support by visiting www.cybrosys.com . Don't forget that you can mail at odoo@cybrosys.com or dial +918606827707 to reach us. Stay tuned for more blogs.


If you need any assistance in odoo, we are online, please chat with us.



0
Comments



Leave a comment

 


whatsapp
location

Calicut

Cybrosys Technologies Pvt. Ltd.
Neospace, Kinfra Techno Park
Kakkancherry, Calicut
Kerala, India - 673635

location

Kochi

Cybrosys Technologies Pvt. Ltd.
1st Floor, Thapasya Building,
Infopark, Kakkanad,
Kochi, India - 682030.

location

Bangalore

Cybrosys Techno Solutions
The Estate, 8th Floor,
Dickenson Road,
Bangalore, India - 560042

Send Us A Message