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.
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