Demonstration · not a client result
Donor MEL reporting automation what the deliverable looks like
The structure of the deliverable for donor MEL reporting automation, how it is produced and how you accept it, with a live specimen generated from the matching free tool’s worked example. Synthetic or permitted data only.
What this page isDemonstration
- Practice
- 05 Digital solutions
- The deliverable
- 4 sectionsProduced in 5 stages, each with a review point
- Data
- Synthetic or permittedNot a client result
Demonstration of methodSynthetic or permitted data.Not a client result.
The deliverable, section by section.
What you receive, and what each part is for.
Mapped pipeline
From your workbook to the donor template.
DemonstrationReconciliation checks
Totals and definitions checked every run.
DemonstrationException log
Records that fail checks, with reasons.
DemonstrationRunbook
How your team runs and maintains it.
DemonstrationA live specimen.
Generated from the worked example in Donor report reconciliation tool: synthetic data, real method. Change the inputs in the tool to see your own.
Demonstration · synthetic data · not a client result
| Indicator | Records | Sum of records | Reported | Difference | Status | Arithmetic | Completeness | Unresolved |
|---|---|---|---|---|---|---|---|---|
| Youth trained | 2 | 235 | 375 | +140 | 1 missing | Does not match | 1 missing | 0 |
| Internships started | 2 | 65 | 65 | 0 | Matches, not ready | Matches | Complete | 1 |
Exception log
- Check: Row 4: Youth trained at Ho has no value. Left missing, not counted as zero.
- Gap: Row 5: duplicate of Youth trained, Tamale, 2026-Q2. Not counted twice.
- Gap: Row 8: Internships started at Ho is negative (-3). Excluded until checked.
Missing values stay missing: a blank is never treated as zero.
How it is produced, and accepted.
Each stage ends in something you review; acceptance is tested against criteria agreed at the start.
- 01
User need
Agree the source workbook, the template and the indicators.
Review pointUser needs and success measures agreed.
- 02
Scope
Scope data flows, checks and exceptions.
Review pointWritten scope with acceptance criteria.
- 03
Build
Build the pipeline and checks.
Review pointWorking build demonstrated at agreed milestones.
- 04
Test
Test with past reporting cycles.
Review pointAcceptance tests passed and recorded.
- 05
Handover
Hand over, with a supported first live cycle.
Review pointHandover of code, content, access and documentation.
How proof is labelled
- DemonstrationsDemonstrations use synthetic or permitted data.
- Documented experienceDocumented experience is attributed to the organisation that held the work.
- Measured resultsMeasured results are added only once they have been measured; none are shown yet.
What needs to move forward?
Tell us the decision, the challenge or the opportunity. We reply with a scoped approach, a named principal and a fee before any work begins.
No charge to submit an enquiry.