Importing financial data

To import data from Xero > Select ‘Add a Company’ > then select ‘Xero’ as the source.

The first time Fathom connects to your Xero organisation, you must authorise Fathom to access your data from Xero. You’ll only need to do this once for each Xero organisation.

Please note: Only users with 'Advisor' or 'Standard' permissions in Xero will be able to authorise access to the Xero data.

When you return to Fathom, you can select the period range of data that you wish to retrieve from Xero. 

Importing budget data

On initial import, Fathom will automatically import the 'Overall Budget' from Xero. This will be applied to the entity, allowing you to easily set targets and enable budget vs actual variance analysis. You can also use the budget figures to perform forward projections.

Note: You can also import a budget from Excel, as opposed to Xero.

Importing tracking category data

Fathom allows you to import tracking category data for analysis. This can be done either during the initial import, or when updating a company that is already in the platform. 

More information on how to import tracking categories can be found here: Import Tracking Category Data from Xero

When you're ready to import your financial data from Xero, click ‘Import’.

Update your data from Xero

By default, Fathom will automatically update your financial data from Xero on a daily basis. This setting can be toggled on or off in 'Settings > Step 1 - Update Data' for a company.

At anytime, you can manually update the data in Fathom by selecting 'Update from Xero' in 'Step 1 - Update Data' of the company settings. This will synchronise the data in Fathom with the data in Xero at that point in time. If required, you can also update the budget from Xero.

Chart of Accounts

Fathom has a limit on the number of accounts that can be imported which can be found at https://support.fathomhq.com/en/articles/2688563-thresholds-limits.

Archived accounts are also imported, but only where they have data assigned to them historically. Archived accounts with no data will not be imported.

Permissions required to connect to Xero

To connect a Xero company, you must be an 'Advisor' or 'Standard' level user with the 'View Reports' permissions set to 'All Reports' in that specific company. If you cannot find your company in the list that Xero presents, you'll want to check on the permission levels in Xero before reattempting the import. 

Did this answer your question?