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.

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,368.71		$ 62,074.63		$ 68,782.11		$ 65,661.23
Deposits in transit:
At 3/31/X0		2,138.45						(2,138.45)
At 4/30/X0				4,965.10				4,965.10
Outstanding checks:
At 3/31/X0		(15,030.62)				15,030.62
At 4/30/X0						(23,133.98)		23,133.98
Bank service charges:
March 20X0		(22.37)				22.37
April 20X0						(19.33)		19.33
Note receivable collected
by bank 4/30/X0				18,370.00				18,370.00
NSF check of customer
L. G. Waite, charged
back by bank 3/31/X0,
redeposited and
cleared 4/3/X0		(421.80)		421.80
Balances as computed		59,032.37		85,831.53		60,681.79		110,011.19
Balances per book		59,920.71		46,109.48		76,888.51		29,141.68
Unlocated difference	$	(888.34)	$	39,722.05	$	(16,206.72)	$	80,869.51

Prepare a corrected four-column proof of cash in good form for Reliable Auto Parts, Inc., for the month of April 20X0. (Negative amounts should be indicated by a minus sign. Round your answers to 2 decimal places.)

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,368.71 $62,074.63 $68,782.11 $65,661.23 Deposits in transit: At 3/31/X0 2,138.45 At 4/30/X0 4,965.10 Outstanding checks: At 3/31/X0 (15,030.62) At 4/30/X0 Bank service charges: March 20X0 22.37 22.37 April 20X0 (19.33) 19.33 Note receivable collected by bank 4/30/X0 NSF check of customer L. G. Waite, charged back by bank 3/31/X0, redeposited and cleared 4/3/X0 421.80 (421.80) Balances per book $59,920.71 $46,109.48 $76,888.51 $29,141.68

Answer 1

RELIABLE AUTO PARTS, INC
Corrected Proof of Cash for April 20X0
July 31, 20X0
	Balance 3/31/X0	Deposits	Checks	Balance 4/30/X0
Per bank statement	72,368.71	62,074.63	68,782.11	65,661.23
Deposits in transit:
At 3/31/X0	2,138.45	(2,138.45)
At 4/30/X0		4,965.10		4,965.10
Outstanding checks:
At 3/31/X0	(15,030.62)		(15,030.62)
At 4/30/X0			23,133.98	(23,133.98)
Bank service charges:
March 20X0	22.37		22.37
April 20X0			(19.33)	19.33
Note receivable collected by bank 4/30/X0		(18,370.00)		(18,370.00)
NSF check of customer
L. G. Waite, charged back by bank 3/31/X0, redeposited and cleared 4/3/X0	421.80	(421.80)
Balances per book	59,920.71	46,109.48	76,888.51	29,141.68