Step 4 Auditing the Totals

Cells F11 and G11 in worksheet 61 — Notes contain formulas that are identical to those entered in the cells of worksheet 31 — Balance Sheet (as described on page 79, Chapter 4, Balance Sheet).

The formulas return the Cash Account Type total balance from worksheet 21 — Trial Balances Data. Cell F20 displays the difference between the totals for Cash in cells B20 and F11; cell G20 displays it for C20 and G11, as shown below.

[g^ Eite Edit ^Eew KrEe^' format Tools Data vjgviSis' Help

[g^ Eite Edit ^Eew KrEe^' format Tools Data vjgviSis' Help

A

s 1

a

S 1

>

0

Éh 1 3

j December 31, 2003

11

4

«

Notes to Finanacial Statemants

6

.7

3

December 31

December 31

.9

2003

2002

2003

2002

10

11

Mote 5 - Cash

ça-ih

301 124

313,597

ml

Checking Account #1

50,446

51-,606

14

Checking Account #2

22535

25,658

15

Payroll Checking Account

«pH

16

Savings Account #1

160,000

50,000

17

Money Market Account #1

5Q"®B

Eawffi

JS:

Petty Cash

wm

MS,

ta

20'

Total Cash

301;1IS|

3MH

Di#

a

3

Figure 7-2: Auditing the Notes Figures

Figure 7-2: Auditing the Notes Figures

Chapter 8

0 0

Post a comment