Wilder Videos checkbook lists the following:

Date	Check No.	Item	Check	Deposit	Balance
April 1					$620
3	643	Quick Mailing	$19		601
5		Service Revenue		$127	728
12	644	Photo Supplies	34		694
14	645	Utilities	77		617
20	646	Cash	64		553
21	647	Office Supplies	90		463
29	648	Upstate Realty Co	273		190
30		Service Revenue		$1240	$1430

 

Wilder Videos April bank statement shows the following:

Balance			$620
Deposits			127
Checks:	No.	Amount
	643	$19
	644	34
	645	110 *
	646	64	-227
Other charges:
Printed checks		26
Service charge		6	-32
Balance			$488

 

* This is the correct amount for Check #645

Prepare Wilder Videos bank reconciliation at April 30, 2020.

Bank

Description	Amount
Balance (ending)Ck #643Ck #644Ck #645Ck #646Ck #647Ck #648Deposits in transitError Ck #643Error Ck #644Error Ck #645Error Ck #646Error Ck #647Error Ck #648New ChecksOutstanding checksService Charge
Subcategory,ADD:
Balance (ending)Ck #643Ck #644Ck #645Ck #646Ck #647Ck #648Deposits in transitError Ck #643Error Ck #644Error Ck #645Error Ck #646Error Ck #647Error Ck #648New ChecksOutstanding checksService Charge	Single line
	Single line
Subcategory,LESS:
Subcategory,Outstanding checks
Balance (ending)Ck #643Ck #644Ck #645Ck #646Ck #647Ck #648Deposits in transitError Ck #643Error Ck #644Error Ck #645Error Ck #646Error Ck #647Error Ck #648New ChecksOutstanding checksService Charge
Balance (ending)Ck #643Ck #644Ck #645Ck #646Ck #647Ck #648Deposits in transitError Ck #643Error Ck #644Error Ck #645Error Ck #646Error Ck #647Error Ck #648New ChecksOutstanding checksService Charge	Single line
Adjusted Balance	Single lineDouble line

CHECKBOOK (COMPANY)

Description	Amount
Balance (ending)Ck #643Ck #644Ck #645Ck #646Ck #647Ck #648Deposits in transitError Ck #643Error Ck #644Error Ck #645Error Ck #646Error Ck #647Error Ck #648New ChecksOutstanding checksService Charge	Single line
Subcategory,ADD:
	Single line
Subcategory,Less:
Balance (ending)Ck #643Ck #644Ck #645Ck #646Ck #647Ck #648Deposits in transitError Ck #643Error Ck #644Error Ck #645Error Ck #646Error Ck #647Error Ck #648New ChecksOutstanding checksService Charge
Balance (ending)Ck #643Ck #644Ck #645Ck #646Ck #647Ck #648Deposits in transitError Ck #643Error Ck #644Error Ck #645Error Ck #646Error Ck #647Error Ck #648New ChecksOutstanding checksService Charge
Balance (ending)Ck #643Ck #644Ck #645Ck #646Ck #647Ck #648Deposits in transitError Ck #643Error Ck #644Error Ck #645Error Ck #646Error Ck #647Error Ck #648New ChecksOutstanding checksService Charge	Single line
Adjusted Balance	Single lineDouble line

Journalize any transactions required from the bank reconciliation.

Journal

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