Best Prompts for Grant Reporting

The right prompt makes all the difference. This guide provides templates and examples for common reporting needs.

Financial Report Prompts

Basic Financial Summary

Create a financial summary for [Grant Name] covering 
[time period] showing:
- Total budget and spending
- Spending by category
- Remaining balance
- Burn rate

Budget vs. Actual Report

Generate a budget vs. actual report for [Grant Name] 
for [period]. Include:
- Each budget category
- Budgeted amount
- Actual spending
- Variance (amount and percentage)
- Notes on significant variances

Quarterly Financial Report

Create a Q[1/2/3/4] [Year] financial report for 
[Grant Name] that includes:
- Executive summary
- Budget status by category
- Comparison to prior quarter
- Spending highlights
- Any concerns or action items

Progress Report Prompts

Narrative Progress Report

Help me write a progress report for [Grant Name] 
covering [period]. The grant's goals are:
- [Goal 1]
- [Goal 2]

Include sections for:
- Activities completed
- Outcomes achieved
- Challenges encountered
- Next steps

Annual Report

Create an annual report for [Grant Name] for [Year].
Include:
- Year in review summary
- Financial overview
- Key accomplishments
- Impact metrics
- Lessons learned
- Plans for next year

Analysis Prompts

Spending Analysis

Analyze spending patterns for [Grant Name] and identify:
- Largest spending categories
- Trends over time
- Any unusual transactions
- Categories with significant remaining budget

Portfolio Overview

Give me an overview of all active grants including:
- Total funding and spending
- Grants by status (on track, at risk, etc.)
- Upcoming deadlines
- Cash flow considerations

Comparison Report

Compare [Grant A] and [Grant B] showing:
- Award amounts and spending rates
- Budget category breakdown
- Timeline and status
- Key differences

Funder-Specific Formats

Federal Grant Report

Create a federal financial report (SF-425 style) for 
[Grant Name] for [period] including:
- Federal cash on hand
- Total federal funds authorized
- Federal expenditures this period
- Cumulative expenditures
- Unobligated balance

Foundation Report

Create a foundation report for [Funder Name] grant 
following their format requirements:
- Brief narrative (250 words max)
- Financial summary table
- Key metrics and outcomes
- Budget modification requests (if any)

Tips for Better Results

Add Context

Include relevant details:

The grant period runs from [start] to [end].
The funder requires quarterly reports.
We're currently in month [X] of [Y].

Specify Format

Tell the AI how you want it:

Format this as:
- A two-page executive summary
- Bullet points, not paragraphs  
- Tables for all financial data
- Professional but accessible tone

Request Iterations

Build on the initial output:

Good start. Now:
- Add more detail to the personnel section
- Shorten the introduction
- Include a chart showing spending over time

Template Library

Save effective prompts as templates:

1. Create a great report
2. Note the prompt that worked
3. Save it for future use
4. Adapt for different grants