Specifications

Computer Tutorial 3 Lesson 6  3
TOPIC 6.2
Modifying a financial statement
Accpac uses MS Excel to produce its financial statements, both in creation and output.
Accpac uses an Excel spreadsheet called a specification file to produce the financial
statements. You can also specify that the output (the financial statement) be an Excel file.
Therefore, as long as you have some experience with Excel spreadsheets, it is straightforward
to modify a financial statement.
You look at specification files in the next two topics. For now, concentrate on modifying the
output, that is, the financial statement itself. In Exercise 6.2, you modify the balance sheet
you printed in Exercise 6.1.
EXERCISE 6.2
1. Repeat Exercise 6.1, but change step 4 so that you print the balance sheet as an Excel
file. Rename the file and note where you saved it (Exhibit 6-2).
EXHIBIT 6-2
Save As window
2. Start Excel and open the Excel file you just created (Exhibit 6-3). Note the file contains
many accounts that could be combined into an aggregate and still remain relevant to
users, for example, the many bank accounts and the many payroll deduction payables.