Skip to main content
All CollectionsCompany SettingsImport a budget
Import a Budget from QuickBooks Online
Import a Budget from QuickBooks Online

Upload & update your budget data in Fathom from QuickBooks Online

Updated over 2 weeks ago

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.

Bring your budget into Fathom

You can import a budget from QuickBooks Online into Fathom at any time for your QuickBooks Online company. If you do not have a budget in QuickBooks you wish to use, then you also have the option to import a budget from Excel or save your forecast as the budget.

When adding a budget from QuickBooks Online, Fathom allows one budget for each financial year to be connected at a single time, enabling you to have one continuous budget covering multiple years in Fathom.

📝 Note: It is not possible to import a budget into Fathom from QuickBooks Ledger. You can import a budget into Fathom from Excel for QuickBooks Ledger companies.

Budget data for classes or locations

If you have classes or locations in QuickBooks, then you also have the option to bring in class or location budget data. The classes or locations must be imported into Fathom before their budget data can be imported.


Add a budget from QuickBooks Online

To add a budget to Fathom from QuickBooks Online,

  1. Go to 'Update data' in the company’s Settings.

  2. Under the heading for 'Budgets', select the option to ‘Add a Budget

  3. Choose to import a budget from QuickBooks

  4. Select ‘+ Add a budget

  5. A budget will be listed in the modal. You can click on the budget name to change the selected budget.

    💡Smart Tip: If you have imported classes or locations and the chosen budget contains class or location data, then the divisional budget data will be imported along with the overall company budget data. If a budget has been subdivided by class or location, then this will be listed in the budget import modal.

  6. You may add budgets for additional financial years by selecting the ‘+Add a budget’ option again. Select the ‘Rubbish Bin/Trash Can’ icon to remove a budget.

    📝 Note: Fathom allows one budget for each financial year to be connected at a single time, enabling you to have one continuous budget covering multiple years in Fathom.

  7. Click the green ‘Save’ button to save your selection and import the budget.

Import class or division budgets

When importing a budget from QuickBooks, Fathom will import the class or location budget data if the divisions themselves have already been imported.

If you do not see divisional budget data when you expect, then you should:

  1. Ensure you’ve imported a budget from QuickBooks with divisional data.

    1. If a budget has class or location data, then you will see this listed in the ‘manage budgets’ menu

    2. If the budget is not subdivided by division, click on the budget name to select a different budget to import for the financial year


    📝 Note: In QuickBooks, you can subdivide a budget by class or location. Fathom allows one budget for each financial year to be connected at a single time, so you must choose to import the class budget or the location budget for a financial year.

If you have parent and child divisions (e.g. subclasses), then the child budget amounts will not roll up into the parent division unless the child divisions are unimported. To learn more about how Fathom treats parent and child divisions imported from QuickBooks Online, please see this article.


Add a budget from other sources

If you do not want to import a budget into Fathom from QuickBooks Online, then you can import a budget from Excel or save your Fathom forecast as the budget.

Excel

Please look at the following article for more details on importing a budget from Excel.

📝Note: Tracking category budget data cannot be imported via Excel unless the tracking categories have been imported into Fathom as standalone entities.

Add a budget from the company’s forecast

You can save the forecast you create in Fathom as your company’s budget.

You can completely replace your current QuickBooks or Excel budget with the company’s forecast or only partially replace your current budget.

View the following article for more details on saving your forecast as your company’s budget.

📝Note: It is not possible to save the forecast as the budget for the company if budget data for divisions or multiple financial years have been imported. You must remove the divisional budgets or budgets for additional financial years before you can save the forecast as the budget for the company.


Update your QuickBooks budget

You can update your budget data or change your budget in Fathom at any time.

To update the budget:

  1. Go to 'Update data' in the company’s Settings.

  2. Under the heading for 'Budget', select the option to ‘Update Budget from QuickBooks Online

    💡Smart Tip: To change the budget you've selected to import from QuickBooks, select the 'manage budgets' option. You can import additional financial years for your budget with the '+ Add budget' option. Click on a budget name to change the budget imported for the financial year.


Next Steps

Congratulations on importing your budget into Fathom! Continue the 'Get Started Workflow' and finish setting up your company for analysis, reporting, and forecasting by choosing from the options below:

What you want to do:

Next step in the process:

Ready to set up your company profile and import your company logo into Fathom?

Happy with your company profile and want to check and customise your Chart of Accounts?

Happy with your Chart of Accounts and ready to set up KPIs to track your company's performance?


Learn more

Did this answer your question?