The following information is available to reconcile Pixar, Inc.'s book balance of cash with its bank statement cash balance as of December 31, 2020.

a. The December 31 cash balance according to the accounting records (books) is $32,800, and the bank statement cash balance on December 31 is $27,950.

b. Outstanding checks (checks that have been written by Pixar, but not yet cashed by their employees and/or suppliers) total $5,400.

c. When the December checks which have been cashed at the bank are compared with entries in the accounting records, it is found that check #1267 had been correctly written for $34 to pay Staples for office supplies, but was erroneously entered in the accounting records (books) as $43.

d. A memo is enclosed with the bank statement and is unrecorded by Pixar at the time of the reconciliation. The memo is for an NSF (not sufficient funds) check for $649 received from one of Pixar's customers (Al's Toy Barn), in payment of its account. In addition, the bank assessed Pixar a $10 fee for processing the NSF check. Pixar did not record these transactions before receiving their bank statement, but needs to do so now.

e. Pixar's December 31 daily cash receipts of $9,600 were placed in the bank's night depository on that date after business hours, but do not appear on the December 31 bank statement.

Prepare the bank reconciliation for this company as of December 31, 2020. Using the information provided in letters a. through e. above, identify what needs to be reported on the bank reconciliation for the items labeled #1, #2, through #20 in the template below. If an item does not need to have anything reported, you may simply omit that number in the response box below. In other words, you only have to list the # if it has words or a dollar amount to be reported. NOT ALL #s WILL HAVE AN ENTRY.

Hint: #'s 1, 2, 18 and 19 must be used. To get you started, note that the erroneous check #1267 has already been listed as a reconciling item on the book side of the reconciliation.

Pixar, Inc.
Bank Reconciliation
12/31/20
.
Bank Statement balance	#1		Book balance	#2
Add: #3	#4		Add: check #1267 error	#5
#6	#7		#8	#9
Less: #10	#11		Less: #12	#13
#14	#15		#16	#17
Adjusted cash balance	#18		Adjusted cash balance	#19

Short Answer

Toolbar navigation opens in a dialog