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 3
- AI prompts to build a budget spreadsheet 3
- AI prompts to extract data from invoices 3
- AI prompts to write variance commentary 3
- AI prompts to automate invoice processing 3
- AI prompts to research a company or market 3
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 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]
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.
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 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.
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.
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 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.
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).
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
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]
Recalculate every variance in this table and list any cell where my figure differs from yours.
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 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.
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.
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
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.
Summarize [company]'s latest quarterly results: revenue, profit, guidance, and what management highlighted. Link the earnings release and give the reporting period.
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