Grant Spend-Down Tracker

What This Tracker Does

The grant spend-down tracker monitors budget burn for each active grant. It answers one question: given what we have spent and when the award ends, are we on track?

That question is deceptively simple. The answer has compliance implications. A grant that projects $40,000 unspent with two months remaining is not a financial planning problem - it is a compliance problem that requires action now.

The Tracker Structure

The tracker covers one grant per worksheet tab. For each grant:

Grant Summary Block

• Grant name and funder
• Grant agreement number
• Award amount
• Award start date and end date
• Total months in award period
• Current month (for calculating months elapsed and months remaining)
• Indirect cost rate (if applicable)

Budget vs. Actual Table

One row per budget line as approved in the grant agreement. Columns:

| Budget Line | Approved Budget | Month 1 | Month 2 | ¦ | Cumulative Actuals | Remaining Budget | % Spent | Variance Flag |

The budget lines should match the grant agreement exactly - not your internal budget structure, but the categories the funder approved. Common federal grant budget categories: Personnel, Fringe Benefits, Travel, Equipment, Supplies, Contractual, Other Direct Costs, Indirect Costs.

Enter monthly actuals from the accounting system, by grant fund code, after each month-end close. Do not estimate. Pull the exact figure from the GL.

Burn Rate and Projection Block

• Months elapsed since award start
• Total cumulative actuals
• Average monthly actuals (cumulative actuals · months elapsed)
• Required monthly actuals to reach $0 by award end (remaining budget · months remaining)
• Projected end-of-award balance (remaining budget ’ (average monthly actuals — months remaining))
• Alert: if projected end-of-award balance exceeds 10% of total award, flag red

Variance Flag Logic

For each budget line, calculate expected-to-date spending: (approved budget · total award months) — months elapsed. Compare to actual cumulative spending.

Flag lines where actual spending is more than 20% below expected-to-date. These are the lines that will drive underspend if the pattern continues.

Flag lines where actual spending exceeds the approved budget amount. This is a compliance issue - over-expenditure on a budget line requires a modification request or reclassification.