What manually aggregating grantee reports is actually costing your foundation

Ask a foundation what portfolio reporting costs and most will point to staff time during collection season. That figure is real, and it is also the smallest and most visible part of the bill.

Picture a foundation with 40 grantees, each submitting quarterly. Even at a conservative 90 minutes per submission, that comes to 60 hours a quarter spent turning inconsistent PDFs, decks and spreadsheets into one board-ready view. Across a year, that works out at roughly 240 hours, or six full working weeks, spent on reformatting rather than on understanding what the numbers actually mean.

The hours are the easy number to see

The costs that matter most never reach a timesheet.

The first is comparability. When forty organisations report in forty different formats, ranking them fairly becomes genuinely hard. A programme having a strong quarter can look weaker on paper than one having a mediocre quarter, purely because of how each report was formatted. Funding decisions made on that basis are shaped by presentation quality as much as by performance.

The second is speed. By the time a portfolio report reaches a board, its earliest submissions are often two or three months old. A problem worth catching early surfaces a full cycle late, because there was no way to see it until the whole batch had been compiled.

The third is the grantee relationship, and it is the easiest to underestimate. Every grantee chased for the same figures in a slightly different template each quarter feels that friction directly. Most funded organisations are already stretched thin, so a clunky reporting process becomes a small but real tax on a relationship that is meant to be supportive.

A rough sum worth running

Take those 240 hours and apply a conservative internal cost of, say, £35 an hour once salary and overhead are included. That is more than £8,000 a year in staff time spent on reformatting alone, before you count the cost of delayed decisions or strained grantee relationships. For a mid-sized foundation, that figure often runs higher than the amount actually budgeted for reporting infrastructure, largely because the cost has always sat hidden inside general staff time rather than named as its own line.

What actually fixes it

The fix is not a better spreadsheet, and it is not asking grantees to try harder. It is giving every organisation in your portfolio a consistent structure to report into, so the aggregation work currently done by hand happens on its own.

Each grantee submits into a shared environment instead of sending over their own document. Those submissions feed one master view without anyone reformatting them by hand. You can filter the report by programme, geography or time period without rebuilding it, and the picture updates as organisations submit rather than waiting for one collection push before a board meeting.

None of this changes what grantees measure or how rigorously they do it. It changes how their evidence reaches you, and how much of your team's time goes into moving information around instead of reading it.

Worth checking for yourself

Add up how many hours your team spent last quarter formatting rather than reviewing, and put a number against it. Most foundations have never run that sum, because the cost has always been absorbed into general staff time rather than named.

If the number comes out higher than you expected, book a call and we will show you what a shared portfolio reporting environment could look like for your foundation.