What's the best way to track grant budgets across several programs?

When a foundation runs more than one funding line, budget tracking tends to drift into a parallel universe. A finance spreadsheet, updated monthly, sitting separately from where the grants are actually managed.

On paper it works. In practice, program leads make commitment decisions against numbers that are already weeks out of date.

Here is the typical sequence. A lead approves a grant believing there is room in the budget. Then they discover that two other approvals landed in the same window. Multiply that across three or four programs and the year-end reconciliation becomes a multi-week forensic exercise:

• Matching committed amounts to paid amounts.
• Hunting down what was promised but never disbursed.
• Explaining variances no one can quite reconstruct.

The teams that escape this pain treat committed, paid and remaining as live figures attached to each program. Visible the moment a decision is made, not after the next monthly export.

It also makes a subtle governance point easier: distinguishing restricted from unrestricted funds, so money earmarked for one purpose is not accidentally committed elsewhere.

The goal is not fancier finance. It is making sure the number a program lead sees when they approve a grant is the real one.