Why does multi-donor reporting cause so much rework?
A country office with three grants often has three sets of indicators. One donor wants “number of people trained”. A second wants “number of women and girls trained”. A third wants “number of people who passed the post-training test”. Each asks for a different period and a different form.
If each project team collects data for its own donor, the same activity gets counted three times, in three files, with three slightly different rules. At report time, someone reconciles them by hand. The work is slow, and two reports can show two different totals for the same event.
What is the one-list approach?
Collect once against your own list, then reshape for each donor. The list has three layers:
- Master indicators. Your organization’s own indicators, each with a definition, unit, source and disaggregation.
- Raw records. Attendance sheets, survey rows and distribution lists, stored in one agreed place.
- Donor views. Each report is built from the same records, using the donor’s wording and period.
Everything depends on the master definition being precise. If it is vague, the donor views will drift apart.
How do you build a crosswalk?
A crosswalk is a table that maps each master indicator to what each donor asks for. Build it when you sign the grant.
| Master indicator | Donor A wording | Donor A period | Donor B wording | Donor B period | Note |
|---|---|---|---|---|---|
| People attending hygiene sessions | Persons reached with hygiene promotion | Quarterly | Participants in hygiene education | Six-monthly | Same records; B counts only those who attended two sessions |
| Households with a working latrine | Households with access to sanitation | Annual | Same | Annual | Definitions match |
Follow these steps:
- List every indicator each donor requires.
- Match each one to a master indicator. If none fits, decide whether to add a master indicator or treat it as donor-specific.
- Write down any difference in definition, period or disaggregation.
- Ask the donor to confirm anything unclear. Do this early.
- Share the crosswalk with the teams who collect data.
What if definitions truly differ?
Sometimes you cannot reconcile them. One donor counts a person once per year; another counts each attendance. Do not bend the field data to match. Instead:
- Keep the raw record detailed enough to produce both numbers.
- Write down the rule used for each report.
- Add a short note beside the figure so a reader sees why two numbers differ.
Be careful with totals across donors. If two grants fund the same activity, adding their reach numbers can count the same people twice. Our article on reach totals and double counting explains why.
How do you handle different reporting periods?
Donors rarely share a calendar. One reports on the calendar quarter, another on a grant year that starts in July. Collect data monthly where you can, with the date of each event. You can then group the same records into whatever period each donor needs. If you collect only quarterly, you cannot rebuild a different period later. For more on this choice, see how to choose reporting periods for indicators.
What routine keeps this working?
- At the start of each grant: update the crosswalk and the master list.
- Each month: one person checks that data is complete and consistent.
- Before each report: one person approves every donor-facing number and signs off the crosswalk for that report.
- Once a year: retire master indicators nobody uses, and merge ones that overlap.
Keep a short log of questions asked by donors and the answers given. The next report will go faster.
Where EMPOBase fits
In EMPOBase, project indicators sit in Monitoring, results frameworks are tied to Programs, with a library of 235 indicators you can adapt to your master list. Approved collection submissions update indicator actuals, so a reviewer can check data before it counts. You can record donors in Donors and give donors read-only access through External Access. Keep the crosswalk itself in a document your team maintains, and check in a walk-through how your donors’ formats fit. See the indicator library for sample definitions.