Best Prompts for Grant Reporting

Good GrantLink prompts define the records, period, audience, evidence, and output. They also tell Chat what not to infer. Use these patterns after reviewing the underlying QuickBooks sync, allocations, budget, and program narrative.

Important: A prompt does not authorize unsupported access or make the output correct. Chat remains limited to the current organization, available tools, saved GrantLink records, the latest synced QuickBooks mirror, and content you attach. Review every external deliverable.

Before You Prompt

Choose the actual goal:

Goal	Ask Chat to…	Expected result
Check or explain data	Analyze or summarize	A Chat response; no report record
Download rows	Export the exact scope	One .xlsx/.csv download card
Fill a sponsor form	Use the saved grant Excel template	A report-specific workbook copy
Build a designed deliverable	Create a grant, program, or funder report	A Draft report and live Preview
Freeze a reviewed report	Generate a PDF	A Download PDF artifact

Rich report and PDF creation requires a Professional, Enterprise, or qualifying agency plan and available monthly report usage. Viewer-role users cannot use Chat.

The Prompt Pattern

A reliable request answers seven questions:

1. Scope: Which one grant, program, or funder owns the work?
2. Included grants: For a program or funder report, current, all, or which custom linked grants?
3. Period: What exact start and end dates apply?
4. Basis: Period activity, inception-to-date, or both?
5. Audience: Funder-facing, board, accountant, or internal operations?
6. Evidence: Which GrantLink data and attached documents support the content?
7. Output: Chat answer, rich report, PDF, sponsor workbook, Excel, or CSV?

Add explicit boundaries such as:

• "Use exact dates rather than an assumed calendar quarter."
• "Label period and inception-to-date amounts separately."
• "Do not invent outcomes, variance explanations, certifications, or missing sponsor fields."
• "Identify missing information for staff review."
• "Keep internal allocation exceptions out of the funder-facing report and list them in Chat instead."

Create a Grant Financial Report

Create a Draft progress report for [Grant Name] covering [start date] through [end date]. Show period and inception-to-date budget versus actual by real budget line, fund receipts, remaining balance, and variances greater than [threshold]. Put allocated transaction detail in an appendix. Use the latest synced GrantLink data, state the sync cutoff, and flag uncategorized or unresolved items in Chat rather than hiding them. Do not invent variance explanations.

Expected result: one grant-scoped Draft report with a live Preview. Verify that the report is associated with the intended grant and that the stated period matches the award.

Create a Narrative Progress Report

Create a funder-facing progress report for [Grant Name] covering [start date] through [end date]. Use the attached [program update name] for activities, outcomes, challenges, and next steps. Use GrantLink only for supported financial facts. If the source does not support a beneficiary count, outcome, or explanation, leave a clearly labeled item for program-staff completion instead of inferring it. Keep the narrative under [word count] words.

Attach the approved source in the same request. Chat cannot infer program results from spending patterns.

Create a Program Report

Create a program report for [Program Name] covering [start date] through [end date]. Include [current grants / all linked grants / exact custom grant list]. Show consolidated period and inception-to-date spending, then break out budget versus actual and receipts by grant. Do not combine incompatible budget categories without labeling the method. List grants excluded from scope in Chat before creating the report.

Current defaults to linked grants in Awarded, Active, or Closeout status. Name a custom set when the default is not appropriate.

Create a Funder Portfolio Report

Create a funder report for [Funder Name] covering [start date] through [end date]. Include [current / all / exact custom linked grants]. Show award amounts, period spending, inception-to-date spending, receipts, reporting deadlines, and a grant-by-grant appendix. Keep unresolved finance issues in Chat, not in the funder-facing page. Do not imply that one consolidated report satisfies separate award submission requirements.

Analyze Without Creating a Report

Budget versus actual check

Analyze budget versus actual for [Grant Name] from [start date] through [end date]. Use the budget workbook and allocated transactions. Show budget, period actual, inception-to-date actual, variance amount, and variance percentage by budget line. Identify uncategorized actuals and stale sync risk. Return the analysis in Chat; do not create a report.

Spending-pattern review

Analyze spending for [Grant Name] from [start date] through [end date]. Identify the largest vendors and budget lines, monthly trends, unusual values that merit human review, and categories with significant remaining budget. Describe the filters and basis for each observation. Do not call a transaction improper or ineligible without supporting evidence.

Cross-grant comparison

Compare [Grant A] and [Grant B] through [cutoff date]. Show award period, award amount, period and inception-to-date spending, receipts, budget structure, and upcoming reporting deadlines. Do not label a grant "on track" or "at risk" unless you define and show the calculation used.

Export Supporting Data

Export allocated transactions for [Grant Name] from [start date] through [end date]. Include transaction date, vendor, memo, source account, grant allocation amount, budget line, and allocation status. Return one Excel download. State the applied filters and row count.

Use CSV instead when a plain machine-readable file is required. For ambiguous filters or columns, ask Chat to preview the export scope before generating the file.

Use a Saved Sponsor Workbook

First upload the funder's original workbook under the grant's Details > Excel templates. Then prompt:

Generate a report-specific copy of the saved [template name] for [Grant Name], covering [start date] through [end date]. Use high-confidence values from the grant, budget, allocations, receipts, reporting cycle, and prior snapshots. Do not overwrite the stored template. Identify every field that is missing or needs staff judgment.

GrantLink generates a copy for review. It does not file the workbook, certify it, or request a draw.

Draft a Federal Review Worksheet Safely

Prepare an SF-425-style review worksheet, not a completed or filed SF-425, for [Grant Name] through [date]. Use only values supported by GrantLink data or the attached award documents. Separate period from cumulative amounts, show the source or calculation for each value, and mark unavailable fields for finance review. Do not certify, submit, log into a federal portal, or request a draw.

GrantLink can organize a review worksheet, but sponsor instructions and finance review remain authoritative.

Revise a Draft Precisely

Stay in the existing report chat and change one bounded item at a time:

• "Shorten the executive summary to 200 words; keep all dates and amounts unchanged."
• "Replace only the personnel variance paragraph with the approved text in the attached memo."
• "Move transaction detail to an appendix; preserve the reconciled total in the financial summary."
• "Remove the stock image; do not change the report content or layout."
• "Generate a new Letter PDF from the reviewed current preview."

After every revision, recheck totals, periods, unsupported claims, and print layout. A polished response can still be incomplete or wrong.

Prompts to Avoid

Avoid requests that leave material scope or evidence unstated:

• "Create my quarterly report." The grant and quarter boundaries are unknown.
• "Make the numbers work." Chat must not hide reconciliation differences.
• "Write impressive outcomes." Outcomes require program evidence.
• "Submit this to the funder." GrantLink does not submit through external portals.
• "Approve and publish everything." Report approval is not a Chat plan, and publication should follow human review.
• "Use all grants." For a program or funder report, define whether that means current, all linked, or a custom set.

Reuse Prompts Without Reusing Assumptions

Keep effective templates in team documentation or reopen prior chats for reference, but update the entity, included grants, exact dates, required fields, and evidence each time. Organization members with Chat access can load organization chat history; do not treat a conversation as private to its creator or place secrets in prompts.

For the full report workflow, see Creating Reports with GrantLink Chat. For verification steps, see Understanding AI-Generated Summaries.