Home › Prompt examples › Finance & accounting AI prompts: 18 copy-ready examples

Finance & accounting AI prompts: 18 copy-ready examples

18 prompts from 6 finance & accounting guides, ready to copy into any AI chat assistant.

Replace the [brackets] with your details. Every prompt comes from one of our full guides, which also covers which tool to use, the steps and the risks. Want a prompt for something else? Use the prompt builder.

Tasks on this page

AI prompts to explain a financial statement

When to use: Walk through a P&L or balance sheet in plain language. Full guide: Explain a financial statement

Explain the statement
Explain this [income statement / balance sheet / cash-flow statement] for [period, currency, units] to a non-accountant. One line per item: what it means and whether it went up or down vs the prior period.

[paste]
Ratios with workings
From these statements, calculate gross margin, operating margin, current ratio and debt-to-equity. For each show: formula, the exact figures used, result. Flag any you can't calculate from what I gave you.
Questions to ask
List 5 questions a careful reader would ask management about these statements, with the line that prompts each question.

AI prompts to build a budget spreadsheet

When to use: Build a budget model with formulas. Full guide: Budget spreadsheet

Design the sheet
Design a monthly budget spreadsheet for [household / small team] in [Excel / Google Sheets]. Columns for date, description, category, amount and month. A summary tab with planned vs actual per category and the difference. Give me the exact formulas with cell references, and explain each in one line.
Fix or explain a formula
This formula is in cell [cell]: [paste formula]. It should [what you expect] but shows [what you see]. Explain what it does step by step and give a corrected version.
Monthly review
Here are my category totals for [month], planned vs actual: [paste a table with no names or account numbers]. Point out the three biggest differences, ask me one question about each, and suggest one realistic change for next month.

AI prompts to extract data from invoices

When to use: Pull fields from invoices/receipts into a table. Full guide: Invoice data extraction

Extract
Extract these fields from each attached invoice into CSV: file_name, vendor, invoice_number, date (YYYY-MM-DD), subtotal, tax, tax_type, total, currency. If a field is unreadable write UNREADABLE. Then check subtotal + tax = total on each row and list mismatches.
Completeness check
Here are the file names I uploaded: [list]. Confirm each appears exactly once in the table, and list any likely duplicates (same vendor, invoice number and total).
Categorise
Add a column "category" using only these categories: [list]. If you're not sure, write "review" instead of guessing.

AI prompts to write variance commentary

When to use: Draft commentary on budget vs. actual. Full guide: Variance commentary

Draft commentary
Write variance commentary for [month/period]. Explain only lines with a variance over [x]% and [amount]. Use only the drivers listed; if none is listed, write 'driver to be confirmed'. Show amount and % vs budget and vs prior period.

Table: [paste]
Known drivers: [list]
Check my numbers
Recalculate every variance in this table and list any cell where my figure differs from yours.
Shorter for leadership
Turn this commentary into 4 bullets for the leadership pack: the two biggest favourable and unfavourable items, in plain words.

AI prompts to automate invoice processing

When to use: Email → extract invoice data → accounting system. Full guide: Invoice-processing workflow

Design the flow
Design an invoice-processing workflow for [tools/systems]. Stages: trigger, AI extraction, validation checks, human approval, final posting. For each stage list inputs, outputs, failure handling and who is responsible.
Extraction prompt
Extract these fields from the invoice as JSON: supplier_name, invoice_number, invoice_date, due_date, currency, net, tax, total, po_number. If a field is missing or unclear, return null and explain in 'notes'. Don't guess.
Test cases
Write 8 test invoices for this workflow: normal, duplicate number, totals that don't add up, missing PO, new supplier, changed bank details, foreign currency, credit note.

AI prompts to research a company or market

When to use: Sourced research on a company or sector. Full guide: Market/company research

Company brief
Research [company, ticker]. Give: business model in 3 lines, latest reported revenue and profit (with period), key segments, recent news (last 6 months), main risks. Cite a source for every figure, preferring the company's filings or investor relations pages. Say when you couldn't find something.
Latest results
Summarize [company]'s latest quarterly results: revenue, profit, guidance, and what management highlighted. Link the earnings release and give the reporting period.
Sector view
Compare [3 companies] in [sector] on revenue growth, margins and main risks, from their latest annual reports. Table with sources and periods.

More prompt examples

All prompt examples · Writing & editing · Coding · Research · IT ops & DevOps · Customer support · Data analysis · Automation & agents · Image & video · Personal productivity · Education & learning · Marketing · Sales · HR & recruiting · Legal & compliance · Healthcare admin · Cybersecurity · Product & design · Personal life & home · Travel · Content creation · Small business

See also: Best AI tools for finance & accounting

Report an error on this page