Bank Reconciliation Statement - Report

Want to Create a Bank Reconciliation Statement Report as:

Bank Name: GIRO BANK LTD, BANK AC No. 1090912

Bank Reconciliation Statement as on 19/04/2013

Balance as per Book:

Add: Cheques Issued But not cleared by Bank

Add: Bank Interests

Less: Cheques Received / Deposited but not yet cleared in Bank

Less: Bank Charges

Balance as per Bank Pass Book:

I will be using the Bank account ledger entry table, .

But which entries should come under Cheques Issued But not cleared by Bank:

and Cheques Received / Deposited but not yet cleared in Bank.

But the main problem is getting these records and from which tables.

We post the statement from the Bank Reconciliation page which is reflected in the Bank Statement page.

Initially all the transactions are kept Open (True) in the Bank Account Ledger Entry table but when the transaction are posted are the Open checkbox is modified to false.

All the new transactions (Bank charges and bank interest) that we get from the Statement issued by the Bank are added in the difference amount in the Bank Reconciliation Page.

I am new in NAV please help.

Regards,

GroundZero