Home
Free Tools
Financial Health
Profit and Loss Statement TemplateFill in your revenue and expenses below and the statement builds itself — gross profit, operating income, net profit and every margin. Download it as Excel, Google Sheets or PDF, or grab a blank template to fill in by hand. Free, no signup, nothing leaves your browser.
Business name
Period covered
| 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 | — |
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.
The answer changes what actually helps next.
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.
Net Profit = Revenue − Cost of Goods Sold − Operating Expenses − Other Expenses + Other Income
A multi-step statement stops twice on the way down, and those two stops are where the diagnosis lives:
Gross Profit = Revenue − Cost of Goods Sold
Operating Income = Gross Profit − Operating Expenses
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.)
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.
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. |
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:
| 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.
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.