Part A

The cash transactions and cash balances of Asad Inc., for November were as follows:

1. The ledger account for Cash showed a balance at November 30 of Rs. 21805.
2. The November bank statement showed a closing balance of Rs. 14710.
3. The cash received on November 30 amounted to Rs. 4250. It was left at the bank in the night depository chute after banking hours on November 30 and therefore was not recorded by the bank on the November statement.
4. November bank statement was a debit memorandum from the bank for Rs. 400 representing service charges for November.
5. A credit memorandum enclosed with the November bank statement indicated that a non-interest-bearing note receivable for Rs. 5000 from Dodge Inc., left with the bank for collection, had been collected and the proceeds credited to the account of Asad Inc.
6. Comparison of the paid checks with the entries in the accounting records revealed that check no. 112 for Rs. 800, issued November 17 in payment for computer equipment, had been erroneously entered in Asads records as Rs. 1800.
7. Examination of the paid checks also revealed that three checks, all issued in November, had not yet been paid by the bank: no. 814 for Rs. 115; no. 816 for Rs. 170; no. 830 for Rs. 530
8. Included with the November bank statement was a Rs. 4170 check drawn by Ahmed a customer of Asad, Inc. This check was marked NSF. It had been included in the deposit of November 27 but had been charged back against the companys account on November 30.
9. Rs. 5,000 deposit in transit, was not recorded by the bank on the November statement.
10. Comparison of the paid checks returned by the bank with the entries in the accounting records revealed that check no. 810 for 430, issued November 15 in payment for computer equipment, had been erroneously entered in Asads records as 340.

Required:

You are required to prepare a bank reconciliation statement for the month of November, 2020.