Question

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. Checks $ 68,643.69 Balance 4/30/X0 $ 65,534.33 (2,134.22) 4,955.32 15,000.89 (23,088.23) 23,088.23 RELIABLE AUTO PARTS, INC. Proof of Cash for April 20x0 July 31, 20x0 Balance 3/31/X0 Deposits Per bank statement $ 72,225.57 $61,952.45 Deposits in transit: At 3/31/X0 2,134.22 At 4/30/XO 4,955.32 Outstanding checks: At 3/31/X0 (15,000.89) At 4/30/X0 Bank service charges: March 20X0 (22.33) April 20x0 Note receivable collected by bank 4/30/XO 18,330.00 NSF check of customer L. G. Waite, charged back by bank 3/31/XO, redeposited and cleared 4/3/X0 (421.04) 421.04 Balances as computed 58,915.53 85,658.81 Balances per book 59,802.27 46,022.51 Unlocated difference $ (886.74) $39,636.30 22.33 (19.29) 19.29 18,330.00 60,559.39 76,734.07 $(16,174.68) 109,792.95 29,090.71 $ 80,702.24

Answer 1

Here is the correct answer

RELIABLE AUTO PARTS, INC
Proof of Cash for April 20X0
July 31, 20X0
	Balance			Balance
	3/31/X0	Deposits	Checks	4/30/X0
Per bank statement	$   72,225.57	$   61,952.45	$   68,643.69	$   65,534.33
Deposits in transit:
At 3/31/X0	$     2,134.22	$   -2,134.22		$                 -
At 4/30/X0		$     4,955.32		$     4,955.32
Outstanding checks
At 3/31/X0	$ -15,000.89		$ -15,000.89	$                 -
At 4/30/X0			$   23,088.23	$ -23,088.23
Bank service charges
March 20X0	$          22.33		$          22.33	$                 -
April 20X0			$         -19.29	$          19.29
Note receivable collected by bank		$ -18,330.00		$ -18,330.00
NSF Check				$                 -
LG Waite	$        421.04	$       -421.04		$                 -
Balance per book	$   59,802.27	$   46,022.51	$   76,734.07	$   29,090.71