# Kingfisher: rent and room tracker

A shared view of rooms, rent, and costs.

Canonical page: https://adonisautomates.com/case-studies/kingfisher-holiday-homes-os/

Category: Work tools
Platforms: Google Sheets, Vercel, React
Tags: See daily work, Profit tracking, Rent collection, WhatsApp leads, See daily work, Profit tracking, Rent collection, WhatsApp leads

## Problem

Kingfisher rents homes in Dubai and lets rooms to tenants. The team needed to track rent, empty rooms, costs, and profit. They wanted to keep using Google Sheets.

## System built

I built a main sheet and a page that reads from it. Staff edit the sheet. The page shows rent, rooms, tenants, and costs. It has a shared passcode. I also wrote the plan for a WhatsApp AI setup. The daily email was a draft.

## Workflow

1. Add room, tenant, rent, and cost data.
2. Work out profit from rent received less costs.
3. Share selected data with the web page.
4. Show rent due, empty rooms, and profit.
5. Prepare WhatsApp details, replies, and a draft daily email.

## Tools

Google Sheets, Vite, React, Vercel, Apps Script, HyperFrames

## Impact

The team can view rent and room figures from the sheet. They also have a plan for checking WhatsApp leads and passing them to a person. We have not confirmed that the WhatsApp AI system is live.

## Metrics

- AED 15.4k: rent in the demo data
- Plan: for handling WhatsApp leads
- 6: tenants in the demo data