Skip to content

Field notes

Why people get counted twice, and how to stop it

Double counting starts when each good program keeps its own list.

Impact Kompass team · · 6 min read

Ask any monitoring team how many people their organization reached last year and you will usually get a careful pause. The pause is honest. Each program knows its own participants well, but the organization as a whole has never seen them on one list.

A young farmer joins a savings group in March, attends a business training in June and signs up for a market linkage event in October. Three programs, three spreadsheets, three rows. Added together, she becomes three people.

Where the duplicates come from

  • Each program registers people on its own form, often with different fields.
  • Names are spelled differently from one form to the next: Ama Mensah, Ama Mensa, A. Mensah.
  • Phone numbers change, and ID numbers are optional or missing.
  • Partner organizations send their own lists, in their own formats.

None of this is a data-entry failure. It is what happens when good programs grow faster than the systems around them.

One profile per person

Impact Kompass reads every source and matches records into one profile per person and per enterprise. Exact matches on ID or phone number merge on their own. Near-misses, like a shared phone number with a slightly different name, wait as possible duplicates for someone on your team to decide.

Registration forms from three programs, one person.

Until a person decides, possible duplicates are counted separately, and every figure shows how many undecided pairs could affect it. Nothing is merged behind your back.

The first time we saw one list of everyone we had worked with, the number was smaller than we expected and far easier to defend.

Head of programs, a fictional livelihoods organization

Reach in layers

Counting people once is half the job. The other half is not adding things that should never be added. Direct participants, enterprises supported and people reached through partners are different kinds of reach. Impact Kompass reports them as separate layers and only combines them in an indicator that names each part.

The result is a people-reached number your board, your funders and your own staff can agree on, and trace back to the records behind it.

Why people get counted twice, and how to stop it · Impact Kompass