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