How to import Accounts in Magnifi

Import Accounts

How do I import Accounts from Xero?

Under Chart of Accounts, click on the Xero icon, enter your Xero credentials and the accounts will then appear in the Account list. You can then update the account information including the Account Type, Account Category, Divisional allocation (if required) and link Profit and Loss Accounts to the Balance Sheet (if required)

If you have multiple divisions and would like to import the accounts against a specific division, select the division and the follow the import process. This will assign all of the imported accounts to the chosen Division.

Click here for more information on the Xero integration


How do I Import Accounts from CSV?

Under Chart of Accounts, click on the CSV option and it will show the format of the required file. The file simply requires 3 columns;
  1. Account Name
  2. Account Type (specify Income, Expense, Asset, Liability or Equity)
  3. GST (enter Yes or No)
If the Account Name includes a comma (eg Postage, Printing & Stationery), you need to insert double quotes around the account name.

Once imported, you can then update the account information including the Account Type, Account Category, Divisional allocation (if required) and link Profit and Loss Accounts to the Balance Sheet (if required)

If you have multiple divisions and would like to import the accounts against a specific division, select the division and the follow the import process. This will assign all of the imported accounts to the chosen Division.