Money and GST, Learning

Understand your profit and loss statement

A plain-English walk through your profit and loss report, what each line means, what stands out, and questions for your accountant.

Short answer Paste the prompt below into ChatGPT, Claude, Gemini or Copilot with your own details and you get a plain-English walk through your profit and loss report, what each line means, what stands out, and questions for your accountant. Works on free plans. Time saved: about 30 minutes each month, and better questions for your accountant (estimate).

Why it helps

Your accountant sends a profit and loss statement, or Xero shows one, and it's a list of numbers with words like "gross profit" and "cost of sales". Many owners nod along and look at the bottom line only. The useful stuff is in the middle: which costs are growing, and whether your margins are holding up.

AI can explain each line in plain words and point out what's changed since last period, using only your numbers. It helps you ask better questions. It doesn't replace your accountant.

The prompt

Copy it, swap the bits in [square brackets], and paste it into ChatGPT, Claude, Gemini or Copilot.

Copy and paste

I run a small [type of business] in New Zealand. Below is my profit and loss statement for [period], with [the same period last year / last month] for comparison. Explain it to me in plain NZ English. Please: 1. Explain what each main section means (income, cost of sales, gross profit, expenses, net profit) in one or two sentences each. 2. Work out my gross margin and net margin as percentages for each period. Show the sums. 3. Point out the 3 biggest changes between the two periods, in dollars and percent. 4. Give me 5 questions to ask my accountant. Rules: - Use only the numbers I give you. Don't guess at reasons for changes. Say "ask your accountant" or "check your records" instead. - Don't give tax advice or tell me what to cut. - Keep it short and friendly. My profit and loss: [paste the summary lines, with no bank account or customer details]

Then keep chatting

  • Explain the difference between profit and cash in the bank, using my numbers.

  • Put my P&L into a simple table I can paste into a spreadsheet, with the percentages.

  • What does "cost of sales" usually include for a business like mine? Mark anything I should check.

Step by step

  1. Run a profit and loss report in Xero, MYOB or your accounting app, or use the one from your accountant. Pick two periods to compare.
  2. Copy the summary lines (the headings and totals). Leave out bank details, customer names and staff names.
  3. Paste them into the prompt and read the explanation.
  4. Check the margins and changes against your report, or in a spreadsheet. AI can make arithmetic slips.
  5. Take the questions to your accountant, and repeat each month or quarter so you spot trends early.

Worked example

What you paste in
I run a small cafe in Napier. P&L for July to September, with the same three months last year in brackets. Sales: $96,000 ($88,000) Cost of sales (food and coffee): $33,600 ($28,200) Wages: $34,500 ($31,000) Rent: $9,000 ($9,000) Power: $3,100 ($2,600) Other expenses: $6,200 ($6,100) Net profit: $9,600 ($11,100)
What you get back
Gross profit is sales minus what the food and coffee cost you. This year: $96,000 - $33,600 = $62,400, a 65% gross margin. Last year: $88,000 - $28,200 = $59,800, a 68% margin. Net profit is what's left after all costs. This year: $9,600, 10% of sales. Last year: $11,100, 12.6%. Biggest changes 1. Cost of sales up $5,400 (19%), faster than sales (up 9%). 2. Wages up $3,500 (11%). 3. Power up $500 (19%). Sales grew, but profit fell because food and coffee costs grew faster. Questions for your accountant 1. Have supplier prices gone up, or is it waste? 2. Should my prices change? 3. Is there anything one-off in here? 4. How does my margin compare with similar cafes? 5. Is this profit or cash?

Example details are made up. Your results will vary, so always read and check before you use them.

Watch out for

  • Check the maths. Paste the numbers into a spreadsheet and check the margins yourself. One slipped digit changes the story.
  • AI doesn't know why your numbers changed. If it gives reasons you didn't tell it, ignore them and check your records or ask your accountant.
  • Privacy: paste the summary lines only. Don't upload full reports with bank account numbers, customer or staff names, or your IRD number.
  • For tax questions, go to your accountant or ird.govt.nz. Business.govt.nz also has free guides to reading financial statements.

Go further

Profit isn't the same as cash, so pair this with the simple cashflow forecast use case to see what's coming in and out. If food costs are the problem, the menu costing use case works out your margin dish by dish.

Related use cases

All 60 use cases

Want this set up for your business?

Book a free 20-minute chat. We'll look at what's eating your week and whether AI can help. No pitch, no pressure.

Book a free 20-min chat