Wilder Videos checkbook lists the following:

Date	Check No.	Item	Check	Deposit	Balance
November 1					$526
4	611	Quick Mailing	$12		514
5		Service Revenue		$123	637
10	612	Photo Supplies	37		600
14	613	Utilities	75		525
18	614	Cash	56		469
25	615	Office Supplies	88		381
29	616	Upstate Realty Co	270		111
30		Service Revenue		$1237	$1348

 

Wilder Videos November bank statement shows the following:

Balance			$526
Deposits			123
Checks:	No.	Amount
	611	$12
	612	37
	613	115 *
	614	56	-220
Other charges:
Printed checks		25
Service charge		10	-35
Balance			$394

 

* This is the correct amount for Check #613

Prepare Wilder Videos bank reconciliation at November 30, 2020.

Bank

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

CHECKBOOK (COMPANY)

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

Journalize any transactions required from the bank reconciliation.

Journal

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