Let's put a plan to your ambition
A practical way to use AI to turn a profit and loss report into better questions about price, volume, mix, timing and cash.
A profit and loss report is not interesting because it has numbers. It’s interesting because it contains clues.
Something changed. Sales moved. Wages moved. Gross margin shifted. Software costs crept up. A one-off item snuck into the month. A supplier price increase finally hit. A big invoice landed early. A debtor paid late. The P&L is not the answer. It’s the crime scene.
Most owners are given a report and expected to magically know what to ask.
This is where AI can help. Not by replacing me(obviously irreplaceable), but by helping you interrogate the numbers before we meet.
A profit and loss report is not interesting because it has numbers. It’s interesting because it contains clues.
Something changed. Sales moved. Wages moved. Gross margin shifted. Software costs crept up. A one-off item snuck into the month. A supplier price increase finally hit. A big invoice landed early. A debtor paid late. The P&L is not the answer. It’s the crime scene.
Most owners are given a report and expected to magically know what to ask.
This is where AI can help. Not by replacing me(obviously irreplaceable), but by helping you interrogate the numbers before we meet.
Image Caption
Dom’t ask for generic analysis
If you upload a P&L and ask, "What do you think?" you’ll usually get a polite summary. Revenue increased. Costs increased. Profit decreased. Thanks, robot. Very moving.
The better move is to force the analysis into commercial categories.
Ask the AI to separate movements into price, volume, mix, timing, cost and one-off effects.
Price means the same work is being sold at a different rate.
Volume means more or fewer units, hours, appointments, jobs, meals, subscriptions or projects.
Mix means the business sold a different combination of high-margin and low-margin work.
Timing means something landed in this month but belongs to another period commercially.
Cost means the input price or labour required to deliver the work changed.
One-off means the number matters, but it should not drive a long-term decision.
Once the movements are sorted this way, the report becomes a management conversation.
If you upload a P&L and ask, "What do you think?" you’ll usually get a polite summary. Revenue increased. Costs increased. Profit decreased. Thanks, robot. Very moving.
The better move is to force the analysis into commercial categories.
Ask the AI to separate movements into price, volume, mix, timing, cost and one-off effects.
Price means the same work is being sold at a different rate.
Volume means more or fewer units, hours, appointments, jobs, meals, subscriptions or projects.
Mix means the business sold a different combination of high-margin and low-margin work.
Timing means something landed in this month but belongs to another period commercially.
Cost means the input price or labour required to deliver the work changed.
One-off means the number matters, but it should not drive a long-term decision.
Once the movements are sorted this way, the report becomes a management conversation.
The best prompt
Use this prompt with a clean export from Xero, MYOB, QuickBooks or your reporting tool:
"Act as a commercially sceptical CFO. Compare this month with the prior month, the same month last year and budget. Separate likely price, volume, mix, timing, cost and one-off effects. Identify the three movements most likely to affect cash over the next 90 days. Tell me what information is missing and do not invent explanations that are not supported by the data."
The last sentence matters. AI can sound confident when it’s guessing. You want it to say, "I do not know", when the data doesn’t support a conclusion.
Use this prompt with a clean export from Xero, MYOB, QuickBooks or your reporting tool:
"Act as a commercially sceptical CFO. Compare this month with the prior month, the same month last year and budget. Separate likely price, volume, mix, timing, cost and one-off effects. Identify the three movements most likely to affect cash over the next 90 days. Tell me what information is missing and do not invent explanations that are not supported by the data."
The last sentence matters. AI can sound confident when it’s guessing. You want it to say, "I do not know", when the data doesn’t support a conclusion.
Clean data beats clever prompts
Before uploading a P&L, keep it simple.
Use clear column headings. Keep one account per row. Remove merged cells. Include the prior month, same month last year and budget where possible. Add notes for genuine one-offs.
If the report is messy, AI will spend half its time trying to understand the shape of the file.
What a useful AI answer should produce
A good output should give you:
· the three movements worth discussing;
· which movements are likely timing versus structural;
· margin pressure by category;
· cash impacts over the next 90 days;
· questions to ask the team; and
· a list of missing information.
The missing information list is underrated. It often shows that the owner is trying to make decisions without knowing job profitability, debtor age, utilisation, product mix or actual labour hours.
The human part
AI can compare and summarise. It doesn’t know that your best salesperson was away, your landlord back-charged outgoings, a supplier changed pack sizes, or a big client delayed approval because their CFO was on leave. That context still lives in the business.
The point isn’t to let AI run the meeting, it’s to arrive at the meeting with sharper questions.
Before uploading a P&L, keep it simple.
Use clear column headings. Keep one account per row. Remove merged cells. Include the prior month, same month last year and budget where possible. Add notes for genuine one-offs.
If the report is messy, AI will spend half its time trying to understand the shape of the file.
What a useful AI answer should produce
A good output should give you:
· the three movements worth discussing;
· which movements are likely timing versus structural;
· margin pressure by category;
· cash impacts over the next 90 days;
· questions to ask the team; and
· a list of missing information.
The missing information list is underrated. It often shows that the owner is trying to make decisions without knowing job profitability, debtor age, utilisation, product mix or actual labour hours.
The human part
AI can compare and summarise. It doesn’t know that your best salesperson was away, your landlord back-charged outgoings, a supplier changed pack sizes, or a big client delayed approval because their CFO was on leave. That context still lives in the business.
The point isn’t to let AI run the meeting, it’s to arrive at the meeting with sharper questions.
What to do this week
What to do this week
Download the P&L prep spreadsheet. Export your last three months, your budget and the same period last year. Run the prompt. Ask yourself one question: "Which number on this report deserves a decision, not just an explanation?"
Then, give me a call and let’s chat about what you’ve found.
Website disclaimer note: This article provides general information only and does not take into account your circumstances. It is not a substitute for tax, legal, financial, employment, cyber security or other professional advice.
Download the P&L prep spreadsheet. Export your last three months, your budget and the same period last year. Run the prompt. Ask yourself one question: "Which number on this report deserves a decision, not just an explanation?"
Then, give me a call and let’s chat about what you’ve found.
Website disclaimer note: This article provides general information only and does not take into account your circumstances. It is not a substitute for tax, legal, financial, employment, cyber security or other professional advice.
Share this post
Got questions?
Maybe it’s time for a
macchiato with Chris.
Got questions?Maybe it’s time for a macchiato with Chris.
Got questions?
Maybe it’s time for a
macchiato with Chris.
Ready to kick-start your
self-made journey?
© 2026 Denari Advisory. Liability limited by a Scheme approved under Professional Standards Legislation.
Strategy and Site by Touching Base
Ready to kick-start your self-made journey?
© 2026 Denari Advisory. Liability limited by a Scheme approved under Professional Standards Legislation.
Strategy and Site by Touching Base
Ready to kick-start your
self-made journey?
© 2026 Denari Advisory. Liability limited by a Scheme approved under Professional Standards Legislation.
Strategy and Site by Touching Base
