Sewerage Interest Rates

Introduction

Interest is levied on the consumer if the consumer fails to make the bill payment before a specified due date. The consumer has to make the full payment before the due date to avoid interest charges. The number of days after which the interest is applicable is configurable at the ULB level. The interest amount is charged to the consumer on a daily basis once the specified grace period is over and till the bill payment is done.

Interest rate: The interest rate on a daily basis can be levied on -

Entire bill amount
Balance pending when partial payments have been made

Data Table

Sr. No.	*Interest based on (Bill amount/Balance pending)	*Grace Period (days)	*Interest rate
1	Balance Pending	15	5

Sr. No.

*Interest based on (Bill amount/Balance pending)

*Grace Period (days)

*Interest rate

Balance Pending

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	Interest-based on	Text	64	Yes	Interest can be levied on either bill amount or balance pending if partial payments are made against the bill
3	Interest rate	Decimal	(3,2)	Yes	Time-based Interest percentage

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

Interest-based on

Text

Yes

Interest can be levied on either bill amount or balance pending if partial payments are made against the bill

Interest rate

Decimal

(3,2)

Yes

Time-based Interest percentage

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 the applicable Grace Period for calculating interest.
Select the relevant parameter for Interest-Based On to specify if the interest is applied to the bill amount or pending balance.
Enter the applicable percentage value for Interest Rate that will be used to calculate the interest amount.
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.