50.1K

Verified Solution

Link Copied!

PROBLEM NO. 2 In the audit of Mandaue Company's cash account, you obtained the following information (all amounts are in Philippine Pesos): The company's bookkeeper prepared the following bank reconciliation as of November 30, 2022. Bank balance - November 30,2022 Undeposited collections Bank service charges Bank collection of customer's note Outstanding checks: 90,800 5,000 100 (8,000) Book balance-November 30, 2022 Additional data are given as follows: a. Company recordings for December: Total collections from customers Total checks drawn 165,000 98,000 b. Bank statement totals for December: Charges 123,800 Credits 169,000 c. Check no. 1159 dated November 25, 2022, was entered as P3,000 in payment of a voucher for P30,000. Upon examination of the checks returned by the bank, the actual amount of the check was P30,000. d. Check no. 2113 dated December 20, 2022 was issued to replace a mutilated check (no. 1767), which was returned by the payee. Both checks were recorded in the amount drawn, P5,000, but no entry was made to cancel check no. 1767. e. The December bank statement included a check drawn by Lapu-Lapu Company for P1,500. f. Undeposited collections on December 31, 2022- P8,000. g. The service charge for December was P150 which was charged by the bank to another client. h. The bank collected a note receivable of P7,000 on December 28,2022 , but the collection was not received in time to be recorded by Mandaue. i. The outstanding checks on December 31,2022 , were: Required: Prepare proof of cash (a.k.a. two-date bank reconciliation or four-column bank reconciliation)

Answer & Explanation Solved by verified expert

See Answer