Free tool

Free Profit and Loss Statement Template

Fill in revenue and expenses to get gross profit, operating income, net profit and margins. Year, quarter or 12-month views, last-year comparison, PDF and Excel-ready CSV. Free, no sign-up.

Loading the profit and loss statement maker…
Profit and loss statement in short
On this page

How to use the profit and loss statement template

1

Name the business and period

Enter the business name and the period, such as For the year ended December 31, 2025. Choose One period, 4 quarters or 12 months at the top.

2

Enter revenue

List each source of income. Use a negative number for refunds, returns or discounts so they reduce revenue.

3

Add costs and expenses

Put the direct cost of what you sell under Cost of goods sold, and running costs such as rent, wages and software under Operating expenses. Interest and taxes go under Other expenses.

4

Review and download

Check net profit and margins in the summary, turn on Compare to add last year, then download the PDF or CSV.

What a profit and loss statement shows

A profit and loss statement, also called a P&L or income statement, shows whether a business made or lost money over a period of time. It starts with revenue, takes away costs in a fixed order and ends with net profit, often called the bottom line. Lenders, investors, landlords and tax preparers all ask for one, and it is the quickest way for an owner to see where money goes.

The P&L in four lines

Gross profit = revenue − cost of goods sold

Operating income = gross profit − operating expenses

Net profit = operating income + other income − other expenses

Margin = profit ÷ revenue × 100

The template shows each of these lines in the table and in the summary, for every column.

SectionWhat goes in itExamples
RevenueMoney earned from sales and servicesProduct sales, service fees, subscriptions, refunds as negatives
Cost of goods soldCosts that rise with each saleInventory, materials, packaging, direct labor
Operating expensesCosts of running the businessRent, wages, marketing, software, insurance, depreciation
Other incomeIncome outside normal operationsInterest earned, gain on selling equipment
Other expensesCosts outside normal operationsLoan interest, income tax, loss on sale of assets

Sample profit and loss statement

Maple Street Coffee, 2025 compared with 2024

The template opens with this example of a small coffee shop. Every number below comes straight from it.

  • Revenue $405,900 (2024: $370,300)
  • Cost of goods sold $123,300
  • Gross profit $282,600, a 69.6% gross margin
  • Operating expenses $254,500
  • Operating income $28,100, a 6.9% operating margin
  • Loan interest $3,100
  • Net profit $25,000, a 6.2% net margin (2024: $7,300)

Revenue grew 9.6%, but profit more than tripled because most costs grew more slowly than sales. That is the kind of insight the Compare column makes easy to spot.

One period, quarters or months?

One period

A single column for a year, a quarter or year to date. The standard format for tax returns, loan applications and annual reviews.

Compare with prior period

Adds last year's numbers and the percentage change for every line, so growth and problem areas stand out.

4 quarters

Four columns with a total. Good for seasonal businesses and quarterly estimated tax planning.

12 months

A month-by-month P&L with a yearly total and a net profit chart. Prints in landscape.

Switching from 12 months to 4 quarters adds the months into quarters for you, and switching to One period carries the yearly totals over, so you never type the same numbers twice.

Profit margins: what is healthy?

Margins vary widely by industry, so compare yourself with similar businesses and with your own past results rather than a single target. As a rough guide, many service businesses with few direct costs keep net margins well above 10%, while restaurants, cafes and grocery stores often run on single-digit net margins. A falling gross margin usually points to rising supplier costs or discounting; a falling operating margin points to overhead growing faster than sales.

Profit is not the same as cash

A P&L can show a profit while the bank balance falls, for example when customers have not paid their invoices yet, or when you repay the principal on a loan, which is not an expense. Depreciation works the other way: it lowers profit without any cash leaving the business that year. Review your P&L alongside your bank statements.

Tips for an accurate P&L

  • Use the same period every time. Monthly or quarterly statements are only useful if they are comparable.
  • Keep owner draws out. Money a sole proprietor takes out is not an expense on the P&L.
  • Separate cost of goods sold. Without it, you cannot see gross margin, which is often the first warning sign.
  • Match your records. Build the statement from bank statements, invoices and receipts, and note how it was prepared.

Need the numbers that feed a P&L? Create invoices with the free invoice generator and track vehicle costs with the mileage log.

More profit and loss templates

Each one opens this tool with a matching example you can edit.

Simple P&L

Revenue, expenses and net profit only.

Small business P&L

12 months with cost of goods sold and gross margin.

Self-employed P&L

Schedule C style lines for freelancers.

Rental property P&L

Rent, repairs, interest and depreciation.

Profit and loss statement FAQ

A financial report that shows revenue, costs and expenses over a period, ending with net profit or loss. It is also called a P&L, income statement or statement of operations.

Yes. You can fill in, save and download as many statements as you like with no sign-up and no watermark.

Yes. Press CSV to download the statement with every line, subtotal and total, then open it in Excel or Google Sheets.

Gross profit is revenue minus the direct cost of what you sold. Net profit is what remains after all other expenses, interest and taxes are also taken away.

Yes. Choose 12 months at the top to enter each month in its own column, with a yearly total and a chart of net profit by month.

Yes. Everything stays in your browser on this device and is never uploaded. Download a backup from My statements to move it to another device.

Scroll to Top