Accounts Receivable Executive / Senior Executive

Keystone Realtors; Mumbai; On-site; INR 1,800,000 - 2,400,000; Full time

Job summary

Keystone Realtors is seeking a skilled finance professional to own MIS reporting, AR aging, and cash-flow tracking for real estate projects. You will collaborate with Sales Support, CRM, Legal, and Treasury to monitor milestones, resolve payment disputes, and ensure accurate postings in SAP FI.

The role requires strong advanced Excel capabilities, SAP FI proficiency, and deep knowledge of RERA, milestone billing, and tax compliance (TDS, GST). Mumbai-based, on-site work.

Qualifications

• Experience building financial MIS reports, AR aging trackers, and executive variance decks using Advanced Excel.
• Hands-on experience with SAP FI Module, WBS mapping, financial document posting, and customer master creation.
• In-depth understanding of real estate revenue accounting, RERA guidelines, milestone billing schedules, and customer collection workflows.
• Strong working knowledge of Income Tax Section 194IA (TDS on immovable property), GST, and Companies Act 2013 related-party regulations.

Responsibilities

• Prepare monthly and quarterly MIS collection dashboards with variance analysis.
• Monitor AR aging portfolios, track overdue accounts, and recommend recovery actions.
• Post FI entries in SAP for customer accounting, credit notes, revenue entries, and project adjustments.
• Manage customer/master data creation and vendor setup in SAP with statutory compliance.
• Track cash flow and DM fee collections to support treasury and working capital planning.
• Coordinate with Sales Support, CRM, Legal, and Treasury to resolve disputes and ensure compliance.

Skills

MIS & Analytics

System Expertise

Domain Knowledge

Taxation & Compliance

Interpersonal Skills

Tools

SAP FI Module

Advanced Excel

Job description

Role & responsibilities

1. MIS Reporting & Collection Review

• Collections Dashboard & Variance Analysis:Prepare monthly and quarterly MIS collection dashboards, analyzing project-wise collection targets vs. actual inflows, identifying collection shortfalls, and highlighting variance drivers (e.g., milestone delays, customer defaults, cancellations, etc.).
• Accounts Receivable (AR) Aging Management:Maintain and monitor AR aging portfolios across project categories. Track overdue accounts, highlight high-risk non-recoverable cases, and recommend targeted recovery interventions.
• Cash Flow & Revenue Realisation Tracking:Monitor month-on-month cash realisations, track Development Management (DM) fee collections, and assist in forecasting monthly cash inflows to support treasury and working capital planning.
• Cross-Functional Coordination:Collaborate with Sales Support, CRM, Legal, and Treasury teams to track milestone completion, resolve payment disputes, and streamline loan sanction/disbursement processes.

2. Customer Accounts & Possession Clearances

• Financial Clearances:Review and issue final financial clearance certificates for customer flat possessions across projects.
• Maintenance & Fitout Deposit Accounting:Verify and clear customer receipts for maintenance charges, fitout deposits, and interest ledger adjustments in SAP.
• Waivers & Approvals:Coordinate multi-level executive approvals for waivers, interest write-offs, and fee adjustments prior to issuing possession clearances.

3. SAP Financial Entries & System Operations

• FI Document Posting:Execute financial postings (FI entries) in SAP for customer accounting, credit notes, revenue entries, and project adjustments.
• Master Data Creation:Manage customer code creation and vendor setup in SAP for refunds, ensuring strict adherence to statutory compliance (e.g., Related Party Declarations under the Companies Act 2013).
• KYC & Customer Records Management:Review legal documentation (Aadhaar, PAN) for customer name modifications and ensure system consistency prior to cheque generation or clearance.

4. Statutory Compliance (TDS & GST)

• TDS Verification:Cross-verify customer TDS certificate submissions (Form 132 / Form 168 / Form 26QB) against internal tax ledgers before releasing NOCs or possession approvals.
• Tax Accounting:Ensure precise accounting of GST, and TDS liabilities across group entities and SPVs

5. Refunds Management

• Customer Refunds:Track, process, and reconcile customer refunds (cancellations, excess payment adjustments, and online transaction refunds via gateway TIDs/RRs).
• Audit & Compliance Support:Gather undertakings, cancelled cheques, and customer declarations required by internal and external auditors before payment disbursements.

6. Legal & Regulatory Tracking

• Disputed Case Monitoring:Coordinate with the legal department to maintain MIS tracking on defaulted units, active customer litigations (RERA, High Court appeals, etc.), and order execution statuses.
• Restricted Ledger Controls:Enforce financial locks on units under legal proceedings to prevent unauthorized possession clearances or refund processing.

Preferred candidate profile

• MIS & Analytics:Expertise in building financial MIS reports, cash flow forecasting models, AR aging trackers, and executive variance decks using Advanced Excel.
• System Expertise:Hands-on experience withSAP (FI Module), WBS mapping, financial document posting, and customer master creation.
• Domain Knowledge:In-depth understanding of real estate revenue accounting, RERA guidelines, milestone billing schedules, and customer collection workflows.
• Taxation & Compliance:Strong working knowledge of Income Tax Section 194IA (TDS on immovable property), GST, and Companies Act 2013 related-party regulations.
• Interpersonal Skills:Proven ability to coordinate across cross-functional teams (Sales Support, CRM, Treasury, Legal, and Senior Leadership) to drive collection catch-ups and operational efficiency.