REQUIREMENT: INFORMAL BANK RECONCILIATION FOR THE MONTH OF SEPTEMBER

45 Problem 1-6 Sept. 30 The general manager of the YELLOW BELL COMPANY presented the following as your basis in preparing a proof of cash for the month of September, 2019, using the bank to book format. 1. Balances per bank statement- Aug. 31 P10,292.25 Sept. 30 17,133.54 2. Balances per books- Aug. 31 5,615.49 Sept. 30 10.898.94 3. Undeposited collections- Aug. 31 1,500.00 6,000.00 4. Outstanding checks- Aug. 31 6,176.76 No. 2520 P3,600.00; 2521 P1,142.76; 2522 P1,434.00 5. Outstanding checks- Sept. 30 6,600.60 No. 2674 P4,110.00; 2675 P720.00; 2676 P1,770.60 6. Cash Receipts Book, Sept., 2019 Sept. 1 Balance P5,615.49 2 Received from customers 9,988.86 7 Received from customers 8,388.66 12 Received from customers 5,367.78 17 Received from customers 15,546.87 22 Received from customers 14,154.57 27 Received from customers 8,814.33 30 Received from customers 11,156.94 P75,433.50 7. Cash Disbursements Book, Sept., 2019 Sept. 5 Checks issued 14 Checks issued 24 Checks issued 28 Checks issued P15,381.33 18,681.69 21,714.33 8,457.21 P64,534.56 8. The following summarized transactions were taken from the bank statement of September, 2019: Deposits including P300 interest coupon credited by the bank but not taken up yet in the cash receipts book, P69,218.01; checks paid, P62,376.72. 9. Cash on hand per count in the afternoon of Sept. 30 amounted to P6,000 which includes accommodated check no. 2675. Check nos. 2522 and 2674 has not been picked up yet by the suppliers as of Sept. 30. 45 Problem 1-6 Sept. 30 The general manager of the YELLOW BELL COMPANY presented the following as your basis in preparing a proof of cash for the month of September, 2019, using the bank to book format. 1. Balances per bank statement- Aug. 31 P10,292.25 Sept. 30 17,133.54 2. Balances per books- Aug. 31 5,615.49 Sept. 30 10.898.94 3. Undeposited collections- Aug. 31 1,500.00 6,000.00 4. Outstanding checks- Aug. 31 6,176.76 No. 2520 P3,600.00; 2521 P1,142.76; 2522 P1,434.00 5. Outstanding checks- Sept. 30 6,600.60 No. 2674 P4,110.00; 2675 P720.00; 2676 P1,770.60 6. Cash Receipts Book, Sept., 2019 Sept. 1 Balance P5,615.49 2 Received from customers 9,988.86 7 Received from customers 8,388.66 12 Received from customers 5,367.78 17 Received from customers 15,546.87 22 Received from customers 14,154.57 27 Received from customers 8,814.33 30 Received from customers 11,156.94 P75,433.50 7. Cash Disbursements Book, Sept., 2019 Sept. 5 Checks issued 14 Checks issued 24 Checks issued 28 Checks issued P15,381.33 18,681.69 21,714.33 8,457.21 P64,534.56 8. The following summarized transactions were taken from the bank statement of September, 2019: Deposits including P300 interest coupon credited by the bank but not taken up yet in the cash receipts book, P69,218.01; checks paid, P62,376.72. 9. Cash on hand per count in the afternoon of Sept. 30 amounted to P6,000 which includes accommodated check no. 2675. Check nos. 2522 and 2674 has not been picked up yet by the suppliers as of Sept. 30