Using Excel to import data into Fathom
Fathom has direct integrations with Xero, MYOB, and QuickBooks. If you’re not using one of these source accounting systems, then you can also import financial data into Fathom via Excel (.xlsx or .csv).
Using Excel as your source, you can import financial data for monthly, quarterly, or annual periods. Typically, you would export a monthly Profit and Loss (Income statement) and Balance Sheet report from your accounting system to Excel, and then adjust to conform to the Fathom Import Template.
Importing financial data from Excel
To import financial data from Excel into Fathom, go to your ‘My Companies’ page in Fathom:
Once your file has finished importing, you’ll see your company listed on the ‘My Companies’ page in Fathom. From there, you’ll be able to access the Settings, Analysis, Reports, and Forecasting tools.
Import multiple Excel files
If you have multiple Excel companies that you would like to import into Fathom, you can select the option to 'Launch Fathom Desktop Connector’ at the bottom of the importing page. This is a small executable file (.exe) ~6mb, which you can use to bulk upload multiple Excel files at once.
For more information, view our dedicated article on Using the Fathom Desktop Connector.
Updating your financial data from Excel
To update the financial data for your Excel company in Fathom, you’ll need to re-import the Excel file. To do this:
💡Pro Tip: To add financial data for a recently completed period, you can just supply the new data that you wish to append to the existing financial range. However, many of our customers prefer to build upon a single excel file which contains all periods. This can be easier to manage and allows you to easily make prior period adjustments, if required.
Congratulations on importing your company into Fathom via Excel! Finish setting up your company for analysis, reporting, and forecasting by continuing on in the 'Getting Started Workflow'. Choose from one of the next steps below:
What you want to do:
Next step in setup process:
Want to import a budget for your company?
Don’t want to import a budget at this time and are ready to begin setting up your Company Profile?
💡Pro Tip: If you want to consolidate several companies in Fathom, we recommend importing and completing the setup process for each company before creating a consolidated group.