Top 10 villas
By overspend; by spend when a filter is active · drill for breakdown
Stale items
Open >7 days
Category heat-map
Spend vs budget, active month
Opex hotspots — villas by opex spend
Repair-heavy villas + the dominant opex category, so you can spot replace-vs-repair candidates. Configure opex categories in Settings.
Location-wise profitability
Revenue vs spend per location · follows the months selected at the top · click a location for its villas
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, resolve, 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%.
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
Expense Tracker
Categories excluded from the budget engine, the profit calculation, or the −10% discipline. Admin only.
Bank Recon
Banks that aren't reconciled against bank transactions (e.g. cash). Payments here show in the Payments backlog only while unverified. Admin only.
Reconciliation tools
Run the Zoho data sync or the screenshot-read + matchers on demand (instead of waiting for the scheduled cycles). Admin only.
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.
Bank Reconciliation
Withdrawal (expense) reconciliation backlog from Zoho, and payment deposits to reconcile.
not loadedDeployment canary
This tab exists only to verify that a code change was successfully deployed to the server. If you can see this, the current build is live.