The person who has to make the numbers make sense

The board pack is due. The CEO needs clarity on performance, commitments and where the foundation stands against its obligations. The information exists across custodian reports, investment statements, grant records and ESG documentation, but pulling it into a single coherent picture requires hours of manual work, careful cross-referencing and more than a little hope that nothing has been missed.

This is not an unusual situation. For many foundation finance teams, it is simply how the work gets done.

When Excel becomes the operating model

There is nothing wrong with a spreadsheet. For a specific task, at a specific moment, it is often exactly the right tool.

The difficulty arises when spreadsheets quietly become the foundation's primary system for managing financial reporting, investment reconciliation, grant tracking and ESG compliance simultaneously. When that happens, the spreadsheet is no longer a tool. It is the infrastructure.

And infrastructure built in Excel is fragile in ways that are easy to underestimate. A formula that has always worked until it doesn't. A file maintained by one person that nobody else fully understands. A reconciliation that takes two days to produce and another day to verify. Numbers that are probably right but carry a margin of uncertainty that nobody is entirely comfortable with.

The Finance Lead carrying this knows it better than anyone. So does the CEO who depends on it.

Holding two worlds together

The Finance Lead in a foundation occupies an unusual position.

On one side sits the rigour of financial control, compliance, audit readiness, accurate reporting and reconciliation across entities and custodians. On the other sits the investment portfolio, with its own reporting timelines, its own data formats and its own complexity.

Bridging those two worlds is the Finance Lead's core responsibility. Ensuring that investment activity translates accurately into financial reality. That grant commitments are reflected correctly in forward-looking obligations. That the CEO and board never encounter a number they cannot trace back to something reliable.

That is a significant responsibility to carry when the systems supporting it were not designed to hold both worlds together.

ESG reporting has raised the stakes further

Foundations are increasingly expected to demonstrate that their investment activity reflects their values, not just in principle but in practice and on paper.

For the Finance Lead, that means ESG reporting has become an operational reality, not just a governance aspiration. Data needs to be gathered across managers and asset classes, structured consistently and presented in a way that satisfies both internal governance requirements and external stakeholders.

Most of that work currently happens in Excel.

The challenge is not the commitment to ESG. It is building reporting that is rigorous enough to be credible, consistent enough to be comparable over time and efficient enough to produce without consuming weeks of manual effort before every reporting cycle.

The cost of fragmentation is rarely visible until it matters most

Finance teams working across fragmented systems and manual processes carry a risk that is easy to overlook precisely because they work so hard to manage it.

When the numbers reconcile, nobody notices the effort behind them. When they don't, the Finance Lead is the first person in the room with an explanation to find.

The Finance Lead's job is not to be the person who holds everything together through sheer effort and institutional memory. It is to be the person the CEO can turn to with a difficult question and receive a confident answer, one that doesn't need three caveats and a follow-up email to stand behind.

That is what a finance function built on trusted, connected information actually makes possible. Not less work necessarily, but work that produces something the whole organisation can rely on.

Other roles across the Foundation

The responsibility of protecting a foundation's mission runs through every role, just not in the same way. Across the foundation, the same tensions look different depending on where you sit.

Related articles:

→ The foundations that endure are not always the most ambitious. They are the most disciplined.

→ The investment committee carries full responsibility for capital it sees only occasionally

→ A foundation's reputation is built over decades. A board member's job is to make sure nothing quietly undermines it.