Problem 10-47 [LO 10-6] You are the senior auditor-in-charge of the July 31, 20X0, audit of Reliable Auto Parts, Inc. Your newly hired staff assistant reports to you that she is unable to complete the four-column proof of cash for the month of April 20x0, which you instructed her to do as part of the consideration of internal control over cash. Your assistant shows you the working paper that she has prepared. Your review of your assistant's work reveals that the dollar amounts of all the items in her working paper are correct. You learn that the accountant for Reliable Auto Parts, Inc., makes no journal entries for bank service charges or note collections until the month following the bank's recording of the item. In addition, Reliable's accountant makes no journal entries whatsoever for NSF checks that are redeposited and cleared. Your assistant's working paper appears below. Balance 4/ 39 / Xe $ 65, 628.88 RELIABLE AUTO PARTS, INC. Proof of Cash for April 20x0 July 31, 20X0 Balance 3/31/X0 Deposits Checks Per bank statement $ 72, 332.42 $62, 043.21 $ 68,746.75 Deposits in transit: At 3/31/XO 2,137.38 At 4/30/X0 4,962.59 Outstanding checks: At 3/31/XO (15,023.10) 15,023.10 At 4/30/0 (23, 122.41) Bank service charges: Mnrahova 326 (2,137.38) 4,962.59 23,122.41 Checks $ 68,746.75 20/10 $ 65,628.88 (2.137.38) 4,962.59 15,023.10 (23, 122.41) 23,122.41 22.36 (19.32) 19.32 3/31/XO Deposits Per bank statement $ 72,332.42 $62,043.21 Deposits in transit: At 3/31/XO 2, 137.38 At 4/30/X0 4,962.59 Outstanding checks: At 3/31/XO (15,023.10) At 4/30/X0 Bank service charges : March 20XD (22.36) April 20x0 Note receivable collected by bank 4/30/10 18. 360.00 NSF check of customer L. G. Waite, charged back by bank 3/31/XO, redeposited and cleared 4/3/X0 (421.61) 421.61 Balances as computed 59.002.73 85,787.41 Balances per book 59,890.67 46,086.81 Unlocated difference $ (887.94) $39, 700.60 18, 360.00 6 0,650.48 76,849.10 $(16,198.62) 109,955.82 29,128.38 $ 80,827.44 Required: Prepare a corrected four column proof of cash in good form for Reliable Auto Parts, Inc., for the month of April 20xo. (Negative amounts should be indicated by a minus sign. Round your answers to 2 decimal places.) Balance | 4300 $ 65,628.88 30X0 RELIABLE AUTO PARTS, INC. Proof of Cash for April 20X0 July 31, 20X0 Balance 3/31/X0 Deposits Checks Per bank statement $ 72,332.42 $ 62,043.21 $ 68,746.75 Deposits in transit: At 3/31/XO 2,137.38 At 4/30/20 4,962.59 Outstanding checks: At 3/31/XO (15,023.10) At 4/30/XOSEPH Bank service charges March 20X0 de 22.36 April 20x0 (19.32) Note receivable collected by bank 4/30/XO NSF check of customer LG Waite, charged back by bank 3/31/XO, redeposited 421.61 (421.61) and cleared 4/3/XO Balances per book $ 59,890.67 $ 46,086.81 $ 76,849.10 1 1 UULI THE NT 118 $ 29,128,38
