Skip to main content
All CollectionsFAQsIntegrations & importing
Changing company start date to earlier
Changing company start date to earlier

How do I upload prior periods for my company?

Updated over 3 months ago

Contents

Can I change the start date for the company?

The initial company start date is imported into Fathom as an anchor point for all subsequent data. For companies sourced from MYOB, QuickBooks Desktop, or Excel the company start date cannot be changed to earlier, without deleting and reimporting the company.

Companies using QuickBooks Online or Xero as the source accounting software are able to change the company start date to include prior periods.

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

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

Xero, QuickBooks Online & Sage Business Cloud

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

  1. Go to the Settings for the company
    ​
    ​

  2. Select Step 1 - Update Data
    ​
    ​

  3. In the Financials section, click the Update button
    ​
    ​

  4. Select an earlier start date from the drop-down menu
    ​
    ​

  5. Select Update Data

MYOB, QuickBooks Desktop, Sage 50, and Excel

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

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:

  1. 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
      ​
      ​

  2. 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
      ​
      ​

  3. 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
      ​
      💡Pro 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.
      ​
      ​

  4. 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)
    ​
    ​

  5. 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
        ​

  6. 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
      ​
      ​

  7. If you have a forecast, you'll need to re-build 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.
    ​
    ​

  8. Freely delete the original company and re-import it with the correct starting date
    ​
    ​

  9. Copy over all settings from the Excel company to the re-imported company
    ​
    ​

  10. Import budget results via the Excel template previously downloaded during the second step of this process
    ​
    ​

  11. Import non-financial results via the Excel template previously downloaded during the third step of this process.
    ​
    ​

  12. Copy all custom templates over to the re-imported company from the Excel company
    ​
    ​

  13. Delete the Excel company

Additional knowledge & common questions

Did this answer your question?