Free Template
Excel, Google Sheets & PDF
No signup

Profit and Loss Statement Template

Fill 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.

Build your profit and loss statement

Business name

Period covered

Statement format

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 itemAmount% 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
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.

The Profit and Loss Formula

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.)

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.

SectionTypical line itemsRule of thumb
RevenueProduct sales, subscription revenue, services, shipping charged to customersRecognised when earned, not when the cash lands.
Cost of goods soldHosting, materials, manufacturing, payment processing, contractor delivery timeOnly costs that rise when you sell one more unit.
Operating expensesSalaries, rent, marketing, software, insurance, accounting and legal feesCosts of running the business whether you sell anything or not.
Other incomeInterest earned, grants, the gain on a one-off asset saleRecord the gain or loss, not the gross sale price. Kept separate so it does not flatter margins.
Other expensesInterest on loans, corporate income tax, business taxes and licensesBelow 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:

  1. Is 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.
  2. Is 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.
  3. Does 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

MetricSaaS / softwareServices / agencyEcommerce / retail
Gross margin70–85%30–50%30–50%
Operating margin0–20%10–20%5–15%
Net margin0–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.

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.

Frequently Asked Questions

A profit and loss statement — also called an income statement or P&L — reports what a business earned and spent over a period, ending in net profit or net loss. Under accrual accounting it records revenue when it is earned and costs when they are incurred rather than when cash moves, which is why a profitable business can still be short of cash. Under cash accounting, which many small businesses use, income is recorded when received and expenses when paid.
List all revenue for the period and total it. Subtract cost of goods sold — the direct costs of delivering what you sold — to get gross profit. Subtract operating expenses like payroll, rent and software to get operating income. Then subtract interest and tax to reach net profit. The builder above does all of it as you type, and exports the finished statement to Excel, Google Sheets or PDF.
Yes. Every download on this page is free, unwatermarked, and requires no email or signup: an Excel (.xlsx) workbook, a CSV you can import straight into Google Sheets, and a print-ready PDF (it runs onto a second page if your statement is long). You can download a blank template with the standard line items already laid out, or fill in the builder first and export a completed statement.
A business bills $120,000 in a month. Hosting and payment fees of $18,000 leave gross profit of $102,000 — an 85% gross margin. Salaries and marketing of $72,000 leave operating income of $30,000, a 25% operating margin. After $4,000 of loan interest and $6,000 of tax, net profit is $20,000, a 16.7% net margin. Enter your own figures above to see the same statement built from your numbers.
A single-step statement subtracts one combined expense total from revenue — simpler, and enough when nobody needs the cost breakdown. A multi-step statement separates cost of goods sold from operating expenses, which reveals gross profit and operating income. Both reach the same net profit. Use multi-step for lenders and investors, because gross margin is what tells them whether the business scales — and also if you report cost of goods sold on your return, since Schedule C keeps that split.
A year-to-date P&L covers 1 January through today rather than a single month. Total each line item across every month so far and enter the totals, then label the period "YTD" — for example Jan–Jun 2026 (YTD). Lenders and mortgage underwriters usually ask for a YTD statement alongside the prior full year, so they can see the trend rather than one month.
Usually yes. A profit and loss statement is what a lender, landlord or mortgage underwriter asks for when you do not have W-2 payslips, and it is the working document behind Schedule C at tax time. If you sell goods and report cost of goods sold, keep the multi-step split, because Schedule C derives gross profit from COGS in Part I and Part III. Note that federal income tax and self-employment tax are not deductible business expenses, so they do not belong on the statement. This is general information, not tax advice.
The Excel download is a real .xlsx workbook, and the CSV imports directly into Google Sheets via File → Import → Upload. QuickBooks generates its own P&L from your bookkeeping data rather than importing one, so use this page when you keep books outside QuickBooks — or to sanity-check what QuickBooks reports. If your records are still PDF bank statements, the free bank statement converter turns them into a spreadsheet first.
Underwriting varies by lender and product, and cash flow available to service debt, leverage and balance-sheet quality often weigh as much as the P&L itself. That said, recurring-revenue lenders typically look hard at gross margin, because it caps how much of each new dollar can service debt, and at the operating expense trend. Net profit alone is rarely decisive — a business reinvesting into growth can be unprofitable and still fundable. Recurring revenue at a high gross margin is predictable enough to borrow against, which is what makes non-dilutive capital possible. Founderpath funds SaaS companies from $10K MRR up to $5M without equity or board seats.
Yes — 100% free, no signup, no email, no watermark and no download limit. The statement is built entirely in your browser and the files are generated on your device, so none of your figures are ever uploaded to a server. Browse the rest of the free tools for founders if you need burn rate, runway or CAC next.