✏️Prompts

Check burn rate across all your grants Prompt

Prompt

Today is [DATE]. Below are our active grants with budget, spent to date, and grant period for each budget line.

For every grant and line, calculate:
- % of budget spent
- % of grant period elapsed
- Burn ratio (% spent ÷ % elapsed)
- Projected date the line runs out at the current pace (or "Won't run out")
- Projected unspent amount at grant end, if spending is slow

Return one table sorted by risk: lines running out earliest first, then lines with the largest projected unspent amount.

Then list the top 5 issues in plain English, with a recommended action for each (request a budget modification, slow spending, accelerate spending, ask for a no-cost extension).

Show the formula you used. Use only the data provided.

GRANTS, BUDGET LINES, SPENT TO DATE, GRANT PERIODS:
[PASTE]

Watch out for

Risks: AI can misapply funder rules or make math errors, and it only knows what you paste. Control: Your finance lead checks every total against the general ledger and makes all allowability and submission decisions.

Used by

Finance TeamsExecutives