Once DEAR Inventory and Xero are connected, DEAR Inventory becomes the central point of all inventory management within your business.  This means that all inventory-related purchases, sales, and manufacturing will be performed in DEAR Inventory and then synchronized over to Xero.


WARNING!  The choice to integrate with Xero, QuickBooks Online or to use DEAR Inventory as a standalone service must be made when you create your account. 

  • Changing from QuickBooks Online to Xero as your accounting system or vice versa requires a completely different DEAR Inventory Account.
  • Changing from one Xero account to another Xero account (or QuickBooks Online account to QuickBooks Online account) requires a complete data wipe - contact DEAR support to know more.
  • Changing from Dear standalone to a QuickBooks Online or Xero account requires a complete data wipe - contact DEAR support to know more.


A Video Tutorial is available here: Xero.


HIghlights

  1. Steps in Xero

  2. Steps in DEAR Inventory

  3. Integration Settings


Steps in Xero

[back to top]


Before commencing the integration process, a number of accounts will have to be created in Xero. You will need to make sure you have at least the following accounts:

  • Accounts Receivable

  • Accounts Payable

  • Inventory

  • Supplies and Materials - COGS

  • Revenue Account 

  • Sales Tax Payable

 

To set up Chart of Accounts in Xero:

  1. In Xero, navigate to Settings -> Chart of Accounts. The Chart of Accounts will be loaded based on the industry that you specified when initially setting up Xero.


    NOTE:  You will need to add an Inventory and a COGS account to the ones already loaded into Xero if your existing accounts are not compatible with DEAR Inventory.


  2. Inventory Account:  

    • Click Add Account.

    • Choose Current Asset from the Account Type drop-down menu.

    • Enter Inventory into the Name field.

    • Enter a Code, Description (optional) and check that the Tax Rule for the account is correct before clicking Save.

  3. COGs Account

    • Click Add Account and choose Direct Costs from the Account Type drop-down menu.

    • Enter Cost of Goods Sold into the Name field.

    • Enter a Code, Description (optional) and check that the Tax Rule for the account is correct before clicking Save.

  4. Once you have added all the relevant accounts, go to DEAR and complete the signup process.

     


Steps in DEAR Inventory

[back to top]

 

To connect DEAR Inventory and Xero:

  1. When creating your DEAR Inventory account, select Xero as your accounting system, then wait for the activation email from DEAR.
  2. Follow the link in the activation email sent to you. You will then be redirected back to DEAR Inventory and asked to choose a password.

  1. Go to Integrations -> Xero.

  1. Click Sync Now to be taken to the Xero login screen. 

  1. Log on to Xero, then click Allow Access to let DEAR Inventory access your data. 

  1. You will be redirected back to the Xero synchronization screen. Follow the link to Account Mapping and check that all your Xero accounts have been correctly mapped. If you receive a synchronization error, check that all the accounts have been set up correctly in Xero as shown above. 



Now your Accounts are synchronized between DEAR and Xero. You can continue to set up your ProductsSuppliers, and Customers


Integration Settings

[back to top]


Once your DEAR Inventory account is set up, you'll be able to locate the Xero Integration page by navigating to the Integration module and selecting Xero.


The Xero Integration page will contain the details of the integration in the page header and it explains the flow of data between DEAR Inventory and Xero.


Created in Xero, sent to DEAR

  • Chart of Accounts, Tax Rules, Payment Terms, and Addresses


Created in DEAR, sent to Xero

  • Bills or Purchase Invoices

  • Purchase Credit Notes

  • Sale Quotes/Estimates (Optional send to QuickBooks Online)

  • Sale Invoices

  • Credit Memos and Sale Credit Notes

 

Can be created in both, synced both ways

  • Bill/Sale/Purchase Payments or Refunds

  • Vendors/Suppliers

  • Customers

  • Products/Items  


Within the Xero Integration page, you are able to control whether your integration is enabled or disabled, and you can authorize your Xero connection. You can also choose whether Payments are pushed to Xero or pulled from Xero (see more).


Consolidating Sales

This setting turns on a condition for all consolidated sales invoices and credit notes to be exported into XERO. These Consolidated documents are then exported to XERO during a manual or automatic synchronization process.


To configure consolidated sales in DEAR:

  1. Navigate to Integrations -> Xero.
  2. On the Xero Integrations page, scroll down to the Consolidated Sales section, then toggle on Consolidate Sales on Export.
  3. Click the View consolidated invoices and credit notes link to open the Consolidated Sales page.


On the Consolidated Sales page, all consolidated sales and credit notes are listed.


To look for a specific sales record, enter either the record's document number in DEAR or the consolidated number in Xero on the Search bar on the page's top right. You can also click on any of the column names on the page to automatically sort the sales records in ascending or descending number. 


If applicable, click the navigation buttons at the bottom to navigate between pages.


NOTE:  

  • The period for consolidation is always one day. Payments, Refunds and Customer Credits should be consolidated and added.
  • Void or Undo cannot be performed on consolidated invoices in DEAR since these operations will cause discrepancies in the exported data. You need to create a credit note or invoice to offset the sales you need to void or undo.