Using a Pivot Table Report to Summarize Balances Used in Financial Statements Reports

The PivotTable report created in this section will form a fixed structure of Fields while summarizing the account balances of the Trial Balance by levels.

Chapter 13

This PivotTable report summarizes the figures from worksheet 21 — Trial Balances Data to use in the Financial Statements report worksheets cells, and removes the need to use complicated formulas when creating Financial Statements reports.

Microsoft Excel - Financial Statements

File Edit View Insert Format Tools Data Window Help

Microsoft Excel - Financial Statements

File Edit View Insert Format Tools Data Window Help

'A

B

©

M .

E,

F

: E

1

Data Sr.

2

BS. PSÜtÄVii

B3 FüL Leve)2 2 -

BS, P&L Level 3 2

Jan 2002

Feb 2002

Mar 2002

Apr 2002

3

Assets

Cürrent^ssets

Accounts Receivable

■£¡33

650

8g

884

4

iStii

1372

14EH

1428

5

Inventories

1029

1050

lœl

1092

6

Prepaid Expenses*.

- 588

«1

m

■624

7

Fi^-é'd^ss'éty

FurnitiJtç-afid Fixtures

950

1000

1020

1040|

S

Lend & Buildif>i£

1715

1750

178.5

4820

9

' : s-i - nH

1029

1050

mt

1D92

10

Lt'^'i: Al:.uirijldt^iJ Dep^e:iatipn!

4B'06

■4700

4Î94

4888

a

MTiG'ti'croi'v and Equipment.

pp

950

969

988

IM;

Invest triéRtÂ.âM ftihet

Investment in Revenue'; tfofld

Pp

714

pl

13

Patents; Trademarks and Goodwill

637

650

8E3

«78

14

Resets Total

144G6

■Í47S0

.14954

■1.5ËS8

ig

Accounts P^able-

1274

13SS

■H

ie

Accrued expenses - payroll

15435

15750

160B5

16380

17-

Current portion^Jonçi-teinT. debt

2058

Én

2142

■2184

w

l^-:- .V" .":■■■:.

1Ç®

9750

pli

jnnH

19

Other accrued liabilities

2009

2050

209!

2132

îo-

Oth er^eùité'FLt J/a brl it i e S:

532.8

BJOD

.5222

6344

p!

M jk-t.F 1 rf.vl l.îh

Deferred tax liabilities

iggs

'2ÍS0

.ÖSE

■.2346

22

Loans-trsm-finaricial institutions

2156

'5306

.2244

'.'2288

2$

Pensien fund tosns

¿254

É¡n

$346

Mt]

4i:j;itn-|i!" n v nir^/

MB.

2337

2444

25'

Paid iftCipital

2352

■.2400

2448

■249E

-Sg';

Retained earnings :

-2450

2439

■■2548

M

Equity t ■■■ ' i.-."."*'

44100

45000

;45900

46800

Figure 13-5: Summary by Account Level Using a PivotTable Report

After creating the PivotTable report, as described in Creating a PivotTable Report, page 229, you should remove all unused Fields from the PivotTable report so that the table structure and Field position in the worksheet do not change when the PivotTable report is refreshed, particularly as a result of adding new Fields to the original source data.

0 0

Post a comment