All Collections
Reporting
Editing a report
Creating a Custom Financial Statement
Creating a Custom Financial Statement
Customizing a Profit & Loss or Income Statement, Balance Sheet, or Cash Flow Statement
Calen Olesen avatar
Written by Calen Olesen
Updated over a week ago

Contents:


Customisation options for financial statements

In Fathom, you’re able to add financial statements to a custom report at any time.

The layout of these financial statements, including the order of accounts and the names of headings & subheadings, is based on how you’ve set up the Chart of Accounts in your company’s Settings in Fathom.

While there are many formatting options that allow you to customise the existing financial statements, such as showing more or less detail and switching to an EBITDA layout for a Profit & Loss or Income Statement, some customisations require you to use a KPIs or KPI Trends table instead of the templated financial statements. Customisations that require a KPI or KPI Trends table include:

  • Changing the name of an account classification

  • Changing the name of an account or subtotal/total

  • Changing the calculation of a subtotal/total

For these options, you are able to use custom KPIs and KPI Trends tables to create your own custom financial statements.

📝 Note: If you only want to change the title of a Financials or Financial Snippet table, then you can do so by hovering over the table and selecting the green 'Pencil' icon. The title of Financial Trends tables cannot be changed, you can use a KPI Trends table instead.


Building a custom financial statement

The outlined process for building a custom financial statement is the following:

  1. Save the report you've created as a template so you can easily create future reports with the custom financial statement you made. You'll also be able to share the template across to other companies on your Fathom account.


Create custom KPIs or headings to use in your custom statement

If you want to change the name of an account, account classification, or subtotal/total or change the formula for how a subtotal/total is calculated, then you'll first need to create custom formula KPIs to include these custom names and calculations in reports.

You can also create headings in your Chart of Accounts to use in place of the current classification names.

To create a custom formula KPI:

  1. Go to the 'Step 4 - KPIs' in the company's Settings

  2. Select ‘Create a KPI’

  3. Choose to create a ‘Formula KPI’

  4. Fill out the information. The KPI Name will be the new name for the account or classification.

  5. If you have many companies or groups that will use a similar custom financial statement, then you’ll need to add the KPI to the KPI Library to share the custom table with other companies or groups.

    1. Add custom KPIs to the KPI Library

    2. Go to the company or group the report is shared with and add the custom KPI from the KPI Library to the company or group.

      📝Note: Only users with an 'Administrator' role in Fathom can add KPIs to the KPI Library.

  6. Create the formula

Once you've set up all of the custom KPIs you’ll be using, you can go into the Report Centre for the company to create or edit a custom report or template.


Add a KPI or KPI Trends Table to your report

In a custom report,

  1. Go to ‘Tables & Financials’ on the left side bar

  2. In the menu that opens, go to the second bolded smart text filter at the top

  3. From the drop down menu, choose ‘KPIs’ or ‘KPI Trends’.

    💡Pro Tip: A 'KPI' table will display the current period's results and allow you to add comparative columns as well as a couple prior periods. A 'KPI Trends' table will allow you to display several periods of results (e.g. A rolling-12 month table).

  4. Choose one of the tables to add to your report. You'll edit it to display the exact information you need.


Customise the table to suit your needs

  1. Once the table has been added to your report, hover over it and select the green 'Pencil' icon in the top right corner.

  2. In the menu that opens on the right, you can type in the new name for the table in the uppermost text box.

  3. Select ‘Rows’. From here, we can customise the rows displayed in the table.

    1. To remove a row from the table, select the ‘Three dot’ icon to the right of the row name. Then choose, ‘Remove’.

    2. Select the ‘Add rows’ option to add rows to the table.

    3. From the menu that opens, we can add KPIs, account classifications, headings, subheadings, and individual accounts to our table.

  4. Once you've added the desired rows, select 'Done'.

  5. For rows that you want to appear as totals or bolded, select the ‘Three dot’ icon to the right of the row name. Check the ‘Total row style’ option.

  6. In the 'Columns' section of the menu,

    1. In a 'KPI' table, select 'Add or remove columns' to add of remove columns from the table. Select the 'box' next to the column name to change the colour of the column.

    2. In a 'KPI Trends' table, change the date range.


Save the report as a template

Once you’ve created your custom financial statement, we recommend turning your report into a custom template.

This will allow you to easily re-create the report in future periods, schedule reports to be automatically created for future periods, and share the report, with the custom financial statement, across multiple companies in your Fathom organisation.

  1. In your custom report, select the 'Back arrow' icon in the upper left corner to return to the Report Centre.

  2. Find the report (it will likely be listed in the 'Drafts' section) in the Report Centre and hover over the name of the report.

  3. To the far right of the report name, a 'Three dot' icon will appear. Select it.

  4. From the drop down menu, choose 'Save as template'

    💡Pro Tip: You can edit a template after it has been created.

  5. Name the template and choose 'Create template'

  6. The new template will be listed as one of your custom templates.

You can share a template with all of the companies in your organisation, all of the companies in a consolidated or benchmark group, or with individual companies.

If you're happy with the report template and want future reports to be created automatically from the template, you can create a schedule for the template.

You're also able to create reports from the template which you can edit and then turn into new custom templates.

💡Pro Tip: When a KPI table or custom financial statement is shared across companies or groups, the rows in the table will be matched according to our matching methodology.


Additional knowledge & common questions:

Did this answer your question?