What funders actually ask for — and why it takes a week to answer

Ask any executive director what the quarterly funder report costs them, and the answer is rarely "the writing." It's the week before the writing — the part where someone reconstructs six months of program history from shift binders, a shared drive, three spreadsheets, and memory.

The questions themselves are not surprising. Across ministries, foundations, and municipal contracts, they cluster into four:

• Occupancy — how many licensed beds were filled, on average, over the period
• Length of stay — how long people actually stayed, per program and per site
• Completion versus discharge — who finished the program, and who left another way
• Move-on outcomes — where people went next: independent living, family, further care

None of these require sophisticated analysis. They require that somebody wrote things down in a form a computer can count.

The reconstruction problem

Here is what makes the week expensive. A bed that sat empty for eleven nights in March leaves no trace unless someone recorded the vacancy at the time. A resident who moved on to independent housing looks identical, in a paper file, to one who left without notice — unless the distinction was captured at exit.

So the report gets assembled backwards: from incident logs, from a coordinator's recollection, from the intake binder. The number that reaches the funder is a good-faith estimate, and everybody involved knows it.

That has two costs. The obvious one is staff time. The less obvious one is that an organization doing genuinely good work cannot prove it — and the next funding cycle is decided on what can be proven.

Keeping records that can answer

The alternative isn't more reporting discipline. It's recording the fact once, at the moment it happens, in a place that can be queried later:

• Bed status changes when the bed changes — occupied, reserved as of a date, in maintenance
• Exit reason is a required field at move-out, distinct from discharge
• Program completion is tracked separately from leaving, so completion rates mean something
• Visit and shift logs are timestamped when written, not backdated at quarter end

Once those four things are true, the quarterly report stops being an archaeology project. The numbers already exist; the report is a query and a review pass.

That is the whole argument for a system of record in community care. Not that software makes people better at their jobs — but that it makes the evidence of their work survive to the moment someone asks for it.