This article explains how to import budgets into Magnifi using the provided Excel/CSV template. Importing budgets allows you to quickly bring in existing data as a starting point for your Profit and Loss Projection.
Use budget import when you:
Already have a budget prepared in Excel or another system.
Want to save time by uploading monthly values instead of re-entering them manually.
Are a first-time user setting up projections with existing data.
Ensure that you have already imported your accounts under Chart of Accounts.
Under Profit and Loss, go to Options > Import Budgets.
Export the template (a CSV file will download).
The template includes:
A column for account names
A column for account type (Income or Expense)
Separate columns for monthly values
Copy and paste your existing budget data into the template.
Return to the Import screen in Magnifi, select your file, and click Upload File.
Multiple months can be imported (up to 12 months at a time).
If Magnifi cannot find a match for an account, the unmatched account will appear for mapping.
Derived accounts in Magnifi (for example, Income Driver or Labour Driver accounts) will not be imported.
Example: Wages budget values are driven from employee data in Magnifi.
If you prefer to enter labour budgets manually, remove the payroll linking under Chart of Accounts.
Can I import budgets directly from Xero?
No. Budgets cannot be imported directly from Xero. You must use the Excel/CSV template.
What if my budget has more than 12 months?
Only 12 months can be imported at a time. Split the data into separate imports if required.
Why is a budget account showing as unmatched?
The account name may not exactly match the Chart of Accounts in Magnifi. You will be prompted to map unmatched accounts during import.
What happens to derived accounts like wages or income drivers?
These are not imported. Values are generated within Magnifi based on the drivers you set up.