Zoho Books and Paytm/PhonePe Integration: UPI Payment Reconciliation for Indian Merchants

Indian merchants processing UPI payments through Paytm and PhonePe face a recurring accounting problem: the money arrives in batches, settlement timelines vary between T+1 and T+2 working days, and transaction references from the payment gateway rarely match bank statement descriptions line for line. For businesses running on Zoho Books, this creates daily reconciliation gaps that compound into month-end chaos. Zoho Books UPI payment reconciliation, when configured correctly, eliminates manual matching entirely by connecting gateway feeds, auto-applying bank rules, and generating GST-compliant receipts the moment a UPI settlement clears. This guide covers the complete workflow for Indian merchants using Paytm Business and PhonePe Business with Zoho Books, from initial gateway configuration through automated reconciliation rules and reporting.

Why UPI Payment Reconciliation Matters for Indian Merchants

UPI transaction volumes in India crossed 14 billion per month in early 2026, and a growing share of that volume flows through merchant payment gateways. For any business accepting UPI payments via Paytm or PhonePe, three reconciliation challenges emerge immediately.

First, settlement timing creates temporary mismatches. A customer pays via UPI at 3 PM on Wednesday, but the gateway settles the net amount (after fees) into your bank account on Thursday morning. Your Zoho Books invoice shows “paid” instantly, but the bank feed does not reflect the deposit until the next day. This one-day gap, multiplied across hundreds of daily transactions, makes it impossible to reconcile books against bank statements without a structured process.

Second, transaction reference formats differ between gateways and banks. Paytm settles funds with a UTR (Unique Transaction Reference) that looks different from what your bank reports in the NEFT or IMPS credit description. PhonePe uses its own settlement ID format. Without mapping rules, matching these references in Zoho Books requires manual lookup for every transaction.

Third, GST compliance demands that payment receipts tie back to specific invoices with correct tax breakdowns. The GST filing process in Zoho Books depends on accurate payment data. A missed or mismatched payment means incorrect GSTR-1 or GSTR-3B figures, which invites scrutiny during audits.

Setting Up Paytm and PhonePe as Payment Gateways in Zoho Books

Paytm Business Gateway Configuration

Zoho Books has a native Paytm integration available in the India edition. To configure it, navigate to Settings, then Integrations, then Online Payments. Paytm appears as a listed gateway. Click Set up Now and enter your Merchant ID and Merchant Key from the Paytm Business dashboard. Generate these keys by logging into the Paytm Business dashboard, navigating to Developers, then API Keys, and selecting the Production mode.

Once connected, Zoho Books automatically appends a “Pay Now” link to every invoice you send. Customers clicking this link can pay via UPI (through any UPI app), credit or debit card, net banking, or Paytm Wallet. Each successful payment triggers an automatic status update on the corresponding Zoho Books invoice, changing it from “Sent” to “Paid” and generating a payment receipt.

Key configuration details to note:

• The integration supports only INR transactions
• Paytm levies a merchant discount rate (MDR) on card and wallet payments, but UPI person-to-merchant transactions currently carry zero MDR per RBI guidelines
• Settlement cycles from Paytm are typically T+1 for UPI and T+2 for card payments
• You need to configure a clearing account in Zoho Books (discussed in the bank reconciliation section below) to handle the settlement delay

PhonePe Business Gateway Setup

PhonePe does not have a native Zoho Books integration in the same way Paytm does. Instead, PhonePe Business works through its payment gateway APIs or through the Zoho Payments platform, which acts as a unified payment layer for Zoho Finance apps. If you are already using Zoho’s ecosystem, the recommended path is to enable Zoho Payments, which supports UPI QR codes and UPI Intent as payment methods.

For merchants who specifically need PhonePe Business as a standalone gateway, the workflow involves exporting settlement reports from the PhonePe Business dashboard and importing them into Zoho Books as bank statements. The PhonePe dashboard at developer.phonepe.com provides settlement exports with UTR numbers, transaction IDs, settlement dates, and net amounts after fee deductions.

UPI Transaction Reference Matching in Zoho Books

The core of UPI payment reconciliation in Zoho Books lies in matching transaction references between three systems: the payment gateway (Paytm or PhonePe), your bank account feed, and the invoices in Zoho Books. Here is how each reference flows through the system.

The matching logic works at two levels. At the invoice level, when a customer pays through the Paytm gateway link on an invoice, Zoho Books automatically records the payment against that specific invoice. This happens in real time and requires no manual intervention. The invoice status changes to “Paid” and a payment entry is created with the gateway’s transaction ID.

At the bank reconciliation level, you need to match the settlement deposit in your bank feed with the corresponding batch of gateway payments. This is where bank rules become essential. In Zoho Books, navigate to Banking, then Rules, and create rules that identify settlement deposits by their narration pattern. For Paytm settlements, the bank narration typically contains “PAYTM” or “ONE97” (Paytm’s parent company name). For PhonePe, look for “PHONEPE” or “PPBL” in the narration.

Creating Automated Bank Rules

A well-configured bank rule in Zoho Books can automatically categorize incoming UPI settlement deposits. Here is the recommended rule structure:

• Rule name: “Paytm UPI Settlement”
• Condition: If narration contains “PAYTM” or “ONE97” or “PAYTM SETTLE”
• Action: Categorize as “Transfer from Payment Gateway Clearing Account”
• Reference: Auto-extract UTR from narration

Create a separate rule for PhonePe settlements with appropriate narration patterns. These rules work with the Zoho Books bank reconciliation engine to auto-match incoming deposits, saving 15 to 30 minutes of daily manual reconciliation for merchants processing 50 or more UPI transactions per day.

Handling Settlement Delays: T+1 and T+2 Cycles

Settlement delays create a timing difference between when Zoho Books records a payment (instantly, when the customer pays) and when the money actually appears in your bank account (T+1 or T+2). Without proper accounting treatment, this gap causes your bank balance in Zoho Books to disagree with your actual bank balance.

The standard accounting solution is a Payment Gateway Clearing Account. Set this up in Zoho Books as follows:

1. Go to Accountant, then Chart of Accounts
2. Create a new account under “Current Assets” named “Paytm Settlement Clearing” (create a separate one for PhonePe if needed)
3. When Zoho Books records an invoice payment via Paytm, the debit goes to this clearing account instead of your bank account
4. When the settlement actually arrives in your bank (visible in the bank feed), create a transfer from the clearing account to your bank account

This two-step process keeps your bank balance accurate at all times. The clearing account balance at any point represents the “in-transit” funds, money that customers have paid but the gateway has not yet settled.

Weekend and Holiday Settlement Handling

UPI settlements through both Paytm and PhonePe follow banking working days. Transactions processed on Friday evening, Saturday, and Sunday are typically settled on Monday (or Tuesday if Monday is a bank holiday). This means your clearing account balance will be higher over weekends. For businesses with high weekend UPI volumes, this is normal and expected. The key accounting principle is that the clearing account balance should return to near-zero after each settlement cycle clears.

Configure a weekly review in Zoho Books to check the clearing account balance every Tuesday morning. If the balance is not near-zero, investigate unmatched settlements from the previous week. Common causes include UTR mismatches, partial settlements due to chargebacks, or gateway fee deductions that do not match expected MDR rates.

GST-Compliant Payment Receipt Workflows

Every UPI payment received through Paytm or PhonePe must generate a GST-compliant payment receipt. Zoho Books handles this automatically when the payment gateway integration is configured, but there are specific settings to verify.

First, ensure your GST settings in Zoho Books are correctly configured with your GSTIN, business legal name, and address. Navigate to Settings, then Taxes, then GST Settings. The GST e-invoicing configuration in Zoho Books should be active if your turnover exceeds the applicable threshold (currently INR 5 crore for e-invoicing mandate).

Second, payment receipts generated by Zoho Books on UPI payment capture include the invoice number, payment date, amount received, payment method (UPI), transaction reference, and the applicable GST breakup (CGST, SGST, or IGST depending on the supply type). These receipts are automatically available in the customer portal and can be emailed to the buyer.

Third, for merchants processing both B2B and B2C UPI payments, configure separate invoice templates. B2B invoices require the buyer’s GSTIN and are reported in GSTR-1 with full details. B2C transactions above the threshold are reported in aggregate. Zoho Books handles this classification automatically based on whether the customer record has a GSTIN entered.

Handling Gateway Fee GST (Input Tax Credit)

Paytm and PhonePe charge MDR on non-UPI transactions (cards, wallets). These fees attract 18% GST, and you can claim input tax credit (ITC) on the GST component. In Zoho Books, record the gateway fee as an expense under “Payment Gateway Charges” with the appropriate GST treatment. The fee invoice from Paytm or PhonePe should be entered as a bill in Zoho Books with the correct HSN/SAC code (SAC 997158 for payment processing services) and GST rate.

Bank Reconciliation Rules for UPI Transactions

Effective bank reconciliation for UPI payments in Zoho Books requires a layered approach. The complete Zoho Books setup for India should include these reconciliation rules from day one.

Layer 1: Automatic Matching

Enable automatic bank feed imports in Zoho Books by connecting your business bank account through the Banking module. Zoho Books supports direct feeds from most major Indian banks including SBI, HDFC, ICICI, Axis, and Kotak. Once feeds are active, incoming settlement deposits appear automatically in the Banking section.

Zoho Books’ auto-match engine attempts to match bank transactions with existing records based on amount, date, and reference. For UPI settlements, the auto-match success rate depends on how consistently the gateway formats its settlement narrations. Typically, auto-match handles 60% to 70% of settlement entries without intervention.

Layer 2: Rule-Based Categorization

For the 30% to 40% of transactions that auto-match misses, bank rules fill the gap. Create rules for common patterns like gateway settlements, refund reversals, and chargeback debits. Each rule should map to the correct account in your chart of accounts, whether that is the clearing account for settlements or a specific expense account for fees.

Layer 3: Manual Reconciliation

A small percentage of transactions will require manual matching. This typically happens when a settlement amount does not correspond exactly to any single invoice payment because the gateway has bundled multiple payments into one settlement transfer, or deducted fees mid-batch. For these cases, use the split-matching feature in Zoho Books to match one bank deposit against multiple payment entries.

For merchants also using Razorpay alongside Zoho Books, the same clearing account and bank rule approach applies. Each payment gateway should have its own clearing account to avoid cross-contamination of settlement tracking.

Reporting and Dashboards for UPI Payment Tracking

Zoho Books provides several built-in reports relevant to UPI payment tracking. The most useful ones for merchants reconciling Paytm and PhonePe payments are:

• Payment Summary Report: shows all payments received, filterable by payment method and date range. Use this to verify that total UPI payments recorded match the sum of gateway settlements.
• Bank Reconciliation Summary: displays the difference between your Zoho Books bank balance and the actual bank balance, with a breakdown of unreconciled items.
• Clearing Account Ledger: tracks the in-transit balance for each payment gateway clearing account. A consistently growing balance here indicates reconciliation problems.
• Receivables Aging Report: identifies invoices that show “Paid” in the gateway but have not been matched to a bank deposit, revealing potential settlement failures.

For more advanced reporting, create custom reports in Zoho Books that cross-reference invoice payment dates with bank deposit dates. This gives you the actual settlement cycle time for each gateway, helping you forecast cash flow more accurately. Similar reporting strategies apply if you use other payment integrations like Stripe with Zoho Books or PayPal with Zoho Books.

UPI payment reconciliation in Zoho Books requires upfront configuration of gateway integrations, clearing accounts, and bank rules, but once set up correctly, it runs with minimal daily intervention. Start by connecting your Paytm or PhonePe gateway, create the clearing account structure, and build bank rules that match your specific settlement narration patterns. Test the workflow with a week of transactions before relying on it for month-end closes. For merchants processing high volumes, the time saved on daily reconciliation compounds into significant operational efficiency across every GST filing cycle.