Roughly 25 to 40 hours a quarter back across operations and program leads
Roughly 25 to 40 hours a quarter back across operations and program leads
Roughly 25 to 40 hours a quarter back across operations and program leads
How a Brisbane community services not-for-profit sees a grant shortfall while there is still time to deliver it, not in the week the acquittal is due.
How a Brisbane community services not-for-profit sees a grant shortfall while there is still time to deliver it, not in the week the acquittal is due.
1
A shortfall found at reporting time is too late to fix.
A shortfall found at reporting time is too late to fix.
The acquittal report for a state government grant is due on a Friday, and the board pack is due the Tuesday after. On the Monday, the operations manager finishes matching service hours from the case management system to the grant's targets and finds the youth program 140 hours short for the year. The program lead's own spreadsheet had shown the gap opening in the second quarter. With four days left there are no sessions left to run, only a variance note to write to the funder. For the operations manager at a community services not-for-profit, that is when reporting stops being paperwork: a gap seen in month four can still be delivered, and the same gap seen in month twelve can only be explained.
The acquittal report for a state government grant is due on a Friday, and the board pack is due the Tuesday after. On the Monday, the operations manager finishes matching service hours from the case management system to the grant's targets and finds the youth program 140 hours short for the year. The program lead's own spreadsheet had shown the gap opening in the second quarter. With four days left there are no sessions left to run, only a variance note to write to the funder. For the operations manager at a community services not-for-profit, that is when reporting stops being paperwork: a gap seen in month four can still be delivered, and the same gap seen in month twelve can only be explained.
2
What had been delivered against each grant ran through one person.
What had been delivered against each grant ran through one person.
Each quarter, frontline staff logged service hours in the case management system and each of the five program leads kept participant outcomes in a spreadsheet of their own. The conditions of each grant sat in funding agreement PDFs on the shared drive. The operations manager emailed every program lead for their numbers, pasted them into a master spreadsheet and matched each line to a grant target by hand. She then wrote the funder reports and the board pack from that spreadsheet, usually across the last two weeks of the quarter. She weighed every hour by which report was due to a funder next, so checking programs against their targets mid-quarter always lost.
Each quarter, frontline staff logged service hours in the case management system and each of the five program leads kept participant outcomes in a spreadsheet of their own. The conditions of each grant sat in funding agreement PDFs on the shared drive. The operations manager emailed every program lead for their numbers, pasted them into a master spreadsheet and matched each line to a grant target by hand. She then wrote the funder reports and the board pack from that spreadsheet, usually across the last two weeks of the quarter. She weighed every hour by which report was due to a funder next, so checking programs against their targets mid-quarter always lost.
3
The system had to fit the tools and the privacy obligations the organisation already had.
The system had to fit the tools and the privacy obligations the organisation already had.
Three things had to hold for the change to survive a reporting quarter. Frontline staff had to keep logging in the case management system they already used, so it was connected rather than replaced. Client-identifying detail had to stay in the case management system, with the shared workspace carrying only hours, counts and outcomes by program, visible by role. And every AI-assembled funder report and board pack had to be released by a named person, with the chief executive releasing anything that went to a funder. If any one of those fails, program leads go back to their own spreadsheets and the operations manager goes back to chasing by email.
Three things had to hold for the change to survive a reporting quarter. Frontline staff had to keep logging in the case management system they already used, so it was connected rather than replaced. Client-identifying detail had to stay in the case management system, with the shared workspace carrying only hours, counts and outcomes by program, visible by role. And every AI-assembled funder report and board pack had to be released by a named person, with the chief executive releasing anything that went to a funder. If any one of those fails, program leads go back to their own spreadsheets and the operations manager goes back to chasing by email.
4
A quarter's funder reports now take about ten hours of review, not two weeks of chasing.
A quarter's funder reports now take about ten hours of review, not two weeks of chasing.
Every grant now has one record holding its conditions, its targets and the delivery logged against them. Service hours arrive from the case management system each week, and program leads enter outcomes against the grant they belong to instead of in their own spreadsheets. When a program runs behind its target, the system flags it to the program lead and the operations manager that week, with the hours still to deliver before the reporting date. At the end of the quarter the funder reports and the board pack assemble from the same records; the operations manager reads and corrects them, and the chief executive releases each one to its funder. The result is a shortfall seen while there are still sessions left to run, and roughly 25 to 40 staff hours a quarter back (illustrative figure, modelled for the segment).
Every grant now has one record holding its conditions, its targets and the delivery logged against them. Service hours arrive from the case management system each week, and program leads enter outcomes against the grant they belong to instead of in their own spreadsheets. When a program runs behind its target, the system flags it to the program lead and the operations manager that week, with the hours still to deliver before the reporting date. At the end of the quarter the funder reports and the board pack assemble from the same records; the operations manager reads and corrects them, and the chief executive releases each one to its funder. The result is a shortfall seen while there are still sessions left to run, and roughly 25 to 40 staff hours a quarter back (illustrative figure, modelled for the segment).