Wilder Videos checkbook lists the following:

Date	Check No.	Item	Check	Deposit	Balance
June 1					$618
2	648	Quick Mailing	$11		607
9		Service Revenue		$137	744
12	649	Photo Supplies	31		713
14	650	Utilities	80		633
19	651	Cash	59		574
25	652	Office Supplies	86		488
28	653	Upstate Realty Co	270		218
30		Service Revenue		$1206	$1424

 

Wilder Videos June bank statement shows the following:

Balance			$618
Deposits			137
Checks:	No.	Amount
	648	$11
	649	31
	650	116 *
	651	59	-217
Other charges:
Printed checks		27
Service charge		7	-34
Balance			$504

 

* This is the correct amount for Check #650

Prepare Wilder Videos bank reconciliation at June 30, 2020.

Bank

Description	Amount
Balance (ending)Ck #648Ck #649Ck #650Ck #651Ck #652Ck #653Deposits in transitError Ck #648Error Ck #649Error Ck #650Error Ck #651Error Ck #652Error Ck #653New ChecksOutstanding checksService Charge
Subcategory,ADD:
Balance (ending)Ck #648Ck #649Ck #650Ck #651Ck #652Ck #653Deposits in transitError Ck #648Error Ck #649Error Ck #650Error Ck #651Error Ck #652Error Ck #653New ChecksOutstanding checksService Charge	Single line
	Single line
Subcategory,LESS:
Subcategory,Outstanding checks
Balance (ending)Ck #648Ck #649Ck #650Ck #651Ck #652Ck #653Deposits in transitError Ck #648Error Ck #649Error Ck #650Error Ck #651Error Ck #652Error Ck #653New ChecksOutstanding checksService Charge
Balance (ending)Ck #648Ck #649Ck #650Ck #651Ck #652Ck #653Deposits in transitError Ck #648Error Ck #649Error Ck #650Error Ck #651Error Ck #652Error Ck #653New ChecksOutstanding checksService Charge	Single line
Adjusted Balance	Single lineDouble line

CHECKBOOK (COMPANY)

Description	Amount
Balance (ending)Ck #648Ck #649Ck #650Ck #651Ck #652Ck #653Deposits in transitError Ck #648Error Ck #649Error Ck #650Error Ck #651Error Ck #652Error Ck #653New ChecksOutstanding checksService Charge	Single line
Subcategory,ADD:
	Single line
Subcategory,Less:
Balance (ending)Ck #648Ck #649Ck #650Ck #651Ck #652Ck #653Deposits in transitError Ck #648Error Ck #649Error Ck #650Error Ck #651Error Ck #652Error Ck #653New ChecksOutstanding checksService Charge
Balance (ending)Ck #648Ck #649Ck #650Ck #651Ck #652Ck #653Deposits in transitError Ck #648Error Ck #649Error Ck #650Error Ck #651Error Ck #652Error Ck #653New ChecksOutstanding checksService Charge
Balance (ending)Ck #648Ck #649Ck #650Ck #651Ck #652Ck #653Deposits in transitError Ck #648Error Ck #649Error Ck #650Error Ck #651Error Ck #652Error Ck #653New ChecksOutstanding checksService Charge	Single line
Adjusted Balance	Single lineDouble line

Journalize any transactions required from the bank reconciliation.

Journal

Date	Description	Debit	Credit
June 30	Bank Fees ExpenseCashUtilities Expense
June 30	Bank Fees ExpenseCashUtilities Expense
June 30	Bank Fees ExpenseCashUtilities Expense