Glossary · Accounting & Bookkeeping
Zoho Banking Feeds
Definition
Zoho banking feeds are the automatic import of bank and credit card transactions into the Banking module of Zoho Books. Each imported line waits in a queue to be matched with an existing entry or categorised to an account. They remove manual typing and make bank reconciliation a review task.
At a glance
- Category
- Accounting & Bookkeeping
- In this entry
- How it works in Zoho Books Gateway and UPI settlements · Example
How it works
01 How it works in Zoho Books
An account is added from the Banking module (Add Bank or Credit Card). It is linked either through a direct or aggregator-based feed, or set up for statement upload where the bank has no feed. The opening balance and start date are set at this stage; the feed brings in history only from that start date.
After that, each line goes through the same path:
- Import
New bank lines arrive, usually daily, as uncategorised entries.
- Match or categorise
Matching links the line to an entry already in the books, such as an invoice payment or a recorded bill, so nothing new is created. Categorising creates a new entry for a line that has no record yet, such as a bank charge.
- Bank rules
Rules code recurring lines automatically.
- Reconcile
When the queue is clear, the Zoho balance agrees with the bank.
Always try to match before categorising. Categorising a receipt that already has an invoice payment recorded counts the income twice.
In detail
02 Gateway and UPI settlements
A payment gateway pays out the net amount after its fee and the GST on that fee. The feed shows only that net credit. The gross sales, the fee and the GST on the fee should be recorded from the gateway's settlement report, and then the net credit is matched. Otherwise sales and input tax credit are both understated.
Worked example
03 Example
An example, not advice on your facts.
| Bank line | Amount (₹) | Treatment in Zoho Books |
|---|---|---|
| Customer NEFT, 5 Aug | 1,18,000 | Matched to invoice INV-084 |
| Payment to supplier, 8 Aug | 47,200 | Matched to bill BILL-231 |
| Bank charges, 31 Aug | 472 | Categorised to Bank Charges by a rule |
| Gateway settlement, 31 Aug | 97,640 | Matched after recording sales 1,00,000, fee 2,000 and GST on fee 360 |
For the gateway line: 1,00,000 - 2,000 - 360 = 97,640.
Watch out
04 Common mistakes
- Accepting suggested matches without checking, so a receipt clears the wrong invoice.
- Wrong opening balance or start date, so the account never reconciles.
- Uploading a statement for a period the live feed already covers, which doubles entries.
- Bank rules written too broadly.
- Booking gateway credits as net sales.
- Letting the uncategorised queue pile up.
Need help with Zoho banking feeds? See our Zoho Books Accounting or Accounting Services.
