Wilder Videos checkbook lists the following:

Date	Check No.	Item	Check	Deposit	Balance
June 1					$595
4	613	Quick Mailing	$16		579
8		Service Revenue		$136	715
12	614	Photo Supplies	34		681
15	615	Utilities	80		601
17	616	Cash	58		543
24	617	Office Supplies	81		462
28	618	Upstate Realty Co	273		189
30		Service Revenue		$1236	$1425

 

Wilder Videos June bank statement shows the following:

Balance			$595
Deposits			136
Checks:	No.	Amount
	613	$16
	614	34
	615	119 *
	616	58	-227
Other charges:
Printed checks		30
Service charge		5	-35
Balance			$469

 

* This is the correct amount for Check #615

Prepare Wilder Videos bank reconciliation at June 30, 2020.

Bank

Description	Amount
Balance (ending)Ck #613Ck #614Ck #615Ck #616Ck #617Ck #618Deposits in transitError Ck #613Error Ck #614Error Ck #615Error Ck #616Error Ck #617Error Ck #618New ChecksOutstanding checksService Charge
Subcategory,ADD:
Balance (ending)Ck #613Ck #614Ck #615Ck #616Ck #617Ck #618Deposits in transitError Ck #613Error Ck #614Error Ck #615Error Ck #616Error Ck #617Error Ck #618New ChecksOutstanding checksService Charge	Single line
	Single line
Subcategory,LESS:
Subcategory,Outstanding checks
Balance (ending)Ck #613Ck #614Ck #615Ck #616Ck #617Ck #618Deposits in transitError Ck #613Error Ck #614Error Ck #615Error Ck #616Error Ck #617Error Ck #618New ChecksOutstanding checksService Charge
Balance (ending)Ck #613Ck #614Ck #615Ck #616Ck #617Ck #618Deposits in transitError Ck #613Error Ck #614Error Ck #615Error Ck #616Error Ck #617Error Ck #618New ChecksOutstanding checksService Charge	Single line
Adjusted Balance	Single lineDouble line

CHECKBOOK (COMPANY)

Description	Amount
Balance (ending)Ck #613Ck #614Ck #615Ck #616Ck #617Ck #618Deposits in transitError Ck #613Error Ck #614Error Ck #615Error Ck #616Error Ck #617Error Ck #618New ChecksOutstanding checksService Charge	Single line
Subcategory,ADD:
	Single line
Subcategory,Less:
Balance (ending)Ck #613Ck #614Ck #615Ck #616Ck #617Ck #618Deposits in transitError Ck #613Error Ck #614Error Ck #615Error Ck #616Error Ck #617Error Ck #618New ChecksOutstanding checksService Charge
Balance (ending)Ck #613Ck #614Ck #615Ck #616Ck #617Ck #618Deposits in transitError Ck #613Error Ck #614Error Ck #615Error Ck #616Error Ck #617Error Ck #618New ChecksOutstanding checksService Charge
Balance (ending)Ck #613Ck #614Ck #615Ck #616Ck #617Ck #618Deposits in transitError Ck #613Error Ck #614Error Ck #615Error Ck #616Error Ck #617Error Ck #618New 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