Wilder Videos checkbook lists the following:

Date	Check No.	Item	Check	Deposit	Balance
November 1					$561
3	650	Quick Mailing	$8		553
5		Service Revenue		$129	682
11	651	Photo Supplies	33		649
14	652	Utilities	76		573
16	653	Cash	56		517
26	654	Office Supplies	85		432
28	655	Upstate Realty Co	272		160
30		Service Revenue		$1217	$1377

 

Wilder Videos November bank statement shows the following:

Balance			$561
Deposits			129
Checks:	No.	Amount
	650	$8
	651	33
	652	122 *
	653	56	-219
Other charges:
Printed checks		26
Service charge		10	-36
Balance			$435

 

* This is the correct amount for Check #652

Prepare Wilder Videos bank reconciliation at November 30, 2020.

Bank

Description	Amount
Balance (ending)Ck #650Ck #651Ck #652Ck #653Ck #654Ck #655Deposits in transitError Ck #650Error Ck #651Error Ck #652Error Ck #653Error Ck #654Error Ck #655New ChecksOutstanding checksService Charge
Subcategory,ADD:
Balance (ending)Ck #650Ck #651Ck #652Ck #653Ck #654Ck #655Deposits in transitError Ck #650Error Ck #651Error Ck #652Error Ck #653Error Ck #654Error Ck #655New ChecksOutstanding checksService Charge	Single line
	Single line
Subcategory,LESS:
Subcategory,Outstanding checks
Balance (ending)Ck #650Ck #651Ck #652Ck #653Ck #654Ck #655Deposits in transitError Ck #650Error Ck #651Error Ck #652Error Ck #653Error Ck #654Error Ck #655New ChecksOutstanding checksService Charge
Balance (ending)Ck #650Ck #651Ck #652Ck #653Ck #654Ck #655Deposits in transitError Ck #650Error Ck #651Error Ck #652Error Ck #653Error Ck #654Error Ck #655New ChecksOutstanding checksService Charge	Single line
Adjusted Balance	Single lineDouble line

CHECKBOOK (COMPANY)

Description	Amount
Balance (ending)Ck #650Ck #651Ck #652Ck #653Ck #654Ck #655Deposits in transitError Ck #650Error Ck #651Error Ck #652Error Ck #653Error Ck #654Error Ck #655New ChecksOutstanding checksService Charge	Single line
Subcategory,ADD:
	Single line
Subcategory,Less:
Balance (ending)Ck #650Ck #651Ck #652Ck #653Ck #654Ck #655Deposits in transitError Ck #650Error Ck #651Error Ck #652Error Ck #653Error Ck #654Error Ck #655New ChecksOutstanding checksService Charge
Balance (ending)Ck #650Ck #651Ck #652Ck #653Ck #654Ck #655Deposits in transitError Ck #650Error Ck #651Error Ck #652Error Ck #653Error Ck #654Error Ck #655New ChecksOutstanding checksService Charge
Balance (ending)Ck #650Ck #651Ck #652Ck #653Ck #654Ck #655Deposits in transitError Ck #650Error Ck #651Error Ck #652Error Ck #653Error Ck #654Error Ck #655New 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