Wilder Videos checkbook lists the following:

Date	Check No.	Item	Check	Deposit	Balance
June 1					$544
2	625	Quick Mailing	$16		528
6		Service Revenue		$136	664
12	626	Photo Supplies	38		626
14	627	Utilities	75		551
16	628	Cash	60		491
25	629	Office Supplies	81		410
27	630	Upstate Realty Co	274		136
30		Service Revenue		$1218	$1354

 

Wilder Videos June bank statement shows the following:

Balance			$544
Deposits			136
Checks:	No.	Amount
	625	$16
	626	38
	627	113 *
	628	60	-227
Other charges:
Printed checks		33
Service charge		9	-42
Balance			$411

 

* This is the correct amount for Check #627

Prepare Wilder Videos bank reconciliation at June 30, 2020.

Bank

Description	Amount
Balance (ending)Ck #625Ck #626Ck #627Ck #628Ck #629Ck #630Deposits in transitError Ck #625Error Ck #626Error Ck #627Error Ck #628Error Ck #629Error Ck #630New ChecksOutstanding checksService Charge
Subcategory,ADD:
Balance (ending)Ck #625Ck #626Ck #627Ck #628Ck #629Ck #630Deposits in transitError Ck #625Error Ck #626Error Ck #627Error Ck #628Error Ck #629Error Ck #630New ChecksOutstanding checksService Charge	Single line
	Single line
Subcategory,LESS:
Subcategory,Outstanding checks
Balance (ending)Ck #625Ck #626Ck #627Ck #628Ck #629Ck #630Deposits in transitError Ck #625Error Ck #626Error Ck #627Error Ck #628Error Ck #629Error Ck #630New ChecksOutstanding checksService Charge
Balance (ending)Ck #625Ck #626Ck #627Ck #628Ck #629Ck #630Deposits in transitError Ck #625Error Ck #626Error Ck #627Error Ck #628Error Ck #629Error Ck #630New ChecksOutstanding checksService Charge	Single line
Adjusted Balance	Single lineDouble line

CHECKBOOK (COMPANY)

Description	Amount
Balance (ending)Ck #625Ck #626Ck #627Ck #628Ck #629Ck #630Deposits in transitError Ck #625Error Ck #626Error Ck #627Error Ck #628Error Ck #629Error Ck #630New ChecksOutstanding checksService Charge	Single line
Subcategory,ADD:
	Single line
Subcategory,Less:
Balance (ending)Ck #625Ck #626Ck #627Ck #628Ck #629Ck #630Deposits in transitError Ck #625Error Ck #626Error Ck #627Error Ck #628Error Ck #629Error Ck #630New ChecksOutstanding checksService Charge
Balance (ending)Ck #625Ck #626Ck #627Ck #628Ck #629Ck #630Deposits in transitError Ck #625Error Ck #626Error Ck #627Error Ck #628Error Ck #629Error Ck #630New ChecksOutstanding checksService Charge
Balance (ending)Ck #625Ck #626Ck #627Ck #628Ck #629Ck #630Deposits in transitError Ck #625Error Ck #626Error Ck #627Error Ck #628Error Ck #629Error Ck #630New 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