Top 10 villas by overspend
Drill to see category breakdown
Stale items
Open >7 days
Category heat-map
Spend vs budget, active month
Villas at a glance
Spend, budget, occupancy, cost per night
Villa
Vendor & employee flags
Concentration patterns that deserve a second look
Staff fuel — by user
Name extracted from Particulars where possible (fuzzy matched against known employees)
Data hygiene alerts
Three tabs — each is a different data integrity problem to fix before analysis
Mismatched billing cycles
Rows whose billing cycle looks wrong — fix inline or export to Zoho team
—Recovery log
Duplicate payments, fraud, vendor refunds — actually recovered ₹
Upload monthly expense CSV
Choose mode below, then drop the file
Drop CSV here or click to choose
Zoho export. Column names flexible.
What's needed in the file
Budget base
Baseline = Jun 2025 – Mar 2026 avg. Staff Salary & Electricity at avg. Rest at avg −10%.
| Villa | Category | 10mo avg | Rule | Monthly Budget | Frequency | Period Envelope | Location |
|---|
Analyst activity
What your team is working on. Filter by period to see daily/weekly velocity.
Daily activity
Anomalies + vendor flags actioned per day, by analyst
By analyst
Per-person summary
Recent activity log
Most recent 100 actions
Budget recommendations
Consistent overruns or underruns across 3 months
Upload 3 months to see recommendations
Sync backend
Google Apps Script web app URL
User management
Users are managed directly in the Google Sheet → users tab.
Columns: email · password · name · role (role = admin or analyst)
Default credentials on first deploy: admin / analyst both use password changeme. Change immediately in the sheet.