Customer story

How Midland Microfin moved 50+ incentive schemes for 4,000 field staff off spreadsheets

Midland Microfin Limited is a microfinance institution based in Jalandhar that runs incentives for 4,000+ field staff across about 500 branches in 10+ states. Its 50+ schemes vary by role, geography and loan type across a 7-level hierarchy, with short-term contests on top. These were calculated in spreadsheets, with no live view for the field. Data now refreshes daily, every scheme and exception runs in one engine, manual calculation effort fell by 95% and payout queries by 70%+.

Quick facts

At a glance

ItemDetail
IndustryBFSI, microfinance, India
Field users4,000+ field staff, from Centre Officers to Branch Managers and above
StructureAbout 500 branches in 10+ states, on a 7-level hierarchy
Plans50+ incentive schemes with geography variants, plus short-term contests
ProductsJoint Liability Group, Individual, Ajeevika, Education and Wash loans, each with its own incentive structure
DataDatasets integrated by the Midland team, refreshed daily
ModulesCalculation engine, contests, AI-powered nudges and leadership analytics
The problem

Why could Midland Microfin's field staff not see their incentive as they earned it?

Midland Microfin is a microfinance institution that pays 4,000+ field staff on incentives, from Centre Officers to Branch Managers and the levels above them. Every payout was calculated in spreadsheets. No one in the field could see what they had earned until the payout arrived.

The business was growing faster than the sheets. Midland runs about 500 branches in 10+ states and has planned to double its branch count. Each new branch added payees, schemes and rows to files that were already hard to check. When a number looked wrong, the question went back to the team that built the sheet, and payout queries reached that team every cycle.

Why spreadsheets broke

What made microfinance incentives hard to run in spreadsheets at Midland?

The structure of the plans. Midland runs a 7-level hierarchy, and across its roles there are 50+ incentive schemes. Many vary by geography, so the same role can earn on different rules in different states.

Each loan type carries its own incentive structure: Joint Liability Group, Individual, Ajeevika, Education and Wash loans. Teams are paid on different measures, including new disbursements, on-time collection, recovery of due amounts and team performance. Payouts also move with each branch's audit grade and its customer grievances.

On top of the regular schemes, Midland runs short-term contests. Each one had to be built, and then explained to the sales team, before it could change what they did.

The buying concern

What did Midland Microfin need to see before choosing an incentive platform?

Midland needed a system that could keep pace with its growth. Calculations could no longer run in spreadsheets, and every new branch and scheme had to fit without a rebuild.

Midland ran a proof of concept with Kennect before deciding. Its team could configure schemes on the platform itself, and Kennect turned the setup around quickly. That self-serve setup, and the speed of the proof of concept, set Kennect apart from the other options Midland evaluated.

How Kennect solved it

How does Kennect run 50+ microfinance incentive schemes on daily data?

The principle Kennect built around: every scheme, contest and exception runs in the system, so nothing goes back to a spreadsheet.

  • We take the datasets the Midland team integrated with Kennect and refresh them every day, so payees see current numbers.
  • We configure all 50+ schemes in the calculation engine, across the 7-level hierarchy, every loan type and each geography variant.
  • We let the Midland team design and launch short-term contests on the platform, and announce each one to the sales team in the Kennect app.
  • We hold exceptions in the system, including excluded transactions, mid-month changes to a collection agent's portfolio and overrides to sales attribution.

Manual effort in incentive calculation has fallen by 95%. The only manual step left is uploading a few datasets. That freed 200+ man-days once spent on incentive work, and Midland now runs incentive payouts with no spreadsheets at all.

Edge cases handled

How are mid-month portfolio changes handled for collection incentives?

A collection agent's portfolio can change partway through a month. The incentive then has to reflect that change, not just the portfolio the agent ends the month with. Kennect captures the change in the system, along with excluded transactions and sales attribution overrides, so the payout follows the rule Midland set instead of a manual fix in a sheet.

Across roles:

  • Field staff receive AI-powered nudges on what they have achieved and where to focus to reach their goals and earn more.
  • The incentive team configures schemes and contests on the platform and uploads only a small set of datasets each cycle.
  • Senior leaders, including the CFO, COO and the heads of sales, credit and operations, follow payout trends in ready incentive analytics.
Impact after go-live

What changed for Midland Microfin after go-live?

MetricBeforeAfterBasis
Manual effort in calculationSpreadsheets and manual calculation95% lower; only some dataset uploads remain manualIncentive team workload
Team time on incentive work-200+ man-days freedIncentive team workload
Payout queries-70%+ fewerPayout query volume
Spreadsheet useEvery scheme in spreadsheetsNone; exceptions held in the systemCalculation engine
Data refreshManualDailyData integration
Contest launchBuilt and explained by handConfigured on the platform and announced in the appContests on Kennect
Roadmap

What comes next

Midland has planned to double its branch network. Each new branch joins the same calculation engine, on the same schemes, contests and daily data refresh, so growth adds payees without adding spreadsheets.

Run incentives for your field force on one auditable ledger

See how Kennect calculates SKU group incentives, reruns six months of payouts and gives every rep a live view of what they earn.

Book a demo
People also ask

FAQs

How are incentives calculated for microfinance field staff?

Each role is paid on its own measures, such as new disbursements, on-time collection and recovery of due amounts. The scheme applies those measures by loan type and geography, then adjusts for branch audit grades and customer grievances. At Midland Microfin, Kennect runs 50+ such schemes across a 7-level hierarchy on data refreshed every day.

How can a lender run short-term sales contests without spreadsheets?

Configure each contest on the incentive platform and announce it in the same app payees already use. The contest then reads the same data as the regular schemes, so results need no separate sheet. At Midland Microfin, the incentive team designs and launches contests on Kennect and reaches 4,000+ field staff through the app.

How are incentive exceptions handled when a collection agent's portfolio changes mid-month?

The change is recorded in the incentive system and applied by rule, not adjusted by hand. The payout then reflects the portfolio change, along with any excluded transactions or attribution overrides for the period. Kennect holds these exceptions for Midland Microfin in the system, so none of its 50+ schemes needs a spreadsheet.

How do lenders reduce incentive payout queries from field staff?

Show staff their achievement and earnings during the cycle, not only at payout. Regular nudges tell each person where they stand and what to focus on, so fewer questions start. At Midland Microfin, Kennect's AI-powered nudges reach field staff through the cycle, and payout queries have fallen by 70%+.

How much manual effort does incentive automation remove for a microfinance institution?

Most of it, once data flows in and every scheme and exception sits in one system. What remains is uploading the datasets that are not yet integrated. At Midland Microfin, Kennect cut manual effort in incentive calculation by 95% and freed 200+ man-days of incentive work.

Related case studies

Explore more case studies