Skip to main content

Bulk Update Financials

Update multiple cloud-sourced companies in Fathom

Updated this week

Update companies in bulk

With the bulk update feature, you can quickly trigger an update of multiple companies if the companies are sourced from:

The bulk update functionality is available to companies on a Fathom Pro or Portfolio plan.

Companies sourced from QuickBooks Desktop or MYOB Desktop cannot be updated in bulk.

Which data will be updated?

A bulk update will update the financials (including divisional data, if applicable) for the selected companies.

📝 Note: Companies with divisional data (e.g. Tracking categories, classes, locations, etc.) will take longer to update.

Budgets, non-financial data, and accounts receivable & accounts payable data cannot be updated in bulk. You can trigger individual updates for this data.

What is the bulk update data range?

Cloud-based companies on a Fathom Pro plan

The periods updated will depend on the date range of the individual companies and the auto-update selection of the individual companies.

If a company's auto-update selection is set to update to the most recently completed calendar month, the bulk update will follow that selection. If a company's auto-update is set to update financial data that includes the current calendar month, a bulk update will follow that selection.

If auto-updates are not turned on for a company, the bulk update will default to importing financials up to the most recently completed calendar month.

Sage 50 Accounts & Excel companies on a Fathom Pro plan

Data for periods included in the update files will be updated during a bulk update.

Companies on a Portfolio plan

Fathom will update financial data for the past 36 months, counting backwards from the most recently completed month.

Start a bulk update

To bulk update companies:

  1. Go to the My Companies page.
    ​
    ​

  2. Select the Revolving Arrows icon in the lower left corner.
    ​
    ​

  3. Click either cloud companies or desktop companies. You must have separate bulk updates for cloud and desktop companies; you cannot start a bulk update that includes both.

    1. For cloud companies:

      1. Check the box next to a company you want to update.

        1. Search to find companies quickly.

        2. Filter to find a consolidated or benchmark group and quickly select to update all of the cloud-sourced companies in the group.
          ​
          ❗ Notice: You will not be able to select (1) companies currently being updated, (2) companies already queued as part of a bulk update, or (3) companies for which you need to re-authorise your connection with the source accounting system.
          ​

    2. For desktop companies:

      1. Click to upload.

      2. Select your files. You can update up to 10mb or 20 files in a single bulk update session.

        1. You can have one file per Excel company you're updating. Update file details can be found here: Excel

        2. You must have two files per Sage 50 Accounts company you're updating. Update file details can be found here: ​Sage 50 Accounts
          ​
          🎉 Beta feature: Bulk update for Sage 50 Accounts and Excel companies is currently in beta. To ​access this feature, you must turn on the beta flag.
          ​
          ​

  4. After making your selections, select Update companies.

Check the progress of a bulk update

Once a bulk update has been triggered, the selected companies will be added to the update queue.

You can check the progress of a bulk update:

  1. Go to the My Companies page
    ​
    ​

  2. Select the Update Companies icon on the black bar at the top of the page.
    ​
    ​

  3. If an update is in progress, select View details. If an update has finished, select View queue history.
    ​
    ​

  4. Click Updates.
    ​
    ​

  5. Select an update status to view the companies currently in that status. The statuses are:

    1. In Progress: Companies currently being updated

    2. Queued: Companies next in line to be updated

    3. Successful: Companies successfully updated within the last 24 hours

    4. Failed: Companies unsuccessfully updated within the last 24 hours

Can I change the order of the queue?

It is not possible to change the order of the companies queued for updates. If you need a company updated quickly, you can trigger a manual update of the individual company.

This will update the company, and the company will be skipped over in the bulk update queue.

What if an update has failed?

Companies that have failed to update will be listed as Failed in the bulk update progress tracker.

An error message will be displayed for each company. If you would like to re-try updating all failed companies, you can select the Retry updates option at the bottom of the tracker.

To re-try updating an individual company listed as Failed, select the Three dots icon next to the company. Then, select Retry update.

Can companies be imported in bulk?

It is possible to bulk import multiple companies if they are sourced from a cloud-based software or Excel.

Automatic vs Bulk Updates

Cloud-based companies on a Fathom Pro plan can also have automatic updates turned on if they are sourced from a cloud accounting system. If automatic updates are turned on for a company, the company's financials will be updated once every 24 hours.

Bulk updates enable you to update several companies before the next scheduled automatic update.

Learn more

Did this answer your question?