Consolidated Income Statement Case Study: Set Up the Statement Definition
Tutorial (Release 9.2 Update): Click here to view a recording of this feature.
You set up the statement definition to establish the relationship between the row definitions and column definitions and how they will be used in the final statement that you generate.
In this consolidated income statement, each row definition that you place in the statement definition is in a separate section. The system automatically numbers the lines and the sections when you exit a line on the statement definition.
Name the statement definition (initials) CONSINCMSTMT, and enter Consolidated Income Statement in the Statement Definition Description field.
Use the information in the following table to add your row and columns definitions to the statement definition:
Row Definition Type |
Rows Definition |
Columns Definition |
Line and Section Number |
Section Description |
Section Number From and Thru |
|---|---|---|---|---|---|
Data |
(initials) CONSREV |
(initials) CURPER (initials) LSTYRCURPER (initials) YTD (initials) LSTYRYTD |
1 |
Consolidated Revenue |
N/A |
Subtotal |
(initials) SUBTOTALSIGNREV |
N/A |
2 |
Total Revenue |
From: 1 Thru: 1 |
Data |
(initials) CONSDIRCST |
(initials) CURPER (initials) LSTYRCURPER (initials) YTD (initials) LSTYRYTD |
3 |
Consolidated Direct Cost |
N/A |
Subtotal |
(initials) SUBTOTAL |
N/A |
4 |
Gross Margin |
From: 1 Thru: 3 |
Data |
(initials) CONSGENADMEXP |
(initials) CURPER (initials) LSTYRCURPER (initials) YTD (initials) LSTYRYTD |
5 |
Consolidated General and Admin Expenses |
N/A |
Subtotal |
(initials) SUBTOTAL |
N/A |
6 |
Operating Income |
From: 1 Thru: 5 |
Data |
(initials) CONSOTHRINCEXP |
(initials) CURPER (initials) LSTYRCURPER (initials) YTD (initials) LSTYRYTD |
7 |
Consolidated Other Income and Expense |
N/A |
Subtotal |
(initials) SUBTOTAL |
N/A |
8 |
Net Profit Before Tax |
From: 1 Thru: 7 |
Data |
(initials) CONSINCTAX |
(initials) CURPER (initials) LSTYRCURPER (initials) YTD (initials) LSTYRYTD |
9 |
Consolidated Income Tax |
N/A |
Subtotal |
(initials) SUBTOTAL |
N/A |
10 |
Other Income and Expense |
From: 7 Thru: 9 |
Subtotal |
(initials) SUBTOTAL |
N/A |
11 |
Net Profit or Loss |
From: 1 Thru: 10 |