Skip to main content
Resources

Reconciliation and bank-statement-intelligence resources

Everything Terra Insight publishes in one place — long-form research on Indian reconciliation, free interactive calculators, ERP and payment-gateway integration notes, and head-to-head comparisons with adjacent products.

Recent additions

Latest from the insights library

How-To
Credit Line on UPI Reconciliation: Separating Pre-Sanctioned Credit from the 15 October 2026 UPI MDR

Pre-sanctioned credit lines on UPI are out of scope of the new UPI MDR and carry their own MCC-based merchant charge. This guide explains the rail, what it costs a merchant, and how to split it out of the UPI settlement file so its charges are neither flagged as leakage nor missed.

How-To
UPI P2PM ₹1 Lakh Limit Monitoring: How Small Merchants Track the 3-Consecutive-Month Graduation Trigger

From 15 October 2026, small merchants on the P2PM category stay zero-MDR only while inward UPI QR receipts are at or below ₹1 lakh per month. Crossing it for three consecutive months moves the merchant into chargeable P2M. This is the monthly monitoring routine, a worked tracking table, and the open questions to raise with your acquiring bank.

Definitions
Will Customers Be Charged for UPI Payments? No — Here Is Exactly Who Pays What from 15 October 2026

Customers will not be charged for UPI payments under the framework notified for 15 October 2026. P2P transfers stay free, paying a merchant stays free at any amount, UPI apps cannot charge consumer platform fees, and merchants cannot pass their MDR on as a surcharge. Here is who pays what, in plain language.

How-To
UPI MDR 2026: The 0.4% P2M Merchant Charge Effective 15 October — Full Rate Schedule, Sector Overrides, P2PM Exemption, and Merchant Reconciliation Playbook

UPI MDR 2026 is the notified rate schedule that takes effect on 15 October 2026 for merchant (P2M) transactions on bank-account UPI: 0.4% flat between ₹2,000 and ₹75,000, capped ₹300 per transaction at or above ₹75,000, zero at or below ₹2,000, sector overrides for essential-services and capital-markets categories, a P2PM small-merchant exemption at or below ₹1 lakh/month inward UPI QR receipts, and explicit exemptions for UPI AutoPay and consumer-side transfers. The framework is currently subject to a pending Supreme Court challenge (PIL filed 16 September 2026). This is the full rate schedule, the primary-source citation trail, and the merchant reconciliation playbook for every UPI-heavy settlement file from October onward.

How-To
Education Services GST Exemption Notification 12/2017 SL 66 India

Education services GST exemption under Notification 12/2017-CTR Serial Number 66 covers services by an educational institution to its students, faculty and staff plus auxiliary transportation, catering, security, housekeeping, admission and examination services — but only for institutions inside the clause 2(y) three-limb definition (pre-school to higher secondary, recognised-qualification programmes, approved vocational courses). Coaching is expressly outside the exemption at SAC 999293 and 18% GST per CBIC Circular 55/29/2018-GST. The reconciliation break-point sits at three seams — the coaching-arm carve-out, guest-faculty Section 194J TDS and Notification 10/2017-IGST reverse charge on imported online courses.

How-To
FASTag Toll Reconciliation NHAI NPCI MID 3PL Fleet Operator India

The FASTag settlement stack an Indian 3PL fleet operator runs against on the monthly close is a four-body reconciliation — the IHMCL-issued Merchant ID (MID) at every plaza the truck crosses, the NPCI NETC switch that routes the debit from the plaza acquirer bank to the customer issuer bank, the T+1 to T+3 settlement window under the RBI Master Direction on Prepaid Payment Instruments, and the 72-hour dispute window for duplicate-charge, wrong-class and out-of-tag reversals. Layered on top, the toll-payment leg is GST-exempt under Notification 12/2017-Central Tax (Rate) Sl. No. 23, the convenience-fee leg is 18% GST under HSN 9967, and the outbound freight-bill against sub-contract carriers runs Section 194C TDS at 1% for individual or HUF carriers and 2% for others.

How-To
Freight Forwarder Ocean + Air GST Place of Supply Section 13(9) India

The Indian freight forwarder's monthly close is a five-place-of-supply cross-check on the same book. Ocean-import CIF pays IGST on the CIF value at the port of clearance under the Customs Tariff Act — but no separate IGST on the ocean freight component under RCM after Union of India v. Mohit Minerals (SC 2022) struck down Notification 10/2017-IGST entry 10. Ocean-import FOB and air-import into India fall under Section 13(2) recipient-location after Finance Act 2023 omitted Section 13(9), replacing the pre-October-2023 destination-of-goods rule. Air-export and ocean-export freight lost the Notification 9/2017-IGST entry 20A/20B zero-rating on 30 September 2022 and are taxable at 18 percent under HSN 9965 unless the recipient is outside India and the export-of-services test at Section 2(6) IGST is met. Domestic road GTA runs the Section 12(8) drill under Section 9(3) CGST RCM per Notification 13/2017-CT. Freight-forwarding-margin books under HSN 9967 support services at 18 percent forward charge on the forwarder's own account.

How-To
Joint Development Agreement TDR 18% RCM Notification 4/2019 India

A Joint Development Agreement between a landowner and a developer is one of the densest reconciliation surfaces in Indian real estate. Notification 4/2019-CTR (effective 1 April 2019) shifts the GST on Transferable Development Rights, additional Floor Space Index and long-term land lease to the developer under reverse charge at 18% — with the taxable value computed as the monetary consideration plus the fair market value of similar apartments in the project. Section 45(5A) defers the landowner's capital-gains trigger to the year the completion certificate is issued, Section 194-IC imposes 10% TDS on cash and kind consideration paid to the landowner, and the RERA Section 4(2)(l)(D) escrow rule keeps 70% of allottee collections inside the project account. A single missed CC-date crystallisation of the TDR RCM opens a Section 74 exposure that surfaces in GSTR-3B Table 3.1(d), the annual GSTR-9C reconciliation, and the RERA quarterly progress report.

How-To
Netflix Prime JioCinema OTT Settlement Reconciliation Section 194O India

A quarterly producer statement from Netflix, Amazon Prime Video and JioCinema lands in an indie content-studio's inbox, and the arithmetic behind the aggregate INR credit is a five-statute overlay: Section 194J royalty TDS at 10% (or 2% for cinematographic film royalty), Section 194O e-commerce TDS at 0.1%, Section 195 foreign remittance TDS with DTAA Article 12 royalty rates (15% India-US, 10% or 15% India-UK), residual equalisation levy considerations under the Finance Act 2016 as amended, and GST at 18% under SAC 998436. Netflix settles T+45, Prime T+30, JioCinema T+15, international-rights split T+90 — the reconciliation must decompose per contract, per platform, per revenue window, per statute.

Talk to the team

If you are evaluating TransactIG for reconciliation or TransactIQ for bank-statement intelligence, we will configure a working demo against your real patterns.