Specifications

Computer Tutorial 3 Lesson 6  9
Missing from this specification file is a title row. This would appear as “/T”. Anything on a
title row would appear on each page of the report.
Column B
If Column A is being used as a body specification row and specifies a range of accounts, then
this column controls which account types or account groups should be included (or excluded)
for the specified range of accounts.
Row 16 contains ACCTGRPID = "Current assets" in column B. This is to limit the account
number reference in column A. Row 16, Column A and B together mean “use all accounts in
the general ledger whose account group equals current assets.”
Column C
This column removes (or excludes) detail lines from being printed on the report.
Row 14 contains an “Z” which excludes zero balance accounts from being printed.
Column D
This column summarizes balances for a series of accounts, either consolidated or in detail.
Row 14 contains “D(ACCT)”, which consolidates account data by the natural account
number segment. Sample Company Ltd. accounts have been set up with the first four digit
segment being the natural account number segment.
Row 21 contains a “T” which consolidates account details into a single total. In this case, all
the accumulated amortization accounts are reported as one amount.
Column E
Columns E and beyond are used for generating the statement. Any value or formula placed in
one of these columns will appear in the report. Items that are usually put in these columns
include: title of the report, account descriptions, column headings, account balances,
subtotals, and totals.
Row 6 contains a formula that generates the company name from the general ledger.
Row 7 has “Balance Sheet.” This will appear as is on the statement.
Row 8 contains a formula that generates the year and period from the general ledger.
Column F
Row 14 has a formula that generates the account name from the general ledger.
Row 16 has a “\” which repeats information above it. In this case, it repeats the formula that
generates the account number from the general ledger.
Row 17 contains “Total current assets.” This will appear as is on the report.
Column G
Row 10 contains “Unaudited.” This will appear as is on the report.