Profit and loss statement template
A profit and loss statement, also called an income statement, shows what your business earned and spent over a period, and what was left. This free template lists income, cost of goods sold and the usual expense lines for a small business, then works out gross profit, net profit and your margins for you.
Updated November 2026
What does the template look like?
Type your numbers in the white cells. Totals and results add themselves in Excel. Here it is with sample figures, so you can see how it fills in.
| Line | This period | Same period last year |
|---|---|---|
| Income | ||
| Sales of products | $182,000.00 | $161,000.00 |
| Sales of services | $64,000.00 | $52,000.00 |
| Other income | $1,200.00 | $800.00 |
| Total income | $247,200.00 | $213,800.00 |
| Cost of goods sold | ||
| Materials and inventory used | $74,000.00 | $68,000.00 |
| Direct labor | $22,000.00 | $19,500.00 |
| Shipping and freight in | $3,100.00 | $2,800.00 |
| Total cost of goods sold | $99,100.00 | $90,300.00 |
| Gross profit | $148,100.00 | $123,500.00 |
| Gross margin | 59.9% | 57.8% |
| Operating expenses | ||
| Advertising and marketing | $8,400.00 | $6,100.00 |
| Bank and card fees | $5,200.00 | $4,500.00 |
| Contractors | $9,800.00 | $8,800.00 |
| Insurance | $4,200.00 | $3,900.00 |
| Meals (business) | $1,300.00 | $1,100.00 |
| Office supplies and software | $3,600.00 | $3,200.00 |
| Payroll: wages | $48,000.00 | $44,000.00 |
| Payroll: employer taxes and benefits | $6,900.00 | $6,200.00 |
| Professional fees | $5,400.00 | $5,000.00 |
| Rent | $24,000.00 | $24,000.00 |
| Repairs and maintenance | $1,900.00 | $1,400.00 |
| Travel | $2,300.00 | $1,700.00 |
| Utilities and phone | $3,800.00 | $3,600.00 |
| Vehicle and mileage | $4,100.00 | $3,700.00 |
| Other expenses | $900.00 | $1,200.00 |
| Total operating expenses | $129,800.00 | $118,400.00 |
| Operating profit | $18,300.00 | $5,100.00 |
| Other items | ||
| Interest expense | $2,600.00 | $3,100.00 |
| Depreciation | $5,500.00 | $5,000.00 |
| Total other items | $8,100.00 | $8,100.00 |
| Net profit | $10,200.00 | -$3,000.00 |
| Net margin | 4.1% | -1.4% |
What goes on a profit and loss statement?
Three blocks. Income is everything you billed or sold. Cost of goods sold is what it cost to make or buy what you sold, like materials, inventory and direct labor. Operating expenses are the costs of running the business, from rent to software. Income minus cost of goods sold is gross profit. Gross profit minus operating expenses, interest and depreciation is net profit.
How often should I run one?
Monthly is best. A month-by-month P&L shows trends early, like rising card fees or a slow quarter, while there's still time to act. Lenders, landlords and investors often ask for the last two years and the current year to date. Want twelve months side by side? Use our small business budget template, which has a column for each month.
Is a P&L the same as an income statement?
Yes. Profit and loss statement, P&L, income statement and statement of operations all mean the same report. Your tax return uses the same numbers: Schedule C for a sole proprietor or single-member LLC, and Form 1065, 1120-S or 1120 for other entities.
What's left out on purpose?
Owner draws, distributions and the principal part of loan payments. They move money out of the business, but they aren't expenses, so they live on the balance sheet instead. Putting them on the P&L understates your profit, and that's a common reason books and returns don't match.
Sources
General information, not tax advice for your situation.
Want your books off your plate?
One accountant keeps them current, every month.
See our bookkeeping serviceWhat is the difference between gross profit and net profit?
Gross profit is income minus the direct cost of what you sold. Net profit is what remains after every other expense, including rent, payroll, interest and depreciation.
Can I use this template for my tax return?
It helps. The totals feed Schedule C or your business return, but the IRS has its own lines and rules, such as the 50% limit on business meals. Your preparer maps them.
Should I use cash or accrual numbers?
Use the method your books and tax return use. Most small businesses use cash: income when paid, expenses when paid.
Tell us what's messy. We'll tell you what it takes.
Tell us what you need and get a fixed price before any work starts. No pressure and no contract.