UK bank feeds and reconciliation in Zoho Books, set up for a weekly check

UK bank feeds and reconciliation in Zoho Books: the short answer

To set up UK bank feeds and reconciliation in Zoho Books, connect each business bank account so that transactions import automatically. Then, once a week, match every transaction to an invoice, a bill or an account. A weekly routine keeps the queue small. Month end becomes a check of balances, not a hunt through weeks of unexplained lines.

The work splits into three parts:

• Connect each account through a feed, or import statements where no feed exists.
• Decide, for each type of transaction, whether you match it to an existing record or categorise it to an account.
• Write bank rules only for the transactions that repeat in exactly the same way.

This guide covers each part in order. It includes a worked example of a payment gateway payout and a factored invoice, plus a decision table for each type of transaction. It also covers the points that matter for a UK company under Making Tax Digital. If you are still choosing software, the overview of Zoho Books for UK businesses explains what the product covers.

Bank feeds, matching and reconciliation: the terms defined

A bank feed is a connection that imports the transactions on a bank account into Zoho Books without manual entry. RMA Accountants' guide to Zoho Books for UK small businesses sums up the routine in two short sentences: Zoho Books imports transactions through connected feeds, and you match them as you go.

Bank reconciliation is the check that every transaction on your bank statement has a matching entry in your books. It also confirms that the two closing balances agree. When an account is reconciled, the cash figure in Zoho Books is the cash in the bank.

Matching and categorising

Matching links an imported transaction to a record that already exists in Zoho Books. A customer payment against an open invoice is one example. A supplier payment against a bill is another. Categorising assigns a transaction to an account in the chart of accounts when no such record exists, such as a bank charge.

The difference between matching and categorising has real consequences. Suppose you enter a supplier bill and then categorise its payment as an expense instead of matching it to the bill. The cost lands in the books twice. Your expenses rise, the bill still shows as unpaid, and payables are overstated, even though the cash left only once.

Bank rules

A bank rule is a condition paired with an action. When an imported transaction meets the condition, Zoho Books applies the action. A typical condition is a description that contains a given text. A typical action is categorising the transaction to a set account.

Before you connect a feed: opening balances, VAT scheme and browser

Settle three things before the first bank feed transaction arrives in Zoho Books. Each one is harder to change once the feed is running.

Opening balances

Decide the date your books start from, and enter an opening balance for each bank account. The feed then begins from a known position. The opening balance date is a common question on the Zoho community. One user whose year starts on 1 August 2013 asked whether the opening balance date should be 31 July or 1 August. Agree the date with your accountant before you connect anything.

VAT scheme

If you are VAT registered, choose the scheme carefully at the start. RMA Accountants advises selecting the right scheme from the outset, because changing it later can complicate reporting. Every categorised bank line carries a VAT treatment, so the scheme shapes the reconciliation work too.

Browser

Zoho Books stopped supporting Chrome, Firefox and Edge versions older than 100 from 15 May 2024, according to a Zoho community announcement. Check the machines your finance team uses before the first weekly session.

Next, pin each bank account to the Accounts watchlist widget on the Zoho Books dashboard. In its description of the accountant module, Zoho says the widget shows the available cash in those accounts at a glance. It is a useful daily view alongside the weekly reconciliation.

Connecting a UK bank account: direct feed or statement import

Connect every account your business pays from or receives into. That means current accounts, savings accounts that move money and business credit cards. Set each one up as a separate bank account in Zoho Books, so that each reconciles to its own statement.

Bank feeds reach Zoho Books through third-party feed providers. In one Zoho community thread, a user asked whether they could change the provider on an account from Plaid to Yodlee. They thought Yodlee would pull transactions in a more timely manner.

Because feed timing varies, do not assume that yesterday's transactions have all arrived. Reconcile to a statement date rather than to today.

Some banks offer no direct feed. In that case, export a statement file from online banking and import it into the same bank account in Zoho Books. Only the import step is manual. Once the lines are in Zoho Books, matching and reconciling work the same way as with a feed.

Payment gateways need their own decision. If customers pay through Stripe, GoCardless or PayPal, the money reaches your bank as payouts, not as individual customer payments. Decide at this stage how you will treat those payouts. They cause most of the matching problems in the worked example below.

Match or categorise: a decision table for each type of transaction

Weekly reconciliation in Zoho Books is quickest when you decide in advance what happens to each type of transaction. The table below is a starting checklist. Adjust it with your accountant.

Transaction	What to do in Zoho Books	Why
Customer bank transfer against an open invoice	Match to the invoice	Closes the invoice and keeps receivables accurate
Payment for a supplier bill already entered	Match to the bill	Avoids recording the cost twice and leaving the bill open
Payout from Stripe, GoCardless or PayPal	Match to the invoice payments it contains, and record the fee	The payout arrives net of fees, so it never equals the invoices alone
Deposit from a factoring company	Match to the invoice, and record the factor's fee	The deposit is the invoice less the factor's deduction
Bank charges and interest	Categorise to the relevant account, or use a bank rule	No invoice or bill exists to match
Recurring direct debit with no bill entered	Categorise, then consider a bank rule	The same description repeats each month

Supplier payments and gateway payouts are the two rows teams most often get wrong. If you categorise a paid bill as an expense, the cost is counted twice. If you match a net payout to a single invoice, a shortfall sits in the books unexplained.

If you run payroll outside Zoho Books, wage payments need a decision of their own. The guide to connecting UK payroll to Zoho Books sets out the options.

Bank rules for repeat transactions, and when to hold back

Bank rules in Zoho Books save time only on transactions that look the same every time. A good candidate has a stable description, goes to the same account each time and never relates to an invoice or bill. Bank charges, card terminal fees and a monthly software direct debit usually qualify.

Bank rules become a risk when they touch anything that should be matched. Picture a rule that categorises every payment to a supplier as an expense. It will quietly double count each bill you have also entered. The bill stays open and the supplier balance is wrong. Nobody notices until someone chases a bill that was paid months ago.

At Svennis we connect a new feed and write no rules for the first few weeks. We then add rules only for lines that repeated with the same description and the same account, and we keep customer and supplier payments out of rules so they are always matched by hand.

Review your rules whenever something changes. A bank may alter its description format. A supplier may change how it collects. A new VAT treatment may apply. Any of these can turn a correct rule into a wrong one.

Bank matches also depend on the bills behind them being right. If you use Autoscan for supplier bills, the guide to keeping VAT lines right with Autoscan in Zoho Books covers that side.

Worked example: a gateway payout and two factored invoices

This worked example follows one week's bank feed in Zoho Books for a UK business. The business takes card payments through Stripe and factors some of its invoices. Both patterns come from questions that real Zoho Books users have asked.

The Stripe payout

A UK poster on the Shopify developer forum thread on Zoho Books reconciliation describes the usual set-up. Most teams they speak to connect a gateway such as Stripe, GoCardless or PayPal to put a "Pay Now" link on invoices. The teams then reconcile those payments against the bank feed afterwards. The hard part, the poster says, is matching a payout, net of fees, back to the original invoice so that Books does not show a mismatch.

To handle the payout, follow these steps:

1. Open the deposit in the bank account's uncategorised transactions.
2. Use the gateway's payout report to identify the invoice payments the payout contains.
3. Match the deposit to those invoice payments.
4. Record the gateway fee as an expense, so that the invoices less the fee equal the deposit.
5. Confirm that no difference remains before you save.

The factored invoices

A user on the Zoho community works with two factoring companies. Company A deducts 2% from each invoice and sends an invoice for that fee. Company B deducts 10% and sends no invoice for the deduction. The result was uncategorised deposits that did not match the sales invoice amounts.

The fix is to account for the fee every time. For Company A, the factor's invoice is your document for the 2% deduction. For Company B, you record the 10% fee yourself, at the point you deal with the deposit. In both cases, the deposit plus the fee equals the original invoice, and the invoice closes in full.

The weekly reconciliation check, step by step

A weekly reconciliation check in Zoho Books follows the same steps every time. Pick a fixed day. Reconcile up to the last full statement date rather than to the current moment.

1. Review the uncategorised transactions on each bank account.
2. Match customer receipts and supplier payments to their invoices and bills first.
3. Deal with gateway payouts and factoring deposits, recording each fee.
4. Categorise the remaining lines, and let bank rules handle the regular ones.
5. Compare the Zoho Books balance with the bank statement balance for the same date.
6. Write down any difference and its reason before you close the session.

Two Zoho Books features from the accountant module keep the weekly work clean. Bulk update lets you find and change several transactions at once. That helps when a run of lines went to the wrong account. You can also upload files to a specific account. Attach each month's bank statement to the bank account itself, so the evidence sits next to the figures for audit or compliance.

Done weekly, month end becomes a confirmation rather than a project. If four weekly checks agree with the bank, the month agrees too. Any difference you find is at most a week old, while the people involved still remember the transaction.

What this means for a UK business: MTD, gateways and locked periods

For a UK business, reconciled bank accounts are the base of the digital records that Making Tax Digital expects. RMA Accountants notes that VAT-registered businesses must keep digital records and submit them through compatible software. It adds that Zoho Books keeps records in a structured digital format that supports that set-up. A VAT return built on unreconciled bank lines inherits every miscategorised fee and double counted bill.

Sole traders and landlords with qualifying income over £50,000 have had to use Making Tax Digital for Income Tax since April 2026. The threshold falls to £30,000 from April 2027 and £20,000 from April 2028. In its 2025 review of Zoho Books, the Zoho Books team says the UK edition supports Making Tax Digital for Income Tax. The team describes it as helping sole traders keep digital records and meet HMRC quarterly reporting. Quarterly updates are only as reliable as the reconciled transactions behind them.

Payments raise a separate UK point. The Shopify forum poster wrote that Zoho Payments is not yet live in the UK. That is why UK teams rely on Stripe, GoCardless or PayPal and then reconcile the payouts. The poster adds that card, Direct Debit and bank transfer payments differ in cost and settlement speed.

Expect each payment method to leave a different pattern in the bank feed. If you bill subscriptions, see Zoho Billing for UK subscription businesses.

Finally, lock what you have reconciled. Zoho Books can lock all transactions, or only selected modules such as banking. You can unlock chosen date ranges for exceptional cases. Lock the banking module after each VAT period. A late edit can then no longer change figures you have already filed.

Next steps for setting up bank feeds in Zoho Books

Work through these steps in order. Each one removes a common cause of the month-end backlog.

1. List every account the business uses, including credit cards and gateway accounts.
2. Agree the opening balance date and the VAT scheme with your accountant.
3. Connect each account by feed, or set up statement imports where no feed exists.
4. Write your own version of the decision table for your transaction types.
5. Run a few weekly checks before you write any bank rules.
6. Lock the banking module once each period is reconciled and filed.

You may want help with the set-up, or with a backlog that has already built up. The guide to Zoho Books partner services beyond the initial setup explains what support looks like after go-live. To discuss your own accounts, start with Svennis's Zoho partner services in the UK.

Sources

• RMA Accountants: The Complete Guide to Zoho Books for UK Small Businesses and SMEs
• Zoho community: Zoho Books Bank Feed
• Zoho community: I factored my invoice - how do I record their fee deduction?
• Zoho community: Opening balances - Accounts Receivable and Payable
• Shopify Developer Community: UK finance teams on Zoho Books, invoice payments and reconciliation
• Zoho Books: Budgets and accountant collaboration
• The Zoho Books Team: Zoho Books' 2025 Wrapped