Spreadsheets

Monthly Profit & Loss (P&L)

A classic monthly financial statement to track business performance.

Updated: January 26, 2026

What does this AI prompt do?

This AI prompt helps UK SMEs by providing a ready-to-use template for a classic monthly financial statement to track business performance.. Simply copy the template below, customize the variables for your business, and paste into any AI tool like ChatGPT or Claude.

AI Prompt Template

Act as a specialist consultant.

Here is the improved business prompt template, maintaining the exact structure and variables while enhancing clarity, persuasiveness, and driving clearer results:

**Objective:** Generate a robust, standardized template for tracking **Monthly Financial Performance** to ensure rigorous business analysis and decision-making.

**Required Structure (Standardized P&L Format):**

| **Time Period** | Jan | Feb | Mar | ... | Dec | **Total YTD** |
| :--- | :---: | :---: | :---: | :---: | :---: | :---: |

**Core Financial Components (Rows):**

* Sales (Total Revenue Generated)
* Cost of Sales (Direct Costs Associated with Revenue)
* **GROSS PROFIT** (Key Profitability Metric)
* Expenses (Detailed Breakdown: Rent, Wages, Utilities, Marketing, etc.)
* **NET PROFIT** (Bottom-Line Performance Indicator)

**Actionable Tasks (Deliverables):**

1. Provide the definitive, comprehensive list of required **Rows** based on standard accounting best practices.
2. Clearly state the precise **Formula** to calculate **Gross Profit** (Must be: Sales minus Cost of Sales).
3. Clearly state the precise **Formula** to calculate **Net Profit** (Must be: Gross Profit minus the sum of all listed Expenses).

How to use this prompt:

  1. Copy the template above
  2. Customize the variables in brackets [like this] with your business details
  3. Paste into ChatGPT, Claude, or your preferred AI tool
  4. Get professional results in minutes

Why this works:

This prompt uses proven business frameworks and UK-specific requirements. It's designed to give you professional results that comply with local regulations and industry best practices.

Browse More AI Prompts →