Introduction
Interest is levied from on the consumer if the consumer fails to make the bill payment for the bill raised 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 should be 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: Interest 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 |
|
|
|
|
Note: Data given in the above table is a The table above contains sample data for Interest Rates.
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 | NAText | 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 |
Steps to fill data
Download the data template attached to this page.
Get a good understanding of all the headers in the Refer to the ‘Data Definition’ section of this document to learn more about the template sheet, their data type, size, and definitions by referring to the ‘Data Definition’ section of this document.In case of any doubt, please .
Please reach out to the person who has shared this template with you to discuss and clear your doubts.
Get information about the type of interest calculation logic that is followed
Get information about the grace period
Get information about interest percentage and what is interest based on.
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 is contains a set of activities to be performed one once the data is filled into a template to ensure data type, size, and format of data is as per the expectationentry requirements are met. These activities have been divided into 2 groups as given below.
Common Checklist
This checklist covers all the activities which are common across the entities.
Sr. No. | Checklist Parameter | Example |
---|---|---|
1 | Make sure that each and every point in this reference list has been taken care of. |
Entity Specific Checklist
This checklist covers the activities which are specific to the entity.
Sr. No.
Checklist Parameter
Example
1
Interest based on logic needs to be clear. Whether it is based on bill amount or pending amount
Interest based on balance pending
2
Data should be collected at state level as it affects the calculation logic
Separate Entity Specific Checklist is not required for this module data.