Society Maintenance Bill Format in Excel (Free) – With Interest on Arrears & Receipt

society maintenance bill format

Advertisement

Quick answer: A society maintenance bill shows what a flat owes for the month:

  • each charge (maintenance per sq ft, sinking fund, repair fund, water, parking)
  • any previous arrears
  • interest on those arrears
  • the total payable and the due date

Download the free Excel format below. Type the charges once, and it works out the per-sq-ft amounts, interest and total, prints the bill, and gives a matching payment receipt with the amount in words.

Key takeaways

  • Charge per sq ft (rate × area) or as a fixed amount, with up to 8 charge lines.
  • Interest on arrears at the rate in your bye-laws (for example 21% p.a.) is worked out for you.
  • Printable maintenance bill and receipt (member copy and office copy) with the amount in words.
  • Free, with no macros. It works in Excel, Excel for Mac and Google Sheets.

↓ Jump to the free download

FOR HOUSING SOCIETIESMaintenance bills for every flat, in minutes.XploreSociety works out each flat’s bill with arrears and interest, prints receipts and lists defaulters.See XploreSociety — from ₹599 →⚡ Instant download · ♾️ Lifetime access · 💳 Pay onceXploreSociety

Society maintenance bill format in Excel with charges per sq ft, arrears and interest
A maintenance bill made with the free template: charges, arrears, interest, total and due date.

What a society maintenance bill must show

PartExample
Society name, registration number, addressShanti Kunj CHS Ltd., Regd. No. HSG/2012/0456
Bill number, bill date, month, due dateSK/1026/B-204 • 01-Oct-2026 • October 2026 • due 15-Oct-2026
Member name, flat number, areaMr. Suresh Patil • B-204 • 1,050 sq ft
Each charge separatelyMaintenance ₹3 × 1,050 = ₹3,150; sinking fund; repair fund; water; parking
Previous arrears and interest₹4,600 arrears + ₹81 interest at 21% p.a. for one month
Total payable, in figures and words₹9,344 – Rupees Nine Thousand Three Hundred Forty-Four Only
How to payUPI ID and bank account with IFSC

Common maintenance charges

  • Maintenance / service charges: usually per sq ft. They cover security, housekeeping, common electricity, lift maintenance and gardening.
  • Sinking fund: savings for major future repairs, often a small rate per sq ft.
  • Repair & maintenance fund and water charges: usually a fixed amount per flat.
  • Parking charges: per vehicle or per slot.
  • Non-occupancy charges: when a flat is let out, if your bye-laws allow them.

How interest on arrears is calculated

Most societies charge simple interest on dues not paid by the due date. The monthly interest is arrears × annual rate ÷ 12. For example, ₹4,600 × 21% ÷ 12 = ₹81 for one month. Use the rate and method in your society’s bye-laws; many states set a maximum.

Enter maintenance charges per sq ft, arrears and interest rate in Excel
Everything is entered on one sheet. Per-sq-ft charges, interest and total are worked out for you.

Is GST charged on society maintenance?

Usually not, for most housing societies. Maintenance is generally exempt from GST when each member’s contribution is up to ₹7,500 a month, and a society with annual turnover up to ₹20 lakh does not need GST registration. If a member pays more than ₹7,500 a month and the society is registered, GST at 18% generally applies to the whole amount, not just the excess. Rules and exclusions (such as property tax or electricity collected on actuals) can vary, so check with your CA.

Advertisement

Maintenance receipt

When a member pays, fill in the receipt details. The template prints a member copy and an office copy on one A4 sheet, with the amount in words, the payment mode and reference, and the balance left after the payment.

Society maintenance receipt format in Excel with member copy and office copy
A maintenance receipt with member and office copies.
Outgrown the free sheet? Here’s what XploreSociety adds

Free sheetXploreSociety
Receipts and defaulter list—✓
Income & expenditure with bank balance—✓
Member statement—✓
Society expense register—✓
Up to 300 flats—✓
Fill-in forms & one-click PDF (macro edition)—✓

⚡ Instant download · ♾️ Lifetime access · 💳 Pay onceGet XploreSociety — from ₹599 →

Download the free Society Maintenance Bill Format

There are three sheets: Enter Details, Maintenance Bill and Receipt. Fill in the yellow cells, then print or save the bill and receipt as PDF to send on WhatsApp.

Get updates and new free templates

Your download below doesn’t need this. Leave your WhatsApp number or email and I’ll send you fixes for this file and new free templates. No spam, unsubscribe anytime.

Was this template useful?

FAQs

How is maintenance per sq ft calculated?

Multiply the rate by the flat’s area, using whichever area your society bills on: carpet or built-up. For example, ₹3 × 1,050 sq ft = ₹3,150 a month.

Can a society charge interest on late maintenance?

Yes, if its bye-laws allow it, and usually only up to the maximum rate set by the state’s co-operative rules. Interest is charged only on dues not paid by the due date.

What is the sinking fund?

It is money collected regularly and set aside for major repairs or rebuilding in the future. It is usually charged per sq ft or as a percentage of construction cost, as the general body decides.

Can I use this for a shop or commercial complex?

Yes. Change the charge names and rates. The per-sq-ft and fixed options work the same way.

Advertisement

More free templates

Advertisement

Amanpreet Kaur Bharaj
I'm Amanpreet Kaur Bharaj from Hoshiarpur, Punjab. I've worked in Excel for about 12 years, and since 2022 I've run my own ethnic-wear boutique, Punjabi Libas, on Excel files I built myself. XplorExcel is where I share those files: free templates for everyday business work, and ready-made Excel software for shops, boutiques, clinics, dairies, mandis and offices. Every file comes with a filled-in sample so you can see how it works. Stuck with one? Message me and I'll help.