Step 1 Entering and Saving the Trial Balance in an Excel Worksheet

^ To enter and save a trial balance:

1. Select worksheet 91 — Trial Balance (Original).

2. Import the Trial Balance from the General Ledger application or type it directly into the worksheet, as shown below. When you have finished, save the Financial Statements.xls workbook.

E3 Microsoft Excel - Financial Statements

File Edit View Insert Format Tools Data Window Help

E3 Microsoft Excel - Financial Statements

File Edit View Insert Format Tools Data Window Help

A

B

D

E

1

Account Numbei

Actùirt Nome

Debit

Credit

il

1011

Checking Account #1

7,502.00

3

1012

.Checking Account #2

5,265.00

4

1021

Payroll Checking Account

5,232.32-

5

1051

Savings Account #1

50.000.00

6

1061

Money Market Account#l

20,000.00

7

1071

Short Term .CD's

15,000.00

S

1001

Petty Èash

2;352'.00

S

1111

Accounts Receivable

275,652.00

_

10

1121

Allowance for douhtfu! accounts

25,500.00

11

1201

Inventories for.sale

98,565.00

12:-

1211

Inventories for use

45,255.00

1301

Prepaid expenses

6,532.00

14

1501

Lease Deposits''

12,565.00

15

1571

Marketable Stocks

28,500.00

16

1601

Loans'.

25,000.00

17

1701

Loans to Employees'

-.32,562.00

18

1811

Land

125,252.00

13

1821

Buildings

485,352.00

20

1831

Tools .^Equipment

45,255.00

21

1841

Office Furninshings & Equip

33,651.00

22

1891

Leasehold Improvements

13,567.00

23

1021

Accumulated Depreciated Building^'

56,444.00

24

1931 ¡Accumulated Depreciated Tools/Equipment

15,652.00

25

1941

Accumulated Depreciated Office Eguipment

12,666.00

The Trial Balance list (as shown in the figure on the previous page) is structured as follows:

® The table has a single title row with a text title at the top of each column.

® There are no empty rows between groups and/or subtotals. ® There are no totals at the bottom.

This structure has a number of advantages. A Trial Balance list entered into the worksheet's cells in list form enables extensive and efficient use of the various techniques offered by Excel, such as Sorting, Filtering, Subtotaling, Consolidating, creating PivotTable reports and easily using Lookup & Reference, and SUMIF formulas.

Secrets of the Subconscious Millionaire Mind

Secrets of the Subconscious Millionaire Mind

In This Book, you will learn all about the fundamentals of true financial empowerment! Gone are the days of thinking like a poor person's mindset. It is time to change that way of thinking so that you will truly attract wealth in your hands.

Get My Free Ebook


Responses

Post a comment