Connecting Zoho Books to Dext lets you extract and code your Cost and Sales documents in Dext and publish them directly to your Zoho Books organisation.
Important: Only Admin users can connect and manage accounting software integrations in Dext. This includes accountants and bookkeepers accessing a client account.
Connect Zoho Books to Dext
To connect Zoho Books, go to Business settings in the bottom-left navigation, then select Connections. In the Accounting software section, select Connect.
Find Zoho Books in the list of available integrations and select Connect.
Log in to your Zoho Books account when prompted and select Accept to allow Dext access.
Select your organisation and follow the on-screen steps to complete the connection.
What Dext syncs from Zoho Books
Once connected, Dext pulls the following from your Zoho Books organisation:
Categories
Suppliers
Customers
Bank accounts
Projects
Locations
Tax rates
Products & Services
Payment methods and payment modes
To publish paid items to Zoho Books, the payment method applied to the item must be linked to a bank account in Dext. For steps on setting this up, see How to link a payment method to a bank account.
In addition to a bank account, Zoho Books requires a payment mode to be selected for each payment method. Payment modes are created and managed in Zoho Books. For help setting them up, see Zoho Books: Default payment mode.
Once created, payment modes sync to Dext and appear in the Payment mode column on the Business settings > Lists > Payment methods page. Select the appropriate mode for each payment method before publishing paid items.
Note: After adding payment modes in Zoho Books, refresh your integration data in Dext to sync the changes. Dext syncs automatically every 48 hours.
Publishing Cost items
Cost items in Dext can be published to four destinations in Zoho Books. Select your destination in the Publish to field on the item details page.
Purchases
The Purchases destination is available for both paid and unpaid items. Items are published to Purchases > Bills in Zoho Books.
Unpaid items arrive with an Open status
Paid items arrive with a Paid status, with a matching payment record created automatically
Unpaid items past their due date are marked as Overdue
Expenses
The Expenses destination is for paid items only. The payment method applied to the item must be linked to a bank account and have a payment mode selected - see Payment methods and payment modes above.
Items are published to Purchases > Expenses in Zoho Books. The category from Dext appears in the Expense Account column, and the bank account linked to the payment method appears in the Paid Through column.
Reimbursable Expenses
The Reimbursable Expenses destination is for paid items only, and requires the document owner in Dext to be linked to an Employee in Zoho Books.
To set this up:
In Zoho Books, go to Settings > Purchases > Expenses and enable Associate employees to expenses. Add at least one mileage rate and save.
Set up employees in Zoho Books. For help, see Zoho Books: Associate employee with expense.
Refresh your integration data in Dext to sync the employees you've added in Zoho Books. Then go to Users and select Link users to Zoho Books - this button only appears once employees are set up in Zoho Books. Match each Dext user to their corresponding Zoho Books employee.
Once linked, items published to this destination appear under the linked employee in Purchases > Expenses in Zoho Books.
Payments Made
The Payments Made destination publishes a standalone payment transaction to Zoho Books that can be matched to an existing unpaid bill. Use this when the payment and the original bill are being handled as separate documents.
Publishing Sales items
Sales items in Dext can be published to two destinations in Zoho Books.
Note: Sales items use Products & Services for coding - categories cannot be applied to Sales items.
Sales
The Sales destination supports three item types:
Sales invoice - published to Sales > Invoices in Zoho Books with a Draft status. Marking the item as paid or applying a payment method does not affect the status.
Sales receipt - published to Sales > Invoices in Zoho Books with a Draft status, regardless of payment method.
Sales credit note - published to Sales > Credit Notes in Zoho Books. Marking the item as paid or applying a payment method has no effect.
Payments Received
The Payments Received destination publishes a standalone payment transaction to Zoho Books that can be matched to an existing unpaid invoice.
Use this when the payment and the original invoice are being handled as separate documents - for example, where an invoice and its payment notification are issued separately.
Publishing expense claims
Expense claims support the same four publishing destinations as Cost items - Purchases, Expenses, Reimbursable Expenses, and Payments Made - and follow the same logic. Items within a claim appear as individual lines in Zoho Books.
Foreign currency
The Zoho Books integration supports publishing Cost and Sales items in foreign currencies, as long as the relevant currencies have been added to your Zoho Books organisation.
Foreign currency is not supported for expense claims. When an expense claim is published to Zoho Books, amounts are converted to your base currency.
Tax
Dext's Extracted Amount tax option is not supported with Zoho Books. You must select an explicit tax rate on each item before publishing. If you attempt to publish using Extracted Amount, Zoho Books will return a "Complete the tax field" error.
The only exception is items with a tax amount of zero - these can be published using Extracted Amount.
Zoho Books publishing errors
"Complete the tax field" - the item is set to publish using Extracted Amount. Select an explicit tax rate on the item details page before publishing.
"Please set the Payment mode field of this Payment method" - the payment method applied to the item doesn't have a payment mode selected in Dext. Go to Lists > Payment methods and add a payment mode to the relevant method.
"In order to publish to the 'Reimbursable Expenses' destination please select a valid user that is linked to Zoho Books" - the document owner in Dext isn't linked to a Zoho Books employee. Go to Users and select Link users to Zoho Books to set this up.
"Involved account types are not applicable" - the category applied to the item isn't compatible with the item type. Select a different category, or update the account type in Zoho Books.
"Projects associated with different customers cannot be associated in the same transaction" - the customer applied to the item in Dext doesn't match the customer associated with the project. Remove or change the customer or project on the item, or update their settings in Zoho Books.

