Sample text in [brackets], replace with yours · Accounting & Small Business Spreadsheets
Profit and Loss Statement Template — Income Statement Format (Excel & PDF)
A P&L (income statement) for a small business, comparing this period with the last, with every total calculated.
Opens in your browser. No Excel needed, no signup.
Free for personal and commercial use · No watermark · Updated November 2026
Guide
About this profit and loss statement template
A profit and loss statement (P&L, or income statement) shows whether a business made money over a period. It starts with revenue, takes away the cost of what was sold to give gross profit, then takes away running costs to give operating profit, and finally interest and tax to give net profit. This Excel sheet does every step for you, shows the net profit margin, and compares each line with the previous period so you can see what changed.
How to use this P&L template
- 1
Click "Edit online", or download the Excel file.
- 2
Set the period at the top: a month, a quarter or a financial year.
- 3
Type your figures in the yellow cells for this period and the previous one. Enter costs as positive numbers.
- 4
Rename or add lines to match your business, keeping new rows inside each section so the totals include them.
- 5
Read gross profit, operating profit, net profit and the margin, and look at the change % column for big movements.
Tips for reading a P&L
Watch gross margin
If gross profit grows more slowly than sales, your direct costs or discounts are rising.
Profit isn't cash
A P&L can show a profit while the bank balance falls, for example when customers pay late. Track cash separately.
Compare like with like
Compare the same months year on year when your business is seasonal.
Use accrual figures
Record income when you earn it and costs when you incur them, not only when cash moves, for a truer picture.
Frequently Asked Questions
Tools that help
Excel to PDF
Convert Excel spreadsheets to PDF with all sheets preserved
PDF to Excel
Extract tables from PDF into editable Excel spreadsheets
Percentage Calculator
Calculate percentages, increase, decrease, and ratios
Currency Converter
Convert between 150+ world currencies with live rates















