Wilder Videos checkbook lists the following:

Date	Check No.	Item	Check	Deposit	Balance
November 1					$596
4	634	Quick Mailing	$18		578
9		Service Revenue		$131	709
12	635	Photo Supplies	36		673
15	636	Utilities	80		593
16	637	Cash	59		534
26	638	Office Supplies	84		450
29	639	Upstate Realty Co	269		181
30		Service Revenue		$1225	$1406

 

Wilder Videos November bank statement shows the following:

Balance			$596
Deposits			131
Checks:	No.	Amount
	634	$18
	635	36
	636	123 *
	637	59	-236
Other charges:
Printed checks		34
Service charge		7	-41
Balance			$450

 

* This is the correct amount for Check #636

Prepare Wilder Videos bank reconciliation at November 30, 2020.

Bank

Description	Amount
Balance (ending)Ck #634Ck #635Ck #636Ck #637Ck #638Ck #639Deposits in transitError Ck #634Error Ck #635Error Ck #636Error Ck #637Error Ck #638Error Ck #639New ChecksOutstanding checksService Charge
Subcategory,ADD:
Balance (ending)Ck #634Ck #635Ck #636Ck #637Ck #638Ck #639Deposits in transitError Ck #634Error Ck #635Error Ck #636Error Ck #637Error Ck #638Error Ck #639New ChecksOutstanding checksService Charge	Single line
	Single line
Subcategory,LESS:
Subcategory,Outstanding checks
Balance (ending)Ck #634Ck #635Ck #636Ck #637Ck #638Ck #639Deposits in transitError Ck #634Error Ck #635Error Ck #636Error Ck #637Error Ck #638Error Ck #639New ChecksOutstanding checksService Charge
Balance (ending)Ck #634Ck #635Ck #636Ck #637Ck #638Ck #639Deposits in transitError Ck #634Error Ck #635Error Ck #636Error Ck #637Error Ck #638Error Ck #639New ChecksOutstanding checksService Charge	Single line
Adjusted Balance	Single lineDouble line

CHECKBOOK (COMPANY)

Description	Amount
Balance (ending)Ck #634Ck #635Ck #636Ck #637Ck #638Ck #639Deposits in transitError Ck #634Error Ck #635Error Ck #636Error Ck #637Error Ck #638Error Ck #639New ChecksOutstanding checksService Charge	Single line
Subcategory,ADD:
	Single line
Subcategory,Less:
Balance (ending)Ck #634Ck #635Ck #636Ck #637Ck #638Ck #639Deposits in transitError Ck #634Error Ck #635Error Ck #636Error Ck #637Error Ck #638Error Ck #639New ChecksOutstanding checksService Charge
Balance (ending)Ck #634Ck #635Ck #636Ck #637Ck #638Ck #639Deposits in transitError Ck #634Error Ck #635Error Ck #636Error Ck #637Error Ck #638Error Ck #639New ChecksOutstanding checksService Charge
Balance (ending)Ck #634Ck #635Ck #636Ck #637Ck #638Ck #639Deposits in transitError Ck #634Error Ck #635Error Ck #636Error Ck #637Error Ck #638Error Ck #639New 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