How to import actual results in Magnifi

Import Actual Results

How do I import actual results from Xero?

The process to import actual results for the Profit and Loss and the Balance Sheet is the same, except you import Profit and Loss under the "Profit" menu item and you import Balance Sheet under "Cashflow"

Step 1: Click on Import Actuals



Step 2: You will be prompted to select the period. You can import multiple months at a time and we suggest selecting prior periods (eg last 3 months) when importing in case there were any adjustments made to a prior period.



Step 3:  Enter your Xero credentials, select your file, and the data will then appear in Magnifi ready for your review. The data is NOT imported until you hit Save at the bottom.

Step 4;  Map any new accounts that could not be matched. In the example below, there is an account called "Suspense" that has values in Xero, but the account does not exist in Magnifi. You can drop down the box next to the Suspense account to assign it to the relevant account category in Magnifi. 



Step 5; "Save" and the data is imported into Magnifi. 

Click here for more information on the Xero integration.

There are rules to determine how an account is matched in Magnifi but it is generally based on the account ID that is captured when the account is first imported. If Magnifi can't find a match based on ID it will then try and match based on the account name. Therefore if you add a new account in Magnifi, it will match to a Xero account providing the account name is identical.

How do I import actual results from CSV?

Step 1: Click on Import Actuals



Step 2: You will be prompted to select the date range and Software



Step 3: Ensure you have the file saved in the right format and you can then click on then upload the file. 

The file needs to be in the following format;
  1. Column 1; List the Accounts in this column and name the top row "Accounts".
  2. Column 2; List the Account Type (income or Expense) and name the top row "Type"
  3. Column 3; List the monthly values and name the top row "Month_Year". Eg Jul 2018. 
You can import more months by adding them after Column 3.

Once imported, you can follow Steps 4 & 5 above, 

How do I change the actual results?

You can amend the actual results under Projections by simply clicking on the cell and changing the value. 

You need to ensure that the Projections are showing the Actual results. You can enter the "Show Actuals to" date as per the screenshot below.