5 Ways to Use AI Most Nonprofit Finance Teams Haven't Tried
If AI keeps letting your finance team down, you're probably asking it to do the wrong things. Here are five things it's actually great at, each with a fully built prompt you can copy and paste.
Every prompt tells AI to show where it found each item, flag anything it isn't sure about, and never guess a number.
Free
5 prompts
Works in Claude, ChatGPT, or Copilot
Most finance teams try AI once: paste in a spreadsheet, ask a question, get an answer they don't trust. The useful work is elsewhere. AI is good at reading long documents, pulling out what matters, and drafting the first version of things your team writes every month. These five uses play to those strengths and keep the decisions with your team.
How it works
1
Gather
Each prompt says what to paste in: a grant agreement, gift letters, a variance report, an auditor's request list.
2
Paste
Open your AI tool, paste the prompt, and replace each [BRACKET] with your material.
3
Check
AI reads and drafts. Your team checks the output against the source and makes the call.
Before you start
Use an approved AI tool. Use the workplace version your organization has approved, with data settings reviewed.
Remove personal information. Strip donor home addresses, participant names and anything identifying a client before you paste. For gift letters, donor names may be needed; check your policy.
AI reads; you verify. Check every date, amount and restriction it pulls out against the original document before you rely on it.
Don't trust its arithmetic. For anything with math, have AI build formulas you can see and check (use 4 shows how).
The five uses
1
Use 1: Reading the grant agreement
Use it when
A new grant is signed, or you inherit grants and don't know every term.
You paste
The full grant agreement (or the terms, budget and reporting sections)
You get
A one-page compliance summary and a dated calendar of every report, deadline and requirement.
Guardrail Check every date and dollar amount against the agreement before it goes into your calendar.
Prompt
Read the grant agreement below and build a compliance summary for our finance team.
Extract only what the agreement says. Do not add requirements from general knowledge. For each item, quote or cite the section it comes from.
1. Grant basics: funder, grant number, amount, grant period, payment schedule.
2. Reporting calendar: every financial and narrative report, with due date, period covered, and format required. List in date order.
3. Allowable and unallowable costs: anything the agreement says the money can or cannot be used for, including any indirect cost rate or cap.
4. Budget rules: how much we can move between budget lines without approval, and how to request a change.
5. Match or cost-share requirements, with amounts and documentation required.
6. Other obligations: audit requirements, record retention period, acknowledgment/publicity rules, required approvals, reasons the funder can reduce or recover funds.
7. Anything unclear or unusual that our team should ask the funder about.
Then give me the reporting calendar again as a simple table I can paste into a spreadsheet: Due date | Report | Period covered | Section.
If the agreement doesn't address one of these topics, write "Not addressed in agreement."
GRANT AGREEMENT:
[PASTE THE AGREEMENT TEXT]
You need a clear list of restricted gifts: at year-end, before the audit, or before spending from a fund.
You paste
Gift letters, pledge agreements, or donor emails that set terms
You get
A restrictions register: donor, amount, purpose, time limits, and anything that needs a decision.
Guardrail The register is a working draft. Your team confirms each restriction against the original letter before reclassifying anything.
Prompt
Below are gift letters and donor agreements. Build a donor restrictions register for our finance team.
For each gift, give:
- Donor (as written)
- Date of letter
- Amount (or "pledge" with the schedule)
- Restriction type: Purpose restricted / Time restricted / Both / Perpetual (endowment) / Unrestricted / Unclear
- Purpose, in the donor's own words (quote it)
- Time conditions: when it can be spent, or when the restriction ends
- Conditions the organization must meet (matching, milestones, naming, reporting to the donor)
- Questions: anything ambiguous that our team should clarify with the donor or our auditor
Rules:
- Use only what the letters say. Do not assume a gift is restricted or unrestricted; if the language is unclear, mark it "Unclear" and quote the words that make it unclear.
- Do not decide accounting treatment. Flag items that may need our auditor's view.
After the register, list:
1. Restrictions that expire or become spendable in the next [NUMBER] months.
2. Gifts with donor reporting obligations, and when they're due.
GIFT LETTERS:
[PASTE LETTERS, ONE AFTER ANOTHER, WITH A LINE BETWEEN EACH]
The finance committee meets and the variance report is twelve columns nobody reads.
You paste
Budget vs actual (or your monthly financial package)
A few notes on what happened
You get
A one-page plain-English memo: the headline, what changed, what to watch, and what you need from the board.
Guardrail Every number in the memo should match the report. Check before you send.
Prompt
Turn the financial report below into a one-page memo for our board finance committee.
Audience: board members who are smart but not accountants. They have 5 minutes.
Structure:
1. The headline: one or two sentences on where we stand. Are we on track for the year?
2. What changed: the three to five biggest variances, each in one sentence with the dollar amount and the reason. Use only the reasons in my notes. If a variance has no explanation in my notes, write [REASON NEEDED].
3. What to watch: risks in the next quarter (cash, grant timing, revenue shortfalls), only if supported by the numbers or my notes.
4. What we need from the board: decisions or approvals, if any. If none, say "No action needed."
Rules:
- Plain English. No accounting jargon unless you explain it in a few words.
- Round to the nearest thousand in the text. Don't change the underlying numbers.
- Do not speculate beyond the numbers and notes provided.
- Under 350 words.
After the memo, list every number you used and where it came from in the report, so I can check them.
FINANCIAL REPORT:
[PASTE BUDGET VS ACTUAL OR FINANCIAL PACKAGE]
MY NOTES ON WHAT HAPPENED:
[PASTE NOTES]
You need a what-if: a late grant payment, a lost funder, a new program, a hiring freeze.
You paste
Your starting cash, expected inflows and outflows by month
The scenario
You get
Spreadsheet-ready tables with formulas you can paste into Excel or Google Sheets and check yourself, plus the assumptions written out.
Guardrail Paste the tables into a spreadsheet and let the spreadsheet do the math. Don't rely on numbers AI calculates in the chat.
Prompt
Help me build a 12-month cash flow scenario model in a spreadsheet. Do not calculate the results yourself. Build the structure and formulas so the spreadsheet does the math and I can check every number.
Scenario to model: [DESCRIBE, FOR EXAMPLE: "Our state grant reimbursements arrive 90 days later than usual starting in [MONTH]."]
Please give me:
1. An ASSUMPTIONS table (one input per row, with a label and a cell I can change): starting cash, each revenue source by month, each expense category by month, and the scenario inputs (for example, delay in days or % reduction).
2. A MONTHLY CASH FLOW table for 12 months: beginning cash, inflows by source, outflows by category, net change, ending cash. Every cell after the inputs must be a formula that references the ASSUMPTIONS table. Write formulas in Excel syntax and tell me exactly which cell each table starts in.
3. Two scenario columns or sheets: BASE CASE and SCENARIO, so I can compare them side by side.
4. A small SUMMARY: lowest ending cash month and amount for each case, and how many months of operating expenses that represents. Again, formulas only.
5. A list of every assumption you made about structure, and any information you need from me that I didn't provide.
Use only the figures I provide below. Where a figure is missing, leave the input cell blank and label it [NEEDED].
MY FIGURES:
[PASTE: STARTING CASH, MONTHLY REVENUE BY SOURCE, MONTHLY EXPENSES BY CATEGORY]
The auditor's request list (PBC list) arrives, or a few weeks before it does.
You paste
The auditor's request list
A list of what you already have (folder names or file list)
Last year's findings, if any
You get
A tracker matching each request to your documents, the gaps, who owns each item, and draft responses to open questions.
Guardrail AI matches by name and description only. Someone opens each file to confirm it's the right document before it goes to the auditor.
Prompt
Our auditors sent the request list below. Help me organize our response.
1. Build a tracker with these columns: Request # | Request (short) | Likely matching file(s) from our list | Status (Likely have / Partial / Missing / Unclear) | Owner [STAFF NAME] | Due date | Notes.
Match files only by name and description. If you're not confident a file matches, mark it Unclear.
2. List every Missing or Partial item, grouped by who probably needs to produce it (accounting, development, program, HR, executive director).
3. For each prior-year finding below, note which requests relate to it and what the auditor will likely check, based only on the finding's wording.
4. Draft short, professional replies for any request that asks a question rather than for a document. Use [BRACKETS] for facts I need to fill in.
5. Suggest an order of work: what to pull first so the auditors can start fieldwork on time.
Do not state that any document satisfies a request. Our team will confirm each one.
AUDITOR'S REQUEST LIST:
[PASTE THE LIST]
FILES / DOCUMENTS WE HAVE:
[PASTE FOLDER OR FILE NAMES, WITH A SHORT DESCRIPTION IF NEEDED]
PRIOR-YEAR FINDINGS (IF ANY):
[PASTE OR "NONE"]
Yes. All five prompts are on this page. Copy them one at a time or all at once. No sign-up required.
Which AI tool should I use?+
Any workplace AI your organization has approved: Claude, ChatGPT, Microsoft Copilot or Gemini. Tools that handle long documents and file uploads make uses 1, 2 and 5 easier.
Can AI read a scanned PDF of a grant agreement?+
Most current tools can read PDFs, including many scans. Check that the dates and amounts it pulls out match the original, especially on poor-quality scans.
Why not just ask AI to do the math?+
AI tools can make arithmetic mistakes that look confident. Having AI build formulas in a spreadsheet gives you a model you can see, check and reuse.
What makes these prompts different from writing my own?+
Each one is fully built for a specific finance task: it tells AI exactly what to pull out, what format to return, to quote or point to its source, and to flag anything unclear instead of guessing. That's what makes the output something your team can check quickly and trust.
Is it safe to paste donor letters or grant agreements into AI?+
Use the business version your organization has approved and check its data settings. Remove personal details you don't need, and follow your donor privacy policy.