In addition to the custom Fathom online and PDF reports, you can download a range of additional default reports in Excel format. These can be found in the 'Excel reports' section of the Report Centre.
This is useful if you want to do more data manipulation or download data from Fathom in spreadsheet format.
Excel reports can be generated for any month, quarter or year. However, reports, such as the 'Forward Projection' report, require a budget to be imported for this company.
Downloading an Excel report
To download an Excel Report,
The report will be downloaded to Excel. After opening the Excel file, you may need to ‘Enable editing’ to edit the report.
List of available Excel Reports
Fathom has several Excel reports, not all of which may be available to a company depending on the data imported for that company. Also, additional Excel reports exist for consolidated and benchmark groups and companies with imported divisional data.
The Excel reports currently available for download from Fathom are:
Financial results - This report downloads a company's Profit & Loss and Balance Sheet into Excel. The date chosen when downloading the report is the final period of data that will be downloaded in the report. All prior periods before the selected date that have been imported into Fathom will also be downloaded.
KPI Results - This report downloads the results for all active KPIs for the company or group. The date chosen when downloading the report is the final period of data that will be downloaded in the report. All prior periods before the selected date that have been imported into Fathom will also be downloaded.
Detailed financial variance - Monthly and quarterly reports include the results for the chosen period, the results for the previous period, the % and currency amount variance between the current and prior period, the results for the same period last year, the % and currency amount variance between the current period and the same period last year. Also included are the YTD results and last year’s YTD results, as well as the % and currency amount variance between YTD and last year’s YTD results.
Forward projection for this FY - This downloads the current year’s results and the projected results based on the imported budget. A total column is also included. A budget must be imported for the company to make this report available.
Financial results [in the Fathom import format] - When the company is sourced from Excel, this report lets you easily download an import template that includes your existing financial data. You can then use this template to update your existing data or add new financial data to your company in Fathom.
Budget results [in the Fathom import format] - When the company is sourced from Excel, this report lets you easily download an import template that includes your existing budget data. You can then use this template to update your existing data or add a new Excel-based budget to your company in Fathom.
Budget results [in the Xero Excel import format] - When the company is sourced from Xero, this report lets you easily download your budget from Fathom to import into Xero. If you have imported tracking category budgets into Fathom and summed the results to create an overall company budget, then you can export the summed budget to import it into Xero.
Three-way forecast - Enables you to download an Excel report of your forecast. You can download the Profit & Loss, Balance Sheet, and/or Cash Flow Statement, with each financial statement on a different sheet in the downloaded Excel report. You can include up to 12 months of actuals along with your forecast data.
Adjustments Audit - If adjustments have been made in ‘Step 1 - Update Data’ for the company or group, then the ‘Adjustments audit’ report will be available for download. This report details the adjustments made for the chosen period and their impact on the Net Income and Retained Earnings.
Additional Excel reports for companies with divisional data (classes, location, tracking categories, etc.) and consolidated and benchmark groups:
In consolidated groups, you can find ‘Consolidated financial results, including eliminations’ and ‘Consolidated budget results, including eliminations’, which give all the details of consolidated accounts for the chosen reporting period along with the eliminations.
In multi-currency consolidated groups, you can download ‘Multi-currency consolidated financial results, including eliminations’ and ‘Multi-currency consolidated budget results, including eliminations’. These reports are the same as the Excel reports for a consolidated group, except they also include the exchange rates used for the reporting period.
If the company is part of a benchmark group, it will also have the option to download the ‘Benchmark results’ report. This report details the chosen period’s metrics results for all of the companies in the benchmark group as well as the 25th percentile, the 75th percentile, and the median for each metric.
If the company has divisional data, you’re able to download the Excel report of the ‘Financials by class’, ‘Financials by location’, and/or ‘Financials by Tracking Category’, which will display the Profit & Loss and Balance Sheet financials for each division for the chosen period as well as the total for the company.
For QBO or Xero companies with divisional budgets, there will also be a ‘Budget results by division’ report(s) available for download.
Can I customise these Excel reports?
These Excel reports cannot be customised. These Excel reports are predefined and are generated based on the data you import from the source accounting system. You can download these standard templates only and edit the reports once they’ve been downloaded to Excel.
Now that you've learned how to download an Excel report, you can learn more about custom reports or other areas of Fathom.
What you want to do:
Where to go next:
Want to learn about custom reporting in Fathom?
Invite others into your Fathom account to share insights
Analyse the company's performance with the Analysis tools
Begin forecasting in Fathom
Want to consolidate your companies in Fathom?
Need to add a company to your Fathom account?
Additional knowledge & common questions