Reconciliation Software for Indian Real Estate Developers
Built for Indian residential and commercial developers: TDS on property purchase under Section 194IA (1% on ≥₹50 lakh consideration) and Section 195 (12.5% + surcharge + cess on NRI-seller transactions), RERA-mandated 70:30 escrow drawdown with engineer/architect/CA certification, GST classification across 1% affordable / 5% non-affordable / nil post-CC, Interest-Free Maintenance Deposit deposit-vs-consideration tracking, car parking + PLC composite supply, and cancelled-flat Section 34 credit note reversal. India-native by construction — the CC lifecycle, the escrow account, the TDS section split all baked into the variance taxonomy.
Six reconciliation surfaces built for developers
Each surface is independently complex — a full-time role of its own in a mid-sized development company. Together, they are the real estate finance and compliance workload. TransactIG handles all six on a single ingest, single variance taxonomy, single audit trail.
Section 194IA + Section 195 NRI TDS
Section 194IA obliges the buyer to withhold 1% on the entire consideration for any immovable property sold at ₹50 lakh or above, with Form 26QB filed within 30 days. Section 195 supersedes it when the seller is an NRI — the buyer must obtain a TAN, deduct at 12.5% plus surcharge (up to 15% on capital gains) plus cess on long-term gains, file Form 27Q instead of 26QB, and issue Form 16A. TransactIG classifies every sale into 194IA or 195, ties deducted TDS to the correct form, reconciles Form 26QB / 27Q entries against the developer's 26AS credit, and generates the NOC-issuance checklist the developer's legal team requires.
RERA escrow 70:30 drawdown discipline
Section 4(2)(l)(D) of the RERA Act 2016 requires 70% of allottee receipts to sit in a separate scheduled-commercial-bank escrow, drawable only against engineer, architect and chartered accountant certification of percentage complete (State-specific Form 3 / Form 5). Generic bank recon does not know about the 70:30 auto-split, the certification cap on drawdown, or the RERA cancellation-refund deduction ceiling. TransactIG models the escrow as a first-class construct — every receipt is auto-split 70:30, every withdrawal is tied to certification references, every refund is validated against the State's cancellation-deduction cap.
GST 5% / 1% / Nil classification
Indian residential real estate GST sits on three rails on one balance sheet under Notification 03/2019-CTR: 1% (without ITC) for affordable — carpet ≤60 sqm metro / ≤90 sqm non-metro and price ≤₹45 lakh; 5% (without ITC) for non-affordable under-construction; and nil (out of GST net under Schedule III) for units sold after CC / first occupancy. Commercial units under construction stay at 12% with ITC. Misclassification at the unit lifecycle boundary — a unit sold on the last day before CC vs the first day after — is a common revenue-leakage surface. TransactIG tags every collection line against the unit's live CC status, carpet-area threshold and base-price threshold.
IFMD deposit-vs-consideration tracking
Interest-Free Maintenance Deposit is the archetypal edge case in real estate GST. Collected as a refundable security to seed post-occupancy society maintenance, it is outside GST net if it is genuinely held on behalf of the residents' welfare association and returned on society formation. Consumed by the developer against maintenance services rendered, it becomes consideration under SAC 9987 and attracts 18% GST. The reconciliation surface is: was IFMD ever drawn against by the developer between OC receipt and society handover, and did the drawdown attract output tax? TransactIG tracks IFMD as a separate liability line at the unit level, flags any drawdown event, and reconciles output GST on drawn-down IFMD to GSTR-1.
Car parking + PLC composite supply
Car parking allotment, floor rise / preferential location charges (PLC), club membership, one-time maintenance and covered / open parking premium are typically bundled with the flat sale under a composite-supply construct where the principal supply is the flat and the ancillary charges inherit the flat's GST rate (1% affordable / 5% non-affordable / nil post-CC). Misclassification — treating parking as a standalone at 18% when it is composite at 5% — inflates output GST and creates a customer-refund liability. TransactIG models the sale as a composite supply, ties every ancillary charge to the principal flat's rate at the moment of sale, and reconciles composite output to GSTR-1 line-by-line.
Cancelled-flat reversal & credit note
When a customer cancels a booking, the developer must issue a GST credit note under Section 34 of the CGST Act (within the September-of-next-FY window), reverse the output GST reported in earlier GSTR-1 / GSTR-3B, refund the customer net of RERA-permitted cancellation deduction (typically capped at 10% of consideration under most State RERA rules), and unwind the 70% escrow entry with the RERA authority. TDS deducted under 194IA is not refundable to the buyer by the developer — the buyer must claim it in their own return. TransactIG builds the cancellation event as a state transition — outputs GSTR-1 amendment, GSTR-3B reversal ledger entry, escrow refund voucher with RERA reference, and customer refund voucher with deduction ceiling enforced.
What makes real estate reconciliation different from every other vertical
Indian real estate reconciliation sits at the intersection of three regulatory regimes on a single transaction — a triple-overlap that does not exist in any other vertical. When a customer pays the next milestone tranche on a ₹1.2 crore flat, the same one wire transfer triggers a RERA obligation (70% must land in escrow, drawable only against certified percentage complete), an Income Tax obligation (buyer must have withheld 1% under Section 194IA and filed Form 26QB, and the developer must claim the 26AS credit against the year's income), and a GST obligation (output GST at 1% / 5% / nil is triggered by the invoice tied to that tranche, with Rule 42/43 ITC reversal implications flowing at project level). Retail, manufacturing, jewellery — none of them have three simultaneous regulator-audited obligations firing off the same rupee. Real estate does.
Second, the transaction has two sides of tax obligation that must reconcile. On the buyer side, the flat purchase generates a Form 26QB filing under the buyer's PAN; downstream, when the buyer eventually claims the property against their income in a subsequent return, that filing anchors the acquisition cost. On the developer side, the same transaction is a revenue-recognition event under Ind AS 115 — where over-time recognition under paragraph 35(c) (control transferring to the customer over the construction period, given significant customisation and no alternative use) or point-in-time recognition at handover (once OC/CC received and possession transferred) drives when the revenue and its associated cost of construction are booked. Reconciling the buyer's 26QB filing (an event) to the developer's revenue schedule (an accrual) requires modelling both sides of the accounting boundary.
Third, the NRI compliance stakes are order-of-magnitude higher. On a ₹1.2 crore transaction from a resident seller, TDS is ₹1.2 lakh; the developer's exposure on getting it wrong is one processing form. On the same ₹1.2 crore transaction where the seller is an NRI (a sub-sale between an original allottee who has since relocated abroad and a new resident buyer, requiring the developer's NOC), TDS jumps to approximately ₹17.94 lakh under Section 195 with surcharge and cess, the buyer must obtain a TAN, and the developer's NOC issuance without verifying that TDS was correctly withheld exposes the developer to co-obligor risk under Section 201. This is a 15x delta on a single obligation — and a generic reconciliation tool that treats every property sale as Section 194IA misses it entirely.
Fourth, the ITC reversal on the CC boundary is proportionately punishing. A developer with 200 units in a project — 160 sold under-construction at 5% without ITC, 30 unsold at CC (which then sell as out-of-GST-net exempt supply under Schedule III), and 10 commercial units at 12% with ITC — must run Rule 42 monthly on inputs and Rule 43 monthly on capital goods, with the exempt-turnover-ratio driver changing every month as CC receipts unfold and unsold-post-CC inventory sells. The formula is simple; the discipline of running it correctly month after month against a moving denominator while tying every reversal to a specific GSTR-3B Table 4B(1) filing and a specific Form 3CD Clause 27(a) working paper is where most developers leak. Statutory audit invariably surfaces the reversal misapplication two years later, and the demand-cum-penalty cycle begins.
Fifth, the composite-supply construction around the flat sale is a first-class part of the invoice, not a footnote. Car parking allotment, PLC (floor rise / view / directional preferential location charges), club membership fee, one-time maintenance, covered vs open parking premium, external development charges (EDC), infrastructure development charges (IDC) — each of these has been contested in advance ruling and litigation on whether it is a composite supply (principal supply is the flat, ancillary charges inherit the flat's rate under Section 8 CGST) or a mixed supply (invoiced separately, each at its standalone rate — parking at 18% under SAC 9967, club membership at 18% under SAC 9995). The safe treatment for most residential ancillaries where they are non-optional bundled with the flat is composite supply, but the classification is not automatic and the wrong call inflates output GST by 13 percentage points on the ancillary component. TransactIG models the sale as a composite supply with configurable line-item overrides where the developer has a specific advance ruling for their project.
Same ₹1.2 crore flat, resident vs NRI seller — a 15x TDS delta
The same ₹1.2 crore property transaction with a resident seller falls under Section 194IA at 1% (₹1.2 lakh TDS). The same transaction with an NRI seller falls under Section 195 at 12.5% LTCG plus 15% surcharge (capped for capital gains) plus 4% health & education cess — effective ~14.95%, or ₹17.94 lakh TDS. Getting this classification wrong on NOC issuance exposes the developer to co-obligor risk under Section 201 of the Income-tax Act.
| Line item | Resident seller (Section 194IA) | NRI seller (Section 195) |
|---|---|---|
| Property consideration | 1,20,00,000 | 1,20,00,000 |
| Applicable section | Section 194IA | Section 195 |
| Base TDS rate | 1% | 12.5% (LTCG) |
| Surcharge on TDS | Nil | 15% (property >₹1cr, LTCG cap) |
| Health & education cess | Nil | 4% |
| Effective withholding rate | 1.00% | 14.95% |
| TDS withheld by buyer (₹) | 1,20,000 | 17,94,000 |
| Filing form | Form 26QB | Form 27Q |
| Buyer requires TAN? | No (PAN sufficient) | Yes (TAN mandatory) |
| Certificate to seller | Form 16B | Form 16A |
| Filing timeline | 30 days from month-end | 7 days from month-end |
| Lower-deduction relief route | Not typically applicable | Form 13 → Section 197 certificate |
Illustrative. NRI seller rate assumes long-term capital gain (holding period over 24 months). Short-term gains are taxed at the NRI's slab rate. Surcharge is capped at 15% for capital gains regardless of consideration; base surcharge on other income above ₹5 crore is 37%. The NRI can apply for a lower-deduction certificate under Section 197 via Form 13. Consult a tax adviser for specific transactions.
Real estate reconciliation surfaces vs generic reconciliation software
How each of the six real estate reconciliation surfaces is handled by generic horizontal reconciliation software (ERP-bundled or standalone), versus TransactIG's India-native, real-estate-aware variance taxonomy.
| Dimension | Generic reconciliation software | TransactIG |
|---|---|---|
| TDS on property purchase | Applies a single TDS rate — either 1% under 194IA universally, or requires manual handoff to tax team when the buyer/seller is an NRI. Form 26QB vs Form 27Q classification is a spreadsheet-side reconciliation performed after the return is filed. | Every sale classified at booking-form save into Section 194IA (resident, ≥₹50L) or Section 195 (NRI seller). Rate model computes surcharge tier (10/15/25/37%) automatically. Form 26QB and Form 27Q entries auto-generated; 26AS credit tied back per transaction; NOC checklist evidence produced. |
| RERA escrow discipline | Bank statement reconciled to invoice numbers. No concept of 70% escrow account split, no engineer/architect/CA certification tie to withdrawals, no RERA cancellation-deduction cap enforcement on refunds. | Every allottee receipt auto-split 70:30 across escrow and operating accounts at clearing. Every escrow withdrawal tied to engineer + architect + CA certificate reference and percentage-complete from project management. Refunds validated against State-specific cancellation deduction cap. |
| GST across CC lifecycle | Single GST rate applied to a project's output. Unit lifecycle transition (under-construction → OC → CC → post-CC sale) not modelled; the 5%/1%/nil rail switch at CC boundary is a monthly manual reclassification exercise. | Every unit modelled as a state machine — under-construction (1%/5%) → OC/CC received → post-CC sale (out of GST). Rule 42/43 proportionate ITC reversal computed monthly. GSTR-3B Table 4B(1) tie-back per project. Annual true-up working paper generated. |
| IFMD & society handover | IFMD booked as a single deposit liability. Drawdown events not flagged; GST implications on consumed-IFMD not tracked. Society handover receipt not tied to the balance write-off. | IFMD tracked as a separate unit-level liability. Any drawdown flagged for GST-consideration classification (SAC 9987 at 18%). Society handover receipt tied to residual balance write-off. GSTR-1 output GST on drawn-down IFMD reconciled per project. |
| Composite supply (parking/PLC) | Parking, PLC, club and IFMD may be invoiced at standalone rates (18%) even where the principal supply is the flat. Output GST inflated; customer refund liability created on discovery. | Sale modelled as composite supply under Section 8 CGST. Ancillary charges (parking, PLC, club, one-time maintenance) inherit the principal flat's rate at booking. Composite output tied to GSTR-1 line-by-line. |
| Cancellation reversal | Cancellation refund processed as a standalone customer refund. GSTR-1 amendment and GSTR-3B reversal are separate manual steps. Escrow refund entry disconnected from the RERA compliance ledger. 194IA TDS treatment on cancellation not documented. | Cancellation event is a modelled state transition. Section 34 credit note auto-issued (within the September-of-next-FY window). GSTR-1 amendment and GSTR-3B reversal chained. Escrow refund voucher tied to RERA compliance ledger. RERA cancellation deduction cap enforced. |
Six reasons Indian real estate developers choose TransactIG
A multi-pass matching engine trained on the real estate variance taxonomy — not a generic reconciliation tool with a real estate skin.
Section 194IA and Section 195 handled as first-class primitives
Every property sale classified at booking-form save into resident (194IA, 1%) or NRI seller (195, up to 14.95% effective). Form 26QB / 27Q auto-generated with correct surcharge tier and cess. NOC checklist evidence produced for the legal team.
RERA escrow as a first-class construct
70:30 auto-split at clearing, withdrawal tied to engineer / architect / CA certification, refunds validated against State-specific cancellation deduction cap. State RERA Authority-defensible ledger delivered quarterly.
Unit lifecycle CC state machine
Every unit is a state machine — under-construction → OC/CC → post-CC. GST rail (5%/1%/nil) switches automatically at boundary; Rule 42/43 ITC reversal computed monthly; Section 17(5) exempt-turnover-ratio applied to common ITC.
IFMD deposit-vs-consideration tracking
IFMD tracked as a separate unit-level liability. Any drawdown event flagged and evaluated for SAC 9987 at 18% GST consideration classification. Society handover receipt closes the loop.
Composite supply for parking + PLC + club
Sale modelled as composite supply under Section 8 CGST. Car parking, PLC, club, one-time maintenance inherit the principal flat's rate — no accidental standalone-at-18% classification, no customer refund liability.
Cancellation reversal chained end-to-end
Section 34 credit note within the September-of-next-FY window, GSTR-1 amendment, GSTR-3B reversal, escrow refund voucher and customer refund with RERA deduction cap — all chained as one state transition.
Related real estate reconciliation insights
Fourteen cornerstone articles on real estate reconciliation surfaces — each anchored to a specific Indian tax code, RERA provision or accounting standard.
Frequently Asked Questions
How does TDS Section 194IA on property purchase reconciliation actually work for a developer? +
Section 194IA of the Income-tax Act obliges the buyer of any immovable property (other than agricultural land) with a consideration of ₹50 lakh or more to deduct TDS at 1% on the entire consideration — not just the excess above ₹50 lakh — at the earlier of credit or payment. The buyer files Form 26QB (challan-cum-statement) within 30 days of the end of the month of deduction, and issues Form 16B to the seller (the developer). From the developer's side, reconciliation runs across four surfaces: (1) the collection ledger, where the flat sale price is booked in tranches against a Booking Application Form (BAF) or Agreement to Sell (ATS) milestone schedule; (2) the buyer's Form 26QB filing, where the developer's PAN, the flat's address and the consideration must match; (3) Form 16B TDS certificates received, which must tie to the year's 26AS credit under the developer's PAN; and (4) the RERA-mandated separate bank account, where the customer's 99% net-of-TDS remittance must flow before the developer can draw down. TransactIG ingests the milestone-linked collection schedule from the sales CRM, the Form 26QB TDS challan file, Form 16B PDFs, and the RERA escrow bank statement — and produces a per-buyer, per-tranche reconciliation with 26AS tie-back, the standard Form 3CD Clause 34(a) working paper the tax audit team requires.
What is different when the buyer is an NRI — how does Section 195 change the reconciliation? +
Section 195 governs TDS on any sum paid to a non-resident that is chargeable to tax in India, and it materially changes both the rate and the mechanics compared with Section 194IA. When an NRI seller transfers immovable property to a resident (or non-resident) buyer, the buyer must deduct TDS under Section 195 — not Section 194IA — regardless of the ₹50 lakh threshold. The rate for long-term capital gains (property held over 24 months) is 12.5% plus applicable surcharge and cess (from the July 2024 Finance Act rate rationalisation, replacing the earlier 20%); for short-term gains it is at the NRI's slab rate. Surcharge kicks in progressively: 10% above ₹50 lakh, 15% above ₹1 crore, 25% above ₹2 crore, 37% above ₹5 crore (capped at 15% for capital gains). On a ₹1.2 crore property sold by an NRI at long-term-gain rates, effective TDS is approximately 14.95% (12.5% + 15% surcharge + 4% cess) — meaning the buyer withholds around ₹17.94 lakh, versus ₹1.2 lakh under Section 194IA for a resident seller. The buyer must obtain a TAN, file Form 27Q (not 26QB), and issue Form 16A. The NRI can reduce the withholding by filing Form 13 with the Assessing Officer for a lower-deduction certificate under Section 197. From the developer perspective, when the seller (of an under-construction unit being resold) is an NRI, or when a sub-sale between original allottees involves an NRI, the developer's NOC-issuance process must verify that TDS under Section 195 was properly withheld before recording the transfer. TransactIG classifies every buyer-side sale into Section 194IA (resident, ≥₹50L) or Section 195 (NRI seller), ties the deducted TDS to the correct form (26QB vs 27Q), and produces the NOC checklist evidence for the developer's legal team.
How does RERA escrow account reconciliation work and why can't a generic bank recon handle it? +
Under Section 4(2)(l)(D) of the Real Estate (Regulation and Development) Act 2016 and the corresponding State RERA rules, a promoter must deposit 70% of the amounts realised from allottees in a separate bank account (the 'RERA account' or 'designated separate account') maintained in a scheduled commercial bank, to cover the cost of construction and the land cost, and withdraw amounts in proportion to the percentage of completion of the project. The remaining 30% may be transferred to the promoter's general operating account for overheads and profits. Withdrawal from the 70% RERA escrow is not free — it requires certification by (a) an engineer certifying the percentage of physical construction completion, (b) an architect certifying the project stage, and (c) a chartered accountant certifying the proportionate cost incurred against the amount being withdrawn (State-specific form; commonly Form 3 or Form 5 depending on the State). Generic bank reconciliation software ties bank credits to invoice numbers and marks matched — it has no concept of 'is this withdrawal proportionate to certified percentage complete', 'is this credit correctly split 70:30 between escrow and operating', 'is this refund on cancelled flat coming back from escrow with correct RERA-permitted deduction'. TransactIG models the RERA escrow as a first-class construct: every buyer receipt is auto-split 70:30 across the two accounts at the moment of clearing; every withdrawal is tied to an engineer/architect/CA certificate reference and a percentage-complete number sourced from the project management module; every refund is validated against the RERA cancellation deduction cap (typically 10% of consideration for post-agreement cancellation, State-specific). The audit output is a State-RERA-Authority-defensible ledger the promoter's compliance officer files quarterly.
How does GST reconciliation work across under-construction, ready-with-CC, and Interest-Free Maintenance Deposit line items? +
Indian residential real estate GST sits on three rate rails on the same developer's balance sheet, and misclassification between them is one of the most common revenue-leakage surfaces. (1) Under-construction affordable housing (unit carpet area ≤60 sqm in metros / ≤90 sqm elsewhere and price ≤₹45 lakh) attracts GST at 1% without input tax credit (ITC) under Notification 03/2019-CTR effective 1 April 2019. (2) Under-construction non-affordable residential attracts 5% without ITC under the same notification. (3) Completed residential units — where the Completion Certificate (CC) or first occupancy has been received before the sale — are treated as sale of immovable property and attract nil GST (out of GST net entirely) under Schedule III of the CGST Act. (4) Commercial units under construction attract 12% with ITC. (5) Ancillary charges bundled with the flat — car parking allotment, floor rise / PLC (preferential location charges), club membership, one-time maintenance, IFMD — often follow the composite-supply rule where the principal supply is the flat, and inherit the flat's rate. Interest-Free Maintenance Deposit (IFMD) is the classic edge case: if collected and refunded on society formation with no service supplied, it is a security deposit outside GST net; if consumed by the developer against maintenance services already rendered, it becomes consideration and attracts GST at 18% under SAC 9987. The reconciliation surface is: was IFMD ever drawn against by the developer? Did the customer sign a residential welfare association handover receipt? TransactIG tags every collection line-item against unit CC status, unit affordable-vs-non-affordable status (carpet area, base price), composite-vs-mixed supply classification for parking/PLC/club, and IFMD deposit-vs-consideration status — producing a per-project, per-quarter GST outward-supply reconciliation to GSTR-1 filed and a per-project ITC reversal working paper for units transitioning across the CC line.
Why can't ITC be claimed on units sold after Completion Certificate, and how does the ITC reversal reconciliation work? +
Since 1 April 2019, under Notification 03/2019-CTR, the new residential GST rate scheme (1% for affordable / 5% for non-affordable) came bundled with the withdrawal of input tax credit. Section 17(5)(c) and (d) of the CGST Act, read with Rule 42/43 of the CGST Rules, deals with proportionate ITC reversal. The mechanic is this: a developer running a project with a mix of under-construction sold units (in GST net at 1% / 5% without ITC), unsold-post-CC units (out of GST net entirely — sale of immovable property under Schedule III), and possibly commercial units (12% with ITC) cannot claim full ITC on cement, steel, tiles, sanitary ware, elevators, project management consultancy, architect fees etc. The ITC available must be proportionately reversed for the portion attributable to (a) exempt supplies (post-CC residential sales) and (b) the 1%/5% residential supplies that are without ITC. Rule 42 governs the reversal on inputs and input services (attributed to unit-level construction); Rule 43 governs the reversal on capital goods (project-level infrastructure). The formula: ITC to be reversed = ITC common × (exempt turnover ÷ total turnover), computed monthly and annualised at year-end with a true-up. Generic reconciliation software has no visibility into the unit-CC-status lifecycle transition, so it cannot compute the exempt-turnover-ratio driver correctly. TransactIG models every unit as a state machine — under-construction → OC/CC received → post-CC-sale → out-of-GST — and computes the monthly Rule 42 / Rule 43 reversal against the unit-count-and-value denominator, ties the reversal to GSTR-3B Table 4B(1) filing, and produces the annual true-up working paper the statutory audit team files with Form 3CD Clause 27(a).
Stop treating real estate reconciliation as three spreadsheets and a prayer
TransactIG ingests your sales CRM (Farvision, In4Velocity, Highrise, custom), Form 26QB / 27Q TDS challan file, Form 16B / 16A PDFs, RERA escrow bank statement, project management percentage-complete feed, GSTR-2B download and cost-of-construction ledger in their native formats. Six real estate reconciliation surfaces, one variance taxonomy, one audit pack. ISO 27001:2022 certified. Multi-pass matching engine trained on the Indian real estate variance taxonomy.