Figure 24 Two Lists After Switching Columns and Deleting the Account Number Column from the Second List Before Consolidating

Chapter 2

The final result, after consolidating the lists, is shown in Figure 2-5:

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

& I D

E

F

1

Account Number

Adjustment # Debit

Credit

I3aiance

'2

C;ice-kinq r.i::L;ijunt #1

1011

1 7,582.00

.3;000.00

4\582.00

Gfis&kinq Account Wl

1012

1 3265',®

4

PnvrtJI Civic 1: in q Account

1021

i; | 1-2,732.321

12,iS2.:32

5

Saving.?.-Ac-count #1

105:1

m

50,000.001 >7,500.00

iâsœ.oo

6

Money Market Account #1

1061

20,000.001

20,000.00

7

Short Term CD's

1071

15,000.00

15,000.00

0

Petty Cash

1091

:2ÎË2:00

'2352.00

9

Accounts Receivable

1111

275,652.00

275,652 00

10

AlloWa'rrte for doubtful accounts:

1121

;25,500.00

-25,600.00

.1ÎE

lnveritories"for ¿ale

1201

98,565 ÊI0

98,565.00

ti

Inventories Imi l-Sh

T2Î.1

45,265.001

45,265.00

13

Prepaid expenses

1301

6,582.00 6,582 00

14

Lease Deposits

150!

12,565.001 12,565.00

0 0

Post a comment