Xero to QuickBooks Online Integration migration - Task list
In this article, we'll go over the steps required from you, the client, to ensure a smooth migration of Xero->QuickBooks Online. The cost of migration from one accounting software integrated with Loft to another is $300 USD.
Important - Please read before you proceed!
DO NOT disconnect your current Connection to Xero
DO NOT cancel your current Xero Account until AFTER the migration occurs.
Because Xero will be removed as your accounting integration in Loft, that connection to Xero will be broken and essentially gone, like a closed road, this means ALL transactions prior to your migration can not be pulled back out of Xero, therefore, the following actions can not be done for all deals paid out before the migration:
DO NOT cancel your current Xero Account until AFTER the migration occurs.
Because Xero will be removed as your accounting integration in Loft, that connection to Xero will be broken and essentially gone, like a closed road, this means ALL transactions prior to your migration can not be pulled back out of Xero, therefore, the following actions can not be done for all deals paid out before the migration:
- Changes or corrections to deals
- Removing transactions
It's important to know this because if you're planning on switching to QuickBooks Online for a certain date, you will need to make sure all your deals are correct in Loft and if not, make any corrections to those deals before your migration date. Also, any deals prior to migration can not be batched to QuickBooks Online.
Subscribe to QuickBooks Online.
Your account must be Plus or Advanced subscription level.
QuickBooks Online preparation tasks
In Settings>Advanced
- Ensure G/L numbers are turned on
- Identify whether you are using Class or Location (one must be turned on)
- Confirm your Office(s) is set up in Lists (for Class or Location). You can view your offices on your Brokerage page, make sure they're spelled exactly alike in QuickBooks Online
- Ensure your current G/L Bank accounts, Mapping accounts & G/Ls used in Deduction Templates are set up in QuickBooks Online, so that we can map from the Xero general ledger account to the QuickBooks Online general ledger account. You can export your current COA / GL list from Xero, reformat and import to QuickBooks Online To export your COA out of Xero, https://central.xero.com/s/article/Export-or-print-your-chart-of-accounts To import your COA : https://quickbooks.intuit.com/learn-support/en-us/help-article/import-export-data-files/import-chart-accounts-quickbooks-online/L9Res1eb1_US_en_US
- If applicable, Tax accounts must be set up (CDN clients only)
Things to note
Don't load your agent list into QuickBooks Online, the first Loft47>QuickBooks Online Sync will load the agents (as mentioned in the Xero vx QuickBooks Online integration article, QuickBooks Online requires 2 contacts for each agent, Loft47 will insert an asterisk before the agent 'customer' A/R contacts profile)
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.
Related Articles
QuickBooks Online Integration to Xero migration - Task list
In this article, we'll go over the steps required from you, the client, to ensure a smooth migration of QuickBooks Online>Xero. The cost of migration from one accounting software integrated with Loft to another is $300 USD. Important - Please read ...Migrating from 1 instance of QuickBooks Online to a new instance of QuickBooks Online
In this article, we'll go over the steps required from you, the client, to ensure a smooth migration of one instance of Quickbooks Online to another instance of QuickBooks Online. The cost of migration from one accounting software integrated with ...Xero VS QuickBooks Online Integration
Differences between Xero & QuickBooks Online integrations with Loft47. Pricing Pricing in Canadian $ & USD $ Xero's cost for the standard version required to integrate with Loft is around $48/monthly (they change their prices, so visit www.xero.com ...What journal entries does Loft post to QuickBooks Online?
Processing transactions through Loft automatically generates the accounting entries in QuickBooks Online. The following descriptions show you the results of Loft activities in your accounting records. Deposits When you post a deposit as a receipt in ...Canadian QuickBooks Online Sales Tax Postings and Filing
Unfortunately, the QuickBooks Online API will not allow Loft to post sales tax the same way we are able to in Xero. In an Agent's payout we post a bill to be paid to the Agent. This bill will include posting the top line commission expense and income ...