Using Column D to Consolidate Account Ranges
The Financial Reporter lets you perform two operations on a group of accounts that are extremely useful:
-
Consolidate all the lines of an account range instead of printing out the details.
-
Print subtotals for groups of accounts according to changes in particular account segments.
Consolidating account ranges and summarizing by account segment code
Financial Reporter gives you the choice of generating separate lines for each account in an account range, consolidating the account reference in a single line, consolidating account data by account group, or consolidating the account data by account segment code.
You specify this choice in column D of a report specification. In addition, you can use the column D setting to override the account order processing on a line-by-line basis.
Column D can have the following values:
D (for detail) to print one line for each account number.
RD (for rollup account detail) to print all the top-level rollup details as well as accounts not in rollup groups.
T (for total) to consolidate the data.
D(ACCT)to consolidate by the account segment code (setting the account number sorting order to account segment order for this single account reference).
D(AcctGroup)to consolidate by the account group.
D(ACSEGVALn)to consolidate by account segment number n.
D(AcctSegID)to consolidate by the named account segment. For example, D(REGION).
In each case where consolidation is performed on the basis of a property of the account number, Financial Reporter processes the account number in the order required for consolidation. (For example, if consolidation is by account group, the account numbers will be processed in account group order.)
Default specification line
Note that anything that appears in column D on a default specification line will be used by all subsequent lines unless you specifically override it.
Examples of "T" and "D" consolidation settings
The following examples show the effect of "T" and "D" settings in column D of a report specification:
"D" prints out all accounts
The above specification contains a "D" in column D. The resulting report lists each of the accounts between 1100 and 1200 on separate lines.
|
|
Current Balance |
|
|
|
|
Petty cash |
274.57 |
|
Bank account |
8,437.54 |
|
Bank account, CAD dollars |
4,372.96 |
|
Total: |
13,085.07 |
In the second example, the "T" in column D indicates that all accounts in the range are consolidated.
"T" consolidates all accounts
The above specification contains a "T" in column D. The resulting report totals the balances of all the accounts between 1100 and 1200, and reports the total on a single line.
|
|
Current Balance |
|
|
|
|
Liquid assets |
13,085.07 |
Example of the D(ACCT) account order override
In this example, the "D(ACCT)" in column D indicates that all accounts in the range are to be listed in account segment order and consolidated by the account segment.
|
|
Current Balance |
|
|
|
|
Petty cash |
274.57 |
|
Bank account |
12,810.50 |
|
Total: |
13,085.07 |
Two lines are printed in the above example, because there are two account numbers with an account segment code between 1100 and 1200.
The first account segment code (1100) is for petty cash, and the second account segment code (1200) is for Bank Accounts. Two separate account numbers have an account segment code of 1200, but these two accounts (shown in the previous example) have been consolidated.
The "D(ACCT)" code summarizes by account segment code all other segments that happen to be within the ranges specified when printing the report.
For subsequent rows, the order will revert to the order that was in effect prior to this specification row.
See also