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.