Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
All Gram Panchayats have a monthly billing cycle for water charges. The Scheduler automatically triggers on the “X” date of every month to generate demand and raise bills for non-metered connections.
Metered connections do not fall under bulk demand generation
For the first month of go-live, it is only the arrears and no demand that is generated hence there is no bill to collect payments.
From the second month (X date of Month 2) onwards, demand is generated.
Once the demand is generated, a notification is triggered to all mGramSeva users.
Details of Notification
“Demand for water charges has been raised for <GP>. New Bill Amount is Rs. Xyz. Overall pending amount is Rs.AbcD”
Each non-metered household also gets notifications
SMS Notification with Bill PDF
Dear “username”, A new water bill has been generated against <connection ID>. Please download the bill using <link>
SMS notification with a payment link
Dear “username”, A new water bill has been generated against <connection ID>. Please pay the bill online to avoid late payment charges<link>
Revenue collectors can see a new card (Updated card from month 2 onwards) with information related to demand and payment collection on the HH Details screen.
There is also a demand collection tile/card on the home screen.
This is used in cases when the scheduler is not run (due to technical errors) and the Gram Panchayat wants to run it manually.
The system does nothing if the manual demand generation is done in the middle of the billing cycle for which demand has already been generated.
Manual demand generation helps only when the scheduler has not generated a demand for a billing cycle.
To explore the Demand Generation Logic refer to Bulk Demand Generation for Non-Metered.
In the Bulk Demand screen -
Service Category: Defaulted to Water Charges (Module)
Service Type: Defaulted to “Non-Metered”
Billing Year: Dropdown with the list of the financial years from the master
Billing Cycle: Dropdown with the list of billing cycles for the selected financial year
Clicking on Generate Demand triggers the demand for the given billing cycle based on the logic defined above.
Users are redirected to the View Consumer screen from the home screen via
Collect payments → Search Screen → Consumer Details Screen
Download bills & receipts → Search screen → Consumer Details Screen
Dashboard → Collections → Click on Consumer ID
Household Register → Click on Consumer ID
This screen contains all information related to HH
Static HH card displays the following details
New Connection ID (also displayed as a heading)
Consumer name
Father's name
Phone number
Old connection ID
Address - Door Number, Street number, Ward (attached)
Property type
Service type
for metered connections - the meter number is displayed
If the bill is not generated (Post rollout until the first month)
Only the data Card is shown - No action is required
Once the first demand is generated - A new consumer bill/card gets generated and displays the following data points and actions -
Billing cycle – the latest billing cycle
Amount -
Current Amount - fixed charges applicable to the billing cycle
Arrears - Arrears from the first month (From next month onwards this field displays any unpaid dues)
Total Amount - Sum of current amount and arrears
Action Items
Download or Share Bill
Clicking on download bill prompts users to download the bill (Bill details are given in a separate user story)
Share bill (WhatsApp icon) opens sharing options to the phone OS and the user can share bills via WhatsApp
Message to go in WhatsApp “Please find Bill for water charges with Connection ID WS-83121-8312 generated on dd/mm/yyyy” along with bill PDF
Name of the PDF - “Bill ID”
Collect Payment
The Collect payment button takes the revenue collector to the payment collection screen
After the First payment collection is done
A receipt history block is visible only after the first payment transaction is completed through mGramSeva
A list of all the receipts is shown under this section as cards, with different data points as actions. Order of receipts is newest → oldest from top to bottom
Each receipt card contains
Receipt ID
Amount Paid
Paid Date
Actions
Download Receipt - Download the receipt in the Revenue Collector's phone as a PDF
Name of PDF - “Receipt ID”
Share (WhatsApp)
Message to go in WhatsApp “Please find the receipt for water charges with Connection ID WS-83121-8312 paid on dd/mm/yyyy” along with the receipt PDF
New Connection Before First Bill Generation
First bill is generated - Payment Collection is pending
2 payments made
If a bill is not generated (Post rollout until the first month)
A data card is displayed on the screen
Below the data card - the Card to generate a new bill is also displayed
This card contains
Last bill generation date - For the first time this is picked up from data entry. Next time onwards the system captures the last bill generation date
Days from last bill generation date - indicates to the revenue collector the number of days that passed since the last time a bill was generated.
Previous Meter reading - Displays the last read meter units
Pending Amount
Before the first bill is generated, the arrears are captured during data entry
After the first bill is generated, the pending amount includes the entire amount due for the specific user
Generate a new bill
Clicking on Generate a New Bill initiates bill generation flow for metered connection
Note - Users have to generate a bill to start collecting payments. Arrear amount collection also is not possible till the first bill is generated.
After the first bill is generated
A new consumer bill/card gets generated with the following data points and actions
Last bill generation date - date of bill generation
Amount -
Current Amount - Volumetric charges between 2 latest meter readings according to rate master
Arrears - All previously unpaid dues
Total Amount - Sum of current amount and arrears
Action Items
Download, Share Bill
Clicking on the download bill prompts users to download the bill for the respective amount (Bill details are given in a separate user story)
Share bill (WhatsApp icon) opens the sharing options of the phone OS and the users can share bill via WhatsApp
Message to go in WhatsApp “ Please find Bill for water charges with Connection ID WS-83121-8312 generated on dd/mm/yyyy” along with bill PDF
Name of the PDF - “Bill ID”
Collect Payment
Collect payment takes the revenue collector to the payment collection screen
After the first payment collection is done
A receipt history block is visible only after the first payment happens through mGramSeva
A list of all the receipts is shown under this section as cards, with different data points as actions. Order of receipts is newest → oldest from top to bottom
Each receipt card contains
Receipt ID
Amount Paid
Paid Date
Actions
Download Receipt - Download the receipt to the revenue collectors phone as a PDF
Name of PDF - “Receipt ID”
Share(WhatsApp)
Message to go in WhatsApp “ Please find receipt for water charges with Connection ID WS-83121-8312 paid on dd/mm/yyyy” along with receipt PDF
If a new bill is generated again by clicking on ‘Generate a new bill’ - the revenue collector goes through the bill generation flow and a single new card appears between ‘Generate bill’ and ‘Consumer receipts block’
The household masters have to be created in the system to initiate the demand generation and collection process. These consumers are also referred to as the household that regularly avails the water connection and supply.
Select the Create Consumer option from the list of tiles/cards on the home page. This redirects the user to the Create Consumer page.
Data element details for the consumer are listed in the table below -
Field Name | Type | Mandatory Y/N | Description |
---|
Multiple connections (HH or household records) can be created using the same phone number.
Phone numbers can be the same, but a new HH record cannot be created using the same old connection ID. The old connection ID should be different to create a new HH record.
A single HH record, cannot be registered in the system more than once. Trying to register the same record on the system again displays the error message “This connection already exists”.
Clicking on the Submit button creates the consumer master and a new consumer ID is assigned to the master. The consumer ID generated is based on logic defined as - “WS-<GP id>-<4 digit running seq No>”
If the connection ID already exists, the system displays an error message.
On first-time/new-load, all data entry fields and dropdowns are empty (since no records are prefilled except for the default fields).
SMS is not sent to any user upon consumer (HH) creation.
Submit is disabled until all mandatory fields are entered. Once all inputs are made, the button is enabled.
Arrears demand:
Metered - The arrear demand for the period is created, where the From date is counted as the start of the Financial year and the To date as the period mentioned on the screen.
Non-metered - The arrear demand is created for the selected billing cycle.
Successful creation of consumer records displays the toast message “ Registration successful”.
Closing this toast message, using the close icon, refreshes the page and the user sees an empty consumer creation screen.
Unlike non-metered connections with a billing cycle for demand & bills generated automatically, a metered connection needs more inputs, which helps in volumetric billing.
A revenue collector can see a CTA to “Generate a new Bill” on the HH details screen.
Clicking “Generate a new Bill” takes users to the bill generation screen where new meter reading details are entered.
The field on the bill generation screen for metered connections is displayed in the table below.
Clicking on “Generate bill” takes the user to the bill generation successful screen.
Logic for Bill ID number - “RB - dd/mm/yyyy-yy/running_sequence_number”.
There are 3 user actions on the success screen
Download bill - Download bill as PDF (name of PDF is always the Bill ID by default)
Share bill on WhatsApp - Share bill as PDF on WhatsApp
Collect Payment - navigates the revenue collector to the payment collection screen
Share on WhatsApp opens the WhatsApp share popup with the option to choose contacts/groups. The bill is shared with the below text and attached PDF details -
Text “ Dear <ConsumerName>, Please find water bill for billing cycle <Cycle> attached as PDF”
Input Metric | Description | Comments |
---|
To find details on Demand Generation Logic refer to the Demand/Bill Generation for metered connection.
All 5 digits in the meter reading must be entered. Show error message “ Old Meter Reading entered is Invalid” or “ New Meter Reading entered is invalid” respectively.
The New Meter reading should be greater than the Old Meter Reading.
The meter reading date is by default set to <today's date> but the user has the option to change it.
Consumer creation - non metered | Consumer creation - metered |
The user of the GP system is onboarded by loading user records in bulk as a backend activity. The system enables the loading of user records in bulk and creates the profiles with a mobile number as login ID and with a random password.
On loading user profiles - The GP users are sent a link and login credentials over SMS required to login to the mGramSeva application. The link navigates to this screen and takes the user through the flow of logging in and resetting the password in case of a first-time login.
The web link, too, initiates from the same screen.
Once the demand is generated for metered and non-metered connections, revenue collectors come to this screen to collect payments.
Users can see the consumer billing information on the screen
Clicking on View Details expands the card and shows more details. Clicking on the Hide Details collapses the card to show only the Connection ID, Consumer Name & Total Due Amount.
Payment amount - can either pay
The full amount, or
Custom amount - Users can enter the custom amount in the input field - this cannot be zero or greater than the total due amount.
Payment methods
Cash - select cash and proceed to payment takes the user to the successful collection screen
Online - The online payment option displays a Q/R code on the user screen that can be scanned by another phone to pay the due.
Post payment via any mode - payment success screen is shown
Receipt ID format - RB-dd/mm/yyyy-yy/running_sequence_number
User Actions
Download receipt - download the PDF version of the receipt with the receipt ID as the name of the PDF while downloading.
Share receipt via WhatsApp - opens the Phone OS sharing options.
back to home - takes the user back to the home screen.
SMS to HH
As soon as the amount is paid and the Revenue collector reaches the Payment success screen SMS is sent to HH.
SMS 1 - Dear ‘Username’, Paid Rs. X for water charges for bill period <Cycle>. Download receipt <link>
SMS 2 - Dear ‘Username’, Please leave a review on water supply at <GP> at <Link>
HH can leave a review for water charges. Refer Feedback - Post Payments
Details on the card
When an online payment method is selected, the “Collect Payment” option is disabled. Since HH scans the QR, the Revenue collector does not have control over the online process.
The partial amount cannot be greater than the full amount.
Consumer’s Name | Text | Y | Name of the household or connection owner. |
Gender | Radio | Y | Male, Female, Transgender |
Father's Name | Text | Y | Name of the father of the owner |
Mobile Number | Numeric | Y | Mobile number for the consumer |
Old Connection id | Alpha Numeric | Y | Old connection id or ref number for reference |
Door Number | Alpha Numeric | N | Address details with door number for the connection |
Street No/Street Name | Alpha Numeric | N | Street number or name of the house for the connection |
Ward | Drop Down | Y |
|
Gram Panchayat | Display | - | For info. the GP or tenant in which the connection master is created. |
Property Type | Drop Down | Y | Dropdown with the list of property types from Master ( Ex - Residential, Commercial, Mixed, etc) |
Service Type | Drop Down | Y | Dropdown with the list of service types from Master (Ex - Metered, Non-metered) |
Meter Number | Alpha - Numeric | Y | Only for Metered connections - Meter number will be attached to consumer respectively |
Previous meter reading date | Date selection | Y | Only for Metered connections - This field is used to tag arrears to a demand. Less than current Date. |
Previous meter reading | Numeric | Y | Only for Metered connections - This field is used to attach arrears to a demand. |
Last Billing Cycle Billed | Drop Down | Y | Only for Non-metered connections - Dropdown with the list of Billing Cycles prior to the current cycle. This field is used to specify the arrears or total outstanding as of the billing cycle. |
Arrears as of Last Bill | Numeric | Y | Arrears as of date - This will be considered for the first Demand/Bill generation as total outstanding or arrears as of the billing period mentioned. If no arrears are present to a HH, '0' has to be entered by the user. |
Submit | Button | - | On click of Submit button, the consumer master is created with the detail entered above. The new connection id is also generated as per the configuration. |
Previous Meter reading | Only for first-time bill generation |
New meter reading | For the first time and all consecutive bill generations | Previous meter reading units and previous meter reading dates will be taken from the last bill for new bill generation |
Meter reading date | The default is the current date. Revenue collectors can change it to a previous date if required. |
Consumer information can be edited under certain conditions -
Before the first demand is generated in the system
After the first demand is generated in the system
Users with permission to edit consumer records can click on the Edit Consumer info tile on the home screen. This navigates them to the consumer search screen.
Users can navigate to the Consumer Edit Screen from the search screen or the search results screen (Case when multiple search results are displayed).
On the successful load of the consumer edit screen, all data parameters of the consumer are shown (with editable and non-editable fields).
By Default - A new consumer ID is shown on the top of the screen and is non-editable.
The table below lists the editable field details -
Date Field | Before First Demand | After First Demand | Comments |
---|---|---|---|
In case there are arrears, demand is generated. If there are no arrears, demand is not generated.
Users can modify the arrear value. In such a case, demand is generated with the updated value.
Users can add arrear to the connection, for which arrear was zero at the time of creating the connection. In such a case, new demand is generated.
Clicking on the Submit button shows a nudge saying Details Submitted Successfully. Closing the nudge navigates the user back to the home screen.
The CTA is activated only when any field is changed or updated. Else, it is in an inactive state.
Expense modification is allowed based on the status of the payment as highlighted in the scenarios below -
Allows users to modify all the details except the Bill id. But the user has the option to mark the Bill as “Cancelled”.
Does not allow users to modify any details. But the user has the option to mark the Bill as “Cancelled”.
The users receive a link via SMS. Clicking on this link redirects the users to the login page of the NalJalSeva app. The users can log in from this screen or even reset their password in case they are logging in for the first time.
The link in the SMS redirects users to this screen which is the first screen which is the language selection screen. The user selects the preferred language and clicks on Continue. English, Hindi, and Punjabi are the supported languages with Punjabi as the default language. Localization in the screens is displayed based on the language selected.
The user enters the User ID, which is the registered mobile number of the user, and the system-generated password. Clicking on the Continue button logs in the user.
The Forgot Password link navigates the user to the password reset screen.
The user is redirected to the password reset screen where they enter the OTP received on the registered mobile number. The next screen prompts the user to enter a new password and then confirm the same. This is similar to the first-time login screen. Clicking on Submit displays the acknowledgement screen. Clicking on the Continue to Login button on the acknowledgement screen takes the user to the login page.
The user is redirected to the home page of the application which displays the menu options based on the mapped user role.
Click on the links below to explore the NalJalSeva workflows:
The expense entry for the O&M regularly is captured on this screen.
On selecting the option “Add Expense Record” from the list of tiles/cards on the home page, the user is navigated to the expense entry screen. The screen displays the following fields.
Field Name | Type | Mandatory Y/N | Description |
---|---|---|---|
On Submitting, the Expense entry gets created with a Bill number assigned. The Bill number generated would be based on logic defined as - “EB-<FY>-<4 digits running seq No>”
On Successful creation of expense entry, an acknowledgement screen is shown “Expense Entry successful” along with the Bill Number.
Users can walk through the application for a better understanding of different user actions available on key screens.
Note: For first-time users after login, the walkthrough automatically starts on the home page. For multi-tenant users, the walkthrough starts after selecting the tenant and landing on the home screen
Step Number | Element | Note |
---|
Step Number | Element | Note |
---|
mGramSeva users can edit their basic information like name, add gender, email and change the password using the hamburger menu on any screen.
Users can click on the hamburger menu from any screen. A slider from the left opens up.
Users can -
Change Language
Edit profile
Logout
Changing language changes localization as per standards
Edit profile takes users to the next screen where changes can be made to the user profile
Name - Can be changed
Phone number - Cannot be changed
Gender - This field is not present by default. Whatever the user enters is stored and saved
Email ID - It is an empty field. User input is stored as the user’s email id
Change Password - This takes users to the password changing screen where the old password, new password and confirmed new password have to be entered as per given standards.
Dynamic password validation happens the same as in the registration flow.
Until all fields are entered, the primary CTA is disabled.
Changing the password shows a nudge to the user “Password updated successfully” and closing this nudge takes the user to the user profile screen.
Clicking on save shows a nudge to the user” Details saved successfully”. Upon closing, this user remains on the screen but the fields show as edited.
Various SMS notifications are sent to different users on different actions. Below is a consolidated list of all SMS notifications required.
Event Type | Target User Type | Message | Comments |
---|
Bill and Receipt PDFs can be sent to consumers at multiple touchpoints.
When bulk demand is generated through SMS.
When a meter reading is done for metered connections, via SMS.
When the revenue collector goes to the HH screen and clicks on download PDF (into his mobile).
When the revenue collector goes to the HH screen and clicks on WhatsApp share PDF (Share PDFs on WhatsApp).
For mGramSeva users, different notifications are displayed on the home screen based on various system triggers.
A new card is used for each notification displayed below.
Cards have a countdown timer - today, 1 day ago, 2 days ago, 3 days ago, and so on.
Cards have a close icon on the top right corner. Upon closing, the card view is removed from the screen. Cards, by default, do not have an expiry date.
A “New” text is shown to the user whenever there is a new notification after the user's last login.
The notification header shows the number of notifications in brackets.
Trigger | When | Text | Action | Data Criteria |
---|
Detail | Comments | |
---|---|---|
Step Number | Element | Note |
---|
Step Number | Element | Note |
---|
Data Parameter | Description |
---|
Data Parameter | Description |
---|
Connection ID
New Connection ID will be displayed here
Consumer Name
Consumer Name (Should take updated consumer name)
Bill ID number
ID of the Bill
Bill period
For non-metered connections
This is the latest billing cycle for which demand is generated
For metered connections
This is the new bill generated from the meter reading between the 2 most recent billing dates
Format
Month <space> Financial Year
Previous meter reading date - New meter reading date
Water charges
Amount for the latest billing cycle
For metered, calculate charges as per rate master between the latest 2 billing dates
Arrears
All old arrears accumulated for HH
Expansion should breakup of arrears by individual billing cycles/bill generation dates
Total Due amount
Net amount consumer has to pay
Role: GP Admin
Actions:
Role: Collection Operator
Actions:
Role: Revenue Bulk Demand Processing
Actions:
Role: Expense Processing
Actions:
Role: Dashboard Viewer
Actions:
1 | Type of Expense | Select the category of expenditure |
2 | Vendor Name | Mention the name of the vendor who raised the bill |
3 | Amount | Add the amount that is mentioned in the bill |
4 | Bill Date | Add date on which bill is entered into records |
5 | Party Bill Date | Add date on which the bill is raised |
6 | Attach Bill | Attach JPEG/ PDF formats of the bill here |
7 |
1 | User feedback section | Feedback provided by consumers is shown here |
2 | Collections Snapshot | Summary of collections made in the selected time period |
3 | Search field | You can search for the consumer by Name or connection ID |
4 | Filters | Use filters to drill down by property type |
5 | Connection ID Column | These are new Connection IDs of consumers. Clicking on a consumer ID takes you to the respective Consumer Detail screen |
6 | Name | Name of the consumer |
7 | Collections | Collections made by the consumers in the selected time period |
On boarding - Creation login details | EMP/GP Users | Dear <user>, You've been invited to mGramSeva Application of Punjab. Please login using <Link>. Username: <Phone Number> Password: <Password> |
On boarding - First time login OTP | EMP/GP Users | OTP for resetting password on mGramSeva is <OTP> |
Forgot Password OTP | EMP/GP Users | OTP for resetting password on mGramSeva is <OTP> |
Demand (Bulk) | EMP/GP Users | Dear <user>, Demand for Billing Cycle <Cycle> has been generated for <GPWSC>. Kindly plan for collection of water charges for this period. <Link> | 1st of each month |
Pending Collection Reminder | EMP/GP Users | Dear <user>, Rs. <Amount> is pending collections against water charges at <GPWSC> as of <Date>. Click <Link> to see more details | fortnight |
On Collection Day | EMP/GP Users | Dear <user>, Rs. <Amount> has been collected today <Date> against water charges from <number> consumers in Cash for <GPWSC>. |
On Collection Day | EMP/GP Users | Dear <user>, Rs. <Amount> has been collected today <Date> against water charges from <number> consumers Online for <GPWSC>. |
New Calendar Month | EMP/GP Users | Dear <user>, Rs. <Amount> has been collected in <previous month> against water charges & Rs. <Amount> has been spent as expenditure for <GPWSC>. Click <link> to see more details |
Fortnight | EMP/GP Users | Please enter new expenditure bills online for <GPWSC>. Click <link> to make an expense entry now |
Alternate Fortnight | EMP/GP Users | Expenditure bills for <GPWSC> are awaiting payment confirmation. Please click <link> and mark them as paid, if paid already |
Demand (Bulk) - (NM & M) | Consumer | Dear <user>, water bill for <cycle> has been generated for consumer id <new consumer id> for Rs. <Amount>. Click <link> to download latest bill. | Dear <user>, water bill for <cycle> has been generated for consumer id <new consumer id> for Rs. <Amount>. Click <link> to download latest bill. Please make payment to your GPWSC. |
Demand (Bulk) - (NM & M) | Consumer | Dear <user>, pending amount for water charges for consumer id <new consumer id> is Rs. <Amount>. Click <link> to pay online. |
Bill Paid | Consumer | Dear <user>, Rs. <Amount> has been paid for water charges for consumer id <new consumer id>. Pending Amount is Rs. <Amount>. Click <link> to download receipt |
Feedback Collection | Consumer | Dear <user>, Thank you for paying water charges. Please take this short survey and help us know more about water supply at <GPWSC> |
Whatspp Message - Bill share | Consumer | x |
Whatsapp Message - Bill Payment | Consumer | Dear <user>, Rs. <Amount> has been paid for water charges for consumer id <new consumer id>. Pending Amount is Rs. <Amount>. Click <link> to download receipt |
Title | Gram Panchayat Water Supply and Sanitation |
Heading | Water Bill |
| As per user details (use mockups for reference)
|
| Service Type - As per Bill generated - Metered or Non metered. Bill Id - For metered connections, after service type - metered, add meter number, meter reading and meter reading date as additional fields before bill ID Bill Period - For non- metered - As per Billing cycle for which demand was generated. For metered, will based on the previous meter reading date of last bill and current meter reading date of the corresponding Bill. Bill Issue Date - Date on which the demand was generated. |
Text Above breakup of charges | Below is the breakup of pending water charges for the connection ID <New Connection ID> |
Breakup of Charges | Expansions of the amount to be paid. For non metered connections
For metered connections
|
Total Amount Due | Total Amount to be paid by consumer until time of bill generation (Also display in words) |
Previous Billing Cycle Summary | Under this section we’ll display data collected from user, along with collection and expenditure done by GP Example: If the bill is generated in November for October and previous months(arrears), all data shown will be w.r.t October. Text: Below is the User Feedback, Collections and Expenditure summary of <GPWSC> |
User ratings | Irrespective of service type, ratings of how many ever users, given in the last billing cycle, is shown. |
Collections | New Demand - Latest Demand generated Actual Collections - Actual collections made in the previous billing cycle Total pending Collections (cumulative) - Total pending collections for GP until the last date of the previous billing cycle
|
Expenditure | New Expenditure - Expenses logged in the previous billing month Actual Payments - actual payments made in the previous billing month Total Pending Expenditure (cumulative)- total pending expenses until last date of the previous billing month
|
Title | Gram Panchayat Water Supply and Sanitation |
Heading | Water Bill |
| As per user details (use mockups for reference)
|
| As per the Receipt generated - For metered connections, after service type - metered, add meter number and meter reading as additional fields before Receipt ID |
Text | Below is the breakup of the amount paid for water charges for connection ID <New Connection ID> |
Breakup of Charges | Expansions of amount to be paid. For non metered connections
For metered connections
|
Amount Paid | Total Amount paid by the consumer for the receipt to get generated
|
Due Amount |
|
Previous Billing Cycle Summary | Under this section we’ll display data collected from user, along with collection and expenditure done by GP Example: If the bill is generated in November for October and previous months(arrears), all data shown will be w.r.t October. Text: Below is the User Feedback, Collections and Expenditure summary of <GPWSC> |
User ratings | Irrespective of service type, ratings of how many ever users, given in the last billing cycle, is shown. |
Collections | New Demand - Latest Demand generated Actual Collections - Actual collections made in the previous billing cycle Total pending Collections (cumulative) - Total pending collections for GP until the last date of the previous billing cycle
|
Expenditure | New Expenditure - Expenses logged in the previous billing month Actual Payments - actual payments made in the previous billing month Total Pending Expenditure (cumulative)- total pending expenses until last date of the previous billing month
|
There are 2 methods to generate Bulk Demand -
Auto (scheduler based)
Manual
The demand is generated at the end of the month or the first day of the next month or as scheduled for the recently completed billing cycle. Use cases are as below -
First demand generated in the system: The demand is generated for the recently completed billing cycle considering the arrears in the master data. The arrears are tagged to the previous billing cycle of the current demand.
Consecutive demands: The demand is generated for all the months pending from the most recent to the last billing cycle completed.
The demand is generated for the recently completed billing cycle.
The demand is generated for the billing cycle selected by the user. The demand is generated only for those consumers for whom demand does not exist for the selected month.
First demand generated in the system: The demand is generated for the selected billing cycle considering the arrears in the master data. The arrears are tagged to the previous billing cycle of the current demand.
Consecutive demand: The demand for the selected month is generated only if the previous billing cycle demand exists. If the demand for the previous cycle does not exist, it gives an error message “Demand generation is pending from billing cycle - <Name of cycle>. Please generate demand from this cycle in sequence”. The validation considers the most recent billing cycle that exists in the system.
Charges/Heads & Calculation Logic
As part of V1, only the water charges head is applicable. Rate Master is defined at the GPWSC level.
Water Charges - Charges are applicable as defined in the Rate Masters based on - Validity, Property Type, and Service Type where the calculation type is “Per Bill Cycle” for the given billing period.
Bill Period - The billing periods are monthly as per the standards followed across GPWSCs. In future, GPWSC may switch to bi-monthly to reduce the processing effort. The sample billing period data is given in the MDMS data.
Exclusion
Reversion of demand is not allowed. This has to be done in the backend.
Exception reporting for every batch processing can be accessed from the backend only.
The demand is generated for metered connections for the billing period (defined based on the meter reading date) selected by the user at the time of recording the meter reading.
The 2 use cases to be handled are -
First demand generated in the system: The demand is generated for the selected billing period. The demand period would be from the “Previous meter reading date” from the consumer master or the demand created as part of the master TO the date entered in the billing screen. The arrears are tagged to the previous billing period of the current demand, and the period is from the start of FY to the “Previous meter reading date” from the consumer master.
Consecutive demand: The demand is generated for the period defined based on
From Date: Meter reading date from the last demand generated for the consumer
To Date: Is the selected meter reading date in the bill generation screen
As part of V1, only the water charges head is applicable. Rate Master is defined at the GPWSC level.
Water Charges - Charges are applicable as defined in the Rate Masters based on - Validity, Property Type, and Service Type where the calculation type is “Unit Rate” for the given number of units.
Bill Period - Is as per the date range selected for the bill generation.
Reversion of demand is not allowed. This has to be taken up in the backend.
New Consumer ID
NO
NO
Consumer ID is generated while user creation and is not editable
Consumer’s Name
YES
YES
bills, receipts, bill generation screens etc starts displaying the newly entered consumer name
Gender
YES
YES
Father’s Name
YES
YES
Phone number
YES
YES
Use Cases
After the phone number is changed, searching with the old/new phone number in the connection search screen leads to the same HH screen
SMS notifications are sent to the new mobile number of the user from the date of the change
Old Connection ID
YES
NO
Validated for unique IDs in the system for the GPWSC
Door Number
YES
YES
Street Number / Name
YES
YES
Ward Number / Name
YES
YES
Gram Panchayat Name
NO
NO
Property Type
YES
YES
Charges applicable as per rate master. Effects take place from the next billing cycle
Service Type
YES
YES
Effects take place from the next billing cycle
The last date of the current billing cycle is taken as the last meter reading date
Previous meter reading is captured while generating the demand
Meter Number
YES
YES
Previous meter reading Date
YES
NA
This field is not shown on screen after the first demand is generated
Previous Meter Reading
YES
NA
This field is not shown on the screen after the first demand is generated
Last Billing Cycle Billed
YES
NA
This field is not shown on the screen after the first demand is generated
Arrears as of Last Bill
YES
NA
This field is not shown on the screen after the first demand is generated. When changed the arrear demand is deleted and updated accordingly based on the selected service type.
Mark Connection as inactive
YES
YES
If a connection is marked inactive, it is not considered for demand generation for future billing cycles.
An inactive connection can be reactivated later from this screen.
Vendor Name
Text (With Suggestions dropdown)
Y
Name of the Vendor. The suggestion list is shown as the user entry is done for every character. The new Name will also create a Vendor Register.
Type of Expense
Drop Down
Y
Type of expense list From Master
Amount
Numeric
Y
Expense amount for the Bill
Bill Date
Date
Y
Date on which the bill is to be recorded in the registers. Validation - Before Current Date and after party Bill Date.
Party Bill Date
Date
N
Date on which the Party/vendor bill was issued. Validation - Before the Bill Date.
Bill Paid
Radio Buttons
N
With option Yes/No. To update status if it is paid. If yes, “Paid Date” is captured.
Paid Date
Date
N
Date on which the bill is paid. Displayed if the Bill paid option is selected as “Yes”. Validation - After Bill date and less than current Date.
Attach Documents
Doc Attachments
N
Option to upload documents (Max of 5). Supported files - PDF, JPEG, PNG. Should show required validation for other types of files.
Submit
Button
-
On click, the consumer master gets created with the detail entered above. The new connection id also should get generated as per the configuration.
Expenditure Entry
Expenditure entry Successful
1 | Tenant selection | Click here to switch to other Gram Panchayats |
2 | Household Register | Household Register contains a list of all consumers and their pending amounts |
3 | Collect Payments | Use collect payments to search for consumers, generate bills and collect payments |
4 | Download Bills and Receipts | Search by consumer details such as name or phone number to download bills & receipts |
5 | Add Expense Record | Use this to make a new expenditure entry into the system |
6 | Update Expenses |
7 | Generate Demand |
8 | Create Consumer | Create consumers records by adding details |
9 | Update Consumer Details |
10 | GPWSC Dashboard | View daily, monthly collection and expenditure summary |
11 | Notifications | Any new notifications that require your action regarding collections and expenditure will be shown here |
1 | Consumer’s Name | Start creating a consumer record by entering the consumer name |
2 | Gender | Select gender of the consumer |
3 | Father's Name | Add father’s name of the consumer |
4 | Mobile Number | Enter the mobile number of the consumer |
5 | Old Connection id | Enter OLD Connection ID Number. Eg.105 |
6 | Door Number |
7 | Street No/Street Name |
8 | Ward | Select the ward where the consumer resides |
9 | Gram Panchayat |
10 | Property Type | Select one from residential/commercial type of property |
11 | Service Type | Select if the connection is metered or non-metered |
12 | Meter Number | Add meter number of the connection of the consumer |
13 | Previous meter reading date | Add the date of the last meter reading |
14 | Arrears | Add amount the household has to pay until today |
New Demand Generation | Monthly | Demand Generated Demand for <billing cycle> has been generated. X bills have been raised and sent to X/X+Y households. Y bills have to be raised. Click here to see details | Take to a filtered view of household register with “Pending” selected | <billing cycle> - new billing cycle for which demand is generated - Demand will be generated on the 1st of each month |
Use - Case 1 | If GP has all non-metered connections then, all X/X bills are generated using bulk demand. Notification change as following Demand Generated Demand for <billing cycle> has been generated. X bills have been raised and sent to X/X households. Click here to see details | Take to a filtered view of household register with “Pending” selected | <billing cycle> - new billing cycle for which demand is generated
|
Use - Case 2 | If GP has all metered connections then, all 0/Y bills are generated using bulk demand. Notification changes as following New Billing Cycle New billing cycle will start today. Y bills have to be raised for last month. Click here to see details | Take to a filtered view of household register with “All” selected | <billing cycle> - new billing cycle for which demand is generated
|
Every fortnight | Pending Collections Rs.X is pending collection as of <Today's Date>. Click here to view dashboard | Take to current months revenue Dashboard | In the current financial year, for each consumer, demand raised minus receipt generated will be pending collections for that HH |
When collection happens | Collection Day | Send only on the days when a collection has happened either online or offline methods Todays Collections Rs. P has been collected today for water charges from <number> consumers in Cash. Rs. Q has been collected today for water charges from <number> consumers online. | Take to current months revenue Dashboard | Sum of receipts value generated that day in that GP via cash. |
New Calendar Month | 1st day of month | Month Summary Rs. X has been collected in <previous month> for water charges and Rs. Y has been spent as expenditure. Click here to view more details | Go to the most recent completed month's dashboard | X - Sum of receipts value generated that day in that GP via cash. Y - Expense Bills marked as paid last month (paid date is previous month) |
Every fortnight | Enter a New Expenditure Please enter new expenditure bills online. Click here to make an expense entry now. | Take to expense entry screen |
Alternate fortnight | Mark expense bills as paid This should only be sent when there is a pending bill is there. If all bills are paid already on the date of notification, do not send this. <N> expenditure bills are awaiting payment confirmation. Click here to search & mark as paid, if paid already. |
Bulk Demand generation doesn't happen as per schedule | Generate Demand We couldn't generate demand automatically for billing cycle <cycle>. Click here to generate demand manually. | Take to demand generation screen. |
Clicking on the Dashboard on the home screen navigates the user directly to the revenue dashboard of the current month. From here, the user can switch to the expenditure tab to get a view of expenses. This provides a tabular view of all expenses incurred in that month.
Following are the data points/actions needed on the screen:
Item | Description |
---|---|
The table on the screen is a horizontal scrollable one with the leftmost column fixed.
As soon as the revenue collector marks the bill as paid by the consumer, they receive one SMS with the link to the receipt in PDF format and another SMS with a link to collect feedback.
On selection of the “Modify Expense” option, the below search screen is shown for the users to search the Bill/s -
Search Criteria -
Vendor Name
Expense Type
Bill D
Search Result - Lists all the Expense bills matching the above search criteria
Bill ID
Type of Expense
Vendor Name
Amount
Bill Date
Status
Clicking on Bill ID displays the Expense Bill in edit mode based on the validations.
There is an option to download bills without clicking on collect payment.
Bills and Receipts can be downloaded by clicking on the card/tile named Download Bills & Receipts on the home page.
Clicking on this card takes the user to the consumer search page. Searching by a phone number/ connection ID redirects to the Household Detail page.
Search Expense Bills
Search by Bill ID or Vendor
The Vendor Name should be a partial match. As the user starts typing a consumer name, respective vendors get filtered in the table displayed below
Bill ID should be a partial match. As the user starts typing a New Bill ID, respective Bills should get filtered in the table displayed below
Filters
Default is “All” View. Switching to Paid or Pending filters the table accordingly. Alongside the filter, how many Bills fall into that filter is shown in numbers
The table also has sort options for each column (ascending, descending)
Columns
Bill ID - Vendor Name
Bill ID is assigned to each bill while creating an expense entry record
Sort happens on the Bill ID
Expense Type
Under which expense head the bill is tagged to
Amount
Bill Date
Paid Date
If Bill is not paid, this should show pending in RED
Heading
HouseHold Register
As of Date
As of <Todays Date>
Search
Search by consumer name or connection id
Partial match should be allowed.
Filters
Default is “All” selected
User can switch to “Pending” or “Paid” view. Based on selection, results are displayed in the table
Download PDF
Download PDF should download PDF format of Household Register with name of document as HH_Register_<Date>
WhatsApp Share
Should trigger same PDF as Whatsapp share
Columns
Connection ID
New Connection ID of the consumer. If there is a metered connection, an “M” in ⭕️ is shown alongside connection ID
Name
Name of the consumer - Similar to Revenue dashboard truncate it to 20 characters and show 3 dots
Pending Collections
Total pending collections of the consumer till date.
The table has sort options by all columns.
The sorted and filtered table, as in the screen view, is exported into the PDF format dynamically on printing.
Search Consumer records |
|
Filters |
|
Columns |
|