Updated 30 March 2026

Profit and Loss Template: Pre-Built With Formulas, Categories, and Example Data You Can Replace

Most P&L templates are blank grids. Ours comes pre-filled with a realistic small business example so you can see exactly what goes where. Just swap in your numbers.

Three Template Formats: Monthly, Quarterly, and Annual

Every business needs a profit and loss statement, but the right format depends on how you plan to use it. We offer three pre-built variants, each designed for a specific purpose. All three include the same core structure: Revenue, Cost of Goods Sold, Gross Profit, Operating Expenses, EBITDA, and Net Income. The difference is in the time columns and how they help you analyse your data.

Monthly (12 Columns)

Twelve month columns side by side, plus a YTD total. This format shows seasonality patterns, identifies months where expenses spike, and reveals cash flow trends. Best for businesses with seasonal revenue, such as retail (holiday peaks in November and December), landscaping (spring through fall), or tax preparation (January through April).

Columns: Jan through Dec + Year Total

Quarterly (4 Columns)

Four quarters with a full-year total. The quarterly format smooths out month-to-month noise and highlights trends more clearly. It is the most common format for board presentations, investor updates, and management reviews. Quarter-over-quarter comparison quickly reveals whether growth is accelerating or slowing.

Columns: Q1, Q2, Q3, Q4 + Year Total

Annual (Single Column)

One column showing the full year, often placed alongside prior years for comparison. This format is what your accountant needs for tax preparation and what banks require for loan applications. Multi-year comparison (2024 vs 2025 vs 2026) shows long-term trajectory and makes it easy to calculate compound growth rates.

Columns: Current Year (+ optional prior years)

Interactive P&L Template Generator

Select your business type below and the template populates with realistic example data for a business like yours. Edit any category name or amount directly. Switch between monthly, quarterly, and annual views to see how the numbers scale. The generator calculates gross margin, EBITDA, estimated taxes, and net income automatically.

Revenue

Cost of Goods Sold (COGS)

Operating Expenses

Generated Profit and Loss Statement

Monthly view for a service business

Revenue
Consulting fees$28,000
Retainer contracts$12,000
Project-based work$8,000
Training and workshops$2,000
Total Revenue$50,000
Cost of Goods Sold
Subcontractor costs($6,000)
Software licenses (client-facing)($800)
Direct labor (project staff)($8,000)
Total COGS($14,800)
Gross Profit$35,200 (70.4% margin)
Operating Expenses
Salaries (non-project)($10,000)
Office rent($2,500)
Marketing and advertising($2,000)
Software subscriptions($600)
Professional development($400)
Insurance($350)
Accounting and legal($500)
Office supplies($200)
Total Operating Expenses($16,550)
EBITDA$18,650 (37.3% margin)
Estimated tax (21% federal rate)($3,917)
Net Income$14,734 (29.5% net margin)

Industry Benchmarks: Service Businesses

Gross Margin
70.4%
Industry average: 50% to 70%
Within healthy range
Net Margin
29.5%
Industry average: 15% to 25%
Within healthy range
COGS as % of Revenue
29.6%
Industry average: 30% to 50%
Within healthy range

Benchmarks are approximate industry averages sourced from IBISWorld, Sageworks, and BizMiner data for 2024-2025. Your results will vary based on business size, region, and specific market segment.

P&L Structure Explained: A Real Small Business Example

To understand what goes where on a profit and loss statement, here is a complete monthly example for a small business generating $45,000 in monthly revenue. This is a hybrid business selling both products ($30,000 per month) and services ($12,000 per month), with $3,000 from other income sources like affiliate commissions and late payment fees.

Example: Monthly P&L for a $45K/Month Business

Revenue
Product sales$30,000
Service revenue$12,000
Other income$3,000
Total Revenue$45,000
Cost of Goods Sold
Materials and inventory($10,000)
Direct labor($5,500)
Shipping and fulfillment($2,500)
Total COGS($18,000)
Gross Profit$27,000 (60.0% margin)
Operating Expenses
Salaries and wages($10,000)
Rent($3,000)
Marketing and advertising($3,000)
Software and tools($1,200)
Insurance($800)
Professional services($700)
Utilities and internet($600)
Office supplies and miscellaneous($700)
Total Operating Expenses($20,000)
EBITDA$7,000 (15.6% margin)
Net Profit (before tax)$7,000 (15.6% net margin)

This example represents a healthy small business. The 60% gross margin means 40 cents of every revenue dollar goes to direct costs. The $20,000 in monthly operating expenses covers the team, office, and marketing. The resulting $7,000 net profit (15.6% net margin) is above average for a hybrid business, where typical net margins range from 10% to 20%. On an annual basis, this business generates $540,000 in revenue and $84,000 in pre-tax profit.

Revenue Recognition: What Counts on Your P&L (and What Does Not)

Revenue on a P&L statement means money earned from your core business operations. This distinction matters because including the wrong items inflates your revenue and distorts your profit margins, making your business look healthier than it actually is.

Counts as Revenue

  • + Product sales (when goods are delivered, not when ordered)
  • + Service fees (when work is completed or milestones are met)
  • + Subscription and recurring revenue (monthly as it is earned)
  • + Commission income from sales
  • + Licensing and royalty fees
  • + Rental income (if rental is part of your core business)

Does Not Count as Revenue

  • - Loans received (this is a liability, not income)
  • - Owner investment or capital contributions
  • - Customer deposits for work not yet delivered (record as deferred revenue)
  • - Tax refunds (unless your business is a tax advisory firm)
  • - Insurance claim payouts
  • - Sale of business equipment or assets (this is a capital gain, not operating revenue)

The deposit vs. delivered distinction trips up many small businesses. If a client pays you $10,000 upfront for a 4-month project, you should not record $10,000 in revenue on day one. Under accrual accounting, you would record $2,500 per month as you deliver the work. Under cash accounting, you would record the full $10,000 when received, but you need to understand this creates a timing mismatch between revenue and the expenses incurred to deliver that work. This is one of the key reasons accrual accounting gives a more accurate picture of business performance.

COGS vs Operating Expenses: Why the Distinction Matters

Cost of Goods Sold (COGS) and Operating Expenses are both costs, but separating them on your P&L reveals two different things about your business. COGS tells you how efficiently you produce or deliver what you sell. Operating expenses tell you how efficiently you run the business itself. The line between them is the gross profit, and it is the single most important number on your P&L.

COGS (Direct Costs)

Costs that scale directly with revenue. If you sell nothing, these costs are zero.

  • Raw materials: $5 to $50 per unit depending on product
  • Direct labor: hours spent producing the product or delivering the service
  • Manufacturing overhead: factory rent, equipment maintenance
  • Shipping and fulfillment: $3 to $15 per order for e-commerce
  • Packaging: $0.50 to $3 per unit
  • Subcontractor fees: costs for outsourced production work

Operating Expenses (Fixed Costs)

Costs incurred regardless of sales volume. These recur even if revenue drops to zero.

  • Rent and utilities: $500 to $5,000 per month for small businesses
  • Salaries (non-production): admin, sales, management
  • Marketing and advertising: typically 5% to 12% of revenue
  • Software subscriptions: $200 to $2,000 per month
  • Insurance: $300 to $1,000 per month
  • Professional services: accountant, lawyer, consultants

Here is why the separation matters in practice. Say your business has $100,000 in revenue. If COGS is $60,000 and operating expenses are $30,000, your gross margin is 40% and your net margin is 10%. Now imagine revenue drops 20% to $80,000. Your COGS drops proportionally to $48,000 (still 60% of revenue), but operating expenses stay at $30,000 because rent and salaries do not change. Your new gross profit is $32,000 and your net income is just $2,000 (2.5% margin).

This is why businesses with high fixed costs are riskier during downturns. A restaurant paying $8,000 per month in rent needs substantial revenue just to break even. A freelance consultant working from home with $500 per month in fixed costs can survive on much less revenue. Your P&L should make this cost structure immediately visible.

Monthly vs Annual P&L: When to Use Each Format

Both formats use the same categories. The difference is what they reveal and what decisions they support. Most businesses need both: monthly for operations and annual for strategy, tax filing, and external reporting.

Monthly P&L Is Best For

  • Spotting seasonal patterns: A landscaping company will see revenue of $2,000 in January vs. $18,000 in June. This pattern guides hiring, equipment purchases, and cash reserves.
  • Cash flow management: Even profitable businesses fail if they run out of cash. Monthly P&L shows which months drain cash and which build reserves.
  • Expense control: A monthly view reveals if marketing spend jumped from $2,000 to $4,500 in March. With an annual view, that spike gets averaged out and hidden.
  • Pricing adjustments: If gross margin drops from 60% to 48% in a single month, you can investigate immediately rather than discovering it 6 months later.

Annual P&L Is Best For

  • Tax preparation: Schedule C (sole proprietors) and Form 1120 (corporations) require annual totals. Your accountant needs the full-year summary.
  • Bank loans and credit lines: Lenders review 2 to 3 years of annual P&L statements. They calculate debt service coverage ratio (DSCR) from annual net income.
  • Year-over-year trends: Comparing 2024 annual revenue ($380,000) to 2025 ($540,000) shows 42% growth. Monthly data makes this harder to see.
  • Strategic planning: Annual figures set the baseline for next year's budget. If operating expenses were 44% of revenue this year, can you reduce them to 40% next year?

Using Your P&L Statement to Make Better Business Decisions

A profit and loss statement is not just a compliance document. It is a decision-making tool. Here are the specific metrics to track and the actions they should trigger, with real benchmarks by industry.

1. Track Gross Margin Monthly

Gross margin is (Revenue - COGS) / Revenue. It tells you how much of each dollar is available to cover operating expenses and generate profit. If gross margin drops by more than 3 percentage points in a single month, investigate immediately.

Common causes of margin decline: Supplier price increases (raw materials up 8% to 15% in 2025 for many categories), offering discounts without adjusting cost structure, scope creep on service projects (delivering $8,000 of work for a $5,000 contract), and shipping cost increases (UPS and FedEx raised rates 5.9% in January 2025).

2. Compare Every Expense as a Percentage of Revenue

Dollar amounts are misleading on their own. Spending $5,000 per month on marketing is too much for a $20,000 per month business (25% of revenue) but appropriate for a $100,000 per month business (5% of revenue). Express each expense line as a percentage to spot where money is being allocated disproportionately.

Typical Marketing Spend
5% to 12% of revenue
B2B: 5-8% | B2C: 8-12% | Startups: 15-20%
Typical Rent
2% to 10% of revenue
Home office: 0% | Retail: 5-10% | Office: 2-5%

3. Benchmark Against Your Industry

Industry benchmarks give you an external reference point. If your gross margin is 35% but your industry averages 55%, something is wrong with your pricing, supplier costs, or production efficiency. Here are net profit margin benchmarks by industry, sourced from NYU Stern, IBISWorld, and BizMiner 2024-2025 data:

Restaurants
3% to 5%
Retail (general)
2% to 5%
Construction
5% to 10%
Healthcare services
10% to 15%
Professional services
15% to 25%
Software / SaaS
20% to 30%

Frequently Asked Questions

What is the difference between a profit and loss statement and a balance sheet?

A profit and loss statement (also called an income statement) measures revenue, expenses, and profit over a specific time period, such as a month, quarter, or year. It shows how much money your business earned and spent. A balance sheet, by contrast, is a snapshot of your financial position at a single point in time. It lists what you own (assets), what you owe (liabilities), and owner equity. You need both: the P&L tells you if the business is profitable, while the balance sheet tells you if the business is solvent. Together they paint the complete financial picture.

Should I use cash basis or accrual basis for my P&L?

Cash basis records revenue when cash is received and expenses when cash is paid. Accrual basis records revenue when earned and expenses when incurred, regardless of when cash changes hands. If your business has annual revenue under $26 million (2025 IRS threshold), you can choose either method. Cash basis is simpler and shows actual cash flow, making it popular with freelancers and small businesses. Accrual basis gives a more accurate picture of profitability because it matches revenue with the expenses that generated it. Most businesses with inventory, significant accounts receivable, or plans to seek investment should use accrual basis.

Is a profit and loss statement enough for tax filing?

A P&L statement alone is not sufficient for filing your tax return, but it contains most of the numbers you need. Sole proprietors and single-member LLCs report their P&L data on Schedule C (Form 1040), which asks for gross receipts, cost of goods sold, and itemized expenses. Partnerships file Form 1065, S-corps file Form 1120-S, and C-corps file Form 1120, all of which require P&L data plus additional schedules. You will also need your balance sheet data, depreciation schedules, payroll records, and 1099 forms. Your P&L is the starting point, not the complete picture.

How often should I prepare a profit and loss statement?

Prepare a P&L monthly at minimum. Monthly statements let you spot problems early, such as a sudden drop in gross margin or an expense category growing faster than revenue. Many business owners also prepare quarterly P&L statements for deeper analysis, comparing quarter-over-quarter trends and checking progress against annual targets. Annual P&L statements are required for tax filing and are useful for year-end reviews with your accountant. If your business is seasonal or fast-growing, weekly P&L reports may help you make faster decisions.

What categories should I include in a small business P&L?

A small business P&L should include at minimum: Revenue (broken into 2 to 4 sources), Cost of Goods Sold (materials, direct labor, shipping), Gross Profit, Operating Expenses (rent, salaries, marketing, insurance, software, professional services, utilities, office supplies), EBITDA or Operating Income, and Net Income after estimated taxes. The IRS Schedule C lists 20 standard expense categories. Most small businesses can consolidate these into 8 to 12 categories that match their actual spending patterns. Avoid creating too many categories, as this makes the statement harder to read without adding useful insight.

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

Net profit margins vary dramatically by industry. Restaurants and food service businesses typically operate at 3% to 5% net margin. Retail businesses average 2% to 5%. Professional services firms (consulting, accounting, legal) commonly achieve 15% to 25%. Software and SaaS companies can reach 20% to 30% net margins at scale. Construction companies average 5% to 10%. As a general benchmark, a net margin above 10% is considered healthy for most small businesses, and above 20% is excellent. If your net margin is below 5%, review your pricing strategy and largest expense categories for opportunities to improve.