Free Profit & Loss (P&L) Template — Excel
Download a free profit and loss statement template in Excel — monthly format with automatic gross profit, margins, and net income, plus a fully filled P&L example so you know exactly what a finished statement looks like. Works in Google Sheets too.
Get the Free P&L Template (Excel)
Monthly profit & loss statement with auto-calculated margins + a complete filled example — the same structure our Ex-PwC CFOs use with 100+ clients.
What's Inside the Template
- P&L Template tab — a full monthly profit and loss statement (Jan–Dec plus annual total) with revenue, COGS, and operating expense categories. Enter numbers in the yellow cells; gross profit, margins, operating income (EBIT), and net income calculate automatically.
- Filled Example tab — a complete, realistic year for a small product business, so you can see exactly what a finished P&L looks like before entering your own numbers.
- Instructions tab — how to use it, what goes where, and the formulas behind the margins.
How to Fill Out a Profit & Loss Statement
- Revenue — total sales for each month, split into product/service and other revenue. Use invoiced (accrual) amounts for a true performance picture; see our guide to accrual vs cash accounting for why this matters.
- Cost of Goods Sold — only costs directly tied to what you sold: materials, direct labor, fulfillment. Rent and marketing do not belong here.
- Operating Expenses — everything else: salaries, rent, marketing, software, insurance, professional fees.
- Read the margins — the template computes gross margin and net margin per month, so trends (and problems) are visible immediately.
Profit & Loss Statement Example, Explained
Open the Filled Example tab and you'll see a business doing roughly $52K/month in revenue by year end. Notice three things a well-kept P&L reveals that a bank balance never will: gross margin holds steady near 50% (pricing and direct costs are under control), operating expenses stay flat while revenue grows (operating leverage — each new sales dollar is more profitable than the last), and net margin climbs from about 12% to 18% across the year. That trend line — not any single month — is what lenders, investors, and good operators actually read.
Why a Spreadsheet P&L Eventually Isn't Enough
This template is a genuinely solid monthly P&L — but it depends on you categorizing every transaction correctly and consistently. As volume grows, the spreadsheet becomes the bottleneck: transactions get miscategorized, months get skipped, and the "quick update" takes a weekend. That is the point where proper bookkeeping pays for itself: your P&L, balance sheet, and cash flow arrive finished every month, accrual-accurate, with a professional reading the story in the numbers. Until then, this template plus our free profit margin calculator and net income calculator will keep you honest.
Want your P&L done for you every month?
Our Ex-PwC CA & ACCA team delivers accurate monthly financial statements — P&L, balance sheet, and cash flow — with a professional reading of what the numbers mean.
Book a Free 30-Min Call →