Xero Connect Wizard

DEAR Inventory can be used either as a standalone accounting system or integrated with either Xero or QuickBooks Online. If you are already using either Xero or QuickBooks, Connect Wizard allows easy integration of these systems with DEAR Inventory.

NOTE: This article covers the Xero Connect Wizard only. For more information on the QuickBooks Connect Wizard, see QuickBooks Connect Wizard.

Once your DEAR account is connected to Xero, the Xero Online Integration page will display the following sections:

  • Integration Settings
  • Cost of Goods Sold Maintenance
  • Connect your DEAR account to another Xero organisation
  • Disable Xero Integration on your DEAR account. This involves clicking Disable Integration on the page to disconnect Xero and DEAR.

Using the Xero Connect Wizard

The Xero Connect Wizard provides easy-to-follow steps for connecting Xero with DEAR. 

NOTE: Before proceeding with integrating Xero or QuickBooks with DEAR, you must ensure you have the correct Chart of Accounts setup. For more information, see either QuickBooks Online Integration or Xero Integration.

To start integrating Xero with DEAR using the Xero Connect Wizard:

  1. On the DEAR menu, click Integration -> Xero.
  2. On the Xero Online Integration page, the details of the integration status and the flow of data between DEAR Inventory and Xero are displayed. Click Connect to enable Xero integration.
    NOTE: If you have previously set up integration between your Xero account and DEAR, there will be a Reconnect button instead of a Connect button on this page. However, the steps are essentially the same, except that the procedure will also disable the integration between DEAR and your Xero account.

  3. On the Welcome page of the Xero Connect Wizard, DEAR is set to keep your data by default. If you want to delete your data from DEAR, proceed to Step 4. If you want to proceed without changing this setting, skip to Step 5.

  4. To delete your data from DEAR, toggle the button to No. You will then be asked to select which data you want to be deleted. You can choose to delete either all data or transactional data onlyIf you select transactional data, you can also choose to delete all products, all customers, and/or all suppliers from DEAR. Not selecting any option during this step means that all transactional data (products, customers, and suppliers) from DEAR will be deleted.

  5. Click Continue to go to the login page for your Xero account. Enter your account credentials to log on to your Xero account and connect it to DEAR Inventory.

  6. You will then be redirected back to DEAR. Click Allow Access to let DEAR Inventory access your data.

  7. Back in the Xero Online Wizard, on the Mapping page, the mapping of your Xero account with DEAR Inventory is displayed. Manually set the correct Xero account if necessary. Click Continue.
    • The Connect Wizard will only map accounts between systems if they have the same settings. If you are missing an account, you can go back to Xero and create them, then click Reload accounts from Xero to continue mapping.

  8. On the Tax Mappings page of the Xero Online Wizard, the mapping of your tax rules in Xero with DEAR Inventory is displayed. Click Next.
    • The Connect Wizard only allows tax rule mapping between Xero and DEAR if the tax rates and Sale/Purchase properties are equal. If DEAR has tax rules that do not have an equivalent in Xero, you will have to create these tax rules in Xero first. Then, click Reload tax rules from Xero to continue mapping.

  1. On the Confirmation page of the Xero Online Wizard, the summary of the mappings of your accounts and tax rules in Xero with DEAR Inventory is displayed. Carefully review the mappings and ensure that they are correct. Once you are satisfied that the mapping is correct, enter the phrase "I would like to start migration to Xero" in the box at the bottom, then click Start Mapping.

While mapping is ongoing, your DEAR account will be locked and all users, including you, as the master user, will not be able to access DEAR Inventory. After the migration is done, DEAR will send you an email, which will contain a link to the page in DEAR where you can export historical data to Xero. If there is any error during migration, the email will contain information about the error, and you will be asked to contact DEAR Customer Support.

Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.