The Noida developer and the quarterly RERA reconciliation (Quick)
🏢 Rohan Mehta, 42, runs Yamuna Crown Developers with two RERA-registered projects and an escrow account that is the linchpin of regulatory compliance. By law, the company secretary manages the board resolutions. The CA prepares the financials. The independent auditor certifies the numbers. In theory, three people watching. In practice: the CS assumed the CA was tracking it, the CA assumed the CS had a board resolution, the auditor arrived to find four unreconciled July transfers and a ₹6.1-lakh NEFT to the main account without RERA Form 5 approval.
🚨 The problem
RERA Section 37 violation: escrow transfers without prior Form 5 approval trigger ₹5 lakh penalties. RERA Section 38 violation: if funds are diverted, registration can be suspended and homebuyers can demand refunds of all units. The violation was on the bank statement. It was unreconciled because nobody was explicitly responsible for reconciling it weekly. The gap is baked into every real estate company with a CS, CA, and independent auditor who do not sit at the same desk.
🚀 How GabFORGE helped
Rohan told his team: deploy an agent on a Google Sheet. Daily SBI transactions sync in. The agent cross-checks them against board resolutions and unit-sale vouchers. Every Friday evening: one-page reconciliation report flagging any unmatched transfers. The agent found six items on the first run: the ₹6.1-lakh violation, four other unmatched July transfers, two August cheques not yet posted.
- 🔍 Daily visibility. Scanned SBI statements and flagged every transaction not matched to a resolution or invoice.
- 🗂️ Weekly reconciliation. Generated Friday reports showing opening balance, inflows, releases, closing balance — so CS, CA, and auditor saw the same picture.
- 📞 Identified gaps. Found the July board resolution approving the disputed refund, located contractor invoices for other transfers, caught a duplicate voucher Arun had entered twice.
✅ Rohan and Vikram spent six hours reconciling October 25–26. Found all documents. Called the auditor Neelam with a complete paper trail. Filed Q3 audit on November 8 — nine days early — with a remediation letter disclosing the Section 37 violation and the new reconciliation process. RERA acknowledged. No penalty.
🇮🇳 Why this matters
The Amrapali collapse was a reconciliation failure at scale. RERA strengthened Section 4 (escrow rules) to prevent it, but the law cannot prevent what happens in the gap between the SBI statement and the spreadsheet where the CS writes down vouchers by hand. An agent that mirrors the account three times a week — and breaks its silence to flag unmatched items — is what turns the gap into visibility.
The long version includes the moment Rohan called Neelam Sharma and said "I have a principle," and the remediation letter that disclosed the mistake before RERA discovered it.