- Home
- Free Tools
- Financial Health
- Profit and Loss Statement Template
Profit and Loss Statement Template
- Free Template
- Excel, Google Sheets & PDF
- No signup
| Line item | Amount | % rev |
|---|---|---|
| Total Revenue | $120,000 | — |
| Gross Profit | $102,000 | 85.0% |
| Operating Income | $30,000 | 25.0% |
| Net Profit | $20,000 | 16.7% |
Build your profit and loss statement
Revenue
Everything you sold in the period — before any costs.
Cost of Goods Sold
Direct costs of delivering what you sold: hosting, materials, payment fees.
Operating Expenses
Running the business: payroll, rent, software, marketing, professional fees.
Other Income
Income that is not from your core business — interest, grants, or the gain on a one-off asset sale (the gain, not the sale price).
Other Expenses
Below-the-line costs: interest on debt, business taxes and licenses. Not your personal or federal income tax — that is not a business expense.
Your Profit & Loss Statement
Add a period above
| Line item | Amount | % rev |
|---|---|---|
| Revenue | ||
| Product / service revenue | $0.00 | |
| Other sales | $0.00 | |
| Total Revenue | $0.00 | |
| Cost of Goods Sold | ||
| Materials / direct costs | $0.00 | |
| Hosting & infrastructure | $0.00 | |
| Total Cost of Goods Sold | $0.00 | |
| Gross Profit | $0.00 | — |
| Operating Expenses | ||
| Salaries & wages | $0.00 | |
| Rent & utilities | $0.00 | |
| Marketing & advertising | $0.00 | |
| Software & subscriptions | $0.00 | |
| Professional fees | $0.00 | |
| Total Operating Expenses | $0.00 | |
| Operating Income | $0.00 | — |
| Other Income & Expenses | ||
| Interest income | $0.00 | |
| Interest expense | $0.00 | |
| Business taxes & licenses | $0.00 | |
| Net Profit | $0.00 | — |
Fill in the line items to build your statement.
Download your statement
Nothing is uploaded — the statement is built in your browser and the file is generated on your device.
Prefer a blank template?
Download an empty profit and loss statement with the standard line items already laid out — revenue, cost of goods sold, operating expenses, other income and expenses — and fill it in yourself. The Excel and Google Sheets versions are editable; the PDF is print-ready if you need to fill it in on paper.
All three files are free and unwatermarked. No email, no signup, no limit on downloads.
What is this P&L for?
The answer changes what actually helps next.
What Is a Profit and Loss Statement?
A profit and loss statement — also called an income statement or P&L — reports what a business earned and what it spent over a period of time, and ends with the one number that matters: whether you made money. It is one of the three core financial statements, alongside the balance sheet (what you own and owe at a point in time) and the cash flow statement (where the cash actually moved).
The distinction that trips people up is timing, and it depends on your accounting method. Under accrual accounting a P&L records revenue when it is earned and costs when they are incurred, not when money changes hands — bill an annual contract in January and the cash arrives at once, but the P&L spreads that revenue across twelve months. Under cash accounting, which many sole proprietors and small businesses use, income is recorded when it is received and expenses when they are paid. Accrual is why a profitable business can still run out of cash, and why lenders read a P&L next to a burn rate and runway calculation rather than on its own.
A P&L is one part of the picture. Our SaaS financial reporting guide shows how it connects to cash flow, the balance sheet, MRR, and a monthly close.
The Profit and Loss Formula
A multi-step statement stops twice on the way down, and those two stops are where the diagnosis lives:
Worked example. A SaaS business bills $120,000 in a month — $100,000 of subscriptions and $20,000 of onboarding services. Hosting and payment fees cost $18,000, so gross profit is $102,000, an 85% gross margin. Salaries and marketing come to $72,000, leaving $30,000 of operating income, a 25% operating margin. After $4,000 of loan interest and $6,000 of corporate income tax, net profit is $20,000 — a net margin of 16.7%. (A sole proprietor would stop at operating income: federal income tax and self-employment tax are personal, not deductible business expenses, so they never appear on a Schedule C P&L.)
How to Make a Profit and Loss Statement with This Template
Use the builder above as a simple profit and loss statement template: enter one reporting period at a time, keep the accounting method consistent, and follow the same order each month so the result is easy to compare.
- 01Choose the period and accounting method. Label the statement by month, quarter or year to date, then use either cash or accrual accounting throughout.
- 02Total revenue. Add subscription, product, service and other operating revenue earned during the period.
- 03Subtract cost of goods sold. Deduct the direct costs of delivering what you sold to calculate gross profit and gross margin.
- 04Calculate operating income and net profit. Subtract operating expenses, add other income, then subtract interest, tax and other expenses.
- 05Review and export.Compare the three margins with earlier periods, check every line against your records, and download the finished P&L as Excel, Google Sheets or PDF.
Single-Step vs Multi-Step Format
Both formats reach the same net profit. They differ in how much they show you on the way there.
A single-step statement lists all revenue, subtracts one combined expense total, and stops. It is the simpler format, and it is enough when nobody needs to see how the costs break down. It is not, however, the format tax returns use: Schedule C derives gross profit from cost of goods sold in Part I and Part III and lists business expenses by category, so if you report COGS the multi-step split maps more closely to the return.
A multi-step statement separates cost of goods sold from operating expenses, which surfaces gross profit and operating income as their own lines. Lenders, investors and anyone underwriting the business will expect this format, because gross margin is what tells them whether the business scales — a company at 85% gross margin has a fundamentally different future than one at 25%, even at identical net profit. The builder above switches between the two, and the export follows whichever you pick.
What Goes on Each Line
The single most common mistake is putting a cost in the wrong block. As a rough rule, costs of producing or delivering what you sold belong in cost of goods sold, and the costs of running the business belong in operating expenses. It is only a rule of thumb — COGS can include allocated fixed production costs, and some variable costs such as sales commissions stay in operating expenses. Get the boundary wrong and your gross margin is meaningless, so pick a treatment and keep it consistent between periods.
| Section | Typical line items | Rule of thumb |
|---|---|---|
| Revenue | Product sales, subscription revenue, services, shipping charged to customers | Recognised when earned, not when the cash lands. |
| Cost of goods sold | Hosting, materials, manufacturing, payment processing, contractor delivery time | Only costs that rise when you sell one more unit. |
| Operating expenses | Salaries, rent, marketing, software, insurance, accounting and legal fees | Costs of running the business whether you sell anything or not. |
| Other income | Interest earned, grants, the gain on a one-off asset sale | Record the gain or loss, not the gross sale price. Kept separate so it does not flatter margins. |
| Other expenses | Interest on loans, corporate income tax, business taxes and licenses | Below the operating line because they say nothing about how the business itself performs. |
How to Read a P&L
Read the margins, not the dollars. Dollar totals only tell you how big the period was; margins tell you whether the business works. Three questions cover most of it:
- 01Is gross margin holding as revenue grows? A gross margin that slips while revenue climbs means you are buying growth — discounting, or carrying delivery costs that scale with sales. This is the earliest warning a P&L gives.
- 02Is operating income moving toward positive? Losses are normal while you invest, but the gap should be closing. Compare operating expense growth against revenue growth — if expenses grow faster for more than a couple of quarters, the model is not yet working.
- 03Does profit match the bank balance? If not, the difference is timing — unpaid invoices, deferred revenue, or capital purchases that never touch the P&L. That gap is what the cash flow statement exists to explain.
Margin Benchmarks by Business Type
| Metric | SaaS / software | Services / agency | Ecommerce / retail |
|---|---|---|---|
| Gross margin | 70–85% | 30–50% | 30–50% |
| Operating margin | 0–20% | 10–20% | 5–15% |
| Net margin | 0–15% | 5–15% | 2–10% |
These ranges are illustrative rules of thumb gathered from common industry reporting, not a sourced benchmark study — treat them as orientation, not a standard to be judged against. They are typical operating ranges, not targets. A growing software business deliberately running at a small operating loss is not in trouble; a services business at 20% gross margin usually is. The metric to compare against your own history is gross margin — it is the one that should be stable. For the SaaS-specific ratios that sit alongside a P&L, see the SaaS metrics hub. If gross margin is unstable because costs keep landing in different places month to month, the fix is one level down in the chart of accounts rather than in the statement. For prepaid subscriptions, a deferred revenue scheduleshows which portion belongs in this month's revenue and which remains a liability.
How Your P&L Affects Your Funding Options
The P&L is usually among the first documents anyone lending you money asks for. Underwriting varies by lender and product — cash flow available to service debt, leverage and balance-sheet quality often matter as much as anything on the P&L — but revenue-based and recurring-revenue lenders typically look hard at gross margin, because it caps how much of every new dollar can ever service debt, and at the operating expense trend, to see whether the cost base is under control. Net profit on its own is rarely decisive: a business intentionally reinvesting into growth can be unprofitable and still fundable.
This is why the same statement leads to different answers depending on the revenue underneath it. Recurring revenue at a high gross margin is predictable enough to borrow against and repay from, which is what makes non-dilutive capital possible at all — Founderpath funds SaaS companies from $10K MRR up to $5M without taking equity or a board seat. One-off project revenue at a thin margin usually is not, and a bank line of credit is the more realistic route.
If your books still live in PDF statements, the free bank statement converter turns them into a spreadsheet you can categorise into the sections above. To model what raising equity instead would cost you, the equity dilution calculator puts a number on it, and the burn rate calculator tells you how long the decision can wait.