Reference no: EM132656941

The cash transaction and cash balances of Hekmatia Company for July were as follows:

1. The ledger account for cash showed a balance on July 31 of Tk.16,766.95.

2. The July bank statement showed a closing balance of Tk.18,928.12

3. The cash received on July 31 amounted to Tk.4,017.15. It was left at the bank in the late hours on July 31 and therefore was not recorded by the bank on the July statement.

4. The bank debited Hekmatia's account an amount of Tk.7.65 as service charge for July.

5. The bank collected a non-interest bearing note receivable for Tk.4,545 on behalf of Hekmatia.

6. Comparison of the cheques paid by the bank with the entries in the accounting records of Hekmatia revealed that cheque no. 821 for Tk.835.02 had been erroneously entered in Hekmatia's records as Tk.853.02.

7. Examination of the paid cheques also revealed that three cheques, all issued in July, had not yet been paid by the bank. These cheques are as follows:

Cheque No.811 Tk.861.12

Cheque No.814 640.80

Cheque No.823 301.05

8. Included with the bank statement was a cheque for Tk.180, which was marked "NSF."

Required:

Create a bank reconciliation statement for Hekmatia Company on July 31.