Maharashtra CHS Maintenance Calculator Guide
A definitive, step-by-step master manual for Housing Society Chairmen, Secretaries, Treasurers, Managers, and Committee Members. Understand every button, formula, legal rule, and parking/water calculation in simple English with Marathi statutory terms.
Calculating monthly maintenance in a Co-operative Housing Society (CHS) in Maharashtra cannot be done arbitrarily. Under the Maharashtra Co-operative Societies Act (MCS Act 1960) and the Model Bye-Laws (Bye-Laws 65 to 71), different expense heads must be divided among members according to strict legal rules:
- Equal Division (Bye-Law 66): Security, housekeeping, office staff, electricity & admin charges are divided EQUALLY among all flats regardless of flat size.
- Area-Based Division (Bye-Law 67a): Sinking Fund (0.25%), Repair Fund (0.75%), and Building Insurance are strictly computed on Carpet Area.
- Vehicle-Based Division (Bye-Law 69): Charged per registered vehicle (2-Wheeler, 3-Wheeler, 4-Wheeler).
- Tenancy Surcharge (Bye-Law 68): Non-Occupancy Charges apply only to rented flats, strictly calculated on Service Charges only, and legally capped at max 10%.
In this first step, you enter the basic identification details of your society. These details are automatically displayed on the official PDF billing certificates, Excel master registers, and WhatsApp share headers.
| Input Field | Example Value | Purpose & What to Enter |
|---|---|---|
| Society Name * | Gokuldham CHS Ltd | Enter the registered name of your housing society. Required field printed on bill headers. |
| Location / City * | Kothrud, Pune | Area and city where society is situated. Displayed on top of member bills. |
| Society Type | Residential Society | Select Residential Society, Commercial Complex, or Mixed (Residential + Commercial). |
| Prepared By * | Suresh Deshmukh | Name of the person creating this calculation sheet (Secretary, Chairman, or Manager). |
| Designation | Secretary | Role: Secretary, Treasurer, Chairman, Manager, or Committee Member. |
| Mobile Number * | 9876543210 | 10-digit phone number. Used for saving report and sending WhatsApp updates. |
| Email Address | society@example.com | Optional contact email for official records and backup sharing. |
Validates that Society Name, Location, Prepared By, and Mobile are filled. Once verified, it automatically saves your progress and moves you to Step 2.
Select how often your society collects maintenance fees. The calculator automatically adjusts all service charges, funds, and vehicle fees according to the selected multiplier:
| Cycle Option | Billing Period | Multiplier (M) | Recommended For |
|---|---|---|---|
| Monthly | Every 1 month | 1x | Standard residential societies with monthly bill dispatch |
| Bi-Monthly | Every 2 months | 2x | Societies billing alternate months |
| Quarterly (तिमाही) | Every 3 months | 3x | Most popular in Mumbai, Pune, Thane & Navi Mumbai societies |
| Half-Yearly (सहामाही) | Every 6 months | 6x | Small societies collecting twice a year in April & October |
| Annual (वार्षिक) | Every 12 months | 12x | Societies collecting full year in advance |
| Field | Default | Calculation Formula & Bye-Law Rule |
|---|---|---|
| Construction Cost (₹/sqft) | ₹700 | Original construction cost per sq.ft determined by the Architect/Builder or registered General Body rate. Used to calculate Sinking & Repair funds. |
| Sinking Fund % p.a. | 0.25% |
Bye-Law 67(a)(i): Legally fixed at minimum 0.25% per annum of the construction cost of the flat.
Monthly Sinking = Area × Construction Cost × (0.25 ÷ 100) ÷ 12
|
| Repair Fund % p.a. | 0.75% |
Bye-Law 67(a)(ii): Legally fixed at minimum 0.75% per annum of the construction cost of the flat.
Monthly Repair = Area × Construction Cost × (0.75 ÷ 100) ÷ 12
|
| Building Insurance Premium (₹) | ₹55,608 |
Bye-Law 67(a)(iv): Total annual building insurance premium paid by society. Divided among flats strictly in proportion to carpet area.
Flat Insurance = (Annual Premium ÷ 12 ÷ Total Society Area) × Flat Area
|
| Charge Option | Toggle | How It Works |
|---|---|---|
| Ground Floor Lift Exemption | Checkbox | If checked, Ground Floor flats/shops are exempt from lift electricity and lift AMC charges. |
| Contingency Reserve | 0%, 5%, 10%, 15% | Adds a safety cushion to common service charges for unexpected repairs or price inflation. |
| Non-Occupancy Charges (Bye-Law 68) | On / Off | Applicable only to tenant/rented flats. Under Bye-Law 68 and Govt Circular, this is strictly computed on Service Charges only and capped at max 10%. |
| Education & Training Fund | On / Off | Contribution of ₹50 or ₹100 per unit for co-operative education and AGM training expenses. |
| Water Tanker Fund | On / Off | For societies buying extra water tankers during summer. Enter monthly tanker budget and number of months (e.g. 3 months). The expense is distributed across all units. |
| Property Tax | On / Off | If your municipality issues a single joint bill to the society, enter per sq.ft rate or total bill to divide by carpet area. |
| Amenities / Clubhouse | On / Off | Fixed monthly charge per unit for gym, swimming pool, or clubhouse maintenance. |
| GST 18% | On / Off | If a flat's monthly bill exceeds ₹7,500 and the society's total annual turnover exceeds ₹20 Lakhs, GST 18% is levied. |
Maharashtra CHS Bye-Law 69 empowers the General Body to prescribe parking rates per vehicle. In our calculator, each vehicle type can be turned ON or OFF individually with zero clutter:
If ON: Shows dedicated 2W Park column.
If OFF: Column is completely hidden and fee is ₹0.
If ON: Shows dedicated 3W Park column.
If OFF: Column is completely hidden.
If ON: Shows dedicated 4W Park column.
If OFF: Column is completely hidden.
If enabled in Step 2, any member parking 2 or more cars is charged at 1.5 times the normal rate for their cars to discourage hoarding scarce society parking space!
Water supply arrangements vary across societies. Our tool gives you complete flexibility over how water charges are billed:
| Mode | How It Works | Formula |
|---|---|---|
| Equal (Same for all units) | The municipal water bill is divided equally among all flats. Best when all flats have identical family sizes or no sub-meters. | Flat Water = Total Water Bill ÷ Total Units |
| Per Tap (Bye-Law 67a-iii) | Strict legal formula. The bill is divided by total water taps in the society, then multiplied by taps inside each flat (e.g. 1BHK = 1 tap, 2BHK = 2 taps, 3BHK = 3 taps). | Flat Water = (Total Bill ÷ Total Taps) × Unit Taps |
| Fixed Amount per Unit | Each unit pays a fixed flat fee (e.g. ₹500/month) regardless of total municipal bill. | Flat Water = Fixed Amount (₹) |
If your society has free borewell water or water charges are paid directly by individual members to the municipal corporation, simply switch the Water Bill toggle to OFF.
When OFF:
- The Water column is completely hidden from the Step 5 Table.
- The Water Charges KPI Summary Card is hidden.
- Water is excluded from the Doughnut Chart.
- Water is excluded from PDF, Excel, and CSV export files.
Under Maharashtra Bye-Law 66, all common service expenses of the society must be divided EQUALLY among all members, regardless of whether their flat is 500 sq.ft or 2,000 sq.ft.
| Action / Button | What It Does |
|---|---|
| Toggle Switch | Enable or disable any expense head. If disabled, it is excluded from all flats. |
| Inline Name & Amount Edit | Every charge head name and monthly amount can be edited directly inside the row with live budget recalculation. |
| Applies To Dropdown | Choose All Units, Lift Eligible Units (excludes ground floor if lift exemption enabled), or Commercial Only. |
| ➕ Quick Add Head | Type charge name, monthly amount, select target units, and click "+ Add Head" to instantly add any custom expense (e.g. Solar Maintenance, CCTV AMC). |
| 📥 Import Excel/CSV | Upload your society's existing expense spreadsheet (.xlsx, .xls, .csv). The system auto-maps columns and lets you Replace or Append to existing charges! |
| 📊 Export Excel & CSV | Export your society's full service budget to an Excel sheet (.xlsx) or CSV file with monthly and annual amounts. |
| 📥 Download Template | Download a ready-to-use sample Excel template with pre-filled expense heads to edit offline and upload anytime. |
| ↺ Reset Defaults | Restores the standard 12 Maharashtra CHS model service charge heads. |
| 🗑️ Delete Button | Deletes any custom or default expense head from the list. |
You have three flexible options to input all flats, shops, and offices in your society:
Download the pre-formatted Excel template, paste your society flat list, and simply drag & drop the file into the upload zone.
📥 Download Excel TemplateWant to test the calculator immediately without typing? Click "Load Demo Units" to generate 15 realistic flats with owners, 2W/3W/4W vehicles, and mixed occupancy.
✨ Load Demo Units (15)Type flats directly in the preview table or click "+ Add Unit" to enter Wing, Flat No, Carpet Area, Owner Name, and Vehicle counts one by one.
+ Add Single Unit| Column Header | Required? | Example | Description |
|---|---|---|---|
| Wing | No | A / B / C | Building Wing name (defaults to 'A') |
| Unit No | Yes | 101, 102, Shop-1 | Flat or commercial shop number |
| Type | No | Flat / Shop / Office | Unit classification (defaults to 'Flat') |
| Owner Name | No | Amit Kulkarni | Member name |
| Area (sqft) | Yes | 850 | Carpet area in square feet. Crucial for Sinking & Repair funds! |
| Water Taps | No | 2 | Number of water taps inside the unit (for Per-Tap water mode) |
| 2W | No | 1 or 2 | Number of two-wheelers (scooters/motorbikes) owned |
| 3W | No | 0 or 1 | Number of three-wheelers (rickshaws) owned |
| 4W | No | 1 | Number of four-wheelers (cars) parked |
| Occupancy | No | Owner Occupied / Tenant | Set to Tenant or Company Lease to apply Non-Occupancy Charges. |
Count of flats, shops & total sq.ft
Total ₹ collected in selected billing cycle
Average per month & 12-month budget
Bye-Law 66 total collection
Bye-Law 67(a) statutory reserves
Total parking with 2W, 3W & 4W breakdown
| Control | Options | How It Helps |
|---|---|---|
| Filter by Wing | All Wings / Wing A / Wing B... | View only flats from a specific building wing. |
| Filter by Unit Type | All / Flat / Shop / Office | Separate residential members from commercial shop owners. |
| Filter by Occupancy | All / Owner Occupied / Tenant / Vacant | Instantly filter rented flats to check Non-Occupancy Charges. |
| Search Box | Type owner name or flat number | Instant search as you type. |
| Sort Dropdown | Unit No / Grand Total (High to Low) / Grand Total (Low to High) / Area | Find highest payers or sequence for printed registers. |
The table shows an itemized breakdown for every single unit. Columns appear dynamically:
- Unit: Wing and Flat Number badge (e.g. A-101).
- Type: Flat, Shop, or Office.
- Owner: Name of the flat owner.
- Area: Carpet area in sq.ft.
- Service: Common service charge (Bye-Law 66). Identical for all identical types.
- Sinking: Sinking fund contribution (Bye-Law 67a-i).
- Repair: Repair & maintenance contribution (Bye-Law 67a-ii).
- Water: Water charge (Automatically hidden if Water Bill is toggled OFF!).
- Insurance: Building insurance share based on area (Bye-Law 67a-iv).
- 2W Park: Two-wheeler parking charge (Only visible if 2W is ON in Step 2!).
- 3W Park: Three-wheeler parking charge (Only visible if 3W is ON in Step 2!).
- 4W Park: Four-wheeler parking charge (Only visible if 4W is ON in Step 2!).
- Non-Occ: Non-Occupancy charge for tenant flats (Only visible if enabled).
- GST: GST 18% (if applicable and enabled).
- Grand Total: The final bill amount payable for the selected cycle.
- Actions: 👁 View (itemized popup) and ✏️ Edit (modify flat live).
| Button | Feature | What Happens |
|---|---|---|
| 👁 View Button | Member Bill Breakdown Popup | Opens a modal showing every charge head for that specific flat with the corresponding Maharashtra Bye-Law number (66, 67, 68, 69). Shows exact vehicle counts and carpet area. Perfect for explaining bills to members at the society office desk! |
| ✏️ Edit Button | Edit Single Unit Record | Allows you to change the flat owner's name, carpet area, number of water taps, 2W/3W/4W vehicle count, or occupancy status (Owner to Tenant). When you click Save & Recalculate, the entire table and all totals update instantly! |
Under Bye-Law 71, if a member fails to pay maintenance charges within the prescribed period, the society may charge simple interest at a rate fixed by the General Body, not exceeding 21% per annum (simple interest).
📄 Download PDF Report
Generates a high-resolution, landscape A4 PDF document complete with society header, financial summary cards, itemized unit table, and Bye-Laws compliance footer.
📄 Download PDF📊 5-Sheet Dynamic Excel Report (.xlsx)
Produces a professional 5-sheet Excel workbook with dynamic columns:
- Sheet 1: Society Details (Address, committee contacts, compliance).
- Sheet 2: Step 2 Config (All rates, statutory %, parking & water modes).
- Sheet 3: Service Charges (Itemized expense heads & per-unit share).
- Sheet 4: Uploaded Units (Raw member roster with wing, unit & area).
- Sheet 5: Maintenance Bill Sheet (Dynamic master billing register with totals).
📱 Share on WhatsApp
Pre-formats a message with society name, monthly collection, and a permanent view-only link to share with committee members or members' WhatsApp group.
📱 WhatsApp ShareClicking "Save Report to Cloud" stores your entire configuration, flats, and summary safely in the MySQL database. You receive:
- View-Only Link: Share with society members to let them view their charges without modifying data.
- Admin Edit Link: Keep this link for yourself to update or recalculate anytime in the future!
Carpet Area: 850 sq.ft • Water Taps: 2 • Vehicles: 1 Scooter (2W) + 1 Car (4W) • Occupancy: Tenant (Rented)
Society Settings: Monthly cycle, Construction Cost = ₹700/sqft, Sinking = 0.25%, Repair = 0.75%, Water Bill = ₹12,000 (30 flats), Insurance = ₹55,608/yr (25,000 sqft total).
| Charge Head | Bye-Law | Formula & Working | Monthly Amount |
|---|---|---|---|
| Service Charges (सेवा शुल्क) | Bye-Law 66 | Total Monthly Service Expenses (₹45,000) ÷ 30 Flats | ₹1,500 |
| Sinking Fund (घसारा निधी) | Bye-Law 67(a)(i) | 850 sqft × ₹700 × (0.25 ÷ 100) ÷ 12 months | ₹124 |
| Repair Fund (दुरुस्ती निधी) | Bye-Law 67(a)(ii) | 850 sqft × ₹700 × (0.75 ÷ 100) ÷ 12 months | ₹372 |
| Water Charges (पाणी बिल) | Bye-Law 67(a)(iii) | Equal Mode: ₹12,000 ÷ 30 flats | ₹400 |
| Building Insurance (विमा) | Bye-Law 67(a)(iv) | (₹55,608 ÷ 12 ÷ 25,000 sqft) × 850 sqft | ₹158 |
| 2-Wheeler Parking (२-चाकी) | Bye-Law 69 | 1 Scooter × ₹100 / month | ₹100 |
| 4-Wheeler Parking (४-चाकी) | Bye-Law 69 | 1 Car × ₹300 / month | ₹300 |
| Non-Occupancy (अ-भोगवटा) | Bye-Law 68 | Flat is rented to Tenant → Strictly 10% of Service Charges only: 10% × ₹1,500 | ₹150 |
| Total Monthly Maintenance | - | Sum of all applicable charge heads | ₹3,104 |
Click on any question below to expand the legal verdict and applicable court citations:
Legal Rule (Bye-Law 66 & 160): As per Maharashtra Model Bye-Laws, Lift is a common capital asset of the entire society, and all members (even Ground Floor) must pay Service Charges equally unless the society's registered General Body has passed an explicit amendment granting exemption.
Our calculator allows you to turn on "Ground Floor Lift Exemption" with 1 click if your society has approved this resolution!
Legal Rule (Bye-Law 68 & Supreme Court / Govt Circular dated 13/01/2000): Absolutely NO. The Government of Maharashtra and Supreme Court have strictly ordered that Non-Occupancy Charges cannot exceed 10% of Service Charges (excluding Municipal Taxes). Any resolution passed by a society charging higher is legally null and void.
Our calculator automatically clamps this at 10% to protect your Managing Committee from consumer court complaints!
Legal Rule: NO. If the flat is occupied by immediate family members (parents, spouse, children, siblings), NO Non-Occupancy Charge can be levied. In our tool, simply select Owner Occupied for such flats.
Legal Rule (Bye-Law 66 & Bombay High Court ruling): Service Charges (security, sweeping, office admin) must be divided EQUALLY among all units. However, for Sinking Fund, Repair Fund, and Insurance, commercial units pay higher amounts naturally because their carpet area is measured in the formula!
Legal Rule (Bye-Law 71): Only Simple Interest up to a maximum of 21% per annum can be charged. Compound interest, arbitrary penalty fines, or cutting off electricity/water connections is strictly illegal under the MCS Act Section 154B.
| Bye-Law No. | Charge Head | Statutory Basis & Legal Rule |
|---|---|---|
| Bye-Law 66 | Service Charges (सेवा शुल्क) | Divided EQUALLY among all flats/units, irrespective of area. |
| Bye-Law 67(a)(i) | Sinking Fund (घसारा निधी) | Minimum 0.25% per annum of construction cost of each flat. |
| Bye-Law 67(a)(ii) | Repair & Maintenance (दुरुस्ती निधी) | Minimum 0.75% per annum of construction cost of each flat. |
| Bye-Law 67(a)(iii) | Water Charges (पाणी बिल) | As per water meter, equal division, or number of taps inside each flat. |
| Bye-Law 67(a)(iv) | Building Insurance (इमारत विमा) | Divided in proportion to the carpet area of each flat. |
| Bye-Law 68 | Non-Occupancy Charges (अ-भोगवटा) | Charged ONLY on rented units. Cannot exceed 10% of Service Charges only (Exempt for immediate family). |
| Bye-Law 69 | Parking Charges (पार्किंग शुल्क) | Fixed per registered vehicle (2W, 3W, 4W) as decided by General Body. |
| Bye-Law 71 | Late Payment Interest (व्याज) | Simple interest on delayed dues, capped at maximum 21% per annum. |