|
Import a budget from Excel
You can choose to import a budget from your source accounting system (Xero, QuickBooks Online, or MYOB Business).
Alternatively, you can import your budget data from Excel (.xlsx or .csv) anytime. This is useful if you import your financial data from QuickBooks Desktop, MYOB Desktop, Sage Business Cloud Accounting, Sage 50 Accounts, or Excel. If you use other tools to create your budget, you can also import it into Fathom via Excel.
Add a budget to your company via Excel
You can import an Excel budget for your company by selecting ‘Settings’ for the company on the ‘My Companies’ page.
|
The budget should now be added to your company from Excel.
💡Smart Tip: You can also save the forecast you create in Fathom as your company’s budget. View the following article for more details on saving your forecast as your company’s budget.
Can you use account codes in an Excel budget import?
When adding a budget from Excel, we revert to the account name and then to the account code. If the account name is specified, we match the values to an account name. The account names must match the Chart of Accounts.
Update your Excel budget
You’ll need to re-import the Excel file to update an Excel budget in Fathom. To do this:
|
📝 Note: Fathom supports only one budget from Excel at a time. Before importing an entirely new budget from Excel, check if an existing budget already exists in Fathom. If there is, you'll need to remove it first by selecting the 'Remove Budget' option in the budget section. If you're only looking to update an existing budget, please use our update budget instructions.
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 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