Copy & deploy · 14 prompts

14 Claude prompts for finance.

These 14 prompts cover the work a B2B finance team actually does: variance analysis and forecasts, close and management reporting, AR and collections, board and investor narratives, and risk and treasury. Each one is annotated, uses [PLACEHOLDER] tokens for your numbers, and is ready to paste into Claude. Swap in your data, keep your judgment on the output.

FP&A AND PLANNING

FP&A, forecasting, and variance analysis

01

Budget vs. actuals variance brief

Use when: you have a month or quarter closed and need to explain the gaps before the leadership review
You are a senior FP&A analyst. I am going to give you budget vs. actuals for [PERIOD, e.g. Q2 FY26].

Data (paste rows: line item, budget, actual, prior period actual):
[PASTE P&L OR DEPARTMENT DATA HERE]

Produce a variance brief:
1. Rank the 5 largest dollar variances and the 5 largest percentage variances separately. Flag any line where dollar and percentage rank disagree.
2. For each top variance, state whether it is favorable or unfavorable, the size, and a plausible driver based only on the data. Where you are inferring, label it "hypothesis" and tell me what to check to confirm.
3. Separate timing variances (will reverse) from run-rate variances (structural) where the data lets you, and say which is which.
4. Flag anything that looks like a coding error or one-time item I should scrub before reporting.
5. End with 3 questions I should ask the relevant department owner.

Keep numbers exactly as given. Do not round in a way that changes the story. Output as a tight memo, no preamble.
02

Driver-based revenue forecast builder

Use when: you are rebuilding a forecast and want the logic explicit instead of buried in spreadsheet cells
Help me build a driver-based revenue forecast for [BUSINESS / SEGMENT] over the next [N] months.

Inputs:
- Revenue model: [e.g. SaaS subscription, usage-based, services]
- Current baseline (paste): [STARTING ARR/MRR, customer count, ACV, churn rate, expansion rate]
- Known commitments: [signed deals, ramp schedules, planned price changes]
- Assumptions I want to test: [e.g. new logo adds per month, gross churn %, net revenue retention]

Do this:
1. Lay out the forecast as a driver tree (what multiplies into what), not a flat number.
2. Build three scenarios: conservative, base, stretch. State the specific assumption changes between them in a table.
3. Show month-by-month revenue and ending ARR/MRR for the base case.
4. Call out the two or three assumptions the output is most sensitive to, and quantify the swing.
5. List the assumptions I should pressure-test with Sales and CS before I commit this.

Show your arithmetic so I can audit it. Do not invent inputs I did not give you; ask if something critical is missing.
03

Headcount and OpEx plan reconciliation

Use when: Finance and the hiring managers disagree on what is actually in the plan
Act as my FP&A partner reconciling a headcount and operating expense plan.

I will give you two things:
- Approved plan (paste): [ROLE, DEPT, START MONTH, FULLY LOADED COST]
- Current state or hiring manager ask (paste): [ROLE, DEPT, STATUS, COST]

Reconcile them:
1. Produce a line-by-line diff: roles added, removed, moved, re-timed, or re-priced versus the approved plan.
2. Quantify the total annualized cost delta and the in-year (this fiscal year) cost delta separately, since timing matters.
3. Flag any role that is double-counted, mis-departmented, or missing a fully loaded cost.
4. Convert each open role's start-month change into a dollar impact on the current quarter and full year.
5. Summarize in two sentences I can send to the CFO: what changed and what it costs.

Use only the figures provided. Where a fully loaded cost is missing, mark it TBD rather than estimating.
CLOSE AND REPORTING

Month-end close and management reporting

04

Management report narrative from the numbers

Use when: the close is done and you need the written commentary that goes around the tables
You are drafting the management commentary for our [MONTH] reporting package. Write for an executive audience that reads the narrative before the numbers.

Financials (paste P&L summary, plus prior month and prior year where available):
[PASTE SUMMARY P&L AND KEY METRICS]

Context I want reflected: [e.g. closed a large deal, one-time legal cost, headcount ramp]

Write:
1. A 4 to 6 sentence executive summary: how the period landed against plan and against prior period, in plain language.
2. Revenue commentary: what moved and why.
3. Margin and cost commentary: gross margin, OpEx trend, anything off-trend.
4. Cash and runway note if cash data is provided.
5. A short "watch list" of 2 to 3 items for next period.

Rules: be specific with numbers, attribute drivers only where the data or my context supports it, and never use em dashes or en dashes. No filler adjectives. If a number contradicts my context, surface the conflict rather than smoothing it over.
05

Close checklist and reconciliation reviewer

Use when: you want a second set of eyes on the close before sign-off
Act as a controller reviewing a month-end close. I will paste my close checklist and the status of each item.

Close data (paste): [TASK, OWNER, STATUS, NOTES, ANY RECONCILING ITEMS]

Review it for risk:
1. Identify any task marked complete that has an unexplained reconciling item or a note that contradicts "done."
2. Flag accounts where the reconciling balance exceeds [MATERIALITY THRESHOLD, e.g. $5,000] and is not explained.
3. Call out missing standard close steps for a [INDUSTRY / ENTITY TYPE] company (accruals, prepaids, deferred revenue, intercompany, FX revaluation, etc.) that are absent from my list.
4. Order the open items by what blocks sign-off versus what can trail.
5. Give me a one-line readiness call: ready to close, close with noted exceptions, or not ready, with the reason.

Do not assume an item is fine because it is marked complete. Treat blank or vague notes as a flag, not a pass.
06

Cash flow bridge explainer

Use when: net income and cash moved in different directions and someone is going to ask why
Build me a clear cash flow bridge and explanation for [PERIOD].

Data (paste): net income, change in AR, change in AP, change in deferred revenue, change in inventory, capex, financing activity, beginning and ending cash.
[PASTE FIGURES]

Do this:
1. Walk from net income to ending cash as a step-by-step bridge, each line labeled as a source or use of cash with the dollar amount.
2. Explain in plain English why cash and profit diverged this period, naming the 2 to 3 biggest reconciling items.
3. Flag any working capital swing that looks unsustainable or like a timing artifact that reverses next period.
4. Give me one sentence I can say to a non-finance executive about what is really happening with cash.

Keep the arithmetic visible so the bridge ties to ending cash exactly. If it does not tie, tell me where the gap is rather than forcing it.
AR AND COLLECTIONS

Accounts receivable, collections, and credit

07

Aging-driven collections action plan

Use when: the AR aging report is bloated and you need a prioritized plan, not a guilt spiral
You are my AR analyst. Here is the current accounts receivable aging.

Aging data (paste: customer, invoice, amount, days past due, last contact):
[PASTE AGING REPORT]

Build a collections action plan:
1. Segment receivables into current, 1 to 30, 31 to 60, 61 to 90, and 90+ days past due, with totals per bucket.
2. Rank accounts by collection priority using both dollar size and days outstanding, not just one. Name the top 10.
3. For each top account, recommend the next action (reminder, call, payment plan, hold, escalate) and the tone.
4. Estimate the at-risk balance (anything 90+ or with no recent contact) and what an allowance for doubtful accounts conversation should consider.
5. Flag any customer concentration risk where one account is an outsized share of total AR.

Use only the data provided. Do not assume a customer is delinquent if the days past due is zero or negative.
08

Collections email that keeps the relationship

Use when: you need to chase payment from an important customer without burning the account
Write a collections email to a customer who is [N] days past due.

Details:
- Customer: [NAME], relationship: [new / long-standing / strategic]
- Invoice(s): [NUMBER, AMOUNT, DUE DATE]
- History: [first reminder / second reminder / previously promised to pay / went silent]
- Outcome I want: [payment by a date / a payment plan / a reason for the delay]

Draft the email so it is firm but professional, easy to act on, and protects the relationship. Include a clear payment link or instruction placeholder, a specific requested date, and a single clear ask. Keep it under 150 words. Offer a short alternative version that is one notch firmer in case this is the second attempt.

Do not use any em dashes or en dashes. No guilt-tripping, no legal threats unless I explicitly ask for the final-notice version.
09

Credit limit and terms recommendation

Use when: Sales wants to extend terms to a new or growing customer and you have to make the call
Help me make a credit decision for a customer requesting [TERMS, e.g. net 60 with a $X credit limit].

What I know (paste any of): payment history with us, current balance, days-to-pay average, order size, public financial signals, industry, any credit report data.
[PASTE WHAT YOU HAVE]

Do this:
1. Summarize the customer's payment behavior and credit signals from the data, separating fact from inference.
2. Recommend a credit limit and payment terms, with the reasoning tied to the evidence.
3. List the conditions or guardrails you would attach (deposit, milestone billing, periodic review, personal guarantee) and when each applies.
4. Identify what additional information would most change your recommendation, so I know what to request.
5. Give me a two-sentence rationale I can send to the Sales lead.

Be explicit about uncertainty. If the data is thin, say the recommendation is provisional and name the gap.
BOARD AND INVESTOR

Board, investor, and executive communication

10

Board deck financial section outline

Use when: you are building or tightening the finance pages of a board deck
Help me build the financial section of a board deck for [COMPANY], stage [SEED / SERIES A / GROWTH / PROFITABLE].

Inputs (paste): latest P&L summary, cash and runway, key SaaS or unit metrics, plan vs. actual highlights, top wins and misses this period.
[PASTE INPUTS]

Produce:
1. A slide-by-slide outline for the finance section: title of each slide, the one message it must land, and the 3 to 5 numbers or charts it shows.
2. The single headline takeaway the board should leave with about the company's financial position.
3. For each slide, the likely board question and a one-line answer I should be ready with.
4. A "do not bury this" list: anything in the data that is bad news the board needs to hear directly.

Match the altitude to the stage: an early-stage board cares about runway and burn, a growth board cares about efficiency and durability. Be direct about risks; boards punish surprises, not bad news.
11

Investor update financials in plain English

Use when: you are writing the numbers section of a monthly or quarterly investor update
Draft the financial portion of an investor update for [PERIOD].

Data (paste): revenue and growth, gross margin, burn or profit, cash balance, runway in months, and 2 to 3 key metrics for our model.
[PASTE DATA]

Write:
1. A short, confident financial summary: where we are on revenue, efficiency, and cash, in language an investor skims in 30 seconds.
2. A clear statement of runway and the assumptions behind it.
3. One honest line on the biggest financial risk or watch item.
4. A specific "how investors can help" line if it relates to finance (intros, hiring, follow-on signaling).

Tone: candid, numerate, no spin. Investors model the numbers themselves, so accuracy beats optimism. Never use em dashes or en dashes. Flag any number you think looks inconsistent with the rest rather than reporting it blindly.
12

Tough finance question prep

Use when: you are walking into a board or exec meeting where the numbers invite hard questions
Act as a skeptical board member and CFO coach. Here is the financial picture I am presenting at [MEETING].

What I am showing (paste): the key numbers, the story I plan to tell, and any soft spots I already know about.
[PASTE]

Do this:
1. Generate the 10 hardest, most specific questions a sharp board member or investor would ask about these numbers.
2. For each, give me a strong, honest answer, and flag where my current data does not actually support a clean answer.
3. Identify the one question I am least prepared for and tell me exactly what to go calculate or confirm before the meeting.
4. Point out any place where my planned narrative gets ahead of the evidence.

Be adversarial and specific. Do not lob softballs. If a number invites a follow-up I would not want, surface it now.
RISK AND TREASURY

Risk, treasury, and contract finance

13

FX and concentration exposure scan

Use when: your revenue or costs span currencies and customers, and you want the exposures named before they bite
Act as a treasury analyst. Scan my exposures for [COMPANY] and flag what matters.

Data (paste any of): revenue by currency, costs by currency, top customers as a share of revenue, top vendors as a share of spend, cash by currency and account, debt and covenant terms.
[PASTE DATA]

Produce:
1. Currency exposure: where revenue and costs are mismatched by currency, and a rough sense of which way a [X]% move hurts.
2. Customer concentration: any customer above [THRESHOLD, e.g. 10%] of revenue, and combined top-3 and top-5 share.
3. Vendor and supply concentration risk worth noting.
4. Liquidity risk: cash trapped in the wrong currency or entity, and any covenant headroom concern.
5. A prioritized list of the 3 exposures I should address first and a sensible first action for each (natural hedge, forward, diversification, covenant conversation).

Use only what I provide. Be clear about which exposures are large versus merely present, and do not recommend a hedge before naming the natural offsets already in the data.
14

Contract financial terms reviewer

Use when: a customer or vendor contract landed on your desk and you need the money terms pulled out fast
You are a finance reviewer reading a [CUSTOMER / VENDOR] contract. I care about the financial and cash terms, not the legal language.

Contract text (paste the relevant sections):
[PASTE CONTRACT]

Extract and assess:
1. Pricing, total contract value, and how it is calculated, including any usage, overage, or escalator clauses.
2. Payment terms: invoicing timing, net days, late fees, and anything that delays our cash.
3. Revenue recognition flags: milestones, acceptance criteria, refunds, or termination-for-convenience clauses that affect when and whether we can recognize revenue.
4. Auto-renewal, price-lock, and termination terms and their cash impact.
5. Any term that is unusual or off-market for this kind of deal, and the question I should raise.

Quote the exact contract language for each point so I can verify it. If a financially important term is silent or ambiguous, say so explicitly; silence is a risk, not a pass. This is a finance read, not legal advice.
FAQ

Frequently asked questions

Is it safe to paste actuals, forecasts, or customer-level data into Claude?
On Claude Team or Enterprise, your prompts and uploads are not used to train Anthropic's models, and conversations stay inside your workspace. That makes it appropriate for management reporting, variance analysis, and board prep. Even so, most finance teams establish a tiering rule: cohort-level GL and forecast data is fine in Claude directly, while raw PII, payroll detail, or material non-public information goes through a sanitized extract first. Build a one-page data-handling policy before you roll Claude out across FP&A and accounting.
How do I keep Claude from hallucinating numbers in a financial analysis?
Treat Claude as an analyst, not a calculator. Three guardrails do most of the work. First, attach the source file (trial balance, AR aging, budget vs. actual export) instead of pasting figures inline, so the model reads structured data rather than reconstructing it. Second, ask Claude to show its work: which rows it summed, which periods it compared, and the formula it would write in Excel. Third, have a human reviewer tie the top three numbers in any Claude output back to the source system before it leaves the finance team. The prompts on this page are written with that pattern in mind.
Does Claude integrate with NetSuite, QuickBooks, Sage Intacct, or our close tools?
Claude does not replace your ERP or close software, and you do not need a native integration to get value. The common pattern is: export a saved report from NetSuite, Intacct, QuickBooks, or Blackline as CSV or XLSX, drop it into a Claude Project alongside your chart of accounts and a short context doc, and run the prompts from there. Teams that want a tighter loop use Claude's API with internal scripts, or use a connector through tools like Zapier and Make to push exports into a shared drive that the Project reads from. Start with the export-and-upload pattern, then automate once you know which workflows you run weekly.
How does using Claude affect SOX, audit trail, and segregation of duties?
Claude is a drafting and analysis layer. It does not post journal entries, approve reconciliations, or change records in the ERP, so it sits outside the system of record. For SOX purposes, the controls that matter are the ones around what Claude produces: who reviewed it, what source data it used, and where the final number was entered. Practical steps: keep Claude conversations for material analyses (export the thread), reference the prompt in your workpaper, and make sure the human approver in your control matrix signs off on the output, not the model. Auditors are increasingly comfortable with this as long as the reviewer evidence is clear.
Which Claude model should FP&A and accounting teams actually use?
For most finance work, the current Sonnet model is the right default. It handles multi-tab spreadsheets, variance commentary, and board-deck drafting at a price point that lets you run it across the team. Reach for the larger Opus model when the task involves long, multi-document analysis (a full audit binder, a diligence data room, a multi-year reforecast) where reasoning depth matters more than speed. Keep Haiku for high-volume, narrow tasks like categorizing transactions or summarizing AP invoices. The prompts in this guide work across all three, but you will notice Sonnet hits the best balance for day-to-day close and FP&A.
Can Claude write the Excel formulas, Power Query steps, or SQL my finance team actually uses?
Yes, and this is one of the highest-leverage uses for finance. Claude is strong at writing and debugging Excel formulas (XLOOKUP, SUMIFS, LET, dynamic arrays), Power Query M code for cleaning ERP exports, and SQL against your data warehouse for ad-hoc analysis. Give it the column headers, a few sample rows, and a plain-English description of what you want. For SQL specifically, paste your table schema first; for Power Query, describe the source file shape. Treat the output the way you would a junior analyst's first draft: read it, test it on a small sample, then run it against the full dataset.
Setup

Making these prompts compound

Drop these into a Claude Project loaded with your team's context: your processes, your templates, your past work, and the standards you hold. With those inputs, the prompts above produce outputs far better than running them in a blank Claude chat.

See Claude for Finance for the full picture, or have Treetop build the Finance Project for your team.

Related

More for Finance teams

Build a Finance Claude Project that knows your numbers
Treetop turns prompts like these into a configured Claude Project with your chart of accounts, reporting templates, and policies built in. Start with an AI Audit or jump straight to Implementation to stand up your finance workflows.
See Implementation → Start with an Audit
Related

Explore more from Treetop