Zoho Expense - Xero Integration

In this guide, you’ll learn how to integrate your Zoho Expense account with Xero’s accounting software. Before we do that, let’s take a look at some of it’s benefits.

  • Accounting for your expenses: This integration will help you to account for your expenses that have been recorded in Zoho Expense.
  • Avoid double entry: You can auto-export your expenses from Zoho Expense to Xero and they will be readily available in Xero for accounting. Hence, there is no need for re-entering your expenses in Xero.

How it works

Once you integrate Zoho Expense and Xero, all your Expense Accounts, Customers and Tracking Categories in Xero are imported as Categories, Customers and Tags respectively. The reimbursable expenses are exported as Bills and the non-reimbursable expenses are exported as Bank Transactions to Xero.

Connect to Xero

Connecting to Xero

Connecting your Zoho Expense account with Xero is easy. In this page, we’ll learn about:

Authorize Access to Xero

This is the first step towards setting up the integration with Xero. To set up:

  1. Switch to Admin View.
  2. Click the Gear icon at the top right side.
    (OR)
    Go to Settings on the left sidebar.
    Authorize Access to Xero
  3. Go to Accounting & ERP under Integrations.
    Authorize Access to Xero
  4. Click Xero.
    Authorize Access to Xero
  5. Click the Connect to Xero button.
    Authorize Access to Xero

By doing so, you will be redirected to Xeroโ€™s sign-in page:

  1. Enter your credentials and sign in.
    Login to Xero
  2. Select the organization which you want to connect with Zoho Expense.
  3. Click the Allow access button to complete the authorization.
    Allow Access to Xero
  4. Once this is done, you will be redirected back to Zoho Expense.
    Redirecting to Zoho Expense

Note: You cannot connect multiple Xero organizations to your Zoho Expense organization and vice versa. Also, ensure that the organizations in both Xero and Zoho Expense have the same base currency.

Configure the Integration

Once you authorize access to Xero, you will be redirected to your Zoho Expense account to set it up. Here, you can configure how the data has to be imported from Xero and exported to Xero. Also, you can map Zoho Expense’s fields with Xeroโ€™s fields.

Import from Xero

To export expenses from Zoho Expense to Xero, the expense accounts and customers in Xero has to be fetched. It is for this purpose, we import data from Xero.

  • Accounts: The expense accounts in Xero can be imported as categories in Zoho Expense. As a result, the existing categories in Zoho Expense will become inactive.

Note: You will not be able to export the expenses that have been associated with the categories that are activated after the sync.

  • Customers: All your customers from Xero can be imported to Zoho Expense. These imported customers can be associated with your expenses in Zoho Expense.
Import from Xero
  • Any new addition to the list of customers or expense accounts in your Xero account will be automatically reflected in Zoho Expense, by virtue of the auto-sync that occurs once a day.

  • If you wish to view the changes immediately, you can do so by clicking the Instant Sync button.

Instant Sync

Export to Xero

Let’s take a look at how you can export the reimbursable and non-reimbursable expenses from Zoho Expense to Xero.

Exporting Reimbursable Expenses

  • The reimbursable expenses in Zoho Expense will be exported as Bills and the vendor of the Bill will be the employee who recorded the expense.
  • The amount to be paid to an employee can be tracked under a liability account that is selected from the dropdown.
  • You can set the bill date as any one of the following:
  • Last Expense Date
  • Report Approval Date
  • Report Submitted Date

Exporting Non-reimbursable Expenses

  • The non-reimbursable expenses in Zoho Expense will be exported to Xero as Bank Transactions.
  • In the choose a default payment account dropdown, the credit card accounts and bank accounts will be listed for choosing the payment account of non-reimbursable expenses.
  • You can set the Bank Transaction date as any one of the following:
  • Expense Date
  • Report Approval Date
  • Report Submitted Date .
  • Select whether the Merchant or the Submitter should be the payee of the bank transaction.

Note: If an expense report has credit expenses and the reimbursable total of the expense report is less than zero, it will be exported to Xero as a Supplier Credit Note.

Export to Xero

Advance

  • The Advance in Zoho Expense will be exported to Xero as Supplier Credit Notes.
  • In the Record advance under dropdown, you can choose an existing advance payment account from Xero.
Export Advances

Mapping Fields

You can map the taxes and tags in Zoho Expense with Xero’s taxes and tracking categories respectively.

Taxes

The taxes that have been created in Zoho Expense can be mapped with the corresponding taxes in Xero. To map the taxes:

  1. Navigate to the Accounting Tax section.
  2. Select a tax from the dropdown under the Zoho Expense Taxes.
  3. Select a corresponding tax in Xero under the Xero Taxes dropdown.
  4. Once this is done, when expenses with taxes are exported from Zoho Expense, the corresponding tax in Xero will be automatically applied.

Tracking Categories

The tags that have been created in Zoho Expense can be mapped with tracking categories in Xero. To map the tags and tracking categories:

  1. Navigate to the Tags section.
  2. Select a tag from the dropdown under the Zoho Expense Tags.
  3. Select a corresponding tracking category in Xero under the Xero Tracking Categories dropdown.
  4. Once this is done, the options of the tracking categories in Xero will be imported as the options of the corresponding tags in Zoho Expense. However, the options of a tag in Zoho Expense will not be exported as the options of tracking categories in Xero.

Note: After mapping the tags and tracking categories, the existing options of the tags in Zoho Expense will become inactive.

Mapping taxes and tracking categories

Configure Export of Reports

Once the report is approved, it is ready to be exported to your Xero account. It can be automatically exported to Xero upon approval or manually exported by the admin who initiates the integration with Xero.

Automatic or Manual export of reports

After you’ve chosen the data you would like to import, export and map, click Save. The data that you’ve chosen to import, export and map will be auto-synced once a day. You can also do instant sync by clicking the Instant Sync button in the Xero integration page.

Now, youโ€™re all set to enjoy the Zoho Expense โ€“ Xero integration.

Map Card Feeds

Sometimes, you might want to export card feeds recorded in Zoho Expense to Xero for accounting or other purposes. You can export your card feeds in Zoho Expense to Xero in a few simple steps:

  1. Associate a card feed in Zoho Expense with a card in Xero.
  1. Switch to Admin View.
  2. Go to Corporate Cards on the left sidebar.
  3. Select the card.
  4. Click the More icon on the top right corner.
  5. Select Edit.
  6. Select a card or a bank account from the Xero Card dropdown.
  7. Click Save.
Mapping card feeds
  1. Export reports associated with the card in Zoho Expense to Xero.

  2. View all transactions of this card in Xero.

Note: You can view the exported transactions under the associated card’s feed in Xero.

Map Users and Vendors

When you export reimbursable expenses from Zoho Expense, they will be exported as bills to Xero and the vendor of the bill will be the user who had created that expense. Hence, to fetch the vendors for creating bills in Xero, you will have to map the users in Zoho Expense with the vendors in Xero. To map the users:

  1. Switch to Admin View.
  2. Go to Settings on the left sidebar.
  3. Go to Users under Users and Control.
  4. Hover over the user you want to map with the Xero vendor and click the More icon at the right side of the user.
  5. Click Edit.
  6. Select a vendor from the Xero Vendor dropdown.
  7. Click Save.

Once this is done, whenever a reimbursable expense created by the user is exported, the mapped Xero vendor will be the vendor of the bill.

Note: If you have not mapped the user with the corresponding Xero vendor while exporting reimbursable expenses, a new vendor will be created in Xero and this vendor will be automatically mapped with the user in Zoho Expense.

Mapping Users and Vendors

Map Merchants and Vendors

When you export non-reimbursable expenses from Zoho Expense, they will be exported as bank transactions to Xero. If you have configured merchants to be the payee of the bank transactions, you can map the merchants in Zoho Expense with the vendors in Xero. To map the merchants:

  1. Switch to Admin View.
  2. Go to Settings on the left sidebar.
  3. Go to Modules under Customization.
  4. Click Merchants.
  5. Hover over the merchant you want to map with the Xero vendor and click the More icon at the right side of the merchant.
  6. Select Edit.
  7. Select a vendor from the Xero Vendor dropdown.
  8. Click Save.

Once this is done, whenever a non-reimbursable expense with the merchant is exported, the mapped Xero vendor will be the payee of the bank transaction.

Note: If you have not mapped the merchant with the corresponding Xero vendor while exporting non-reimbursable expenses, a new vendor will be created in Xero and this vendor will be automatically mapped with the merchant in Zoho Expense.

Mapping Merchants and Vendors

Export Your Reports to Xero

Your expense reports can be exported manually or automatically upon approval, as per the configurations made in the Xero integration page. If you choose to export your reports manually, perform the following steps:

  1. Switch to Admin View.
  2. Go to Reports.
  3. Click the approved report you want to export to QuickBooks.
    Export Your Reports to Xero
  4. Click on the Export to Xero button located on top of the report. Export Your Reports to Xero
  5. Once that’s done, you will know how each expense was exported. If your report contains both reimbursable and non-reimbursable expenses, each will be exported separately as configured previously.
  6. For reimbursable expenses, reimbursement has to be recorded manually after making the reimbursement in Xero.
  7. If you have made changes in the exported expenses and you want those changes to be updated in Xero, that can be done by clicking on Export to Xero button once again. By doing so, the changes made will overwrite the existing transaction.

Disconnect the Integration

When you disconnect the integration, you will no longer be able to export your expense reports to Xero. However, all the imported accounts, users and customers from Xero will continue to remain active in Zoho Expense.

To disconnect the integration:

  1. Switch to Admin View.
  2. Go to Settings on the left sidebar.
    Authorize Access to Xero
  3. Go to Accounting & ERP under Integrations.
    Authorize Access to Xero
  4. Click Xero.
    Authorize Access to Xero
  5. Click Disconnect.
Disconnect Xero integration

A pop-up will appear on the screen. Click Confirm to disconnect the integration.

Get a personalized demo from our experts

Attend a demo and receive $50 worth of Zoho Wallet credits that you can use to subscribe to Zoho Expense!

credit-coins-illustration
*
*
*
*
*
*

By clicking Submit, you agree to our Privacy Policy.