Liberation Sans $12$

AA

H

Wrap led

Ten

Paste

B

I W

$$

A

Merge & Center

$5-\%952$

Condo Femal

Clipboard

Font

Alignment

Hunter

A$1$

fx

Function: SUM; Formula: Add, Subtract; Cell Referencing:

E D

F C

$1$ Function: SUM: Formula: Add, Subtract; Cell Referencing

BE$7\mathrm{.}10$ Using Excel to Prepare a Bank Reconciliation

$4$

PROBLEM

$5$ The following information relates to Southco Limited's Cash

$6$ account.

Student Work Area

Required: Provide input into cells shaded in yellow in this template, Use mathematical formulas with cell references to the Problem and work ares as

indicated

$7$

Prepare the necessary journal entries required on July $31$ for Southco

$10$

$11$

Add:

$12$

$13$

Less

$14$

Reconciled cash balance from

June's bank reconciliation

$ $18,920$

Amounts from the general ledger July cash receipts

$21,700$

July cash payments

$24,300$

Amounts from the July bank statement: Balance, July $31)$

$19,260$

Outstanding cheques

$3,6301,450$

Deposit in transit

EFT collections on account that were not yet recorded on the books

$2\mathrm{.}170$

NSF cheque

$1\mathrm{.}27050$

NSF fee

Bank service charge

$90$

$15$

$16$

$17$

Add:

$18$

$19$

Less: Bank service charge

$20$

$21$

$22$

$23$

$26$

$27$

$211$