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
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.