Most Indian societies start their bookkeeping in Excel — and a well-built sheet is genuinely enough for the first months. Here's a free apartment maintenance Excel template built the way small societies actually bill: fixed maintenance plus water by meter reading, payment tracking, and carried-forward balances. Download it, put your flats in, and it works.
⬇ Download the template (.xlsx, free)
The sheet works — until the society grows past what one volunteer can maintain. The usual breaking points: part-payments smudging the paid column, "I paid last month" disputes with no proof attached, residents asking for their balance on WhatsApp at 10pm, a secretary handover where the formulas travel but the discipline doesn't, and month-end statements that need manual assembly. That's the moment societies move to an apartment maintenance app — Flatra generates every flat's bill in one tap from your real expenses, bills water by meter, records cash and UPI with a full history, and gives every resident their own view. Your Excel history comes along as opening balances, so nothing is lost.
Set up in one evening — add flats, add bills, generate the month. First 10 societies free, then from ₹10 per flat per month. Residents always free.
Get it on Google Play Visit flatra.inYes — download it directly, no email or sign-up. It's a standard .xlsx that opens in Excel, Google Sheets and LibreOffice.
Yes. Enter each flat's previous and current readings plus the month's total water cost; the sheet computes the rate and each flat's water amount automatically.
Yes — upload the .xlsx to Google Drive and open with Google Sheets; the formulas work as-is.
When payment tracking starts eating the secretary's evenings — usually past 15–20 flats, or the first disputed payment. An app like Flatra keeps the same billing logic but adds payment history, resident logins and automatic statements.