For a tenant upstairs on a sub-meter, keep one row per month: opening reading, closing reading, units used, the rate you worked out from the main bill, the amount due and the amount paid. Photograph the meter on the same date each month so both of you can see the numbers.
What columns does the sheet need?
| Month | Reading date | Opening | Closing | Units | Rate (₹/unit) | Due (₹) | Paid (₹) | Balance (₹) |
|---|---|---|---|---|---|---|---|---|
| June | 01 Jul | 1,240 | 1,325 | 85 | 9.00 | 765 | 765 | 0 |
| July | 01 Aug | 1,325 | 1,418 | 93 | 9.00 | 837 | 500 | 337 |
The figures are invented. Units are closing minus opening: 1,325 − 1,240 = 85 and 1,418 − 1,325 = 93. Due is units times rate: 85 × 9 = ₹765 and 93 × 9 = ₹837. The balance in July is ₹837 − ₹500 = ₹337, which carries into August. In a sheet, with Opening in C and Closing in D, Units is =D2-C2, and Due is =E2*F2.
Where does the rate come from?
Take it from the electricity provider's bill for the main meter, not from a guess. One way is the bill's total amount divided by the units billed. If the main bill for a month is ₹6,480 for 720 units, the average is ₹6,480 ÷ 720 = ₹9 a unit, matching the table. Providers usually charge in steps where each band of units has its own rate, and there may be fixed charges, so the average moves from month to month. Whether to use a single agreed rate or the month's average is something to settle with your tenant at the start.
Check the rules that apply to you: some places have limits on what a landlord may charge a tenant for electricity, and what is allowed may differ by state or provider. Ask the provider or a local professional rather than assuming.
How do you take the readings fairly?
- Choose a fixed date each month, and take the reading together or by photo.
- Photograph the meter display with the date visible, for example holding a dated slip beside it or relying on the phone's date stamp.
- Both of you note the reading in the sheet the same day.
- Send the tenant a message with the units, rate and amount due.
- Record payment when it arrives, with the mode and date.
What about the fixed charge and the common areas?
The main bill may carry a fixed or minimum charge, and the stair light or the water motor may run on your meter. Agree whether the tenant shares these. A common approach is a small fixed amount added to the sub-meter charge. Write the agreement into the rental agreement or a message so it stays clear. Whatever the basis, do not change it mid-year without both agreeing.
What if the sub-meter and the main meter do not add up?
The sum of the sub-meter units and your own units should come near the main meter's units. If the main meter says 720 and the sub-meter says 85, your part should be around 635. A large gap can come from a faulty meter, wiring that bypasses it, or reading on different dates. Ask the provider or an electrician to test the sub-meter if the gap is big and persists.
Where does a tracker help?
The sheet covers the unit calculation. In SpendixAI, you can put the main electricity bill, the tenant's payment and any meter repair under one category for the house, so your net electricity cost after the tenant's payment is easy to see over the year. Add cash payments by hand.
Month-end checklist
- Reading photo taken and saved.
- Units, due and balance filled in.
- Message sent to the tenant.
- Payment recorded.
- Main bill compared with the sum of both meters.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


