Wilder Videos checkbook lists the following:

Date	Check No.	Item	Check	Deposit	Balance
November 1					$571
2	637	Quick Mailing	$17		554
5		Service Revenue		$139	693
11	638	Photo Supplies	31		662
15	639	Utilities	78		584
20	640	Cash	64		520
26	641	Office Supplies	85		435
27	642	Upstate Realty Co	273		162
30		Service Revenue		$1216	$1378

 

Wilder Videos November bank statement shows the following:

Balance			$571
Deposits			139
Checks:	No.	Amount
	637	$17
	638	31
	639	122 *
	640	64	-234
Other charges:
Printed checks		25
Service charge		8	-33
Balance			$443

 

* This is the correct amount for Check #639

Prepare Wilder Videos bank reconciliation at November 30, 2020.

Bank

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

CHECKBOOK (COMPANY)

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