Recipe

How to Have Claude Read Your P&L Like a CFO

Twenty minutes, one prompt, and the monthly P&L your accountant sends stops being a PDF you file and starts being a conversation.

Every month your bookkeeper sends a P&L, and every month it gets skimmed, filed, and forgotten — not because you don't care, but because a wall of line items doesn't tell you what to do. Drag that PDF into Claude, paste one prompt, and you get what a sharp CFO would give you: the three numbers that actually moved, your biggest cost as a share of revenue and which way it's trending, and one specific question to take back to your bookkeeper. Twenty minutes, works with QuickBooks, Xero, or whatever your accountant exports.

Total time

20 minutes

Difficulty

Easy

Makes

A plain-English read of your monthly P&L

Tool

Claude or ChatGPT

Ingredients

Your most recent P&L — PDF, spreadsheet, or even a clear photo (QuickBooks: Reports → Profit and Loss → Export)
The same report from the month before, or the same month last year, if it's handy (the comparison is where the gold is)
20 minutes

The prompt

You're a sharp small-business CFO reviewing my P&L — attached. Give me, in plain English with no accounting jargon: 1) The three numbers that moved most compared to the prior period, and why each one matters to a business like mine. 2) My biggest cost as a percentage of revenue, and whether it's trending the wrong direction. 3) One thing you'd investigate this week, phrased as a specific question I can send to my bookkeeper. If anything looks miscategorized, duplicated, or just odd, flag it — even if it makes the report look worse, especially then.

The method

A P&L is a list of what happened to your money, written by someone paid to be precise rather than interesting. Owners don't ignore it out of laziness — they ignore it because nothing on it says so what. That's the job you're hiring Claude for: not the math, the so what.

Export the P&L. QuickBooks: Reports → Profit and Loss → Export to PDF. Xero, FreshBooks, or your accountant's email attachment all work too — Claude reads PDFs, spreadsheets, and even a decent photo of a printout.
Grab the prior month (or same month last year) if you can. One P&L is a snapshot; two is a story. The prompt works either way, but the comparison is where the gold is.
Open Claude, drag the file or files in, paste the prompt above.
Read the answer, then push back — this is the step people skip. Ask "why would labor jump if sales were flat?" or "what would you cut first if you had to find $2,000 a month?" It answers from your actual numbers, and it never gets tired of follow-ups.
Send your bookkeeper the one question it surfaced. That single specific question is worth more than an hour of staring at the report yourself.

Do it the same day the P&L lands each month and it becomes a 20-minute ritual instead of a guilt pile. Same chat, drag in the new month, one line: "new month attached — what changed?" It pairs well with automating your Google search report, and there's more on the small business shelf.

On the plate

The good draft

Labor ran 34% of revenue in May, up from 31% in April — sales were flat, so that's roughly $1,900 of extra cost, not growth. Rent didn't change, but because revenue dipped, occupancy crept to 11% of sales — watch it, don't act on it. The flag: "Supplies" tripled to $3,600. Question for your bookkeeper: was that a one-time bulk purchase, or did something get recategorized from COGS in May?

The bad draft

Your business demonstrates solid fundamentals! Revenue is a key performance indicator worth monitoring closely. Consider exploring opportunities to optimize expenses and drive operational efficiencies across categories going forward.

Notes from the kitchen

Is it safe to upload my P&L?

Treat it like any vendor who sees your financials. Use a paid account if you can, and check the data settings (Claude and ChatGPT both let you keep your data out of training). A P&L has no bank account numbers or SSNs on it — but if the company name makes you nervous, blank it out; the analysis doesn't need it.

My books are kind of a mess. Will this still work?

Better than you'd expect — and the prompt asks Claude to flag oddities instead of politely ignoring them. Messy categories, duplicated entries, cash-vs-accrual confusion: it will name them. Tell it which basis you're on if you know.

Does this replace my accountant?

No, and that's not the goal. Your accountant closes the books; this makes you a sharper reader of what they send — the owner who shows up with one specific question instead of a shrug.

What if I run more than one location?

Drag in both P&Ls and add one line to the prompt: "compare my two locations and tell me where they differ most." When you're past a handful of locations and the exports stop fitting in a chat window, that's a different problem — the one Expo exists for.

Export the P&L. QuickBooks: Reports → Profit and Loss → Export to PDF. Xero, FreshBooks, or your accountant's email attachment all work too — Claude reads PDFs, spreadsheets, and even a decent photo of a printout.
Grab the prior month (or same month last year) if you can. One P&L is a snapshot; two is a story. The prompt works either way, but the comparison is where the gold is.
Open Claude, drag the file or files in, paste the prompt above.
Read the answer, then push back — this is the step people skip. Ask "why would labor jump if sales were flat?" or "what would you cut first if you had to find $2,000 a month?" It answers from your actual numbers, and it never gets tired of follow-ups.
Send your bookkeeper the one question it surfaced. That single specific question is worth more than an hour of staring at the report yourself.

About the author

By the Expo Team. AI Confidential is Expo's plain-English guide to using AI in your business — written by operators, for operators. Browse more recipes and guides.