This is an article on restoring an automatic banking feed within Zoho Books, specifically within the United Kingdom. The article serves as a store for both a possible resolution as well as findings from the research/investigation into the issue.
Why?
The workaround for a lot of our clients is to do a manual import (CSV) of the transactions for a particular account and then to reconcile these. This particular case covers where the Cx had a working automatic bank feed for a while but at some point simply stopped working.
How?
First let's go through a resolution and get the official response on what impact this has on refreshing the token. Then I'll put all my notes I made along the way.
When a Zoho Books bank feed stops syncing in the United Kingdom, there are a few possible causes. Sometimes the issue is with the bank or the Open Banking token, but other times the feed itself becomes stuck and cannot be refreshed or disabled from within Zoho Books.
Pre-amble: I had to check
- ZohoBooks Downtime Server Incidents: US Zoho Services Availability or Zoho EU Services Availability
- Permission Issue: Are we logged in to Zoho Books as the super admin? Most likely yes and the client would have already checked this.
- Did this ever work before? Kinda pointless question but needs to be asked just in case this was never meant to work in the first place.
- When did the connection last work? Within ZohoBooks > Banking > Active Accounts > Account > Filter by "Matched Transactions"
- Bank Issue: Check with client which bank they use, type in the "Search" when connecting a bank on a demo system to see what comes up. If there are multiple options then note these; note it if there is just 1 as well.
- Zoho Issue: If you can, try to mark it as inactive, and you should get the error: Accounts associated with Integration cannot be marked Inactive
Summary
In this case, the client’s bank account had previously been syncing correctly. After several weeks, however, the feed stopped updating, and the option to Refresh Feed was missing entirely from the Banking module. Comparing screenshots showed that the expected menu option (“Refresh Feeds”) had been replaced with only “Automatic Import.” Attempts to make the account inactive failed with the message that it was “linked with an integration.”
This message doesn’t necessarily mean a third-party app; it usually means the existing bank feed integration is still registered within Zoho’s system. Even if it’s no longer functioning, Zoho treats that integration as active and blocks you from deactivating or deleting the account until the connection is reset.
The resolution in this situation required confirming with Zoho Partner Support whether reconnecting a new feed (and thereby generating a new Open Banking token) would have any impact on existing balances or manually imported transactions. The short answer is that reconnecting or refreshing a feed does not affect historical transactions, but deleting the account altogether can affect balances, so that should only be done after Zoho confirms it’s safe.
Once the backend team confirmed there was no risk to balances, the correct approach was as follows:
Resolution
- Confirm permissions. Sign in as the Super Admin in Zoho Books. Feed management options can be hidden for standard admins.
- Check the current feed. Go to Banking > Selet the active account (click into it) and click the gear icon in the top right of this page (not the one next to your profile as that's global settings but the one next to the "Import Statement" button).
- Reconnect Token
- There are a couple of options here depending on what you can see
- If you can see "Refresh Feeds" and/or "Deactivate Feeds" then try "Refresh Feeds" (note my below notes on impact analysis)
- If you can see "Automatic Import" then selecting this will run you through setting up the connection again.
- If you can see "Update Credentials" then selecting this should also run you through setting up the connection again (never seen this option myself).
- If it shows “Connected via Yodlee” or “Connected via Plaid,” note it for later. These indicate which aggregator the feed was using.
- Set Date Filter In any of the above, you can go through connecting to your bank again and follow the wizard through. When it comes to the date filter, pay special attention to the date you select.
- Datacleansing / Tidy Up
- There's a strong chance of duplicate transactions; unique from the automatic feed, and some from your manual import (workaround while feed was down). You will need to delete the manual ones.
- Escalate with your Zoho partner if you cannot disable/refresh the feed. If disabling returns the “linked with an integration” message, raise a ticket with Zoho Books or Partner Support. Ask them to reset or remove the integration mapping for that specific bank account.
- Reconnect the account using Open Banking.
After Zoho confirms the old feed has been cleared, go to Banking > Connect Bank. In the search box, start typing <Your_Bank_Name> and if there is a feed, it should appear. You will want the modern Open Banking connection that replaces the old Yodlee and Plaid labels.
Follow the prompts to log in securely via your online banking and authorise Zoho Books. Once redirected back, link the feed to the existing account (rather than creating a new one) so previous transactions remain associated. - Fetch transactions and verify. Once the connection is restored, click Fetch Transactions to confirm new data flows in. Historical balances and manual imports will remain intact, and only new transactions will sync.
- Refreshing the feed means that duplicates will be created. You will need to delete the ones manually imported in order for the numbers to be brought in line.
Notes and findings:
- Integration locks: The “Accounts associated with Integration cannot be marked Inactive” message almost always refers to a stuck bank feed token, not a third-party app. This can only be cleared by Zoho’s backend support.
- Yodlee vs Plaid: Older Zoho Books feeds in the UK were powered by Yodlee. From 2024 onward, Zoho migrated UK accounts to Open Banking connections handled by Plaid. The “via Plaid” or “via Yodlee” tags no longer appear in the UK interface; instead, you’ll see the bank listed as “& Country (United Kingdom).”
- Deleting accounts: Deleting a bank account can affect balances and reconciliations. Always confirm with Zoho before deletion to ensure historical manual imports are preserved.
- Manual import workaround: During any downtime, you can manually upload transactions using CSV import and reconcile as usual. Once the feed is reconnected, Zoho Books won’t duplicate entries if date ranges are managed carefully.
Source(s):
- ZohoBooks - Help Docs - Bank Feeds
- Spondoo - How to refresh Zoho Books Bank Feeds in the United Kingdom - what to do when Token expires: August 3, 2022
Category: Zoho :: Article: 915
Add comment