Question

Chavez Company most recently reconciled its bank statement and book balances of cash on August 31 and it reported two checks outstanding, No. 5888 for $1,024 and No. 5893 for $513. Check No. 5893 was still outstanding as of September 30. The following information is available for its September 30 reconciliation.

From the September 30 Bank Statement

PREVIOUS BALANCE	TOTAL CHECKS AND DEBITS	TOTAL DEPOSITS AND CREDITS	CURRENT BALANCE
20,500	9,878	11,563	22,185

CHECKS AND DEBITS					DEPOSITS AND CREDITS
Date	No.	Amount			Date	Amount
09/03	5888	1,024			09/05	1,124
09/04	5902	716			09/12	2,230
09/07	5901	1,886			09/21	4,305
09/17		685	NSF		09/25	2,322
09/20	5905	926			09/30	12	IN
09/22	5903	449			09/30	1,570	CM
09/22	5904	2,057
09/28	5907	267
09/29	5909	1,868

From Chavez Company’s Accounting Records

Cash Receipts Deposited
Date		Cash Debit
Sept.	5		1,124
	12		2,230
	21		4,305
	25		2,322
	30		1,654
			11,635

Cash Payments
Check No.		Cash Credit
5901			1,886
5902			716
5903			449
5904			2,013
5905			926
5906			984
5907			267
5908			428
5909			1,868
			9,537

Cash			Acct. No. 101
Date	Explanation	PR	Debit	Credit	Balance
Aug. 31	Balance				18,963
Sept. 30	Total receipts	R12	11,635		30,598
30	Total payments	D23		9,537	21,061

Additional Information

1. (a) Check No. 5904 is correctly drawn for $2,057 to pay for computer equipment; however, the recordkeeper misread the amount and entered it in the accounting records with a debit to Computer Equipment and a credit to Cash of $2,013.
2. (b) The NSF check shown in the statement was originally received from a customer, S. Nilson, in payment of her account. Its return has not yet been recorded by the company.
3. (c) The credit memorandum (CM) is from the collection of a $1,570 note for Chavez Company by the bank. The collection is not yet recorded.

Required:
1. Prepare the September 30 bank reconciliation for this company.

2. Prepare journal entries to adjust the book balance of cash to the reconciled balance. (If no entry is required for a transaction/event, select "No journal entry required" in the first account field.)

Answer 1

A E F 1 B C D Chavez Company Bank Reconciliation Sep-30 $ 22,185 Book balance Add: $ 1,654 $ 1,654 Collection of note $ 23,839 Interest earned 2 3 4 Bank statement balance 5 Add: 6 Deposits in transit 7 $ 21,061 $ 1,570 $ 12 $ 1,582 $ 22,643 8 685 9 Deduct: 10 Outstanding Checks 11 No: 5893 12 No: 5906 13 No: 5908 14 Adjusted bank balance $ 513 $ 984 $ 428 Deduct: NSF Check $ Error in recording ($2,057 - $2,013) $ 1925 $ 21,914 Adjusted book balance 44$ 729 $ 21,914

А B D E F 1 Chavez Company Bank Reconciliation w N 22185 21061 Book balance Add: Collection of note Interest earned 1570 1654 =+B6 =+C4+C6 12 =+E6+E7 =+F4+F7 3 11202 4 Bank statement balance 5 Add: 6 Deposits in transit 7 8 9 Deduct: 10 Outstanding Checks 11 No: 5893 12 No: 5906 13 No: 5908 14 Adjusted bank balance 513 685 984 Deduct: NSF Check Error in recording ($2,057 - $2,013) =+B11+B12+B13 =+C7-C13 | Adjusted book balance =2057-2013 =+E11+E12 428 =+F8-F12

Debit Credit No. Date 1 Sep. 30 General Journal No entry required 2 Sep. 30 $ 12 Cash Interest Revenue (To record the interest earned) $ 12 3 Sep. 30 1,570 Cash Notes Receivable (To record the collection of notes receivable) 1,570 4 Sep. 30 No entry required 5 Sep. 30 $ 685 Accounts Receivable-S. Nilson Cash (To record the NSF check) $ 685 6 Sep. 30 $ 44 Computer Equipment Cash (To correct the error) $ 44