By default, financial statements in Accountability follow your agency's account structure.  If you need a format that's different from the default structure, e.g. Management Summary version, you can create a custom financial statement format  within the Platform.

To create your custom balance sheet or P&L. Navigate to ACCOUNTING&gt; General Ledger &gt; General Ledger Accounts

You will be directed to the financial report formats search page, where you can view any existing report formats that have been set up.

To create a new financial report format, click **New Financial Report Format.**

Let’s explore the Financial Report Format page. In the top-right corner, you’ll find four action buttons:

- New Report Format – Create a new financial report.
- Copy – Duplicate an existing report format.
- Delete – Remove a selected report format.
- Save – Save your current report progress.

You can create a new financial report using one of three types:

- Profit & Loss
- Balance Sheet
- Dashboard Tile

You can customize your financial report by setting a **report name** and **report title**. Use the **Active** checkbox to specify whether the report format is enabled.

To add more lines to your financial report template, click the **More Lines** button.

**Tip:** As you create your custom financial report, additional lines will be automatically added when you reach the end of the table—just click **"Save"** to generate more lines.

In the middle of the page, you'll find the **Report Builder**. Let’s go over the table from left to right:

**Sort Order** – This determines the sequence in which your report items appear. You can insert items between existing numbers using decimals (e.g., 1.1, 1.2) to maintain a logical order.

### **Line Type Options**

The **Line Type** setting determines how each line item appears in your financial report. Here are the available options:

- **Heading** – Creates a main heading or subheading to organize your report.
- **Blank** – Inserts an empty line to add spacing between sections.
- **Single Account** – Displays a specific account from your general ledger.
- **Account Range List** – Lists multiple general ledger (GL) accounts within a specified range.
- **Account Range – Summary** – Summarizes all accounts within a defined range into a single line.
- **Total** – Calculates and displays the sum of selected accounts.
- **Percentage** – Shows the percentage of a selected account relative to a total.

The **From Account No** and **To Account No** fields define the range of GL accounts from your chart of accounts to be included in the report. This allows you to pull in specific accounts or a range of accounts as needed.

The **Value** field defines how amounts are calculated for the report line item. You can specify whether the value is displayed as **debit minus credit** or **credit minus debit**, depending on how you want financial data to be presented in your Balance Sheet or Profit & Loss statement.

You can customize descriptions for the following line types:

- **Heading** – Define section headers or subheadings within the report.
- **Total** – Label total calculations for clarity.
- **Percentage** – Specify how percentage values should be described.

For **Single Account** line types, the system automatically pulls in the GL account description. When using the **Account Range – Summary** line type, you can manually enter a custom description to represent the summarized accounts.

### **Total As (+ / -) Field**

The **Total As** field controls how amounts are factored into the report’s totals. You can set this field to either **+ (positive)** or **- (negative)** to adjust how the value impacts the overall calculation.

- **(+) Positive** – Includes the amount in the total as-is. Use this for revenue, assets, or any values that should contribute positively.
- **(-) Negative** – Subtracts the amount from the total. This is useful for expenses, liabilities, or adjustments that reduce the overall figure.

This setting ensures financial reports accurately reflect your agency’s revenue, costs, and profitability at a glance.

### **Total Level Field**

The **Total Level** field determines the hierarchy of a total within the report structure. It defines which lines are summed together, ensuring accurate roll-ups of financial data.

- **Level 1** – The highest-level total, summing all applicable lines above it.
- **Level 2, 3, 4, etc.** – Subtotals within different sections. For example:
  - **Level 2** totals a subset of lines before rolling into a higher-level total.
  - **Level 3+** is used for deeper breakdowns, calculating nested subtotals.

This structure helps create clear, organized financial reports, ensuring totals are properly grouped for analysis.

### **Report Formatting Options**

Customize how your financial report appears with the following options:

- **Suppress** – Hides the report line so it won’t be displayed in the final report. Use this to remove unnecessary details without deleting data.
- **Bold** – Highlights important figures or section headings by making the text bold.
- **Clear Totals** – Resets the total at this line, preventing it from rolling up into higher-level calculations. This is useful for breaking out key financial sections.
- **Underline Style** – Controls how lines are visually separated in the report:
  - **None** – No underline.
  - **Single** – A standard underline for emphasis, often used for subtotals.
  - **Double** – A double underline, typically used for grand totals or final figures.

These options help you design a clean, professional report that makes key financial data easy to analyze.

Step-by-Step Guide: Creating a Custom Profit & Loss Report

#### **Report Setup**

- **Report Type:** Profit & Loss
- **Report Name:** Custom P&L
- **Report Title:** Profit and Loss
- **Active:** Checked

#### **Sort Order 1 – Heading**

- **Description:** Revenue
- **Purpose:** Creates a main section heading for revenue.

#### **Sort Order 2 – Account Range**

- **From Account:** First GL account in the revenue category.
- **To Account:** Last GL account in the revenue category.
- **Value:** **Cr - Dr** (Displays revenue as credit minus debit).
- **Purpose:** Pulls in all revenue accounts within the specified GL range.

Create a custom balance sheet or P&L report

Financial Statement Formats

Step-by-Step Guide: Creating a Custom Profit & Loss Report