Xero to QuickBooks Online Integration migration - Task list

Xero to QuickBooks Online Integration migration - Task list

In Article Navigation can be found to the right of this article or via the buttons below
Important message
Migration Prep Steps
Mid Migration Steps

Important - Please read before you proceed!

Xero >> Xero Migration

You can migrate to either QuickBooks Online or to another instance of Xero, the process will be the same and requires you to reach out to our support to begin the process.

Cost

The cost of any migration is $300 USD.   If you don't wish to complete the prep prior to the migration date just give support a heads up and we'll assist at an additional $75/hour.

Please be sure to follow all of the instructions/steps below to ensure a smooth and timely migration and make sure you
  1. DO NOT DISCONNECT your current Connection to Xero in Loft.
  2. DO NOT CANCEL your current Xero Account until AFTER the migration occurs. (We suggest that you hold onto your Xero Account for at least a month after migration, unless you are confident that your deals  are without any errors or issues.
  3. DO NOT LOAD/ADD your agent contacts into QuickBooks Online.
    Your first '    QuickBooks Online Sync' will push/Sync the agents contact to your QuickBooks Account. 
Since Xero will be removed as your accounting integration in Loft, the connection between the two apps will be permanently severed.  Think of that connection like a two way road, once disconnected, the road will become closed both ways, this means ANY/ALL transactions posted to Xero, from Loft, prior to the migration can not be pulled back from Xero, therefore, the any incorrect deals that need to be fixed can not be fixed after the migration, so it's best to make sure all your deals are correct before you migrate!

Preparation Steps

Subscribe to QuickBooks Online.

Your account must be Plus or Advanced subscription level.

Preparation Tasks

In Xero

When migrating from Xero to QuickBooks Online, you must first set up your Quickbooks/Settings to be closely matched to how your Xero is set up.  This will ensure a timely migration! Our recommendations, to accomplish this, are as follows:
  1. Either setup your new QuickBooks Online Chart of Accounts to match your current Xero's Chart of Accounts.  Or import your Exported  Xero's Chart of Account. If you are looking to clean up your Chart of Accounts for your migration, we suggest you do your G/L cleanup AFTER your migration you may miss crucial G/L accounts mapped in your Loft/Xero integration.  This will cause issues when migrating because the migration requires specific G/L mapping in both your Settings and deductions.
    1. To export your Chart of Accounts out of Xero, follow the instructions in this Xero article https://central.xero.com/s/article/Export-or-print-your-chart-of-accounts please note, you will need to reformat the spreadsheet export to be compatible with the import template required by QuickBooks Online. https://quickbooks.intuit.com/learn-support/en-us/help-article/import-export-data-files/import-chart-accounts-quickbooks-online/L9Res1eb1_US_en_US#:~:text=Here%27s%20a%20sample%20of%20how%20your%20spreadsheet%20should%20look.%20You%20can%20also%20download%20our%20sample%20spreadsheet%20if%20you%20need%20more%20references.

In QuickBooks Online

To setup your QuickBooks Online, follow the steps in this article https://support.loft47.com/portal/en/kb/articles/setup-a-new-quickbooks-account-to-integrate-with-loft 
Please make sure each of the following below are setup correctly in QuickBooks Online:
    1. Financial Settings (Fiscal reporting dates)
    2. Ensure G/L numbers are turned on in your QuickBooks Online/Settings/Advanced menu (Loft can not find a G/L Account in your Chart of Accounts without a number assigned to it)
    3. Identify whether you are using Class or Location for Office tracking/mapping (one must be turned on)
    4. Confirm your Office(s) is set up in your QuickBooks Online/Lists and spelled exactly as they are in your Loft/Offices page. You can also view your offices on your Brokerage page.
*If you're Importing your Chart of Accounts to QuickBooks Online, follow the steps/instructions in this article https://quickbooks.intuit.com/learn-support/en-us/help-article/import-export-data-files/import-chart-accounts-quickbooks-online/L9Res1eb1_US_en_US   

Invite Loft

Once everything on this list has been completed, invite lofttechnologies@loft47.com as an Admin (not accounting admin). This is the trigger for us to schedule development to run the accounting conversion.  Please note the migration can take up anywhere from 24 to 48 hours after being scheduled.

Mid Migration tasks

Because we require you to connect your new accounting software and sync to finalize the migration, make sure you are available to connect when we reach out and instruct you with the following steps:
  1. Connect Xero in Loft via the Integrations/QuickBooks Online/Activity page
  2. Click the blue 'Sync QuickBooks Online' button and let the sync fully run !!Important!! Please DO NOT POST A BATCH
  3. Reach out to your Migration Leader and let them know you've connected and synced
We'll finalize your migration and reach out to you when done :)