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.

Example figures
LineThis periodSame 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 margin59.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 margin4.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 service
Questions

Still wondering?

Ask anything else on a free 30-minute call.

Book a call
What 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.

Get started

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.

Get a free quote

Your name, plus an email or a phone number, whichever you prefer.

A sentence or two is plenty. Please don't include Social Security numbers, bank or card numbers, or tax documents here.

Thanks. This is a design preview, so nothing was sent.