Profit and Loss Template for Small Business: Simplified Categories With 3 Worked Examples (2026)
A simple 8-category P&L for small businesses. Three complete worked examples with real numbers: freelance designer, local bakery, and e-commerce store. See exactly what healthy margins look like for your type of business.
"Your business is not a Fortune 500 company. Your P&L should not look like one."
A simple, consistently-maintained P&L is worth far more than a complex one you only update once a year.
Three Complete Worked Examples
Real line items, realistic numbers, with margin analysis for each business type.
Example 1: Freelance Designer
$120,000 Annual Revenue| Line Item | Annual | % Revenue |
|---|---|---|
| Revenue | ||
| Client Projects | $112,000 | 93.3% |
| Retainer Clients | $8,000 | 6.7% |
| Total Revenue | $120,000 | 100% |
| Direct Costs | ||
| Printing / Production | $3,200 | 2.7% |
| Gross Profit | $116,800 | 97.3% |
| Operating Expenses | ||
| Software Subscriptions | $2,880 | 2.4% |
| Marketing / Portfolio | $1,800 | 1.5% |
| Home Office Deduction | $2,400 | 2.0% |
| Professional Dev | $1,200 | 1.0% |
| Insurance (E&O) | $1,560 | 1.3% |
| Accounting / Legal | $1,400 | 1.2% |
| Other | $1,060 | 0.9% |
| Net Income | $104,500 | 87.1% |
Analysis: A gross margin of 97.3% is excellent for a service business. At 87.1% net margin, this designer keeps $87 of every $100 billed after all business expenses. The main opportunity: marketing spend at 1.5% of revenue is very low - modest investment in portfolio development and referral marketing could grow revenue substantially.
Example 2: Local Bakery
$350,000 Annual Revenue| Line Item | Annual | % Revenue |
|---|---|---|
| Revenue | ||
| Retail Sales | $290,000 | 82.9% |
| Catering / Wholesale | $60,000 | 17.1% |
| Total Revenue | $350,000 | 100% |
| Cost of Goods Sold | ||
| Ingredients / Supplies | $92,400 | 26.4% |
| Packaging | $14,000 | 4.0% |
| Gross Profit | $243,600 | 69.6% |
| Operating Expenses | ||
| Rent | $30,000 | 8.6% |
| Staff Wages | $105,000 | 30.0% |
| Utilities | $9,600 | 2.7% |
| Equipment / Maintenance | $8,400 | 2.4% |
| Marketing | $7,000 | 2.0% |
| Insurance | $4,800 | 1.4% |
| Other | $4,800 | 1.4% |
| Net Income | $74,000 | 21.1% |
Analysis: Net margin of 21.1% is strong for a bakery (industry average is 5-10%). Staff wages at 30.0% of revenue is the largest cost driver - typical range is 25-30%. The catering/wholesale revenue stream at 17.1% of total revenue is worth growing - it typically has better margins than retail.
Example 3: E-Commerce Store
$200,000 Annual Revenue| Line Item | Annual | % Revenue |
|---|---|---|
| Revenue | ||
| Product Sales | $185,000 | 92.5% |
| Subscription Boxes | $15,000 | 7.5% |
| Total Revenue | $200,000 | 100% |
| Cost of Goods Sold | ||
| Product / Inventory Cost | $88,000 | 44.0% |
| Shipping / Fulfillment | $22,000 | 11.0% |
| Gross Profit | $90,000 | 45.0% |
| Operating Expenses | ||
| Platform Fees (Shopify, etc.) | $4,800 | 2.4% |
| Paid Advertising | $24,000 | 12.0% |
| Contractors / VAs | $18,000 | 9.0% |
| Software Tools | $3,600 | 1.8% |
| Returns / Refunds Provision | $6,000 | 3.0% |
| Other | $3,600 | 1.8% |
| Net Income | $30,000 | 15.0% |
Analysis: Net margin of 15.0% is at the lower end for e-commerce (healthy range is 10-20%). The gross margin of 45.0% includes shipping/fulfillment which is high - finding a 3PL or negotiating better shipping rates would drop this. Paid advertising at 12.0% of revenue is above the 10% benchmark - worth auditing ROAS by channel.
Target Margins by Small Business Type
| Business Type | Gross Margin Target | Net Margin Target | Biggest Cost Driver |
|---|---|---|---|
| Freelance / Consulting | 85-95% | 60-80% | Time (opportunity cost) |
| Marketing / Creative Agency | 55-70% | 15-25% | Staff salaries |
| Retail Store | 40-55% | 3-8% | Inventory + rent |
| E-Commerce | 40-60% | 10-20% | Ads + fulfillment |
| Restaurant / Cafe | 60-70% | 3-9% | Food cost + labor |
| Bakery / Food Maker | 55-68% | 5-15% | Ingredients + labor |
| Personal Training / Fitness | 70-85% | 25-45% | Facility / equipment |
| Home Services (cleaning, repair) | 45-65% | 15-25% | Labor + supplies |
| Real Estate Agent | 80-95% | 30-50% | Marketing + MLS fees |
| Childcare / Tutoring | 60-80% | 20-35% | Staff wages |
| Photography / Videography | 70-85% | 35-55% | Equipment depreciation |
FAQ
How many categories does a small business P&L need?
Most small businesses can run well with 8-12 expense categories. More categories create overhead without proportional insight. The key categories are: rent and utilities, salaries and wages, marketing, professional fees, insurance, software, supplies, and other. If 'other' grows above 10% of expenses, break it out further.
What is a good profit margin for a small business?
It varies dramatically by industry. Service businesses (consulting, design, coaching) typically run 20-35% net margins. Food businesses run 5-15%. E-commerce runs 10-20%. If you are below these benchmarks, look at pricing first - a 10% price increase on a 20% margin business doubles profits.
When should I add more categories to my P&L?
Add more categories when: (1) You have multiple distinct revenue streams and want to know which is most profitable. (2) Any single expense category exceeds 15% of revenue. (3) You are seeking investment or a business loan. (4) You have more than 5 employees. Until then, simpler is better.