Content:
Importing a budget from Excel
You can choose to import a budget from your source accounting system (Xero, QuickBooks Online, QuickBooks Online Advanced, MYOB AccountRight Live).
Alternatively, you can import your budget data from Excel (.xlsx or .csv) at any time. This is useful if you use other forecasting tools for creating your budgets, or if you are importing your financial data from Excel, QuickBooks Desktop, or MYOB AccountRight.
❗Note: Fathom only allows one budget to be imported for a company at a single time.
Adding a budget to your company via Excel
You can import an Excel budget for your company by selecting the ‘Settings’ for the company on the ‘My Companies’ page.
|
The budget should now be added to your company from Excel.
💡Pro Tip: You’re also able to save the forecast you create in Fathom as your company’s budget. View the following help article for more detail on saving your forecast as your company’s budget.
Updating or replacing your Excel budget
To update an Excel budget in Fathom, you’ll need to re-import the Excel file. To do this:
|
💡Pro Tip: To add financial data for a recently completed period, you can just supply the new data that you wish to append to the existing financial range. However, many of our customers prefer to build upon a single excel file which contains all periods. This can be easier to manage and allows you to easily make prior period adjustments, if required.
Next Steps
Congratulations on importing your budget into Fathom! Continue the 'Getting 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 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 the performance of your company? |