Understanding the Consolidated Income Statement Case Study

This case study walks you through the steps to set up and generate a consolidated income statement using the One View Financial Statements (OVFS) feature. It is intended to help you gain a deeper understanding of how to use the functionality to generate the financial statement outcomes that you desire. You should be familiar with the One View Financial Statements feature before beginning this case study.

A consolidated statement includes the account balances for a range of companies or business units. For example, you might need a consolidated income statement to show the revenue and expenses for all business units in a company.

When you set up the consolidated income statement, you will set up row definitions to obtain account balances and descriptions for your revenue and expense accounts. You will also set up a subtotal row definition that you will use to provide interim totals within your income statement for categories such as the gross margin and operating expenses. Each of the row definitions will be a section in the report, such as revenue, direct costs, gross margin, and so on.

You will set up column definitions to show current and prior period account balances, and year-to-date and prior year-to-date account balances. You will also set up columns in the BI Publisher Layout Editor (Layout Editor) to show calculated amounts, such as the percent of revenue and the change in the amounts from the last year to the current year.

After you create the column and row definitions, and create the statement definition, you will create a statement version and layout. You will then run the statement to confirm that the results are what you expected.

The following images show the Consolidated Income Statement that you will create in this case study. Your results might be slightly different, depending on the data in the system that you use and on the placement and formatting of components: