Restricted Fund Tracker

Restricted Fund Tracker

Track approved budgets, actuals and open commitments without treating the available budget as cash.

Method And Expected Result

Available = budget minus actuals minus open commitments. Invoicing an existing commitment transfers value to actuals; it must not count the same obligation twice. Availability does not override eligibility, award dates or approval requirements.

Worked planning examples, not customer performance results. Changes stay in this page until exported; reloading resets them. Keep sensitive personal information out of this planning tool.

Working Sheet

Edit the fields to calculate or prepare your working copy.

GrantCurrencyBudgetActualsOpen commitmentsAvailableEligibility reviewOwner
EDU-01USD1000060002000UnresolvedPendingGrant owner
HLT-02USD50001500500UnresolvedPendingGrant owner

Download Excel toolkit

The Excel toolkit includes the Restricted funds worksheet for this resource. CSV exports contain current values; Excel retains the calculator formulas.

Related Guidance