Company
  • Home
  • About Us
  • UAE Explore

Bank Reconciliation in Odoo

By Syama Ramachandran

Bank Reconciliation is one of the most important procedures that has to be done in a business, in order to ensure that the balance as per the company books and the bank statements are equal. With Odoo, this process becomes very easy to manage.

The module adds two menus Under ‘Accounting’  main menu.

  • Bank Reconciliation
  • Bank Reconciliation Report

Bank Reconciliation:

 On clicking the Bank Reconciliation menu a wizard appears.

In the wizard below when clicking the ‘Refresh/Update ‘ button all the account move lines with the following condition is selected. The conditions include:

  1. The move corresponding to the  move line is in posted state.
  2. Account of the move line is same as the one selected in the wizard.
  3. Date of account move line is within the range between Date From and Date End selected in the wizard.
  4. If ‘Show only’ option in wizard selected is :
  • Reconcile – account move lines  with reconciliation date not equal to false.
  • To Reconcile – account move lines with reconciliation date equal to false.
  • All – all the account move lines  with above 3 conditions.

All the move lines satisfying the above conditions are selected and is written to the one2many field Bank Reconciliation Line.

If the amount currency field in move line is set then:

  • Credit = amount currency value * -1
  • Debit = amount currency value.

Else the debit and credit value is corresponding value of move line debit and credit.

        

Above wizard shows the lines with the conditions selected.

In the wizard we need to reconcile particular moveline then ‘Reconcile?’ boolean in the line is set to true and then we can change the credit and debit amount , select a reconciliation date and click save button .By default when the ‘Reconcile?’  boolean is set the bank credit and debit values will be the corresponding debit and credit values and reconciliation date is today date.

On clicking the save button the Reconciliation Date,Bank Debit,Bank Credit of the selected line is written to the corresponding account move line fields and the line is unlinked from the wizard field. The selected line is reconciled now.

When ‘Reconciled’ option is selected from wizard the above reconciled line will be listed in the wizard lines

And the remaining lines which is unreconciled can be reconciled by selecting the option as ‘To Reconciled’  in wizard which shows the unreconciled lines. We can make these lines reconcile as above.

Bank Reconciliation Report

Bank reconciliation report can  be generated by clicking on  ‘Bank Reconciliation Report’ menu and a wizard pop ups

The Print wizard have same options to select as in the ‘Bank Reconciliation’ wizard.Filter will be applied to the report contents based on the values specified in the wizard.The report prints the account move line details. Report looks like:

Post navigation

Previous PostPrevious
Next PostNext
Related Posts

Generate Recurring Jounral Entries in Odoo

Customized Product Costing Module in Odoo

AUDIT TRACKER: A POWERFUL AUDIT MANAGEMENT SOLUTION

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Recent Posts

  • Weighbridge Integration In Odoo
  • Odoo Retail ERP Case Study
  • Bank Reconciliation in Odoo
  • Merge Shipment from Multiple Purchase Orders in Odoo
  • HR, Payroll and Leave Management Module in odoo

Categories

  • Asset Managment
  • Finance Management
  • Human Resource
  • odoo 11
  • Odoo Inventory
  • POS
  • property management
  • UAE Explore
  • Uncategorized
  • Zesty Products

Archives

  • October 2020
  • September 2020
  • August 2020
  • July 2020
  • June 2020
  • May 2020
  • April 2020
  • March 2020
  • February 2020
  • January 2020
  • December 2019
  • November 2019
  • October 2019
  • September 2019
  • August 2019
  • July 2019
  • June 2019
  • May 2019
  • April 2019
  • March 2019
  • February 2019
  • January 2019
  • December 2018
  • November 2018
  • October 2018
  • September 2018
  • August 2018
  • July 2018
  • June 2018
  • May 2018
  • April 2018
  • March 2018
  • February 2018
  • January 2018
  • December 2017
  • November 2017
  • October 2017
  • September 2017
  • August 2017
  • July 2017
  • June 2017
  • May 2017

Recent Comments

  • Wainaina on Odoo Functional Documentation-DB Integration
  • Diego Gonzalez on Revenue Realisation in Odoo
  • Fazil Mahammood Abdullah on Serial Line Numbering Module In Odoo
  • Fazil Mahammood Abdullah on Stock Aging Report
  • Bakir Boubakkir Hussain on Delivery Tracking Module | Odoo

Quick Links

  • About Us
  • Contact Us
  • Sample Page

Connect with us

  • Contact us
  • Blog
  • Presentations
  • +91 9544 644 399
  • contact@alraislabs.com

ZESTY LABS - About us

Zesty Labs (part of Alrais Labs) is a multi national company, with its expertise in Odoo (formerly Open ERP) and has direct offices in Germany, India and UAE

We are leading among the odoo partners across UAE region and other GCC countries, with large odoo implementation to show case in its forte. Our goal is to deliver error free and robust ERP solution in and affordable cost .

Our products are designed for medium to large sized companies willing to optimize their performance.

To know more about our updates visit our blog,

Blog : Trends & Updates on ERP

Copyright © ZESTY LABS