> For the complete documentation index, see [llms.txt](https://docs.rillet.com/EjmEP4KZ9BVp9j2ho4Mh/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.rillet.com/EjmEP4KZ9BVp9j2ho4Mh/reporting/financial-statements/customize-the-income-statement.md).
# Customize the Income Statement
The Income Statement report in **Rillet** lets you customize how financial data is displayed, so you can build reporting views that match your business needs. Configure the report layout, filter data, and add custom rows, columns, or entire sections directly inside the report to support departmental P\&Ls, custom margin analysis, operational KPIs, and executive reporting. Customized reports can be saved for reuse and downloaded to Excel with formulas retained.
### Understand Common Use Cases
Custom sections, rows, and formulas let finance teams tailor the Income Statement for operational, management, and executive reporting.
| Use Case | Description |
| --------------------------------- | ---------------------------------------------------------------------------------------------------------------- |
| Departmental P\&Ls | Break down financial performance by department or business unit. |
| EBITDA and Margin Analysis | Create custom profitability and operational margin calculations. |
| Operational KPIs | Track metrics such as OpEx per employee, headcount-based analysis, or internal efficiency metrics. |
| Product or Service Line Reporting | Build custom profitability views for specific products, services, or operational segments. |
| Executive Reporting | Create simplified management views with grouped accounts, custom calculations, and summarized financial metrics. |
### Open the Income Statement
Follow these steps to open the report:
1. Go to **Reporting**.
2. Select **Income Statement** under **Financial Statements**.
The report opens using the default reporting layout, which you can customize based on your reporting and analysis needs.
### Build a Report from Scratch
Take these steps to start a new report with no sections at all, then build it up using only the sections and accounts you choose:
1. Go to **Reporting**.
2. Click **New Custom Report** in the top-right corner.
3. Select **Income Statement** from the menu.
4. Select **Build from scratch**.
Add sections one at a time using the steps in [**Add a Custom Section**](#add-a-custom-section) below.
### Configure the Report Layout
Before customizing the report structure, configure the layout and reporting view using the controls at the top of the page.
| Control | What It Does |
| -------------------- | -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| Period | Choose a predefined date range, a custom range, or year-to-date and partial-period results. |
| Subsidiary | In multi-entity organizations, view all subsidiaries, a single subsidiary, or select several to compare side by side. |
| Columns | Set the report breakdown to **Monthly**, **Quarterly**, **Yearly**, or **Total**. Also break the report down by dimensions such as **Department**, and depending on your setup, **Stage**, **Location**, or **Subsidiaries**. Selecting **Total** enables a **Variance Analysis** toggle to compare the period against **Previous Year**, **Preceding Period**, or **Budget**, shown in dollars, as a percentage, or both. |
| Custom field filters | Narrow the report to specific dimensions, such as **Department**, and depending on your setup, **Stage** or **Location**. |
{% hint style="warning" %} **Warning:**
Automated entries scheduled for the last day of the month are not included when using date ranges that end before month close.
{% endhint %}
### Enter Customize Mode
Complete these steps to create a group:
1. Click **Customize** in the top-right corner to enter edit mode.
2. Hover over a section header and click the **+** icon.
3. Select **Add subgroup**.
4. Enter the group name.
5. Drag and drop accounts into the group, or select **Add account(s)** to add existing accounts directly.
You can also create subgroups within existing groups, which is useful for simplifying management reports or grouping accounts by operational function.
### Add a Custom Section
While in Customize mode, use these steps to add a new, free-form section to the report:
1. Click **Add section** below any existing section.
2. Select **Custom Section** from the list.
3. Enter a name for the section.
4. Click the **+** icon next to the new section name.
5. Select **Add account(s)**.
6. Search for and select the accounts to include in the section.
Any account can be added to more than one section, and Rillet automatically assumes the correct debit and credit normal balance when a section mixes accounts from different standard categories. Add a formula row on top of a custom section's accounts for further calculations, following the steps in [**Add Custom Rows**](#add-custom-rows) below.
### Add Custom Rows
Take these steps to add a row:
1. Click the **+** icon next to any section.
2. Select **Add data row**, **Add formula row**, or **Add text row**.
3. Enter the row name.
4. Enter the values or label directly into the report cells for a data or text row, or type the formula (for example, **Total Revenue - Total Cost of Goods Sold**) and click the **checkmark** icon to save it for a formula row.
Each row type serves a different purpose and supports its own display formats:
| Row Type | Use For | Display Formats |
| ----------- | --------------------------------------------------------------------------------------------------------------------------------------------------------------- | ------------------------------------------ |
| Data row | Manually entered custom numeric values, such as department headcount, operational targets, or internal KPI tracking, that are not stored in the general ledger. | Number, Currency, Percentage, Basis points |
| Formula row | Calculated metrics that reference existing report rows, custom data rows, or other calculated rows, such as Subscription Revenue minus Compensation Expense. | Number, Currency, Percentage, Basis points |
| Text row | Labels or visual separators with no numeric value, useful for organizing management reports into readable sections. | None |
### Add Custom Columns
Use these steps to add a column:
1. Click **Add column** in the top-right corner of the table.
2. Select **Add data column**, **Add formula column**, or **Add text column**.
3. Enter the column name.
4. Enter the values directly into the report for a data or text column, or define the formula and click the **checkmark** icon to save it for a formula column.
Each column type serves a different purpose and supports its own display formats:
| Column Type | Use For | Display Formats |
| -------------- | -------------------------------------------------------------------------------------------------------------------------------------------- | ------------------------------------------ |
| Data column | Manually entered custom values, such as operational or planning metrics not stored in the general ledger, across report columns. | Number, Currency, Percentage, Basis points |
| Formula column | Calculated comparisons and percentage-based analysis between columns, such as combining multiple departments into a single reporting column. | Number, Currency, Percentage, Basis points |
| Text column | Labels or visual separators with no numeric value. | None |
### Adjust the Report View
While in customize mode, continue refining how the report is displayed:
| Action | How |
| ----------------------------- | ------------------------------------------------------------------------------------------------------------ |
| Hide or show columns | Click the eye icon next to any month column, or open the column-visibility panel from the toolbar. |
| Collapse or expand all groups | Click the collapse icon in the toolbar. Click it again to expand. This also works outside of customize mode. |
| Resize columns to fit content | Click the fit to content icon in the toolbar. |
### Undo or Redo a Change
While in customize mode, click **Undo** or **Redo** in the top-right corner to step backward or forward through your recent changes, or use **Cmd+Z** on your keyboard. This lets you experiment with a report's structure without the risk of losing earlier work.
### Choose a Fixed or Relative Date Range
While in Customize mode, complete these steps to choose a fixed or relative date range:
1. Click the **Period** field.
2. Select the **Relative dates** tab for a rolling range, such as **Month to Date** or **Year to Date**.
3. Click the **Fixed dates** tab to pick exact start and end dates from the calendar instead.
A report saved under **Fixed dates** keeps those exact dates every time it is opened, instead of rolling forward with the current date.
### Save or Download the Report
After customizing the report, save the configuration for future use or download the current view.
| Action | How |
| ------------------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ |
| Save the report | Click **Save As** in the top-right corner, enter a report name, and save it. Saved reports retain filters, formatting, custom groups, rows, and formulas, making it easy to reuse recurring management or departmental reporting views. Access saved reports, or reset a report to its default layout, from the report name dropdown at the top of the page. |
| Download the report | Click **Download** to export the current view as an `.xlsx` file. The exported spreadsheet includes active filters, grouping, custom rows and columns, and formula calculations, with custom formulas retained in Excel. |
### View a Report's Audit History
Follow these steps to view a report's audit history:
1. Open a saved report from the report name dropdown at the top of the page.
2. Click the **three-dot icon** in the top-right corner.
3. Select **Audit history**.
The **Audit History** panel opens, showing the report's change history.
### See Also
To learn more about reporting and financial statements in **Rillet**, review these articles:
* [**Reporting Overview**](/EjmEP4KZ9BVp9j2ho4Mh/reporting/reporting-overview.md)
* [**Financial Statements**](/EjmEP4KZ9BVp9j2ho4Mh/reporting/financial-statements.md)
* [**Set Up the Executive P\&L**](/EjmEP4KZ9BVp9j2ho4Mh/reporting/financial-statements/set-up-the-executive-p-and-l.md)
* [**Review the Budget vs Actuals Report**](/EjmEP4KZ9BVp9j2ho4Mh/reporting/budget-vs-actuals/review-the-budget-vs-actuals-report.md)
---
# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.
## Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.
Perform an HTTP GET request on the current page URL with the `ask` query parameter, and the optional `goal` query parameter:
```
GET https://docs.rillet.com/EjmEP4KZ9BVp9j2ho4Mh/reporting/financial-statements/customize-the-income-statement.md?ask=&goal=
```
`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is optional and describes the broader end goal you are ultimately trying to accomplish on behalf of the user. GitBook uses it to tailor the answer towards what is most useful for that goal.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.
Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.