The December 31 bank statement for Miller Corporation showed a $2,040.75 balance. On this date, the company's Cash account reflected a $716.7 overdraft. In reconciling these amounts, the following information is discovered:

1. Cash on hand for undeposited sales receipts, December 31, $151.5.

2. Customer NSF check returned with bank statement, $407.7.

3. Cash sales of $604 for the week ended December 18 were recorded on the books. The cashier reports this amount missing, and it was not deposited in the bank.

4. Note receivable of $2,900 and interest of $29 collected by the bank and not recorded on the books.

5. Deposit in transit December 31, $370.

6. A customer check for $290.4 in payment of its account was recorded on the books at $940.2.

7. Outstanding checks, $2,011.45. Includes a duplicate check of $78.5 to C. Brown, who notified Miller that the original was lost. Miller stopped payment on the original check and has already adjusted the cash account in the accounting records for this amount.

Question

1. Prepare a December 31 bank reconciliation for Miller. When required, enter amounts to the nearest cent.

Bank Reconciliation

December 31, 2013

Balance from bank statement		$..........
Add: Deposit in transit	$..........
Add: Cash on hand (Undeposited)	$..........	$..........
		$..........
Deduct: Outstanding checks		$..........
Adjusted cash balance		$..........
Balance from company records		$..........
Add: Note collected by Bank	$..........
Add: Internet on Note	$..........	$..........
		$..........
Deduct: Missing Deposit	$..........
Deduct: Error in Recording	$..........
Deduct: NSF checkreturned	$..........	$..........
Adjusted cash balance		$..........

hint:

You should complete the following steps in a bank reconciliation:

Step 1: Compare the deposits listed in the company's records with the deposits shown on the bank statement

Step 2: Compare the checks listed in the company's records with the checks shown on the bank statement.

Step 3: Identify any deposits or charges made directly by the bank that are not included in the company's records.

Step 4: Determine the effect of any errors

Step 5: Complete the bank reconciliation.

2. Prepare any journal entries necessary by Miller to record the information from Requirement 1.

For a compound transaction, if required, round your answers to two decimal places.

Dec. 31	Accounts Receivable (error)		$..........
	Accounts Recevable (NSF check)		$..........
	Loss from Cash Shortage (missing deposit)		$..........
	Cash	$..........
Dec. 31	Cash		$..........
	Notes Receivable	$..........
	Interest Revenue	$..........

Hint:

You should refer to the bank reconciliation completed in requirement (1) of this problem. The company only makes journal entries for the adjustments it made to its records on the bank reconciliation. It does not make journal entries for the adjustments it made to the bank statement balance on the reconciliation; the bank will record these adjustments in its accounts at the appropriate time.