Can I change the start date for a company?

For companies on a Portfolio plan...

Fathom, by default, will always import up to 36 months of historic data starting from the most recently completed calendar month, and this cannot be amended.

For companies on a Fathom Pro plan...

The initial company start date is imported into Fathom as an anchor point for all subsequent data.

You can change the company start date to include prior periods if the company is sourced from:

QuickBooks Online
Sage Business Cloud
Xero
Excel

You cannot change the company start date to earlier, without deleting and reimporting it, if the company is sourced from:

MYOB (Business or Desktop)
QuickBooks Desktop
Sage 50 Accounts

For all Fathom Pro companies, the start date can be changed to later by removing prior periods.

❗ Notice: If the company is sourced from MYOB, QuickBooks Desktop, or Sage 50 and the company start date is changed to a later period, it cannot then be changed to the previous, earlier start date.

How to change a company's start date

This feature is included with Fathom Pro - the plan with access to all of Fathom's features. Companies on Portfolio can be upgraded to Fathom Pro at any time.

Xero, QuickBooks Online & Sage Business Cloud Accounting

To change to an earlier start date for companies sourced from Xero, QuickBooks Online, or Sage Business Cloud Accounting:

Click the Cog/Gear icon on the 'My Companies' page to go to the Settings for the company.
Go to the Source Data section on the left sidebar.
Under Financials, click the Update button.
Select an earlier start date from the drop-down menu.
Select Update Data.

Excel

🎉 Beta feature: The ability to add earlier periods to Excel-based companies is in beta. To enable this functionality, you must turn on the beta flag.

Click the Revolving Arrows icon in the lower-left corner of the 'My Companies' page.
Select Desktop companies.
Click to upload. Select your Excel file with the added periods.
1. If you need to create the file, go to the company's Reports.
2. Select Excel reports on the left sidebar.
3. Download the Financial results (in the Fathom Excel import format) file.
4. Add the earlier periods and data to the downloaded file.
5. Save your file.
6. Once you’ve created or updated your Excel financials file, return to the bulk import modal and choose the file to upload.

MYOB, QuickBooks Desktop, and Sage 50

If you have a Fathom Pro company sourced from MYOB, QuickBooks Desktop, Sage 50, or Excel, to change the start date to earlier you must delete and re-import the company.

To make the transition as seamless as possible and retain many of the company’s Settings (KPIs, non-financial data, targets, custom templates, etc.) and reports, take the following steps:

Download the Financial results (in the Fathom Excel import format) Excel report
1. Go to Reports for the company
2. Select Excel reports from the left sidebar
3. Hover over the 'Financial results in Fathom import format' report and select the Cloud icon
If you have a budget, download the Budget (in the Fathom Excel import format) Excel report
1. Go to Reports for the company
2. Select Excel reports from the left sidebar
3. Hover over the 'Budget (in the Fathom Excel import format)' report and select the Cloud icon
If you have imported non-financial data for the company,
1. Go to the Reports for the company
2. Select Excel Reports from the left sidebar
3. Download the Non-financial KPI Results (in the Fathom Excel import format) report
  
  💡Smart Tip: If you have imported non-financial data via a connected Google Sheet, you can simply connect that Google Sheet to the re-imported company.
Create a new Excel company with the Financial results Excel report downloaded during the first step in this process.

📝 Note: You must change the company name by at least 1 character from the existing company name prior to importing the duplicated company
(ex: change 'Fathom' to 'FathomHQ' in cell B1 on the import file)
Copy over all settings (Chart of Accounts, KPIs, Targets, Alerts) from the original company to the new Excel company
1. The Company Profile settings cannot be copied over, so after copying over the other settings, you'll want to:
  1. Ensure the terminology used in the new company matches the original company's
  2. Import the company's logo into the new company (if you have a logo)
  3. Ensure the Default Rates and currency selections in the new company match the original company
In Reports for the original company, copy over reports to the new Excel company.
1. Hover over a draft or published report and select the Three dots icon
2. Choose Save as template from the drop-down menu and save the report as a custom template
3. Hover over the new custom template and select the Three dots icon
4. Choose Copy to another company and copy the template to the new Excel company
5. Do this for any existing custom templates as well
If you have a forecast, you'll need to rebuild the forecast in the new company. For documentation of the original forecast, download the Forecast and Value Audit reports from the original company's Forecast Settings.
Make note of any Tags assigned to the Original Company. You'll want to assign these tags to the New Company.
Make note of the Threshold collection of the Original Company. You'll want to assign the New Company to the same collection.
Freely delete the original company and re-import it with the correct starting date
Copy over all settings from the Excel company to the re-imported company
Import budget results via the Excel template previously downloaded during the second step of this process
Import non-financial results via the Excel template previously downloaded during the third step of this process.
Copy all custom templates over to the re-imported company from the Excel company
Delete the Excel company

Learn more

Change a company's start date to earlier