In ‘Step 1 - Update Data’ of the company’s Settings, scroll down to the ‘Budgets’ section.

Select the ‘+Add a budget’ option. If you already have a budget imported into Fathom from your source accounting system or your Fathom forecast, then you’ll need to remove that budget before being able to select the ‘+Add a budget’ option.

Choose ‘Excel’

In the following screen, you’ll see our import guidelines for importing from Excel. We recommend downloading our detailed Import Guidelines, which provide step-by-step instructions on creating your Excel file.

Select the option to 'download an import template’. You can open this in Excel and enable editing to enter your accounts and values.

💡Pro Tip: Classifications (Column A) are 3 or 4-letter codes that allow Fathom to determine the type of account. View this article for more information on Account Classifications.

Once you’ve created your budget import file in Excel, return to Fathom.

❗ Note: You'll need to ensure that the budget is contained in the first worksheet of the spreadsheet for the import to be successful.

Select the option to ‘Choose a file to upload.’

Then, select your budget import file.

Go to ‘Step 1 - Update Data’ of the company’s Settings

In the ‘Budgets’ section, select ‘Update from Excel.’

You can download a blank import template, download an import template that includes the existing budget data, or add data to your existing Excel import file.

💡Pro Tip: To add financial data for a recently completed period, you can only include the new period of data to add to the existing financial range. However, many of our customers prefer to build upon a single Excel file that contains all periods. This can be easier to manage and allows you to easily make prior period adjustments if required.

Once you’ve created or updated your Excel budget file, select the ‘Choose a file to upload’ option.

Select your Excel file with the updated budget