FAQ: How Do I Make a Consolidated Income Statement with Multiple Cost Centers?
This article directs users to the steps to create a custom Income Statement including an individual Income Statement per Cost Center or a consolidated Income Statement with all Cost Centers.
To create a Consolidated Income Statement from a specific cost center or multiple cost centers, customize an Income Statement by following the steps below:
Income Statement Detail – Combined / Specific Cost Center
1. Configuration
- Navigate to Accounting > Reports > Open the report you wish you modify (such as Income Statement Detail)
- Select Config > Copy to Management
- Remove “- Copy” from the Name field
2. Name
- Rename to reflect the specific Cost Center(s) or Fund(s)
2. Grid Designer: Type 1
- Values Template:
"<br><span style='font-weight:bold;'></span>" - Total Template:
"<br><span style='font-weight:bold;'></span>" - Expand Type 1 (auto-collapses after changes)
- Click Apply and Save
3. Columns Configuration
For the following columns:
- Current Month
- Variance
- YTD Actual
- YTD Variance
- Cost Center: The specific Cost Center(s) the Report represents
- Fund: All, or the specific Fund, for Fund reports
- Uncheck: Show Total for Report
- Click Save
For the following:
- Budget Monthly
- YTD Budget
- Yearly Budget
- Uncheck: Show Total for Report
- Click Save
- Cost Center:
- Uncheck Show Total for Report
- Click Save
4. Blank Columns
- Go to Options > Delete
- Click Apply and Save
5. Formatting
- Widen the Account Name column as needed
- Apply further column formatting as desired
6. Template
- Associations: Select all using this report. Must exactly match the selected Cost Center or Fund name.
- Header Tab: Update middle column with Fund or Cost Center name or use the Name parameter
- Body Tab:
- Add margin:
style="margin:0 20px;width:95%" - Optional:
text-transform:uppercase(for all caps) - Click Save
7. More Options
- Cost Center: Select All
- Fund: Select All
- Options > Save
- Hide Standard Report