Community mailing list archives

Re: Bank Statement Reconciliation in Anglo-saxon countries

WiseTree Consult Nigeria Limited, Kayode Adeniyi
- 10/07/2015 09:44:37

Many thanks for this post. I have also wondered how this is done in Odoo.
So, I am following this thread with rapt attention.

Best Regards,

Kayode Adeniyi
(Managing Consultant)
WiseTree Consult
28, Aba Johnston Crescent,
Off Adeniyi Jones Avenue,
Ikeja, Lagos.

Tel: +234 1 8037214830

On Wednesday, October 7, 2015 1:52 PM, Jordi Ballester Alomar <> wrote:

Hi, just to clarify, 

You can maintain a bank account in line with the Bank using Odoo's bank reconciliation if you post transactions such as Deposits in Transit  or Outstanding Checks to separate journals, and then reconcile them once you receive the bank statement.

The issue would be to create a comprehensive report of what transactions (Deposits in Transit, Outstanding Checks) remained uncleared for the period that the bank statement is created.

On Wed, Oct 7, 2015 at 2:22 PM, Jordi Ballester Alomar <> wrote:
Dear community members,

We have customers in various Anglo-Saxon countries that use, or intend to use bank statement reconciliation, but I'm seeing a gap in Odoo's approach. Perhaps you can help me to clarify it. 

As a general overview of the bank statement reconciliation in such countries (or at least in the US), see the following article:

Thus, Banc rec. is a process to prove that the company's bank account balances are aligned in the company's books and at the Bank, and that differences are reported.

As far as I can see, Odoo's Bank Statement allows to complete Step 2 'Adjust the Balance per Books', but not Step 1 "Adjust the Balance per Bank" or Step 3 
"Compare the adjusted balances".

Generally a report is required to show the results of steps 1,2,3.

Post to: