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.
Four entry points
1092+ articles on Indian reconciliation: TDS, GST, NACH, banking, platform settlement, manufacturing, auto components.
Free browser-based calculators: RMPV, ITC-04 tracker, three-way-match cost, FASTag, FI steel yield, 90+ GST rate finder.
ERP and payment-gateway connectors: SAP, Oracle, Tally, D365, Razorpay, PayU, Cashfree.
Side-by-side reads of TransactIG / TransactIQ vs Perfios, Finbox, HighRadius, BlackLine, Cointab, Precisa, FinFriend, ScoreMe.
Latest from the insights library
Ambulance service GST classification is a five-way split — patient transport by hospital ambulance is exempt under Notification 12/2017-CTR SL 74(b), commercial ambulance-on-hire is 18% under SAC 9964/9966, contractor-leased ambulances hit hospitals with 18% input GST that is blocked as ITC under Section 17(5)(b), government-funded 108 and CATS services are exempt as constitutional welfare, and composite bundling with hospital medical services rides on the healthcare exemption. The reconciliation break-point is at the ambulance-contractor invoice, not the patient bill.
The 1 April 2019 rate switch collapsed the old 12%/8% + ITC regime into a new 5%/1% no-ITC regime for under-construction residential real estate. The 1% affordable-housing rate carries a dual test — carpet area under 60 sq mtr (metro) or 90 sq mtr (non-metro) AND transaction value at or below Rs 45 lakh — and misclassification either way triggers a reconciliation break that surfaces in the annual GST return, in the RERA escrow withdrawal, and in the customer's Section 194-IA TDS position.
A single Flipkart Seller Central bank credit bundles at least nine deduction lines — category commission, GST on commission, MDR/collection fee, Flipkart shipping (F-Assured), platform/fixed fee, reserve/rolling hold, refund netting, Section 194O TDS at 0.1%, and Section 52 CGST TCS at 0.5%. Section 194Q sits on the buyer side of any Rs 50 lakh+ B2B trail. The reconciliation is not the total; it is the per-order decomposition against the settlement report, the GSTR-8 filed by Flipkart, and the Form 26AS Part F/G under the seller's PAN.
The Indian gold-loan product mixes four structural choices that every reconciliation cycle must reconcile: bullet versus EMI, tenure options from 3 to 24 months, no-penalty mid-tenure part-payment (unusual across retail lending), and tenure rollover under a fresh RBI 75% LTV re-appraisal. Interest recognition — simple interest versus Ind AS 109 EIR — is the accounting-policy choice that decides whether the residual after a part-payment is booked correctly.
Gold-loan NBFCs charge 18% GST on the processing fee, appraisal fee and defaulted-loan auction fee, but interest income on the loan itself is exempt from GST under Notification 12/2017-CTR SL 27. The correct reconciliation splits the fee-income leg from the interest-income leg, applies the Section 17(4) 50% ITC reversal, and layers Section 194A TDS on FD-collateral interest — a four-way split that the retail-branch collection sheet almost never captures cleanly.
The Section 54(3) CGST Act refund of accumulated ITC on account of inverted duty structure has three moving parts most textile controllers get wrong on the first filing — the Rule 89(5) formula that carries only input goods and not input services after the VKC Footsteps Supreme Court decision, the Notification 5/2017-CT list that historically blocked fabric refund and was fully rescinded for chapter 50–55 fabric by Notification 15/2021-CT effective 1 January 2022, and the Section 54(6) provisional 90% refund that a compliance-rated exporter should receive within seven days of the RFD-01 acknowledgement. Get all three lined up on a monthly cadence and the eligible refund converts to bank cash; miss the two-year window under Section 54(1) and the amount is trapped in the electronic credit ledger with no recovery path.
For a hospital, GST paid on a medical device is not recoverable input tax credit — healthcare service under Entry 74 of Notification 12/2017-CTR is exempt, and Section 17(2) read with Rule 43 forces proportionate ITC reversal to the extent of exempt supply. A misclassification from 5 percent to 18 percent on a Rs 45 lakh MRI machine converts a Rs 2.25 lakh cost into a Rs 8.1 lakh cost — permanently.
The Electronic Credit Ledger on the GST portal shows Rs 45 lakh of accumulated input tax credit that has no output tax to absorb. The output supplies are zero-rated exports, or the input rate is higher than the output rate on an inverted duty structure, or a genuinely excess payment has piled up over several months. Section 54(3) of the CGST Act opens a refund route for exactly this situation — but only on Form GST RFD-01, only within the 2-year time bar, and only into a bank account (the balance cannot be re-credited to the ledger). This is the walkthrough.
The draft financials show a Rs 45 lakh customer lawsuit. The legal team says the payout is roughly 30 per cent likely. The CFO wants to know whether the item belongs as a provision on the balance sheet or a contingent liability in the notes — and whether the classification changes if a court order arrives. This is the three-test walkthrough under Ind AS 37, the Section 37 IT Act deductibility angle, and the common items where the classification is a recurring judgement call rather than a mechanical rule.
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.