MAVIX ESTATE
COMMAND CENTRE
🔍
A
Arvind Rao
Super Admin
Notifications 5
Good Morning, Managing Director
Consolidated operating position — Aarohan Realty & Infrastructure Ltd.
Portfolio Value
₹486.40 Cr
↑ 2.3% vs last month
Project Cost
₹312.75 Cr
→ On Budget
Booking Value
₹321.80 Cr
↑ ₹18.65 Cr this month
Amount Collected
₹204.65 Cr
↑ ₹14.28 Cr this month
Pending Receivables
₹117.15 Cr
↑ 3.1% overdue growth
Vendor Payable
₹28.42 Cr
→ Within 30 days
Cash & Bank
₹34.86 Cr
↑ ₹4.46 Cr net inflow
RERA Account
₹51.27 Cr
→ Across 3 projects
Physical Progress
57.8%
↑ 3.2% this month
Financial Progress
61.4%
↑ 2.8% this month
Projected Margin
₹93.15 Cr
↑ 18.5% ROI
Active Approvals
17
⚠ Action Required
Project & Site Overview
● On Track
Aarohan Grande
📍 Kharadi, Pune | Premium Residential | 4 Towers
68%
Financial Progress71%
CompletionDec 2027
ManagerRohan Kulkarni
288
Total
214
Booked
62
Available
7
Blocked
💰 Collected: ₹94.25 Cr
⚠ Pending: ₹48.80 Cr
👷 284 Workers
🚨 7 Issues
Stage: Superstructure
⚠ Attention Required
Aarohan Business Bay
📍 Baner, Pune | Commercial Development | 2 Towers
52%
Financial Progress58%
CompletionJun 2028
ManagerSneha Deshmukh
160
Total
103
Booked
49
Available
6
Blocked
💰 Collected: ₹72.40 Cr
⚠ Pending: ₹35.65 Cr
👷 196 Workers
🚨 11 Issues
Stage: Structural Work
🔴 Delayed
Aarohan Serenity
📍 Wakad, Pune | Mid-Premium Residential | 3 Towers
39%
Financial Progress43%
CompletionMar 2029
ManagerAditya Joshi
200
Total
104
Booked
85
Available
5
Blocked
💰 Collected: ₹38.00 Cr
⚠ Pending: ₹32.70 Cr
👷 143 Workers
🚨 14 Issues
Stage: Podium/Structural
Monthly Inflow vs Outflow (₹ Cr)
Sales Bookings — Last 6 Months
Project Cost vs Budget
Physical vs Financial Progress
Receivables Ageing
Organization Snapshot
186
Total Employees
171
Present Today
Corporate Office62 employees
Site Deployment124 employees
On Leave Today9
Absent Today6
Open Tasks148
Overdue Tasks23
Departments17
🤖 AI Operations Live
All Systems Active
🧠 AI Enquiry Agent
● Active
💬 AI Collection Reminder
● Active
🏗 AI Site Delay Detection
● Active
🔍 AI Expense Anomaly Scanner
⚠ 3 Flags Today
📦 AI Material Shortage Predictor
⚠ 2 Alerts
🏢 AI Vendor Risk Monitor
● Active
📋 AI Daily Management Brief
Generated 8:30 AM
📨 43 enquiries handled | 🎯 17 leads qualified
📅 11 site visits scheduled | 💌 28 payment reminders
💰 ₹42.50L dues followed up | 🚩 3 anomalies flagged
📅 11 site visits scheduled | 💌 28 payment reminders
💰 ₹42.50L dues followed up | 🚩 3 anomalies flagged
Company ERP
Aarohan Realty & Infrastructure Ltd. — Corporate Operations
Overview
Project Portfolio
Approvals 17
Legal & Compliance
Vendor Management
Procurement
Documents
Reports
Audit Trail
Total Revenue
₹204.65 Cr
↑ 12.4% YoY
Operating Expenses
₹16.84 Cr
→ Within budget
Pending Approvals
17
⚠ Action needed
Key Compliance
3 Expiring
⚠ Review required
Monthly P&L Summary
Key Risks
Site C Delay Risk
12-day projected delay affecting Q1 2029 handover
Collection Lag
₹24.8 Cr overdue >60 days across projects
RERA Withdrawal Pending
₹4.85 Cr withdrawal awaiting compliance clearance
Site A On Track
68% physical progress, 71% financial — performing well
| Project | Type | Total Value | Cost Budget | Physical% | Financial% | Units | Booked | Collected | Pending | Completion | Status | Action |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Aarohan Grande Kharadi, Pune | Premium Residential | ₹218.60 Cr | ₹139.40 Cr | 68% | 71% | 288 | 214 | ₹94.25 Cr | ₹48.80 Cr | Dec 2027 | On Track | |
| Aarohan Business Bay Baner, Pune | Commercial | ₹174.80 Cr | ₹111.25 Cr | 52% | 58% | 160 | 103 | ₹72.40 Cr | ₹35.65 Cr | Jun 2028 | Attention | |
| Aarohan Serenity Wakad, Pune | Mid-Premium Residential | ₹93.00 Cr | ₹62.10 Cr | 39% | 43% | 200 | 104 | ₹38.00 Cr | ₹32.70 Cr | Mar 2029 | Delayed |
Pending Approvals 17
Legal & Compliance Register
| Document | Project | Authority | Issue Date | Expiry Date | Status | Action |
|---|---|---|---|---|---|---|
| RERA Registration | Aarohan Grande | MahaRERA | 15 Jan 2023 | 31 Dec 2027 | Valid | |
| RERA Registration | Business Bay | MahaRERA | 03 Apr 2023 | 30 Jun 2028 | Valid | |
| RERA Registration | Aarohan Serenity | MahaRERA | 18 Sep 2023 | 31 Mar 2029 | Valid | |
| Environmental Clearance | Aarohan Grande | MoEF | 22 Nov 2022 | 22 Nov 2027 | Expiring Soon | |
| Building Plan Approval | Business Bay | PMC | 14 Mar 2023 | 14 Mar 2026 | Expiring Soon | |
| Fire NOC | Aarohan Grande | CFO Pune | 05 Jun 2024 | 05 Jun 2026 | Expiring Soon | |
| Insurance — Project | All Projects | HDFC ERGO | 01 Apr 2025 | 31 Mar 2026 | Pending Renewal | |
| Commencement Certificate | Aarohan Serenity | PMRDA | — | — | Pending | |
| Occupancy Certificate | Aarohan Grande T1 | PMC | — | — | Not Applied | |
| Land Title — Kharadi | Aarohan Grande | Sub-Registrar | 12 Aug 2021 | Perpetual | Clear |
| Vendor Code | Vendor | Category | Projects | Purchase Value | Outstanding | Quality Score | Risk | Action |
|---|
Open POs
24
POs Pending Approval
7
This Month PO Value
₹8.42 Cr
Delivered GRNs
18
| PO No. | Vendor | Material | Project | Value | Date | Delivery | Status | Action |
|---|---|---|---|---|---|---|---|---|
| PO-2026-0284 | Tata Steel Ltd. | TMT Steel Fe500 | Site A | ₹42.80 L | 12 Jun 2026 | 25 Jun 2026 | Pending Approval | |
| PO-2026-0283 | UltraTech Cement | OPC 53 Grade Cement | Site B | ₹18.60 L | 10 Jun 2026 | 18 Jun 2026 | Delivered | |
| PO-2026-0282 | Prime Aluminium | Aluminium Sections | Site A | ₹32.40 L | 08 Jun 2026 | 30 Jun 2026 | In Transit | |
| PO-2026-0281 | AquaFlow Plumbing | CPVC Pipes & Fittings | Site C | ₹9.85 L | 05 Jun 2026 | 15 Jun 2026 | Delivered | |
| PO-2026-0280 | Spark Electricals | LT Power Cables | Site B | ₹24.70 L | 02 Jun 2026 | 20 Jun 2026 | Partial |
📁
RERA Documents
Registration, Extensions, Reports
12 files
⚖️
Legal & Title
Land title, agreements, NOCs
28 files
💼
Finance Documents
Audit reports, bank docs, tax
45 files
📐
Drawings & Approvals
Architectural, structural, MEP
186 files
📝
Contracts & Agreements
Vendor, contractor, customer
64 files
🛡️
Insurance
Project, workmen, property
8 files
📊 Executive Business Report
Complete company performance summary
🏗 Project Progress Report
Site-wise physical & financial progress
💰 Sales Report
Bookings, collections, pending dues
💳 Cash Flow Report
Monthly inflow, outflow & forecasts
🏢 Vendor Payable Report
Outstanding vendor & contractor dues
🤖 AI Risk Report
AI-generated risk analysis & predictions
| Date & Time | User | Role | Module | Action | Description | IP |
|---|
Construction Site ERP
Site operations, progress tracking & contractor management
Site Dashboard
Planning & Progress
Daily Progress (DPR)
BOQ & Budget
Material & Inventory
Purchase & GRN
Labour & Contractors
Contractor Billing
Quality
Safety
Issues & Delays
Physical Progress
68%
Financial Progress
71%
Current Manpower
284
👷 Workers on site
Delayed Activities
8
⚠ Needs attention
Safety Score
87
↑ 3 pts this month
Quality Score
91
→ Good
Active Contractors
18
Open Issues
7
⚠ 3 High Priority
Planned vs Actual Progress by Activity
Site Expenditure by Category
Today's Site Activities
✓
RCC Casting — Tower 2, Floor 14
Completed • BuildMax Contractors • 28 workers
▶
Plastering — Tower 1, Floor 8-10
In Progress • Alpha Plastering • 18 workers
▶
MEP — Electrical Conduit, Tower 3
In Progress • Spark Electricals • 12 workers
!
Structural — Tower 4, Floor 3 Delayed
Delayed — material shortage • 0 workers
Contractor Productivity
BuildMax Contractors89% ↓ 11%
Spark Electricals94% ↑ 4%
AquaFlow Plumbing97% ↑ 2%
SecureFire Systems85% →
Prime Aluminium91% ↑ 6%
Alpha Plastering78% ↓ 8%
| Tower | Floor | Activity | Contractor | Planned% | Actual% | Variance | Delay(Days) | Status | Action |
|---|
Submit Daily Progress Report
Recent DPR Entries
Bill of Quantities — Budget vs Actual
| Cost Code | Work Category | Budget (₹L) | Committed | Actual Cost | Paid | Remaining | Variance | Status |
|---|
Material & Inventory Management
Low Stock Alerts
3
⚠ Immediate action needed
Pending Deliveries
8
Material Value on Site
₹4.28 Cr
| Material | Unit | Opening | Received | Consumed | Closing Stock | Min Stock | Value (₹L) | Alert |
|---|
Material Requests
Purchase Orders
GRN
Material Requests
| MR No. | Date | Material | Qty | Required By | Raised By | Status | Action |
|---|---|---|---|---|---|---|---|
| MR-2026-142 | 20 Jun 2026 | TMT Steel Fe500D | 18 MT | 28 Jun 2026 | Nikhil Patil | Pending PO | |
| MR-2026-141 | 18 Jun 2026 | OPC 53 Grade Cement | 200 Bags | 25 Jun 2026 | Pratik More | PO Issued | |
| MR-2026-140 | 15 Jun 2026 | CPVC Pipes 25mm | 500 Rmt | 22 Jun 2026 | Akash Shinde | Delivered |
| PO No. | Date | Vendor | Material | Qty | Value | Delivery Date | Status |
|---|---|---|---|---|---|---|---|
| PO-2026-0284 | 12 Jun 2026 | Tata Steel Ltd. | TMT Steel Fe500D | 25 MT | ₹18.75L | 25 Jun 2026 | Pending |
| PO-2026-0280 | 02 Jun 2026 | Spark Electricals | LT Power Cable 4Cx25sqmm | 1200 Rmt | ₹8.40L | 20 Jun 2026 | Partial Delivery |
| GRN No. | Date | PO Ref | Vendor | Material | Ordered | Received | Accepted | Rejected | Status |
|---|---|---|---|---|---|---|---|---|---|
| GRN-2026-089 | 19 Jun 2026 | PO-0283 | UltraTech Cement | OPC 53 Cement | 500 Bags | 500 Bags | 496 Bags | 4 Bags | Accepted |
| GRN-2026-088 | 17 Jun 2026 | PO-0281 | AquaFlow Plumbing | CPVC Pipes | 500 Rmt | 480 Rmt | 480 Rmt | 0 | Accepted |
| Contractor | Work Category | Deployed | Required | Attendance% | Productivity | Safety Compliance | Quality Score | Status |
|---|---|---|---|---|---|---|---|---|
| BuildMax Contractors | Structural / RCC | 142 | 160 | 88% | 89% ↓ | 91% | 87/100 | Attention |
| Spark Electricals | Electrical MEP | 48 | 50 | 95% | 94% ↑ | 98% | 94/100 | Good |
| AquaFlow Plumbing | Plumbing MEP | 32 | 32 | 97% | 97% ↑ | 96% | 92/100 | Excellent |
| SecureFire Systems | Fire Fighting | 22 | 24 | 90% | 85% → | 93% | 88/100 | Normal |
| Alpha Plastering | Plastering & Finish | 40 | 52 | 76% | 78% ↓ | 84% | 80/100 | Underperforming |
Contractor Running Account Bills
| Bill No. | Contractor | Work | Work Order Value | RA Bill Amt | Retention | Advance Rec. | Net Payable | Status | Action |
|---|---|---|---|---|---|---|---|---|---|
| RAB-2026-048 | BuildMax Contractors | RCC — Tower 2-3 | ₹280.00 L | ₹68.25 L | ₹3.41 L | ₹6.82 L | ₹58.02 L | Pending Approval | |
| RAB-2026-047 | Spark Electricals | Electrical MEP | ₹120.00 L | ₹24.70 L | ₹1.24 L | ₹2.47 L | ₹20.99 L | Under Review | |
| RAB-2026-046 | AquaFlow Plumbing | Plumbing MEP | ₹85.00 L | ₹18.30 L | ₹0.92 L | ₹1.83 L | ₹15.55 L | Approved | |
| RAB-2026-045 | SecureFire Systems | Fire Fighting | ₹62.00 L | ₹14.85 L | ₹0.74 L | ₹1.49 L | ₹12.62 L | Approved — Paid | |
| RAB-2026-044 | Prime Aluminium | Aluminium Windows | ₹145.00 L | ₹32.40 L | ₹1.62 L | ₹3.24 L | ₹27.54 L | Pending Payment |
Quality Score
91/100
Pending Inspections
3
Open NCRs
2
| Inspection ID | Date | Activity | Tower/Floor | Inspector | Result | NCR | Status | Action |
|---|---|---|---|---|---|---|---|---|
| QI-2026-124 | 21 Jun 2026 | RCC Concrete Test | T2/F14 | Nikhil Patil | Pass — M30 Grade OK | — | Passed | |
| QI-2026-123 | 20 Jun 2026 | Brick Masonry Check | T1/F8 | Nikhil Patil | Minor Issues Found | NCR-18 | NCR Open | |
| QI-2026-122 | 19 Jun 2026 | Waterproofing | T3/Terrace | Pratik More | Fail — Retest Required | NCR-17 | Failed | |
| QI-2026-121 | 18 Jun 2026 | Plastering Thickness | T1/F6-8 | Nikhil Patil | Pass | — | Passed | |
| QI-2026-120 | 17 Jun 2026 | Electrical Wiring | T2/F1-5 | Akash Shinde | Pending | — | Scheduled |
Safety Score
87/100
Days Without Incident
42
Near Misses (Month)
2
PPE Compliance
94%
Safety Checklist — Today
Incident Log
22 Jun 2026No incident reported ✓
15 Jun 2026Near Miss — Falling object T3
08 Jun 2026No incident reported ✓
01 Jun 2026Near Miss — Scaffold at T2
May 20260 incidents ✓
Issues & Delay Register
Organization & Team
186 employees across 17 departments
Org Chart
Departments
Employees
Attendance
Tasks & Work
Performance
Payroll Summary
Arvind Rao
Managing Director
Vikram Deshpande
Project Director
Rohan Kulkarni
PM — Site A
Sneha Deshmukh
PM — Site B
Aditya Joshi
PM — Site C
Meera Shah
CFO
Harshad Kulkarni
Accounts Mgr
Tanvi Mehta
RERA Compliance
Nisha Kapoor
Sales Head
Pooja Iyer
CRM Manager
Sales Team
8 Executives
Rahul Jadhav
Operations Head
Sameer Khan
Procurement Mgr
Kavita Nair
HR Head
HR Team
4 Executives
| Emp ID | Name | Designation | Department | Project | Open Tasks | Perf Score | Status | Action |
|---|
Present Today
171
On Leave
9
Absent
6
Attendance %
91.9%
Monthly Attendance Trend
Task Board — All Projects
📋 Assigned (12)
▶ In Progress (8)
✅ Completed (48)
🔴 Overdue (23)
Department Performance Scores
Employee Performance Distribution
Top Performers This Month
🥇 Nikhil Patil — Site Engg96/100
🥈 AquaFlow Plumbing94/100
🥉 Harshad Kulkarni — Finance93/100
Pooja Iyer — CRM91/100
Sameer Khan — Procurement89/100
Spark Electricals94/100
Total Payroll (Jun)
₹1.38 Cr
Processed
172
Pending
14
TDS Deducted
₹14.28 L
| Department | Headcount | Gross Salary | Deductions | Net Pay | Status |
|---|---|---|---|---|---|
| Site Execution | 48 | ₹38.40 L | ₹4.22 L | ₹34.18 L | Processed |
| Sales & CRM | 22 | ₹26.40 L | ₹3.17 L | ₹23.23 L | Processed |
| Finance & Accounts | 12 | ₹18.00 L | ₹2.16 L | ₹15.84 L | Processed |
| Project Management | 18 | ₹28.80 L | ₹3.46 L | ₹25.34 L | Processed |
| Procurement | 10 | ₹12.00 L | ₹1.44 L | ₹10.56 L | Pending |
| Corporate Management | 8 | ₹16.00 L | ₹1.92 L | ₹14.08 L | Processed |
Sales, Booking & Customer CRM
Lead management, bookings, collections and customer relations
Sales Dashboard
AI Enquiry Agent
Leads
Follow-Ups
Unit Inventory
Bookings
Customers
Collections
Pending Dues
Channel Partners
New Enquiries Today
68
↑ 12 vs yesterday
AI Handled
43
63.2% auto-qualified
Qualified Leads
31
Follow-Ups Due
46
⚠ Action today
Site Visits Scheduled
18
Bookings This Month
24
↑ vs target 20
Monthly Booking Value
₹18.65 Cr
Pending Dues
₹117.15 Cr
⚠ 24.8 Cr overdue
Conversion Rate
8.7%
↑ 0.8% this month
Collection Efficiency
74.3%
Bookings by Project — Last 6 Months
Lead Source Breakdown
Demo AI Intelligence Engine
● Active
MAVIX AI Enquiry Agent
Handling real estate enquiries automatically
I need a 3 BHK in Kharadi under ₹1.5 Cr
Office in Baner under ₹80L
Investment property under ₹90L
Schedule a site visit tomorrow
Available units in Site A
AI Activity Log — Today
08:14 AMEnquiry from Rajesh Kumar — 2BHK Kharadi — Qualified
08:28 AMSite visit booked — Priya Sharma — Site A — 24 Jun
09:02 AMPayment reminder sent — Anil Mehta — ₹4.80L overdue
09:18 AMLead qualified — Sanjay Verma — Budget 2Cr — 3BHK
10:04 AMEnquiry — NRI from Dubai — Office unit — Assigned to team
10:35 AM12 payment reminders sent — WhatsApp campaign
11:02 AMAnomaly flagged — Vendor bank account change detected
11:48 AMSite B progress alert — 6.2% behind planned schedule
AI Stats — Today
Enquiries Handled
43
Leads Qualified
17
Site Visits Booked
11
Reminders Sent
28
| Lead ID | Customer | Phone | Source | Project | Budget | Type | AI Score | Executive | Stage | Next Follow-Up | Action |
|---|
Follow-Up Schedule — Today & Upcoming
| Lead | Customer | Phone | Stage | Follow-Up Date | Type | Executive | Last Interaction | Action |
|---|
■ Available
■ Booked
■ Blocked
■ Cancelled
■ Registered
New Booking
Recent Bookings
| Customer | Unit | Project | Agreement Value | Received | Pending | Next Demand | Overdue | Days OD | Action |
|---|
This Month Collection
₹14.28 Cr
Total Collected
₹204.65 Cr
Due This Month
₹19.20 Cr
Collection Efficiency
74.3%
| Date | Customer | Unit | Project | Payment Type | Amount | Mode | Reference | Status |
|---|
Not Due
₹54.20 Cr
1–30 Days
₹24.40 Cr
31–60 Days
₹18.35 Cr
61–90 Days
₹12.20 Cr
> 90 Days
₹8.00 Cr
| Customer | Unit | Due Amount | Overdue Amount | Days Overdue | Bucket | Action |
|---|
| Partner | Code | City | Bookings | Value | Commission Earned | Commission Paid | Pending | Status |
|---|---|---|---|---|---|---|---|---|
| Pune Properties Hub | CP-001 | Pune | 28 | ₹22.40 Cr | ₹44.80 L | ₹40.00 L | ₹4.80 L | Active |
| Kharadi Realty Network | CP-002 | Pune | 18 | ₹14.20 Cr | ₹28.40 L | ₹28.40 L | — | Active |
| PropTech Associates | CP-003 | Mumbai | 12 | ₹10.80 Cr | ₹21.60 L | ₹18.00 L | ₹3.60 L | Active |
| NRI Connect Services | CP-004 | Dubai/NRI | 8 | ₹9.60 Cr | ₹28.80 L | ₹28.80 L | — | Active |
| Baner Property Advisors | CP-005 | Pune | 6 | ₹4.80 Cr | ₹9.60 L | ₹8.00 L | ₹1.60 L | Pending Dues |
Finance
Company Finance & Construction Finance
Financial Command Centre
Manage company finances and project construction costs in one unified platform
Company Finance
P&L, banking, collections, vendor payments, payroll, loans, tax, cash flow and profitability analysis
Cash Balance
₹34.86 Cr
₹34.86 Cr
Receivables
₹117.15 Cr
₹117.15 Cr
Revenue
₹204.65 Cr
₹204.65 Cr
Construction Finance
Project-wise cost tracking, BOQ vs actual, contractor bills, RERA accounts and withdrawal management
Total Budget
₹312.75 Cr
₹312.75 Cr
Spent
₹164.50 Cr
₹164.50 Cr
RERA Balance
₹51.27 Cr
₹51.27 Cr
Company Finance
Overview
Transactions
Banking
Cash Flow
Vendor Payments
Loans & Investors
Tax & Compliance
Profitability
Total Revenue
₹204.65 Cr
Construction Expenditure
₹164.50 Cr
Operational Expense
₹16.84 Cr
Available Cash
₹34.86 Cr
Loans Outstanding
₹46.50 Cr
Investor Funds
₹18.00 Cr
Gross Margin
₹93.15 Cr
18.5% ROI
Finance Cost
₹3.28 Cr
Cash Flow — Last 12 Months
Expense Breakdown
| Txn ID | Date | Category | Description | Project | Party | Mode | Debit (₹) | Credit (₹) | Status | Entered By |
|---|
Bank Accounts Summary
RERA Accounts
This Month Inflow
₹18.74 Cr
This Month Outflow
₹14.28 Cr
Net Cash Flow
₹4.46 Cr
90-Day Forecast
₹52.40 Cr
90-Day Cash Flow Forecast
Upcoming Collections (30 Days)
Demand notices due₹18.40 Cr
Overdue reminders₹8.20 Cr
New booking collections₹3.60 Cr
Registration payments₹2.80 Cr
Total Expected₹33.00 Cr
Upcoming Payments (30 Days)
Contractor bills due₹8.42 Cr
Vendor payments₹3.80 Cr
Loan EMI₹1.24 Cr
Salary₹1.38 Cr
Tax payments₹0.84 Cr
Total Committed₹15.68 Cr
| Vendor | Category | Invoice No. | Invoice Date | Due Date | Amount | Status | Action |
|---|---|---|---|---|---|---|---|
| Tata Steel Ltd. | Material | TS-2026-4821 | 10 Jun 2026 | 25 Jun 2026 | ₹18.75 L | Due Soon | |
| UltraTech Cement | Material | UC-2026-3312 | 12 Jun 2026 | 27 Jun 2026 | ₹8.42 L | Due Soon | |
| BuildMax Contractors | Contractor | BM-2026-0148 | 18 Jun 2026 | 30 Jun 2026 | ₹58.02 L | Pending Approval | |
| Spark Electricals | Contractor | SE-2026-0084 | 20 Jun 2026 | 05 Jul 2026 | ₹20.99 L | Under Review | |
| DesignGrid Consultants | Professional Fee | DG-2026-0041 | 01 Jun 2026 | 15 Jun 2026 | ₹4.80 L | Overdue |
Total Loans Outstanding
₹46.50 Cr
Investor Funds Received
₹18.00 Cr
Monthly Loan Outflow
₹1.24 Cr
| Lender | Type | Sanctioned | Drawn | Outstanding | Rate% | Maturity | Monthly EMI | Status |
|---|---|---|---|---|---|---|---|---|
| HDFC Bank Ltd. | Construction Finance | ₹30.00 Cr | ₹28.50 Cr | ₹24.80 Cr | 9.25% | Mar 2028 | ₹0.72 Cr | Regular |
| ICICI Bank Ltd. | Project Loan | ₹25.00 Cr | ₹22.00 Cr | ₹18.40 Cr | 9.50% | Jun 2027 | ₹0.42 Cr | Regular |
| Patel Family (Investor) | Private Investment | ₹10.00 Cr | ₹10.00 Cr | ₹10.00 Cr | 12.00% | Dec 2026 | ₹0.10 Cr | Maturing Soon |
| Mehta Ventures | Private Investment | ₹8.00 Cr | ₹8.00 Cr | ₹3.30 Cr | 11.50% | Mar 2027 | ₹0.00 Cr | Equity |
GST Summary
GST Collected (Output)₹18.42 Cr
GST Paid (Input Credit)₹14.28 Cr
Net GST Payable₹4.14 Cr
Last Filed (May 2026)Filed ✓
Next Due (Jun 2026)20 Jul 2026
TDS Summary
TDS Deducted (Contractors)₹8.24 L
TDS on Salary₹14.28 L
TDS on Professional Fees₹2.40 L
Total TDS Deducted₹24.92 L
TDS Filed (Q4 FY25-26)Filed ✓
Project-wise Profitability Analysis
| Project | Sales Value | Construction Cost | Marketing Cost | Finance Cost | Admin Cost | Total Cost | Gross Margin | Margin% |
|---|---|---|---|---|---|---|---|---|
| Aarohan Grande | ₹218.60 Cr | ₹139.40 Cr | ₹1.20 Cr | ₹1.40 Cr | ₹0.60 Cr | ₹142.60 Cr | ₹76.00 Cr | 34.8% |
| Business Bay | ₹174.80 Cr | ₹114.10 Cr | ₹0.80 Cr | ₹1.20 Cr | ₹0.40 Cr | ₹116.50 Cr | ₹58.30 Cr | 33.4% |
| Aarohan Serenity | ₹93.00 Cr | ₹63.85 Cr | ₹0.42 Cr | ₹0.68 Cr | ₹0.16 Cr | ₹65.11 Cr | ₹27.89 Cr | 30.0% |
Construction Finance
Cost Summary
Budget vs Actual
RERA Accounts
Withdrawal
Cost Performance
● Site A — Aarohan Grande
Approved Budget₹139.40 Cr
Committed Cost₹112.80 Cr
Actual Cost₹76.15 Cr
Paid Amount₹69.40 Cr
Outstanding₹6.75 Cr
Cost-to-Complete₹59.60 Cr
Forecast Cost₹135.75 Cr
Expected Saving▲ ₹3.65 Cr
⚠ Site B — Business Bay
Approved Budget₹111.25 Cr
Committed Cost₹86.20 Cr
Actual Cost₹56.90 Cr
Paid Amount₹51.35 Cr
Outstanding₹5.55 Cr
Cost-to-Complete₹57.20 Cr
Forecast Cost₹114.10 Cr
Expected Overrun▼ ₹2.85 Cr
🔴 Site C — Aarohan Serenity
Approved Budget₹62.10 Cr
Committed Cost₹44.60 Cr
Actual Cost₹31.45 Cr
Paid Amount₹27.80 Cr
Outstanding₹3.65 Cr
Cost-to-Complete₹32.40 Cr
Forecast Cost₹63.85 Cr
Expected Overrun▼ ₹1.75 Cr
Budget vs Actual Cost by Project & Category
RERA Withdrawal Request — Site A
Awaiting Compliance ReviewProjectAarohan Grande — Site A
Requested Withdrawal₹4.85 Cr
Certified Physical Progress68%
Eligible Withdrawal Amount₹5.10 Cr
Collection Account Balance₹28.40 Cr
Withdrawal Workflow
1
Project Progress Entry
68% physical — Updated 20 Jun 2026
2
Engineer Certificate
Nikhil Patil — Uploaded & Verified
3
Architect Certificate
DesignGrid Consultants — Complete
4
CA Certificate
R.K. & Associates — Complete
5
Finance Verification
Meera Shah — Complete
6
Compliance Verification
Tanvi Mehta — In Review
7
Director Approval
Awaiting compliance clearance
8
Bank Withdrawal
Pending
Site A — CPI
1.03
Under budget ✓
Site B — CPI
0.97
Slight overrun ⚠
Site C — CPI
0.97
Slight overrun ⚠
Cost Performance Index — Monthly Trend
AI Intelligence Command Centre
Enterprise AI layer — Monitoring, prediction and decision support
AI Executive Assistant
Site Intelligence
Finance Intelligence
Collection Agent
Risk Centre
Activity Log
AI Executive Assistant
● Online
MAVIX Intelligence Engine
Enterprise data-driven executive assistant
Today's company summary
Which project is delayed?
Highest pending customer dues
Budget overrun risk
Low stock materials
Pending approvals
This month collection
Unusual transactions
AI System Status
🧠 AI Executive Assistant● Online
📞 AI Enquiry Agent● Active — 43 handled today
💰 AI Collection Agent● Active — 28 reminders sent
🏗 AI Site Monitor⚠ 3 alerts active
🔍 Expense Anomaly Scanner🚨 3 anomalies flagged
📦 Material Predictor⚠ 2 shortage risks
🏢 Vendor Risk Monitor● Monitoring
Today's AI Highlights
Enquiries Handled43
Leads Auto-Qualified17
Payment Reminders Sent28
Dues Followed Up₹42.50 L
Financial Anomalies3 flagged
Material Risk Predictions2 alerts
Delayed Activities Escalated4
AI Site Intelligence Alerts
Live Monitoring
Site B is 6.2% behind planned progress
Structural work completion at 52% vs planned 58.2%. Primary cause: labour shortage in RCC team. Financial impact: potential 3-week delay. Recommended: mobilise additional workers from Site A or engage alternate contractor.
Site C may face 12-day RCC delay due to labour shortage
AI prediction based on current deployment (143 vs required 180) and work progress velocity. Tower 2 floor 4–6 likely delayed. Impact: ₹1.2 Cr cost escalation risk.
Site A cement consumption 8.4% above BOQ estimate
Current cement consumption: 12.4 bags/sqm vs budgeted 11.45 bags/sqm. Possible causes: wastage or mix ratio issue. Recommend quality audit and consumption tracking review.
Site B TMT steel stock may run out in 6 days
Current stock: 18 MT. Daily consumption: 3 MT. Estimated stock-out: 28 Jun 2026. Pending PO: 25 MT from Tata Steel (delivery: 25 Jun). Risk: 1–2 day gap if delivery delayed.
BuildMax contractor productivity 11% below target
RCC output: 89% of target for past 3 weeks. Root cause: 18 workers absent on average. Recommend performance review meeting and replacement of underperforming team leads.
3 quality inspections overdue across projects
QI-2026-119 (Site B, T1/F8) overdue 4 days. QI-2026-118 (Site C, T2/F2) overdue 2 days. QI-2026-117 (Site A, T4/F1) overdue 1 day. Pending engineer sign-off required.
AI Finance Intelligence — Anomaly Detection
🚨 3 Active Anomalies
Possible duplicate invoice — BM-4587 vs BM-4522
Invoice BM-4587 (₹18.75L, 20 Jun) has 94% similarity to previously paid invoice BM-4522 (₹18.42L, 28 May). Same vendor, same material, overlapping quantities. HOLD payment pending verification.
Vendor Elevate Systems changed bank account 2 days before payment
Bank account update recorded 18 Jun 2026. Payment due 20 Jun 2026 for ₹15.00L. This pattern matches vendor fraud scenarios. Verify change with vendor directly before payment.
Site C legal expense 240% above monthly average
June 2026 legal expense: ₹12.50L vs monthly average ₹3.68L. Possible one-time settlement but requires MD approval. Check if this expense was pre-approved.
3 payments below ₹10L threshold to same vendor in 48 hours
Vendor: Urban Landscape Works. Payments: ₹9.8L + ₹9.6L + ₹9.4L over 19-20 Jun 2026. Total: ₹28.8L. Pattern suggests splitting to avoid approval limit. Review approval policy compliance.
Site B electrical budget may overrun by ₹24.60 Lakh
Current committed cost for electrical work: ₹89.60L vs approved budget ₹65.00L. Additional scope added without budget revision. Budget revision approval required immediately.
Customers Contacted
84
Reminders Sent
128
Promises to Pay
42
Payments Received After Reminder
₹8.40 Cr
High-Risk Overdue
12
| Customer | Unit | Due Amount | Days Overdue | Last Contact | Promise Date | Risk Level | AI Action |
|---|
High Risk Items
5
Medium Risk Items
8
Monitored
24
| Risk Type | Project/Area | Severity | Probability | Financial Impact | AI Recommendation | Status |
|---|---|---|---|---|---|---|
| Construction Delay | Site C — Tower 2 | High | 78% | ₹1.20 Cr | Mobilise 40 additional workers immediately | Monitoring |
| Budget Overrun | Site B — Electrical | High | 82% | ₹2.46 Cr | Initiate budget revision approval | Action Needed |
| Collection Default | 12 customers | High | 65% | ₹8.40 Cr | Legal notice for 90+ day defaulters | In Follow-up |
| Vendor Fraud Risk | Elevate Systems | High | 45% | ₹15.00 L | Verify bank change directly with vendor | Payment Held |
| Material Shortage | Site B — TMT Steel | Medium | 70% | ₹0.80 Cr | Expedite PO from Tata Steel | PO Raised |
| RERA Compliance | All Projects | Medium | 30% | ₹5.00 Cr | Ensure quarterly updates filed on time | On Track |
AI Activity Log — All Operations
| Time | AI Module | Action | Entity | Result | Value |
|---|