Question

Prepare a Bank Reconciliation Statement of Cili Traders, a Profit making organisation, for the period 1-1-2018 to 31-3-2018

While comparing with Cash book with Pass book, the following details were noted.

1. Clearance date of Cheque No.7125 was on 7/4/18 

2. Cheque No. 9614 cleared only on 2/4/2018 

3. Cheque No. 7127 is cleared on 1/4/18 

4. Clearance date of Cheque No.4528 was on 12/2/18 

5. Cheque No. 7129 was cleared on 19/3/2018 

6. All other transaction’s clearance date is same as transaction date

Answer 1

procedure: 

Step 1 – Start GNUKhata Application → Office → GNUKhata 

Step 2 – Create Organisation Create an organisation → Cili Traders → Profit making → 1-1-18 to 31-12-2018 → Create admin with imaginary data.

Step 3 – Create Ledger accounts Master Menu → Create Account → Select Group → Sub Group → Account Name → Save

Analysis Table

Step 4 – Voucher Entry Transaction/Voucher → Select appropriate voucher → Number → Date → DebitCredit → Save 

Step 5 – Preparation of Bank Reconciliation Statement Press Alt +R 

OR 

1. Master → Bank rEconciliation statement → Select Bank’s Name (Canara Bank) → Set Reconciliation period → Click on view button to view Bank reconciliation screen 

2. Enter clearance date → Click on View statement button 

3. To show the cleared Transactions, click on cleared items 

4. To show the uncleared transactions, click on uncleared items

Output: