Talk to an expert

Tell us what you need and we will call you back.

🇮🇳 +91

    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.

    • Written by Gautami Deshpande, reviewed by CA Puja Pradhan

    Read the full entry

    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:

    1. Import

      New bank lines arrive, usually daily, as uncategorised entries.

    2. 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.

    3. Bank rules

      Rules code recurring lines automatically.

    4. 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.

    Review and sources

    Written by Gautami Deshpande, reviewed by CA Puja Pradhan

    Talk to an expert

    Tell us what you need and the right person calls you back.

    🇮🇳 +91

      By sending this form you agree to our privacy policy.

      Get compliance due-date alerts on WhatsApp. Join →