Wilder Videos checkbook lists the following:

Date	Check No.	Item	Check	Deposit	Balance
September 1					$525
3	610	Quick Mailing	$12		513
9		Service Revenue		$123	636
10	611	Photo Supplies	33		603
15	612	Utilities	79		524
17	613	Cash	65		459
22	614	Office Supplies	88		371
29	615	Upstate Realty Co	269		102
30		Service Revenue		$1218	$1320

 

Wilder Videos September bank statement shows the following:

Balance			$525
Deposits			123
Checks:	No.	Amount
	610	$12
	611	33
	612	105 *
	613	65	-215
Other charges:
Printed checks		34
Service charge		9	-43
Balance			$390

 

* This is the correct amount for Check #612

Prepare Wilder Videos bank reconciliation at September 30, 2020.

Bank

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

CHECKBOOK (COMPANY)

Description	Amount
Balance (ending)Ck #610Ck #611Ck #612Ck #613Ck #614Ck #615Deposits in transitError Ck #610Error Ck #611Error Ck #612Error Ck #613Error Ck #614Error Ck #615New ChecksOutstanding checksService Charge	Single line
Subcategory,ADD:
	Single line
Subcategory,Less:
Balance (ending)Ck #610Ck #611Ck #612Ck #613Ck #614Ck #615Deposits in transitError Ck #610Error Ck #611Error Ck #612Error Ck #613Error Ck #614Error Ck #615New ChecksOutstanding checksService Charge
Balance (ending)Ck #610Ck #611Ck #612Ck #613Ck #614Ck #615Deposits in transitError Ck #610Error Ck #611Error Ck #612Error Ck #613Error Ck #614Error Ck #615New ChecksOutstanding checksService Charge
Balance (ending)Ck #610Ck #611Ck #612Ck #613Ck #614Ck #615Deposits in transitError Ck #610Error Ck #611Error Ck #612Error Ck #613Error Ck #614Error Ck #615New ChecksOutstanding checksService Charge	Single line
Adjusted Balance	Single lineDouble line

Journalize any transactions required from the bank reconciliation.

Journal

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