Electricity Billing System

Upload Excel/CSV files to calculate electricity charges and download reports

Billing Rules:
• Employee Rooms: First 25 units are free (company subsidy). Charges apply at ₹5 per unit beyond the free limit.
• AC Employee Rooms: First 50 units are free (enhanced subsidy). Charges apply at ₹5 per unit beyond the free limit.
• Contractor Rooms: Full electricity reading is charged at ₹5 per unit (no subsidy). Employee code can be blank for contractors.
• Mixed Rooms (Employees + Contractors): Consumption is proportionally divided. Employees get subsidy on their portion, contractors pay full rate on their portion.
• Others Rooms Data: Rooms with others employee data (missing required fields) will have zero deduction regardless of electricity consumption.
All charges are split equally among room occupants within their respective categories.

AC Subsidy Room Configuration

Configure specific room numbers to receive 50 units free subsidy instead of the standard 25 units (applies only to employees, not contractors)

Add AC Subsidy Rooms

Room Numbers (comma or line separated)

AC Subsidy Rooms (0)

No AC subsidy rooms configured. All rooms will use standard 25 units subsidy for employees.

Custom Filter Configuration

Create custom filters for generating separate reports based on 'Under' and 'Plant Code' conditions

Add New Filter

Filter Name

Under Values

Plant Code Values

Current Filters (8)

MYTR,ADI,SET,SAI

Under: MYTR, ADI, SET, SAI, Plant Code: RML-2, RML-4, RML-5

BANSAL

Under: BANSAL, Plant Code: Any

RML-3

Under: Any, Plant Code: RML-3

OMPL,OMIPL(RML-4)

Under: OASPL, GDPL, RSPL, RUPL, OMPL, OMIPL, Plant Code: RML-4

Automobile(RML-2)

Under: GDPL, Plant Code: RML-2, RML-5

Contractor

Under: CONT, Plant Code: Any

OMPL,OMIPL(RML-2)

Under: OMPL, OMIPL, Plant Code: RML-2, RML-5

OTHERS-DATA

Others rooms with incomplete employee data (zero deduction)

Sample Files

Download sample files to understand the required format (Excel for Employee Master, CSV for Readings)

Employee Master Sheet

Excel format (.xlsx) with merged cells for same rooms OR CSV format: Room Nur, Under, Employee Code, Employee Name, Plant Code. For contractors (Under = "CONT"), Employee Code can be blank.

Upload Employee Excel/CSV File

Electricity Readings

CSV format: Room Number, Units Consumed

Upload Readings CSV

Generate All Billing Reports

Process uploaded data and prepare all billing Excel files for download

How to Use

Step 1: Configure AC subsidy rooms that should receive 50 units free instead of 25 units for employees.

Step 2: Configure custom filters by adding filter conditions based on 'Under' and 'Plant Code' values.

Step 3: Download sample files to see the required format (Excel for Employee Master with merged cells, CSV for Electricity Readings).

Step 4: Prepare your Employee Master Excel file with columns: `Room Nur`, `Under`, `Employee Code`, `Employee Name`, `Plant Code`. Use merged cells for same room numbers. For contractors (Under = "CONT"), Employee Code can be blank.

Step 5: Prepare your Electricity Readings CSV with columns: `Room Number`, `Units Consumed`.

Step 6: Upload both files using the upload buttons above. Others employee data will be flagged.

Step 7: Click "Process & Generate Reports" to calculate and prepare all billing reports. Mixed rooms will have proportional subsidy calculations.

Step 8: Download the "Full Electricity Billing Report" and any of the custom filtered reports you configured.