Zoho Books Integration: Setup & Transaction Sync

Zoho Books Integration: Setup & Transaction Sync

LedgerSync connects to Zoho Books. You can then use the Rules Engine to categorize your clients' bank transactions and sync them into each client's Zoho Books organization. Your firm can have Zoho Books clients and QuickBooks clients at the same time.

What the Zoho Books Integration Supports

  • Linking each LedgerSync client to one Zoho Books organization
  • Importing the client's Zoho Books chart of accounts (categories) and vendors into the Rules Engine
  • Categorizing bank transactions with Global Rules and Client Rules
  • Syncing accepted (categorized) transactions into Zoho Books
  • Syncing to Zoho Books bank accounts and credit card accounts
  • Checking the result of each sync on the Sync Status tab

How to Connect Zoho Books to a LedgerSync Client

  1. Open the Rules Engine menu and choose ZohoBooks.
  2. In the setup steps, select the client from the list.
  3. Click AUTHORIZE ZOHOBOOKS and confirm. LedgerSync sends you to Zoho's sign-in page. Sign in with your firm's master Zoho Books login and approve access.
  4. Back in LedgerSync, choose the client's organization under Select an Organization to Proceed, then click PROCEED TO NEXT STEP.
  5. Connect the client's LedgerSync bank accounts to the matching Zoho Books accounts, so each transaction goes to the right account.

The Zoho Books authorization covers your whole firm. Once it is in place, you connect another client by selecting the client and choosing its organization. You are not sent to Zoho again. To connect a client later, go to Settings > Client Settings > Manage Connections and click AUTHORIZE NEW CLIENT. You can change bank account links under Settings > Initial Setup > Bank Accounts Mapping.

To refresh a client's chart of accounts and vendors from Zoho Books, select the client and click SYNC ZOHOBOOKS DATA.

To disconnect, click REMOVE AUTHORIZATION on the Manage Connections page. This unlinks every client from its organization, and you will have to link them again.

Setting Up the Rules Engine for Zoho Books Clients

Step 1. Map Global Categories to Zoho Books accounts

In Rules Engine > ZohoBooks, go to Settings > Global Settings > Global Categories. For each Global Category your firm uses, link the client's Zoho Books account. This tells LedgerSync which Zoho Books account to post a transaction to when a matching rule fires.

Step 2. Add Client Rules (optional)

If this client needs rules that differ from your firm's Global Rules, create them under Rules > Client Rules.

Step 3. Review and accept transactions

Bank transactions appear on the Transactions tab under For Review. Transactions that match a rule are categorized for you; the Applied Rule column shows which rule did it. Select the transactions you approve and click ACCEPT. They move to Categorized.

Syncing Transactions to Zoho Books

  1. On the Transactions tab, choose Categorized.
  2. Select the transactions you want to send to Zoho Books.
  3. Click SYNC WITH ZOHOBOOKS. LedgerSync posts the transactions to the client's Zoho Books organization.
  4. Open the Sync Status tab to confirm each transaction synced.
  5. If a transaction failed, read its error message, fix the cause and sync it again.

Credit card accounts: transactions from a credit card account sync to the Zoho Books credit card account you link it to in Bank Accounts Mapping.

Sync Status: Checking Results

Each sync is one row on the Sync Status tab. It shows when it was requested, who requested it and how many transactions were synced, failed or skipped. Click a row to see each transaction:

  • Synced: the transaction was posted to Zoho Books.
  • Failed: the transaction was not posted. The Event column gives the reason. Correct the account mapping or transaction data, then sync it again.

Failed transactions are listed above synced ones, so you can spot them quickly. LedgerSync does not hold back Zoho Books transactions as possible duplicates, so the Sync Anyway option used for QuickBooks does not appear for Zoho Books clients.

Client List Filtering: Find Zoho Books Clients

At the top of the client list there is an integration filter (it shows All Integrations by default). Choose ZohoBooks to see only clients connected to Zoho Books. Choose No Integration to find clients that are not connected to an accounting platform yet.

Frequently Asked Questions

Q: Can I use LedgerSync with both QuickBooks and Zoho Books clients in the same firm?

Yes. Each client is connected to the accounting platform it uses. Global Rules are kept separately for each platform: the Global Rules you create under Rules Engine > ZohoBooks apply to your Zoho Books clients, and those under Rules Engine > QuickBooks apply to your QuickBooks clients.

Q: Can I connect a Zoho Books client that has multiple organizations?

Yes. After you authorize, you choose the organization in LedgerSync. Each LedgerSync client is linked to one Zoho Books organization, so to work with several organizations, connect each one as a separate LedgerSync client.

Q: Does the Rules Engine treat Zoho Books clients differently from QuickBooks clients?

Mostly no. Global Rules, Client Rules, Global Categories, Audit Logs and the Rules Engine Audit work for Zoho Books clients. A few features are for QuickBooks only: Classes, Import Rules, Intercompany Transfers and the Sync Anyway option for possible duplicates.

Q: What does Reset Transactions do for a Zoho Books client?

Reset Transactions clears the categorization of the client's transactions from MasterCard bank connections that have not been synced and are not excluded or pending, and moves them back to For Review. It also removes the client's Global Category mappings, so Global Rules stop applying to that client until you map its categories again.

Need Help?

Contact LedgerSync Support at support@ledgersync.com

Related Articles: