ownernumbers
All guides

Guide

Using AI to extract calculator inputs from your financial statements

Three ready-to-paste prompts that turn your P&L or balance sheet into structured calculator inputs. With caveats about where AI gets it wrong and how to verify quickly.

What this is

If you'd rather not dig through your accounting software or your accountant's PDF report to find each calculator input one at a time, you can paste your financial statements into ChatGPT or Claude with a structured prompt and get the numbers back in a usable format. This guide gives you three ready-to-use prompts and a worked example.

The companion to this is the guide on where to find these numbers in QuickBooks, Wave, or your accountant's report — for owners who'd rather pull the numbers manually. Either path is fine. Use whichever feels less like work.

The verification rule

Before any of the prompts: AI gets numbers wrong sometimes. Not often, but enough that you should never trust an AI extraction without a quick check. Specifically, AI tends to:

  • Confuse subtotals with totals — pulling "Operating Income" when you asked for "Net Income", or vice versa
  • Miss line items that span multiple lines because of long account names
  • Confidently invent numbers when an item isn't actually on the statement (e.g., asking for EBITDA when only Operating Income is shown — AI will sometimes return a number rather than say "not directly shown")
  • Round things in ways you didn't ask for, especially with multi-thousand-dollar numbers

The rule: every number AI extracts, you eyeball against the statement before pasting into a calculator. It takes about ten seconds per number — much faster than typing the whole statement, but slower than blind trust. Don't skip the ten seconds.

Prompt 1: Income statement → calculator inputs

Use this when you have a P&L (income statement) and you want to run profitability or break-even calculators. Paste the prompt below, then attach or paste your P&L underneath.

I'm going to give you a profit and loss statement (income statement) for a small business. Extract the following numbers and return them in a structured format.

For each item, give me:
- The dollar value (use plain numbers, no currency symbol or commas)
- The exact line item label from the statement where you found it
- Any caveat or note (e.g. "computed by adding X and Y", "not directly shown")

Items to extract:
1. Revenue (or Total Income, or Net Sales)
2. Cost of Goods Sold (or Cost of Sales, or Cost of Revenue)
3. Gross Profit
4. Total Operating Expenses
5. Operating Income (or Operating Profit)
6. Depreciation and Amortization expense
7. Interest expense
8. Income tax expense
9. Net Income (or Net Profit)
10. EBITDA — if not shown directly, compute it as Net Income + Interest + Tax + Depreciation + Amortization, and tell me the formula you used

Format your response as:
- Item: [name]
- Value: [number]
- Source: [line item label from the statement]
- Note: [any caveat, or "none"]

If a number isn't directly shown and can't be computed from what's on the statement, say so explicitly. Do not guess. Do not fill in approximate values.

Here is the statement:

[paste your P&L below this line]

The structure of this prompt is deliberate. Asking AI to quote the source line item makes hallucination easier to spot — if the source label looks weird or doesn't match the statement, the number is suspect. Asking for the computation method on EBITDA forces AI to show its work rather than guessing.

Prompt 2: Balance sheet → calculator inputs

Use this when you have a balance sheet and you want to run liquidity or leverage calculators (current ratio, quick ratio, working capital, DSCR-related debt inputs).

I'm going to give you a balance sheet for a small business. Extract the following numbers and return them in a structured format.

For each item, give me:
- The dollar value (use plain numbers, no currency symbol or commas)
- The exact line item label from the statement where you found it
- Any caveat or note

Items to extract:
1. Total Current Assets
2. Cash and Cash Equivalents
3. Accounts Receivable
4. Inventory
5. Prepaid Expenses (if separately shown)
6. Total Current Liabilities
7. Accounts Payable
8. Current Portion of Long-Term Debt
9. Accrued Expenses (if separately shown)
10. Long-Term Debt (non-current portion)
11. Total Debt = Current Portion of Long-Term Debt + Long-Term Debt + any Notes Payable + any Bank Loans + any Lines of Credit. Show me which line items you summed.
12. Total Equity (or Stockholders' Equity, or Owner's Equity)

Format your response as:
- Item: [name]
- Value: [number]
- Source: [line item label or "computed from X + Y"]
- Note: [any caveat, or "none"]

If a number isn't on the statement, say so explicitly. Don't guess. For the Total Debt line, only include interest-bearing debt — do NOT include accounts payable, accrued expenses, deferred revenue, or other operating liabilities.

Here is the statement:

[paste your balance sheet below this line]

The Total Debt line is the one most likely to go wrong. AI will sometimes include accounts payable in "total debt" because the word "debt" is ambiguous. The explicit instruction to show which line items it summed, plus the explicit exclusions, helps a lot.

Prompt 3: Combined financial statements → all inputs

Use this when you have a single PDF or document containing both your income statement and balance sheet — the typical format from an accountant's compilation or year-end report.

I'm going to give you a combined financial report (income statement + balance sheet, possibly cash flow statement) for a small business. Extract every number I might need to run small-business financial ratio calculators.

For each item, return:
- The dollar value (plain number, no commas or currency symbols)
- The exact line item label and which statement it's on (P&L, Balance Sheet, or Cash Flow)
- Any caveat or computation note

From the Income Statement:
1. Revenue / Total Income
2. Cost of Goods Sold
3. Total Operating Expenses
4. Operating Income
5. Depreciation and Amortization
6. Interest Expense
7. Income Tax Expense
8. Net Income
9. EBITDA (compute if not shown directly; show your formula)

From the Balance Sheet:
10. Total Current Assets
11. Inventory
12. Total Current Liabilities
13. Total Debt (interest-bearing only — sum all loans, lines of credit, notes payable, both current and long-term portions; exclude accounts payable and accrued expenses)
14. Total Equity

If any number isn't on the statements, say "not on the statements" — do not guess or approximate. If a value requires summing multiple line items, list each item and amount before giving the total.

Format your response as a clean list:
- Item: [name]
- Value: [number]
- Source: [statement and line item label]
- Note: [caveat, computation method, or "none"]

Here are the statements:

[paste the combined report below this line]

Worked example

Here's a realistic sketch of what running Prompt 1 looks like end to end. Pretend you've pasted in a small construction company's P&L showing $2.4M in revenue. The AI's response should look something like:

- Item: Revenue
  Value: 2400000
  Source: "Total Revenue"
  Note: none

- Item: Cost of Goods Sold
  Value: 1560000
  Source: "Total Cost of Goods Sold"
  Note: none

- Item: Gross Profit
  Value: 840000
  Source: "Gross Profit"
  Note: matches Revenue - COGS

- Item: Total Operating Expenses
  Value: 620000
  Source: "Total Operating Expenses"
  Note: none

- Item: Operating Income
  Value: 220000
  Source: "Operating Income"
  Note: none

- Item: Depreciation and Amortization
  Value: 38000
  Source: "Depreciation Expense" ($35,000) + "Amortization Expense" ($3,000)
  Note: summed across two line items

- Item: Interest expense
  Value: 12000
  Source: "Interest Expense"
  Note: none

- Item: Income tax expense
  Value: 0
  Source: not directly shown
  Note: this appears to be a pass-through entity (S-corp or LLC); income tax is paid at the owner level, not the entity level

- Item: Net Income
  Value: 208000
  Source: "Net Income"
  Note: none

- Item: EBITDA
  Value: 258000
  Source: computed
  Note: Net Income (208000) + Interest (12000) + Tax (0) + Depreciation/Amortization (38000) = 258000

To verify: each "Source" line tells you exactly where to look on the statement. Spend ten seconds eyeballing two or three of them. If they match, the rest are probably right too. Then you can plug Revenue ($2,400,000), COGS ($1,560,000), Operating Expenses ($620,000), and EBITDA ($258,000) directly into the Profit Lift calculator and see your ranked levers within seconds.

Things to watch for

A few specific failure modes to be aware of:

  • Multi-period statements. If your statement shows two columns — current year and prior year, or current quarter and year-to-date — AI sometimes mixes columns. Pick the period you want before pasting, or explicitly tell the AI which column to use ("use the 'Current Year' column only").
  • Negative numbers. Statements use either parentheses ($1,200) or minus signs (-$1,200) for negatives. AI handles both, but check the sign on the extracted value when an item could plausibly be negative (e.g., Net Income for a loss period).
  • Currency. The prompt asks for "plain numbers". If your statement is in CAD, GBP, or EUR rather than USD, the extracted numbers are still correct — just make sure you set the right currency in the calculator before computing.
  • OCR'd PDFs. If your statement is a scanned PDF (an image of a printout) rather than a text-native PDF, AI may misread digits — 3 vs. 8, 0 vs. 6, decimal placement. Numbers from scanned PDFs need closer verification than numbers from text-native PDFs or pasted text.
  • Owner-related items. AI can't tell you what's an owner draw vs. a salary, or whether specific expenses are owner-personal. For SDE, owner's salary normalization, or any add-backs work, you'll still need to know your own books. The add-backs guide covers what owner-specific adjustments to make.

Which AI to use

Both ChatGPT (GPT-4-class models) and Claude (Sonnet or Opus) handle these prompts well. Both support file uploads, so you can attach a PDF directly rather than copy-pasting text. Use whichever you already pay for or have free access to. If you're evaluating both: Claude tends to follow structured output instructions slightly more reliably; ChatGPT tends to be slightly faster to respond.

Free-tier models (GPT-3.5, smaller Claude variants) handle these prompts more loosely — they may skip caveats, miss line items, or give less reliable computation on derived values like EBITDA. If you're using a free tier, plan to verify more carefully.

A note on privacy

When you paste your financial statements into a public AI chatbot, you're sending those numbers to a third-party provider. For a small business, this is usually low-risk — the data isn't personally identifying and isn't tied to a specific entity unless you include the company name. If you're sensitive about this, two options: (1) strip the company name and any account numbers before pasting; (2) use a paid tier that offers no-training and no-logging guarantees, or run a model locally if you have the technical setup.

For most owner-operators, the privacy trade-off is acceptable. But it's worth knowing the trade-off exists rather than discovering it later.