## 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 1ï 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.