Water Penalty Rates

Introduction

The penalty is levied on the consumer in case the consumer fails to make the payment for the bill raised before the specified due date. The consumer has to make the full payment before the due date to avoid penalty charges. The number of days after which the penalty is applicable is configurable at the ULB level. The penalty calculation logic may differ from one state or ULB to another.

The penalty can be -

Fixed amount
Percentage: When it is a percentage, it can be levied on
1. Entire bill amount
2. Balance pending when partial payments have been made

Data Table

Sr. No.	*Penalty based on (Bill amount/Balance pending)	*Grace period (days)	*Penalty flat amount (Rs)	*Penalty (%)
1	Balance Pending	15	40	10

Sr. No.

*Penalty based on (Bill amount/Balance pending)

*Grace period (days)

*Penalty flat amount (Rs)

*Penalty (%)

Balance Pending

The data given in the table is sample data for reference.

Procedure

Data Definition

Sr. No.	Column Name	Data Type	Data Size	Mandatory	Description
1	Grace period	Integer	2	Yes	After the bill is generated, certain days are provided to the citizen for making the payment
2	Penalty flat amount	Decimal	(3,2)	Yes	If the penalty is not levied on a percentage basis, it is generally a flat fee which is penalty charges amount
3	Penalty based on	Text	64	Yes	The penalty can be a certain percentage of the bill amount or balance pending if partial payments are made against the bill
4	Penalty (%)	Decimal	(3,2)	Yes	The penalty is calculated as a percentage amount based on either Bill amount or Balance pending

Sr. No.

Column Name

Data Type

Data Size

Mandatory

Description

Grace period

Integer

Yes

After the bill is generated, certain days are provided to the citizen for making the payment

Penalty flat amount

Decimal

(3,2)

Yes

If the penalty is not levied on a percentage basis, it is generally a flat fee which is penalty charges amount

Penalty based on

Text

Yes

The penalty can be a certain percentage of the bill amount or balance pending if partial payments are made against the bill

Penalty (%)

Decimal

(3,2)

Yes

The penalty is calculated as a percentage amount based on either Bill amount or Balance pending

Steps to fill data

Download the data template attached to this page.
Refer to the ‘Data Definition’ section of this document to learn more about the template sheet, data type, size, and definitions.
Please reach out to the person who has shared this template with you to discuss and clear your doubts.
Enter an appropriate value for Penalty Based On.
Enter a value for the Grace Period.
Enter the Penalty Flat Amount.
Enter the Penalty value in percent.
Verify the data once again by going through the checklist and making sure that each and every point mentioned in the checklist is covered.

Checklist

The checklist contains a set of activities to be performed once the data is filled into a template to ensure data entry requirements are met. These activities have been divided into 2 groups as given below.