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.
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 | 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 |
Steps to create Sewerage Interest Rates master data table
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 onEnter 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
Separate Entity Specific Checklist is not required separatelyfor this module data.