ChatGPT Prompt for Financial Statement Analysis: 12

A useful ChatGPT prompt for financial statement analysis makes the model show formulas and use only the numbers you paste. Use these prompts for margins, leverage, returns, and question lists for your accountant or lender. They are not buy or sell advice and must not invent missing lines or industry averages. Below are 12 copy-paste prompts plus a flagship ratio pack.

Not investment, tax, or credit advice. Recompute every result. Do not paste confidential client data into public tools without permission.

Prompts for cleaning the paste

1. Line normalization

Here are raw statement lines: [paste]. Make a clean table by period. Mark missing lines as MISSING. Do not invent numbers. Units: [currency].

2. Mapping aliases

Map these labels to standard names (Revenue, COGS, OpEx, NI, Cash, AR, Inventory, Debt, Equity): [labels]. Ask me about any ambiguous line.

3. Unit and scale check

Check whether these figures look like whole dollars or thousands: [paste]. List inconsistencies. Do not rescale without my OK.

Prompts for ratios

4. Core profitability set

Using only [IS lines], compute gross, operating, and net margins. Show formula, substitution, and percent for each period.

5. Liquidity set

Using [BS lines], compute current and quick ratios if current liabilities and inventory are present. If CL is MISSING, say so and stop.

6. Leverage and returns

Compute debt-to-equity and ROE from [debt], [equity], [NI]. Show formulas. Skip if any input is MISSING.

7. Common-size income statement

Express each IS line as a percent of revenue for [periods]. Use only pasted lines.

Prompts for narrative and review

8. Trend bullets

From these computed ratios, [paste results], write 5 bullets on what improved or worsened. No speculation beyond the arithmetic.

9. Driver questions

Revenue rose and margin fell in [summary]. List 8 clarifying questions for management or my CPA. Do not answer them.

10. Lender one-pager outline

Outline a one-page numeric summary for a lender using only [ratios]. Leave blanks where data is missing. No credit recommendation.

11. Student practice key

I am practicing. Here is my worked solution: [paste]. Check arithmetic only against [source numbers]. List errors without rewriting the whole set unless wrong.

12. Hallucination sweep

Review this analysis draft: [paste]. List any number, peer average, or forecast that did not come from my inputs: [inputs].

Build a ratio pack with the flagship prompt

The Financial Statement Ratio Pack from Pasted Numbers normalizes your lines, computes a core ratio set with formulas, compares periods, and lists advisor questions. Its bakery example shows gross margin moving from 50.0% to 47.9% because COGS grew faster than revenue, and it refuses current ratio without current liabilities.

Related prompts

For adjacent finance work, see ChatGPT Prompts for Accountants, ChatGPT Prompts for Financial Planning, the subscription cost audit from bank export, and the Amazon seller business report to action plan.

Related: ChatGPT prompts for investment banking.

Find more in the Finance category, look through Browse, or post your own on Share.