How to Load the Opening Balance for the Bank Reconcillation Statement

Dear All,

We are migrating the closing balance of legacy to make GO Live for one of the Organization . We loaded AP, AR, GL  balances into the System. Now we are facing the difficulty and customer asks us to upload the closing balance of BRS

The Statement as on 30th Jun 2015  is as follows (Example )

Closing Balance                                               - Rs 1,00,000

Cheque Issued But not deposited                       - Rs 30,000 (Cheque We issues thru Payable but not presented by Supplier)

Cheque Deposited But Not realized                    - Rs 50,000 (Cheques Received thru AR Receipt ,, Deposited in Bank but pending in clearing)

Cheques might be realized later on 2nd July .