Profit & Loss Statement Template
A clean Profit & Loss report that summarises income minus expenses to show your business profitability.
File format: .xlsx (Microsoft Excel, Google Sheets, LibreOffice compatible)
P&L Statement
- Professional P&L layout
- Gross and net profit calculation
- Month-by-month comparison
- Year-on-year tracking
What is a Profit & Loss Statement?
A Profit & Loss Statement (P&L) is the most important financial report for any small business. It summarises all income minus all expenses over a period to show whether you made a profit or a loss. It is the first thing banks, investors, and HMRC look at — and the first thing every business owner should understand.
Common use cases:
- Summarising business performance for a month, quarter, or year
- Preparing figures for your Self Assessment tax return
- Applying for loans or finance (lenders always ask for a P&L)
- Comparing performance year-on-year to spot trends
- Making business decisions — can I afford to hire? Should I cut costs?
When to use this template
- You need a clear summary of income vs expenses for any period
- You are filing your tax return and need organised figures
- You want to understand whether your business is actually profitable
- You need to show financial performance to a bank, investor, or partner
What Your Template Contains
Everything you need, pre-built and ready to use. Just enter your data in the blue cells.
Professional P&L Layout
Standard format with revenue at the top, expenses below, and net profit at the bottom. Recognised by accountants and lenders.
Gross and Net Profit Calculation
Gross profit (revenue minus direct costs) and net profit (after all expenses). Both figures matter for different decisions.
Month-by-Month Comparison
See each month side by side. Spot seasonal trends and one-off events that affected performance.
Year-on-Year Tracking
Compare this year against last year. Are you growing, shrinking, or flatlining?
Key Ratio Calculations
Profit margin, expense ratio, and other KPIs calculated automatically from your figures.
Print-Ready Format
Clean, professional layout suitable for printing or saving as PDF for meetings, lenders, or HMRC.
How This Template Helps Your Business
Know If You Are Actually Profitable
Revenue is vanity, profit is sanity. This template strips away the noise and shows you the one number that matters: are you making money?
Bank-Ready Financials
Every lender asks for a P&L. This template produces one in the standard format they expect — no reformatting, no explaining.
Spot Trends Before They Bite
Month-by-month and year-on-year views reveal problems early. A shrinking margin over 6 months is a warning. A P&L makes it visible.
Get Started in Minutes
No accounting knowledge required. Follow these simple steps and you'll be tracking your finances in no time.
Download TemplateDownload the template and open in Excel or Google Sheets
Enter your business details and reporting period on the cover sheet
Input your total income figures (or link from your Cash Book if you use one)
Input your expense totals by category (or link from your Expense Tracker)
Review the automatic calculations — gross profit, net profit, margins
Save as PDF for your records, tax return, or bank meeting
Related Templates
You might also find these useful
Cash Book
Track income and expenses month by month with automatic running balance, bank reconciliation, and profit summary.
Expense Tracker
Detailed expense logging with receipt tracking, mileage integration, and HMRC-compliant categorisation.
Balance Sheet
Know what your business is worth. Track assets, liabilities and equity in a professional format.
Budget Forecast
Forecast your income and expenses for the year ahead. Plan cash flow and avoid nasty surprises.
Frequently Asked Questions
Quick answers about this template
Ready to Get Started?
Download this free template and take control of your business finances today.
Free download, no email required. Works in Excel and Google Sheets.