Consolidated Income Statement Case Study: Set Up Row Definitions
Tutorial (Release 9.2 Update): Click here to view a recording of this feature.
To create the row definitions for the consolidated income statement, you set up row definitions that the system will use in conjunction with column definitions and data selection to retrieve account balances.
According to the plan that you developed, you need to create row definitions to retrieve account balances for your revenue and expense accounts. You also want to:
Provide subtotals for specific sections in the statement.
Include account descriptions on the statement output.
To achieve those results, you use the information in the following table to set up your row definitions:
Row Definition Name and Description |
Row Definition Type |
Grouping Element |
Additional Attributes |
Data Selection |
|---|---|---|---|---|
Name: (initials) CONSREV Description: Consolidated Revenue |
Data Select the Row Definition Grouping check box |
Object (OBJ) |
Select these check boxes:
|
Object Accounts between 5000 and 5999 |
Name: (initials) CONSDIRCST Description: Consolidated Direct Cost |
Data Select the Row Definition Grouping check box |
Object (OBJ) |
Select these check boxes:
|
Object Accounts between 6000 and 7999 |
Name: (initials) CONSGENADMEXP Description: Consolidated General and Admin Expenses |
Data Select the Row Definition Grouping check box |
Object (OBJ) |
Select these check boxes:
|
Object Accounts between 8000 and 8999 |
Name: (initials) CONSOTHRINCEXP Description: Consolidated Other Income and Expense |
Data Select the Row Definition Grouping check box |
Object (OBJ) |
Select these check boxes:
|
Object Accounts between 9000 and 9250 |
Name: (initials) CONSINCTAX Description: Consolidated Income Tax |
Data Select the Row Definition Grouping check box |
Object (OBJ) |
Select these check boxes:
|
Object Accounts between 9700 and 9750 |
Name: (initials) SUBTOTAL Description: Subtotal Section Enter Subtotal Section in the Row Definition Title field. You will use the same subtotal row definition for all instances of subtotal sections,. except for the Total Revenue section. |
Subtotal Section |
N/A |
N/A |
N/A |
Name: (initials) SUBTOTALSIGNREV Description: Subtotal Section Sign Reversed Enter Subtotal Section Sign Reversed in the Row Definition Title field. You will use the this subtotal row definition for instances of subtotal sections where the sign needs to be reverse like Total Revenue |
Subtotal Section |
N/A |
Select the Reverse Sign check box. |
N/A |