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.
- Fill in revenue, cost of goods sold and expenses; gross profit, operating income, net profit and margins are worked out for you.
- Show one period, four quarters or twelve months side by side, and compare this year with last year.
- Add, rename or remove any line to match your business.
- Download a clean PDF or an Excel-ready CSV, or print a blank template. Free, no sign-up, and your numbers stay in your browser.
How to use the profit and loss statement template
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.
Enter revenue
List each source of income. Use a negative number for refunds, returns or discounts so they reduce revenue.
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.
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.
| Section | What goes in it | Examples |
|---|---|---|
| Revenue | Money earned from sales and services | Product sales, service fees, subscriptions, refunds as negatives |
| Cost of goods sold | Costs that rise with each sale | Inventory, materials, packaging, direct labor |
| Operating expenses | Costs of running the business | Rent, wages, marketing, software, insurance, depreciation |
| Other income | Income outside normal operations | Interest earned, gain on selling equipment |
| Other expenses | Costs outside normal operations | Loan 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.
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
What is a profit and loss statement?
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.
Is this profit and loss statement template free?
Yes. You can fill in, save and download as many statements as you like with no sign-up and no watermark.
Can I use it as an Excel profit and loss template?
Yes. Press CSV to download the statement with every line, subtotal and total, then open it in Excel or Google Sheets.
What is the difference between gross profit and net profit?
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.
Can I make a monthly profit and loss statement?
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.
Is my financial information private?
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.