Overview

This guide is designed to give you a detailed and comprehensive rundown of the Zoho CRM 2 Xero extension portal setup process.
If any questions or confusions arise throughout the course of this guide,
please send an email to extension@oscillosoft.com.au  with details regarding your issues and we will provide you with further assistance.

What happens to your CRM when the extension is effectively installed? 

The installation of the “Zoho CRM 2 Xero” extension will result in new fields being created in your CRM for each of the following modules : 

Disclaimer: Some fields will have to be manually set up during the installation, as explained in the “CRM Customization” part of Set Up.
 The rest will be created automatically if the plugin is installed correctly.

An Overview of The Set-Up :

The set up of your plugin can be categorized into 2 stages : 

1. CRM Customization (Module & Fields): Involves the manual addition of a few fields in the CRM.
   

2. Extension Portal Settings : Involves correctly mapping and setting up the extension configurations to enable the sync between Xero and the CRM.
   

To ensure your Zoho CRM’s compatibility with our sync, specific fields will need to be added to your CRM.
 Most of these will be automatically done during the extension’s set up but a few will require manual configuration:

To begin, open up the Module & Fields Settings in the CRM : 

Path: CRM Settings> Customization> Module & Fields

Then follow the next few Configurations to successfully prepare the CRM for the integration.

1. Products Module 

Setting the Tax Rates for Products as per your organization/country rules

Path: CRM Settings> Customization> Module & Fields > Products > Layouts > Specific Product Layout
> Price Information > Tax > … > Customize Tax Rate > Save

Go to the Price information section of your Product module (1) and follow the path, head to Tax (2)
Customize Tax rate (3) as per your organization’s rules (4) and Save (5) the information.

2. Invoices Module

Configuring fields in the Invoice Module.

Common Path : CRM Settings> Customization> Module & Fields > Invoices > Layouts > Specific Invoice Layout
 

1. Add an Auto-Number field : “Invoice No.”  
   

• Drag an Auto-Number Field into the Invoice Information Section as shown in the screenshot below.
  Path: Specific Invoice Layout > New Fields > Auto-Number > Invoice Information

  
  

  
  

• Configure the Field as follows and as shown in the screenshot below:
  Rename the Field : “Invoice No” 

Set the invoice prefix to : INV -
Set Starting Number to : 1
TICK - Also update existing records. 

2. Delete the “Invoice Number” field.
   Path: Specific Invoice Layout > Invoice Information > Invoice Number > … > Remove Field
   
   
   

3. This step only applies if you're using the Branding theme and Tracking Category in your invoices. These fields need to be manually created as well :  
   

• Drag two Picklist fields from the New Fields Menu to the Invoice Information Section and rename them to Branding theme and Tracking Category respectively.
  Path : Specific Invoice Layout > New Fields > Pick List > Invoice Information

Branding Theme field configurations - 

Field Label - Branding theme
Pick List Options - Add your Branding theme options here

Tracking Category field configurations -

Field Label - Tracking Category
Pick List Options - Add your Tracking Category  options here

4. Make sure the “Modified by” field is Active
   

3. Purchase Orders Module 

Configuring fields in the Purchase Order Module

Common Path : CRM Settings> Customization> Module & Fields > Purchase Orders > Layouts >
 Specific Purchase Order Layout

1. Add an Auto-Number field: ”Purchase Order Number”  
   

• Drag an Auto-Number field into the Purchase Order Information section
  Path : Specific Purchase Order Layout > New Fields > Auto-Number > Purchase Order Information 

• Configure the Field as follows and as shown in the screenshot on the right: 
  

Rename the Field : “Purchase Order Number” 

Set the Prefix to : “PO - “
Set Starting Number to : 1
TICK - Also update existing records.

2. Delete “PO Number” field.
   Path: Specific Purchase Order Layout > Purchase Order > Purchase Order information> PO Number

   
   

3. 
   Make sure the “Modified by” field is Active.
   
   

And with that, your CRM is ready and designed to enable the sync!

This next step involves setting up the extension around your Zoho CRM & Xero
profiles to guarantee the primary functionality and effectiveness of the sync.
To begin, please use the Zoho CRM 2 Xero portal to login to the extension interface. : https://xero2zoho.saasplugin.com.au 

Note: Your login credentials should have been emailed to you on the installation of the extension.
 If you do not have these credentials yet, please contact extension@oscillosoft.com.au

Connecting the Zoho CRM 2 Xero extension to your specific Zoho CRM & Xero applications through the extension portal.
Common Path: Zoho CRM 2 Xero extension > Settings > Web Service Settings

1. To fill up the Xero Credentials (3) section in the Webservice Settings (2) :
   Path: Webservice Settings > XERO Credentials
   
   

1. Create an “App” in your Xero developer space and configure it as follows :
   Path: Xero Developer > My Apps > New App
   
   

• To access Xero Developer : https://app.xero.com/
  
  

• Configurations :
  App Name :
  X2Z Application for <your company name>
  Company or application URL : https://xero2zoho.saasplugin.com.au/Xero OAuth Redirect URLs:
  https://xero2zoho.saasplugin.com.au/getXeroAccess
  
  

2. Obtain Client ID & Client Secret :
   Path: Xero Developer > My Apps > New App > Create App > App Details > Client ID / Client Secret
   
   

3. Fill in relevant details and configurations as follows :
   Path: Zoho CRM 2 Xero Portal > Settings > Webservice Settings > Xero Credentials
   
   

• Configurations :
  Client ID & Client Secret based on Xero App Details
  Time Zone : UTC
  Overwrite Xero Invoice # :  NO 

2. To fill up the Zoho CRM Credentials (4) section in the Webservices Settings :
   Path: Web Service Settings > Zoho CRM Credentials
   
   

1. Create an “App” in your Zoho CRM Developer Console and configure as follows:
   Path: Zoho CRM Developer Console > Client Type > Server-Based Applications > Create Now
   
   

• To access the Zoho CRM Developer Console :
  https://accounts.zoho.com/developerconsole
  
  

• Select Server-Based Applications on the Client Type selection menu
  
  

• Configurations :
  Client Name :  X2Z Application for <your company name>
  Homepage URL :  xero2zoho.saasplugin.com.au
  Authorized redirect URL :
  https://xero2zoho.saasplugin.com.au/authorizeZohoCRM
  
  
  

2. Obtain Client ID & Client Secret
   Path: Zoho CRM Developer Console > Client Type > Server-Based Applications > Create Now > Client Secret
   
   

3. Fill in relevant details and configurations as follows :
   Path: Zoho CRM 2 Xero Portal > Settings > Webservice Settings > Zoho CRM Credentials
   
   

• Configurations :
  Client ID & Client Secret based on step 2(b)
  
  Settings : 

Note: You cannot use both (Item-based and Total based) in your CRM at the same time.
You can use only one for your CRM either it is Item-based or Total based; both types cannot work at the same time. 

CRM time zone: Your CRM time zone

3. Set the Log Retention (5) period
    Path: Web Service Settings > Settings

1. Log Retention (days)*: default is 7-14; This is for how long you want to keep your data saved here. 
   

2. Cut-off Time: Select your desired date from the available dates on the calendar ;
   This is for the day you want the sync to begin.
   
   

4. Set up Notification Emails (6) to notify you when syncs occur via email
    Path: Web Service Settings > Notifications

5. Save Settings (7)
    Path: Web Service Settings > Save Settings

6. After the settings have been saved, the Webservice settings need to be connected to Xero and Zoho CRM (8-9)

1. Connect to Xero :
   Path: Web Service Settings > Xero Credentials > Connect To Xero
   
   

• Follow the 3 steps picture below to give the extension access to your Xero account :
  

2. Connect to Zoho CRM :
   Path: Web Service Settings > Xero Credentials > Connect To Xero

• Allow Zoho CRM Access to the extension in the pop up that follows.
  

7. Complete Default Field Mapping  (10)
    Path: Web Service Settings > Complete Default Field Mappings .

Note : This feature will allow you to automatically map all the default fields between your Zoho CRM and Xero accounts.

Fetching the relevant fields from both CRM & Xero and mapping them via the extension portal.
Common Path: Zoho CRM 2 Xero Portal > Settings > Field Mapping

If you ticked off the “Complete Default Field Mapping” stage in Step 1, all the default fields are already mapped.
All that’s left is to map the separately configured fields created during the “CRM Customization” part of the set up.

Note : This does not include the Products Module as the fields’ settings were only adjusted and nothing new was created,
and the Purchase Orders Module as the fields’ configured are automatically synced through the backend.

Invoices Module Fields Mapping : 

Path: Field Mapping > Invoices

Here, you need to map all fields created in the Invoices Module during the CRM Customisation.
This includes the following : 

• Invoice No.
  

• Branding Theme (only if this field was created during CRM Customisation)
  

• Tracking Category (only if this field was created during CRM Customisation)
  

To successfully map these fields, 

1. Fetch CRM Invoice Fields (1)
   

2. Fetch Xero Invoice Fields (2)
   

3. Create Mapping or set Default Value (3)
   
   

4. Manually mapping the previously configured Zoho CRM Fields with their relevant Xero Fields :
   Invoice No. -> Invoice Number
   Branding Theme -> Branding Theme
   Tracking Category -> Relevant Tracking Category 

5. Save Field Mapping
   

   
   
   
   

   
   

Fetching relevant statuses from both your Zoho CRM and Xero and mapping them through the extension portal.
Common Path: Zoho CRM 2 Xero Portal > Settings > Status Mapping 

1. Invoice Status Mapping :
   Path : Status Mapping > Invoices
    

1. Fetch CRM Invoices Statues (1) 
   

2. Fetch Xero Invoices Statues (2) 
   

3. Create Mapping (3)
   

4. Map the relevant Zoho CRM Status Fields to the Xero Status Fields.
   
   Note : This stage will vary based on your business processes and preference, so there
   is no specific configuration here that will impact the sync. That said, the image below is an example of how a set of configurations can be set up and is intended to be used as a reference only.

5. Save Status Mapping
   

2. Purchase Orders Status Mappings
   Path : Status Mapping > Purchase Orders
   
   

1. Fetch CRM Purchase Orders Status.
   

2. Fetch Xero Purchase Orders Status.
   

3. Create Mapping.
   

4. Map the relevant Zoho CRM Status Fields to the Xero Status Fields.
   

Note : This stage will vary based on your business processes and preference, so there
is no specific configuration here that will impact the sync. That said, the image below is an example
of how a set of configurations can be set up and is intended to be used as a reference
only.

5. Save Status Mapping.
   

Fetching the relevant Tax Fields from both Zoho CRM and Xero and mapping them through the extension.
Common Path : Zoho CRM 2 Xero Portal > Settings > Tax Mapping 

1. Fetch Xero Taxes 
   

2. Fetch CRM Taxes 
   

3. Map the Xero Tax Codes to the relevant CRM Taxes: Mapp with CRM Taxes 
   

Note : This stage will vary based on your business processes and preference, so there is
no specific configuration here that will impact the sync. That said, the image above is an example 
of how a set of configurations can be set up and is intended to be used as a reference only. 

4. Save Taxes Mapping. 
   

Fetching the CRM Records for the relevant modules in the CRM.
Common Path : Zoho CRM 2 Xero Portal > Settings > Fetch CRM Records

To fetch the records : 

• Click Refresh for each module to collect the data relevant to it. 
  

Fetching the Xero Records for the relevant modules in the Xero.
Common Path : Zoho CRM 2 Xero Portal > Settings > Fetch Xero Records

To fetch the records : 

• Click Refresh for each module to collect the data relevant to it. 
  

Note : The data will automatically be fetched every 3 hours once the extension is set up. 

And that’s it. Your Zoho CRM 2 Xero extension is all set up and ready to push your records between your Zoho CRM & Xero !

For reference, the data transfer channels utilised by our extension is as follows :
 

Zoho CRM 2 Xero Extension Setup Complete!

Once the extension is set up and ready to go, you have a couple of options when it comes to syncing : 

1. Manual Sync
   

2. Auto Sync
   

The Manual Sync

Here, your data can be instantly synced for your Accounts, Contacts, Vendors, Products,
Invoices and Purchase orders modules with the “Xero to CRM” and “CRM to Xero” sync modes.
These modes can also be activated so the data push can occur both individually and simultaneously. 

You can further specify the time frame of the sync by toggling the settings under the Sync Options menu.

Auto Sync

Apart from manually triggering syncs to take place, Auto Syncs can be scheduled, 
and through this option, you can run the sync up to 10 times a day for all the modules in the sync
(Accounts, Contacts, Vendors, Products, Invoices, Purchase Orders modules).
This option also utilizes the “Xero to CRM” and “CRM to Xero” sync modes so both unidirectional and bidirectional syncs can take place.

Once you set the auto-sync time please follow the below steps

1. Turn on the auto-sync switch
   

2. Select the period and time of the sync process
   

3. Select Module names
   

4. Select sync Mode
   

5. Select Sync Options
   

6. Notification: Email
   
   

Contact us:

Thanks for setting up our extension. If you have any more queries please contact us at -