How to use non-financial data in Fathom
When you first import data into Fathom, we will only bring in financial data from the Profit & Loss and Balance sheet. You can then supplement this financial data in Fathom with your own non-financial data, including data from other software sources or systems related to business operations, by creating non-financial KPIs.
Non-financials KPIs (key performance indicators) can be customised to suit any business or industry. You can define your own metrics or select from a range of recommended non-financial KPIs available in the KPI Library.
Non-financial KPIs are typically used to measure common business functions, operational data, or leading indicators for a business. This includes: sales and marketing KPIs, CRM data, point of sale data, workforce management, inventory, customer service KPIs, production figures, operations, research and development, staff utilisation, or other staff metrics.
Creating non-financial KPIs
Before you import your non-financial data into Fathom, you will need to create non-financial KPIs to assign the imported data.
To create a non-financial KPI, go to 'Step 4 - KPIs' of the company’s Settings:
Importing Non-financial Data
Unlike financial KPIs, data for non-financial KPIs is not sourced directly from your accounting system and must be imported to Fathom separately.
After you have created your Non-financial KPIs, there are two options for importing non-financial KPI results:
Add non-financial KPI results manually
You can choose to manually key in your non-financial results directly to Fathom. This is useful if you only have a few non-financial KPIs to import or update.
To manually add Non-financial KPI results directly into Fathom:
Importing non-financial KPI results from Excel
You can also choose to import your non-financial results using an Excel spreadsheet. This is useful if you have multiple non-financial KPIs to import or update, as you can upload multiple periods of results in a single upload.
To import Non-financial KPI results into Fathom via Excel:
The Non-financial KPI results you entered will be imported into Fathom.
What happens if I leave a cell blank?
If you upload an excel file and some of the results are left blank, this is recognised in Fathom as 'No Result' for the period in question. We do not automatically substitute the value zero in this case because 'No Result' is a valid value for many KPIs. It will often appear as blank or a dash.
If this non-financial KPI is used as part of a Formula KPI then the Formula KPI will not be calculated for the period with a ‘No Result’.
Using Non-financial KPIs in Fathom
Once you have created and entered or imported results for non-financial KPIs, Fathom enables you to access your non-financial KPI results in the Analysis Tools and Reports.
Non-financial KPIs become accessible as options in the variable selector in any analysis tool or component within Fathom that uses custom KPIs. This includes the ‘Trend’, ‘KPIs’ and ‘KPI Explorer’ Analysis tools, and in charts and KPI tables in custom reports.
Non-financial KPIs can be used as variables in Formula KPIs to calculate custom ratios. For example, to calculate ‘Average Revenue per Employee’, you would create a Non-financial KPI called ‘Number of Employees’ or ‘Headcount’, and then create a Formula KPI dividing Total Revenue by the Non-financial you created.