Description

The Income Statement report captures the Revenue and Expense type ledger account balances. The report can be viewed in Standard, Entity, or Comparative format, while allowing for either Consolidated or Unconsolidated balances at all levels of the entity structure. The Income Statement layout can be custom formatted to meet any reporting requirements.

• Configuration Settings
• Report View
  • Report Formats
    • Standard
    • Entity
    • Comparative
      • Example
• Balance Drill Down
  • Saving Report
  • Exports
    • Detail Export
    • Summary Export

Configuration Settings

Depending on the Type of report selected you will be presented with different options. See an image of the Income Statement and Configurations below:

1. Column Format - Standard, Entity, or Comparative. This determines whether you are viewing a single column for a Standard report, comparing multiple date periods, or seeing your Locations split out with balances in an entity view.

2. Edit Layout - Open the Report Layout Editor to control what rows show and how data is summarized. See more details here-->

3. Consolidated

   • Enabled - consolidate journal lines for the selected Location and all its children Locations.
   • Disabled - only show journal lines for the selected Location.

4. Location - Location to include journal lines from. Uses Location context from the Location Picker if not set.

5. Date - Will show journal lines data up to and including this date. Uses date context from the Date Picker if not set.

6. Column Type - Month, Quarter, or Year

   • Only available for the Comparative type report

7. Number of Comparative Columns - The number displayed will be the selected number PLUS one (e.g, if selecting 11 months, this will display 12 monthly column periods in the report)

   • Column Type selection will limit the options:

     • Month: 1 - 12
     • Quarter: 1 - 4
     • Year: 1 - 2

Report View

Income Statement reports have three types of columns:

1. Headers - Text only (e.g. Gross Profit).
2. Account balances - A list of one or more Ledger Accounts with their balance shown.
3. Summary Rows - A summed value of all the account balances above (e.g. Total Revenue).

Report Formats

Standard

The Standard column format will display a single column of account and summarized balances up to and including the date selected.

Entity

The Entity column format will display a list of balances for direct child Locations, elimination entries and the total consolidated balance.

If you have the entity structure above. The report will show these columns

1. Consolidation of North American Operating Entity - Direct child of Holding Company
2. Consolidation of European Operating Entity - Direct child of Holding Company
3. Asia - Direct child of Holding Company
4. Holding - Location selected
5. Elimination - Balance of all elimination type journal lines.
6. Consolidated - Consolidated balance of the Location the report is run for.

Comparative

Report used to compare months, quarters, years side by side in a column view. The farthest right column is Column Type to date of the selected configuration date. The number of columns is determined based on the Start Date and End Date.

Example

If you run a monthly comparative income statement with 2024-01-01 through 2024-04-30. The report will look as follows:

Note: Column balances are NOT cumulative on the Income Statement comparative report - each column's balance includes journal lines for that period only.

Balance Drill Down

Clicking into an account balance will display the Journal Lines associated with it, where the Journal Lines will change based on the Report Configurations (e.g. Entity, Consolidated or Unconsolidated, etc.)

Saving Report

The following configurations are saved when the report is saved

• Column format
• Edited Report  Layout
• Consolidation
• Location
• Date
• Column Type
• Number of Comparative Columns

Exports

The Income Statement can be exported in two ways.

Detail Export

This view will be equivalent to what's shown in the report view.

Summary Export

This view collapses all sections containing ledger accounts. The collapsed section will omit ledger accounts and direct summary rows. Only the header of that section will show with the balance normally shown in the summary