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

society maintenance bill format
Ads loading…

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.

Ads loading…
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.

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.

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.

Ads loading…

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.

More free templates

Ads loading…

Advertisement

Amanpreet Kaur Bharaj
Welcome to my profile! My name is Amanpreet Kaur, and I am a Freelance Microsoft Excel Specialist with an extensive background in data management and analysis. I offer top-tier Excel services, helping businesses optimize their processes, make informed decisions, and improve overall efficiency.Over the years, I have honed my skills in Excel to provide solutions tailored to each client's unique needs. I specialize in creating and maintaining complex Excel spreadsheets, utilizing advanced functions and formulas for optimal data processing, and designing macros to automate repetitive tasks.My expertise extends to crafting custom Excel VBA scripts, which allows me to cater to specific project requirements. Additionally, I am adept at building and managing pivot tables for robust data analysis and visualization. I also offer data cleaning services to ensure data integrity and reliability.With a keen eye for detail and a strong commitment to accuracy, I provide Excel-related technical support and training, always ensuring the highest quality in the work I deliver. My strong analytical and problem-solving skills, combined with excellent communication abilities, enable me to understand and fulfill your data requirements effectively.As a freelancer, I understand the value of meeting deadlines and deliver high-quality output within the agreed timeframe. I can work independently on projects, offering turnkey solutions that drive successful results. Staying updated with the latest developments and features in Microsoft Excel is a commitment I take seriously, always aiming to provide the most current and efficient solutions to my clients.Having worked with various industries, I have a broad outlook that allows me to adapt quickly to new environments and data structures. Whether it's a small business looking to streamline their data management or a large corporation in need of complex data analysis, I take pride in delivering the best possible results.I'm passionate about helping organizations make sense of their data and uncover insights that can propel their growth. So, if you're looking for a reliable, efficient, and professional Microsoft Excel expert, you've come to the right place.Thank you for visiting my profile. I look forward to the opportunity of working together and leveraging the power of data to drive your business forward!