← Financial Statements & Reporting

Profit and Loss Statement Analysis

Financial Statements & Reporting

Beginner15-20 minutes11 inputs
ClaudeChatGPTGemini

Quick Answer

Enter your P&L figures for current and prior period, paste into Claude or ChatGPT, receive professional P&L commentary ready for board or management review in minutes.

What You Get

A professional P&L analysis narrative covering revenue performance, gross margin analysis, operating expense breakdown, net income explanation, and period-over-period comparison with specific variance drivers identified.

Who Is This For

Business owners who need to explain P&L results to investors or advisors, finance managers preparing management accounts, and CFOs producing board reporting.

About This Template

The profit and loss statement tells the story of your business performance over a period β€” but the numbers alone do not explain what happened or why. This template takes your P&L figures and uses AI to produce a professional narrative analysis covering revenue performance, gross margin movement, operating expense trends, and net income drivers. The output gives you board-ready P&L commentary that would previously require hours of manual analysis writing.

Fill In Your Details

1
Company NameRequired

Your company name

2
Reporting PeriodRequired

e.g. Q2 2026, June 2026, FY2025

3
Total Revenue (Current Period)Required

e.g. 850000

4
Total Revenue (Prior Period)Required

e.g. 720000

5
Cost of Goods Sold (Current)Required

e.g. 340000

6
Cost of Goods Sold (Prior)Required

e.g. 295000

7
Total Operating Expenses (Current)Required

e.g. 380000

8
Total Operating Expenses (Prior)Required

e.g. 310000

9
Net Income (Current)Required

e.g. 130000

10
Net Income (Prior)Required

e.g. 115000

11
Key Business Drivers This Period

Any specific events that affected results β€” new product launch, lost customer, pricing change, one-time costs

Gather these details then use them to fill in the prompt below.

AI Prompts

1

Generate P&L analysis narrative

Paste this prompt into Claude or ChatGPT with your figures filled in.

You are a CFO preparing a professional profit and loss analysis. Using the financial data below, write a clear management commentary explaining the P&L results for the period.

Company: [company_name]
Period: [period]
Revenue: [revenue_current] vs [revenue_prior] prior period
Cost of Goods Sold: [cogs_current] vs [cogs_prior]
Operating Expenses: [opex_current] vs [opex_prior]
Net Income: [net_income_current] vs [net_income_prior]
Key business drivers: [key_drivers]

Write a professional P&L commentary covering:
1. Revenue Performance β€” growth rate, key drivers of change
2. Gross Margin Analysis β€” margin percentage, what changed and why
3. Operating Expense Analysis β€” total movement, key cost categories
4. Net Income Performance β€” movement from prior period, margin percentage
5. Key Takeaways β€” top 2-3 items management should focus on

Use professional finance language. Calculate percentages and growth rates from the numbers provided. Be specific about what drove each movement.

Sample Output

This is an example of what AI produces when you use this template.

Revenue Performance

Revenue grew 18.1 percent to $850,000 in the period compared to $720,000 in the prior period. Growth was driven primarily by expansion revenue from existing enterprise customers, which contributed approximately 60 percent of the incremental $130,000. New customer acquisition contributed the remaining 40 percent. The revenue run rate implies approximately $10.2M annualized, placing the business on track for the fiscal year target.

Gross Margin Analysis

Gross margin was 60.0 percent in the current period compared to 59.0 percent in the prior period, a 100 basis point improvement. Cost of goods sold grew at a slower rate than revenue (15.3 percent versus 18.1 percent revenue growth) reflecting improved delivery efficiency and the scaling benefit of fixed delivery costs spread across higher revenue.

Related Resources