MENU
HomeGuides
Guide

Profit and Loss Statement for Small Business (Free Template + Example)

A profit and loss statement is one of the most important documents in your business. It tells you whether you are actually making money — or just staying busy. This guide explains what a P&L is, walks through every line item, shows you a real filled-in example, and gives you a free downloadable template you can use today.

Try YourProfitBook Free

Track profit, expenses, and taxes in one dashboard. AI insights included. No credit card required.

Start Free
Updated June 2026·7 min read

What a P&L Actually Tells You

A profit and loss statement — also called an income statement or P&L — answers one question: did my business make money or lose money during this period?

It works by listing everything your business earned (revenue) at the top, then subtracting everything it spent (expenses) below. The number at the bottom is your profit — or your loss. Revenue minus expenses equals profit. That is it.

Revenue is not profit. You might bring in $8,000 a month, but if $7,200 goes out to materials, insurance, gas, and tools, you actually kept $800. Without a P&L, most business owners think they are doing well because their bank account looks healthy — until a quarterly tax bill wipes it out. A P&L prevents that surprise.

The 5 Parts of a P&L Statement

Every P&L follows the same structure, whether you run a cleaning company or a food truck. Here are the five parts:

  1. Revenue (Total Income). All the money your business brought in during the period — client payments, product sales, service fees. If a customer paid you, it goes here.
  2. Cost of Goods Sold (COGS). The direct costs of delivering your product or service. For a cleaner, that is supplies and chemicals. For a food truck, it is ingredients. These costs are tied to specific jobs or sales.
  3. Gross Profit. Revenue minus COGS. This tells you how much is left after covering the direct cost of doing the work — before overhead.
  4. Operating Expenses. The costs of running your business that are not tied to specific jobs: rent, insurance, phone, marketing, software, travel. These happen whether you get one client or fifty.
  5. Net Profit (The Bottom Line). Gross profit minus operating expenses. This is the money you actually keep. If this number is negative, your business is losing money.

A Real Filled-In P&L Example

Here is a complete P&L for a solo residential cleaning business operating in a mid-size city. Every number below is realistic for this type of business over one month.

Sparkle Clean Co. — May 2026

Revenue
  Residential cleaning (48 jobs × $135 avg)$6,480
  Deep clean add-ons (6 × $85)$510
Total Revenue$6,990
Cost of Goods Sold
  Cleaning supplies & chemicals−$218
  Replacement mop heads, sponges, rags−$47
Total COGS−$265
Gross Profit$6,725
Gross Margin96.2%
Operating Expenses
  Vehicle insurance (monthly)−$195
  Gas — 820 miles at ~$3.40/gal (24 mpg)−$116
  Phone bill (business line)−$55
  Scheduling software + YourProfitBook Pro−$30
  Facebook/Instagram ads (local)−$150
  General liability insurance (monthly)−$85
  Bookkeeper (quarterly, 1/3 of $270)−$90
  Estimated tax set-aside (federal + state)−$680
Total Operating Expenses−$1,401
Net Profit$5,324
Net Profit Margin76.2%

This cleaning business brought in $6,990 in revenue and kept $5,324 after all expenses — a 76% net margin, which is strong for a solo service business with minimal materials cost. The biggest expense lines are the tax set-aside ($680) and insurance ($280 combined). That kind of visibility is exactly what a P&L gives you: not just "I made about seven grand" but "I kept $5,324 and here is where every dollar went."

How to Read Your P&L (What to Look For)

Once you have a P&L in front of you, here are the three things that matter most:

  • Gross margin. (Gross Profit ÷ Revenue) tells you how much you keep before overhead. In the example above, 96.2% means almost every dollar of revenue survives the direct cost of doing the job. If this number drops month over month, your per-job costs are rising — you may need to raise prices or find cheaper supplies.
  • Biggest expense lines. Sort your operating expenses from largest to smallest. The top two or three items are where to focus if you need to cut costs. In our example, the tax set-aside and insurance together are $960 — nearly 70% of all operating expenses. Those are not easy to reduce, which means this business is already lean.
  • Month-over-month trend. A single month’s P&L is a snapshot. Three months side by side is a story. Is revenue growing? Is net margin stable or shrinking? Are any expense categories creeping up? Compare your P&L monthly to catch problems early — not at tax time when it is too late to act.

For more on tracking the expenses that feed into your P&L, see our guide to tracking business expenses.

Free P&L Template Download

We built a clean, formula-ready Profit & Loss template you can download and start using immediately. It includes Revenue, COGS, Gross Profit, Operating Expenses, and Net Profit sections with auto-calculating formulas. Three month columns let you compare periods side by side.

Free Profit & Loss Template

Excel (.xlsx) — formulas included, no email required, no strings attached.

Download Free Template

Works in Excel, Google Sheets, LibreOffice, and Numbers.

Fill in your business name, enter your revenue and expenses, and the template calculates gross profit, net profit, and profit margin automatically. If your business has more than a handful of transactions per month, you may want to automate the process instead of updating a spreadsheet manually.

Build Your P&L Automatically

A spreadsheet template works. But if you log more than a few transactions per week, updating it manually gets old fast. YourProfitBook generates your profit and loss statement automatically as you log income and expenses. Every transaction hits your live P&L Dashboard the moment you enter it — no formulas to build, no end-of-month report to generate.

Need to share your P&L with a lender, partner, or accountant? Export to PDF, Excel (.xlsx), or CSV with one click. The AI Profit Assistant explains your numbers in plain English and flags unusual changes — like a sudden spike in supply costs or a revenue dip compared to last month.

The free plan includes 30 lifetime transactions and a live P&L dashboard — enough to try the system without commitment. No credit card required. The Pro plan ($9.99/month) unlocks unlimited transactions, custom categories, receipt OCR, and full export capabilities. See all plans, or explore our P&L report software for more details.

Frequently Asked Questions

How often should I run a profit and loss statement?

Monthly is the right cadence for most small businesses. Monthly reviews let you catch problems early — a cost spike, a revenue dip, a subscription you forgot to cancel — while they are still small enough to fix. Quarterly P&L reviews are useful for trends, but monthly is where you make decisions.

What is the difference between a P&L and a balance sheet?

A P&L shows flow: how much money came in and went out over a period of time. A balance sheet shows position: what your business owns (assets), what it owes (liabilities), and the owner equity at a single point in time. You need both, but the P&L is the one most small business owners should check monthly.

Can I make a P&L statement in Excel?

Yes. Download our free P&L template (available on this page) and fill in your revenue and expenses. The formulas calculate gross profit, net profit, and profit margin automatically. For businesses with more than a handful of transactions per month, a tool like YourProfitBook generates your P&L automatically as you log transactions.

What is a good net profit margin for a small business?

It varies by industry. Service businesses (consulting, cleaning, grooming) often see 15–50% net margins. Retail and food businesses typically run 3–10%. The important thing is not hitting a specific number — it is knowing your number and watching the trend month over month. A declining margin is a signal to act, regardless of the absolute percentage.

Is a profit and loss statement the same as an income statement?

Yes. Profit and loss statement, income statement, P&L, and statement of earnings all refer to the same document. Different industries, accountants, and textbooks use different names, but the structure is identical: revenue minus expenses equals profit.

Related Guides

Ready to Track Your Profit?

Start free. No credit card required. Setup takes less than 30 seconds.

Start Free Demo