Two requests, one tempting shortcut
You run a small service business that schedules client appointments. A funder pays for completed appointments; a referral partner tracks distinct clients reached. Both ask for “monthly activity,” so replacing their reports with one total looks sensible. But matching labels can hide different decisions. A tidy report could support payment while overstating reach.
Follow the repeat appointment
Consider one hypothetical month, using illustrative values rather than reported results. The funder pays €40 per completed appointment. Your team records 12 completed appointments for nine distinct clients; client A17 attended twice. Each record includes Client ID, Appointment Date and Status = Completed.
Your manager builds one summary, counts completed appointment rows and labels the result “Clients served: 12.” The appointment records remain intact. The summary has changed the counting unit: A17’s second visit becomes another person. The funder still has 12 billable appointments, but the referral partner receives an inflated reach figure. That could encourage expansion on the mistaken belief that more people used the service.
Check definitions before cutting work
Treat consolidation like a compilation: one cover can hold different answers. Keep the appointment records and calculate both completed appointments and distinct Client IDs. Repeat visits represent delivery without necessarily extending reach.
Before replacing either report, inspect its reporting period, completion rule and counting unit. Recalculate both totals from the same records, then trace A17: two appointments should contribute two to delivery and one to reach. Fail the check if the shared report shows 12 distinct clients or includes cancelled appointments. Correct the calculation and keep separate labelled measures before using it for payment or expansion decisions.
When one total is enough
In a hypothetical boundary case, both partners require completed appointments for the same period under identical status rules. One reconciled total can serve both. Consolidate when definitions match; preserve separate measures when they differ. Less preparation time may improve margin, but it does not itself prove additional demand or bring cash in sooner.