/
Product - mGramSeva - iFIX

Product - mGramSeva - iFIX

Owned by Chandra Kiran (Unlicensed)
Last updated: Jan 04, 2022

Introduction  

This document contains Product Requirements and specifications of mGramSeva.

mGramSeva app is majorly used to capture revenue and expenditures of GPWSCs. This will also help in brining about financial transparency to DWSS department on handed over schemes.

iFIX is designed and developed in 4 important parts.

  1. mGramSeva

  2. iFIX Adapter

  3. IFIX Core

  4. Reference dashboard

 

About mGramSeva

  1. Manage Gram Panchayats Master Data

    1. Manage Gram Panchayat Administrator

      1. Scheme handed over to GPWSC - RD

      2. Scheme with WSSD - WSSD

  2. Manage GP Level Settings

    1. Electricity Meters etc..

  3. Manage User Access 

  4. Manage Receipts

  5. Manage Expenditure

  6. View Reports

  7. Integrate with iFix Adaptor

    1. Manage Internal Transaction to Head Mappings

    2. Post to iFIX

      1. Save Reference ID

    3. Reconcile Transactions

    4. Fetching data from other systems

      1. Rural development system

      2. Banks

      3. Origami

      4. PFMS/Treasury

      5. PSPCL

Abbreviations

Abbreviations

Description

GP

Gram Panchayat

HH

Household

FY

Financial Year

PSPCL

Punjab State Power Corporation Limited.

IFMS

Integrated Financial Management System

PFMS

Public Financial Management System

GPWSC

Gram Panchayat Water Supply and Sanitation Committee

 



Why mGramSeva

  1. No visibility in the financial information(revenue and expenditure) of the GPWSS run schemes.

Objectives

  1. Digitize the revenue collection process for water charges pertaining to schemes under GPWSC.

  2. Digitize expenditure information of schemes under GPWSC

  3. Pass the digitized fiscal information into the reference dashboard via iFIX.



Success Metrics

  1. 70% of GPs  from Anandpur Division should start using GPWSS system in month 1

  2. 90% GPs should start using GPWSS System by month 3

Potential Risks

  1. Not having adoption at ground

    1. Revenue collector not having a smart phone.

    2. Possible poor-connectivity issues in certain villages?

Users

  1. GPWSC committee 

    1. Sarpanch/Secretary 

      1. View the dashboards by month/by billing cycle to ensure collections and expenditure rightly collected and spent. 

    2. Treasurer

      1. Generate bulk demand for each billing cycle in addition to viewing the dashboards for each billing cycle.

  2. Revenue collector

    1. Revenue collector is responsible for collection of revenue under each billing cycle. 

      1. Visiting each HH, raising bills, entering meter details for HH with metered connection, collecting the amount and handling collected revenue back to treasurer/committee will be part of Revenue collectors job.

Types of roles

  1. Collection Operator

  2. GP Admin (Consumer creation)

  3. Revenue (Bulk Demand) Processing

  4. Expense Processing

  5. GP Dashboard 

 

Feature List

 

 

Feature Group

Sub - Feature

Remarks

Login

Select Language



Login



Forget Password



Cards listing based on roles (Landing Page)



Tenant Selection

Select Tenant



Switch Tenant



Generate Bulk Demand

Generate Bulk Demand



Bulk notification



Household information (New/Edit/Search)

New Connection



Search Connection



Edit Connection



View Household information



Billing

Raise Water bill (Metered)



Generate Bill (Acknowledgment screen)



SMS Notification



Bill PDF



Exception cases ??should this be handled.



Bill sequence number (Config)



Revenue of

Collect Payment



Generate Receipt



SMS Notification / eMail



Receipt PDF



Online Payment interface (navigated from SMS)



Payment gateway integration



Expenditure

Add Expense



Update expense detail



Dashboard

View collection & Exp dashboard



Sort & Filter Revenue table



Sort & Filter Expenditure table



Master

Revenue and Expenditure Heads

State

Scheme Master

State

Electricity Connection

Tenant

Boundary (Hierarchy Type, Boundary Type and Boundary)

State

Gram Panchayat

State

User Role

State

User

 

Rate

Tenant

Billing Cycle

 

Integration

PSPCL

NA

 

Out of scope : 

  • Penalty Calculation (P2)

  • Advance Payment (P2)


Links to Screens

Application Flow 


Registration, Login and tenant selection

 

Step

Description 

Screens

1

Registration:

Users will be invited to the GP system via SMS. SMS will take the user to a language selection screen followed by a password setup screen.

Users will have 3 languages to select English,  Hindi and Punjabi.

GPs linked to the user's mobile number are shown on this screen.

Password Validation

Once the password is set, the user can log into the system.

2

Click on ‘Continue to login’  to proceed to the login screen.

Enter phone number and password to login.

For users associated with single GP, home screen will be shown with NO Dropdown for GP selection

IF a GP is added/removed to a user at a later point of time, the same will be added/removed from dropdown.



3

For users associated with multiple GPs, the home screen will be shown with Dropdown for GP selection.

Drop down will contain a list of GPs linked to the user's mobile number in alphabetical order.

Show GP Code along with GP name

4

Users who want to reset their password or forgot password will come on forgot password screen by clicking on “Forgot Password” Link on login screen.

Enter phone number and continue to receive a link to reset password.

Phone number should NOT be new. It should already be existing (linked to any GPs) in the system



How will users change of phone number be entered?

 

 

New Connection & Modify connection

 

Step

Description 

Screens

1

Home Screen:

Users will see maximum 9  cards on home screen

  1. House Hold Register

  2. Create consumer

  3. Update Contact info

  4. Generate Water Bill

  5. Collect payments

  6. Download bill and receipts

  7. Add Expense record

  8. Update Expense record

  9. Dashboard

Validations: Depending on roles users will be able to take respective actions.

2

Consumer Creation

Users can create new HH/Consumer/Connection in the application using this option.  

UX after submitting the page - Confirm with Antriksh

Data Elements: 

  1. Consumer name*

  2. Father/spouse name*

  3. Phone number*

  4. Connection ID*

  5. Street number/street name

  6. Property type *

    1. Residential

    2. Commercial

  7. Service type*

    1. Metered Connection

    2. Non-Metered Connection

  8. Arrears

    1. Total Amount

    2. As on -  Date/Bill Month

Validations: 

  1. Same phone number with multiple connection IDs are allowed.

  2. Show error message when <user>  tries to create a second connection with the same connection ID, even if it is with a different phone number, name and address.

 

3

Edit Consumer information

Edit contact info (Home Screen) -> Search connection -> Consumer detail Screen

Connection ID is not editable. Rest all fields are editable.



4

Closed/Inactive connections



 

 

Generate Bulk Demand

Step

Description 

Screens

1

This screen will be used by <role> to generate Bulk demand for non-metered consumer types in the GP.

Once Demand is generated for a billing cycle  all non-metered consumers will get notification that a bill is generated.

*Metered connections will get bill generated messages only after meter reading is entered. 

Data Elements:

  1. Service Category

  2. Service Type

  3. Billing Year/FY

  4. Billing Cycle

    1. Monthly

    2. Bi Monthly

    3. Quarterly

    4. Half yearly

    5. Yearly



Validations

If the demand is already generated, it should generate only for those HH for which demand does not exist for the given cycle. 





 

2

Online Payment



An SMS with payment link is sent to HH(Non-metered) as soon as demand is generated. This link will contain payment to current month plus arrears if any.

For metered connections,SMS is sent only after revenue collector visits the household enters meter readings and generates the bill.

 

Billing

Step

Description 

Screens

1

<User> Can search for HH by mobile number or connection ID



Use Cases

  1. Mobile number or connection ID exists

  2. Mobile number has more than one HH

  3. Mobile number or connection ID doesn’t exist

  4. Both mobile number and Connection ID entered

    1. Correct mapping

    2. Incorrect mapping

2

Screen when HH mobile number has more than 1 Connection.

Each card will show following details

  1. Connection ID

  2. Owner Name

  3. Household Address

  4. CTA - View Details

3

After searching for HH by phone number or connection ID <user> lands onto this screen.

Show below details of the user

  1. Consumer Name

  2. Fathers/Spouse Name

  3. Phone number

  4. Connection ID

  5. Door Number

  6. Street Name/Street Number

Under this Aggregate information of the user is shown by the selected time range Financial year?

  1. Total amount paid

  2. Months paid for/ Months Demand is generated

  3. Units consumed

    1. For non metered connection this will be NA

  4. Months not billed

    1. Number of months in the selected year the household is not billed.

  5. Months unpaid

    1. Bill is raised but payment is not collected

  6. Net Due

    1. Amount to be paid against the bills raised

Below the aggregate information month wise billing information will be shown to <user>

Each card will have

  1. Month

  2. Amount

  3. Status & Actions (Mapped)

    1. Paid - Amount is collected

      1. Download Receipt

      2. Download Bill

    2. Unpaid - Bill is raised but amount is not collected

      1. Collect Payment

      2. Download Bill

    3. Unbilled -  Demand is generated but bill is not raised (Metered connections)

      1. Generate Bill

  4. Actions

    1. Generate Bill 

      1. Non metered connection - Generate bill option won’t be there as bill is already generated while demand creation

      2. Metered connection - User will be taken to generate a bill screen where meter readings will be entered.

    2. Download Bill

      1. Users will be taken to the download bill screen. A notification will be sent to HH with link to PDF

Is this possible? Are we storing month/cycle wise bill information for previous years too in the system?

  1. Collect Payment

    1. User will be taken to payment collection screen for respective cycle

  2. Download Receipt

    1. User will be taken to download receipt screen.Notification will be sent to HH with link to PDF

4

To generate bill for metered connection <role> will come onto this screen where

  1. Service category - Do we need this?

  2. Property type- Default

  3. Service type - Metered - Default

  4. Billing cycle(Month)

    1. Drop down can show list of months for which demand has been generated but not yet billed

  5. Previous meter reading (Number validation)

  6. New meter reading (Number validation)



Clicking on generate bill will generate bill for HH

Notification will be sent to HH

<role> will have the option to download the bill on his device.



5

HH information-> Generate Bill->Collect payment

HH information-> Collect payment

Payment information

  1. Bill ID number - Format

  2. Billing - Need to confirm whether payment will be collected for each month individually or will there  be only one bill generated which includes previous month bills as arrears?

 

Expense Record

 

Step

Description 

Screens

1

<user> Can record expenses from this screen.

Following details are captured while entering expense record 

  1. Vendor Name

  2. Type of expense (Expenditure heads)

  3. Amount

  4. Bill Issued Date (Calendar Selection)

  5. Bill Paid

    1. YES

      1. Amount Paid

        1. Partial

          1. Bill Due Date

        2. Full

    2. NO

      1. Bill Due Date

  6. Attach Bill



2

User gets to this screen from two flows

Home screen -> Click on Dashboard -> Expenditure Tab

Home Screen -> Update Expenses 

Dashboard will be filtered by date

Data fields

  1. Total expenditure - Bill raised in selected month or amount spent in selected month (Applies to all fields)

  2. Amount paid

  3. Amount unpaid

  4. Total Bills

  5. Bills paid 

  6. Pending Bills

  7. Electricity Bill

  8. O&M and Misc

  9. Salary.

 



 

Dashboard

 

Step

Description 

Screens

1

<role> clicks on dashboard on home screen to view GP dashboard

Default dashboard shows collections and expenditure table by each billing cycle in selected year(Financial/Calendar?)

Each cell represents net collection and expenditure for that billing cycle (Cash/Accrual?)