$2$ A company provides the following information related to its ending cash balance.

$3$

$4$

$1$ Cash on hand at the company and not yet

deposited at the bank

$2$ EFT for monthly utility bill not yet recorded

by the company

$3$ Note collected by the bank and not yet

recorded by the company

$4$ Interest collected by the bank from note in

number $3$ not yet recorded by the company

$5$ Debit card used to purchase supplies not yet

recorded by the company

$6$ Checks written by the company but not yet

processed by the bank

$7$ Service fee charged by bank but not yet

recorded by the company

$12$

hemer checks determined by the bank to

have nonsufficient funds

Required:

Complete the following bank reconciliation.

$($Use cells A$2$ to B$14$ from the given information above to complete this question. Amounts to be deducted should be indicated with a minus sign.$)$

$22$ Deposits outstanding

$23$ Checks outstanding

Per general ledger

EFT for utilities

Note collected

Interest earned

Supplies purchased

Service fee

NSF checks

Company balance per reconciliation