SmallBizHandbookSmallBizHandbook

Free Profit and Loss (P&L) Statement Template

Last updated: 2026-10-07

Build your small business P&L by month, quarter or year, compare it with last year, and see gross, operating and net margins update as you type. Start from an industry layout or IRS Schedule C. When you're done, download an Excel file that keeps calculating, or print a clean income statement.

$
Line item
FY 2025
ended Dec 31
FY 2024
ended Dec 31
Revenue
$
$
$
$
$
$
Net revenue––
Cost of goods sold
$
$
$
$
$
$
$
$
Total cost of goods sold––
Gross profit––
Operating expenses
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
Total operating expenses––
Operating income (loss)––
Other income
$
$
$
$
Total other income––
Other expenses
$
$
$
$
Total other expenses––
Net income (loss)––

Saved automatically in this browser only. Nothing is uploaded. Click next to a line to see what belongs there.

Automatic checks

  • Enter your figures, pick an industry layout, or load the example to run the checks.

Key ratios (per column)

Gross margin

FY 2025
—
FY 2024
—

Gross profit ÷ net revenue

Operating margin

FY 2025
—
FY 2024
—

Operating income ÷ net revenue

Net profit margin

FY 2025
—
FY 2024
—

Net income ÷ net revenue

EBITDA

FY 2025
—
FY 2024
—

Net income + interest + income taxes + depreciation and amortization

Source: SBA SOP 50 10 8.1

Debt service coverage (DSCR)

FY 2025
—
FY 2024
—

EBITDA ÷ loan payments (principal + interest) for the same period

Source: SBA SOP 50 10 8.1

Operating expense ratio

FY 2025
—
FY 2024
—

Total operating expenses ÷ net revenue

Interest coverage

FY 2025
—
FY 2024
—

Operating income ÷ interest expense

Revenue growth

FY 2025
—
FY 2024
—

(Net revenue − prior net revenue) ÷ prior net revenue

How to prepare a profit and loss statement, step by step

  1. Choose the period and layout. Annual for tax and lender packages (add the prior year for comparison), year-to-date for an interim statement, monthly to spot seasonality and trends. Pick an industry layout or the Schedule C layout to start with sensible line items.
  2. Revenue. Total sales for the period from your accounting software, POS or bank deposits (cash basis), or invoices (accrual basis). Enter refunds and discounts on the “Less:” line.
  3. Cost of goods sold. The direct costs of what you sold: materials, products bought for resale, production labor, subcontractors. If you carry inventory, use beginning inventory + purchases − ending inventory (the Retail and Schedule C layouts are set up that way).
  4. Operating expenses. Rent, payroll for staff not in cost of goods sold, insurance, marketing, software, professional fees, depreciation. Leave out owner draws, loan principal and the purchase price of equipment.
  5. Other income and expenses. Interest earned, interest paid, gains or losses on selling assets. Keeping these below operating income shows how the core business performs.
  6. Income taxes. Choose your business type. Pass-through businesses usually show none. C corporations can estimate tax at a rate or enter it.
  7. Review. Turn on % of net revenue to see each cost as a share of sales, read the automatic checks, and compare the margins with last year.

Worked example: a small bakery's P&L, 2025 vs. 2024

The same fictional Maple Street Bakery LLC used on the balance sheet and cash flow templates. It's a pass-through LLC, so no income tax appears at the business level.

Maple Street Bakery LLC
Profit and Loss Statement
For the years ended December 31, 2025 and 2024
(In U.S. dollars)
FY 2025
ended Dec 31
FY 2024
ended Dec 31
Revenue
Retail bakery and café sales412,000368,000
Wholesale and catering96,00074,000
Less: Returns, discounts and comps(3,500)(3,000)
Net revenue504,500439,000
Cost of goods sold
Ingredients128,000113,000
Packaging14,50012,800
Production wages (bakers)72,00064,000
Total cost of goods sold214,500189,800
Gross profit290,000249,200
Operating expenses
Salaries and wages (counter and admin)88,00079,000
Payroll taxes and benefits21,50019,200
Rent54,00052,000
Utilities and phone14,20013,100
Insurance6,4006,000
Advertising and marketing9,8008,500
Card processing and bank fees11,3009,900
Repairs and maintenance5,2004,100
Professional fees (accounting, legal)4,8004,500
Office, software and supplies3,1002,900
Depreciation and amortization18,00016,000
Total operating expenses236,300215,200
Operating income (loss)53,70034,000
Other income
Interest income300200
Total other income300200
Other expenses
Interest expense6,0006,800
Total other expenses6,0006,800
Net income (loss)48,00027,400

Fictional company for illustration. Click “Load example” in the template above to explore these figures, then open the other two templates to see the same company's statements.

What it says: net revenue grew from $439,000 to $504,500. Gross margin edged up from 56.8% to 57.5%, and because overhead grew more slowly than sales, operating margin improved from 7.7% to 10.6%. Net income rose from $27,400 to $48,000. EBITDA was $72,000. With $20,000 of loan payments in the year, debt service coverage is 3.60×, well above the 1.15:1 minimum SBA sets for standard 7(a) loans.

How to read a P&L: margins and ratios

  • Gross margin (gross profit ÷ net revenue): how much of each sales dollar is left after direct costs. A falling gross margin usually means costs rose faster than prices.
  • Operating margin (operating income ÷ net revenue): profit from the core business before interest and taxes. The SEC guide uses this definition.
  • Net profit margin (net income ÷ net revenue): the bottom line. For pass-through businesses it's before the owners' personal income and self-employment taxes.
  • EBITDA (net income + interest + taxes + depreciation and amortization): SBA's lending rules use it as “operating cash flow” when testing repayment ability.
  • Debt service coverage (EBITDA ÷ annual principal + interest): enter your loan payments in the template's settings. SBA requires at least 1.15:1 for standard 7(a) loans and 1.10:1 for 7(a) Small Loans.
  • Interest coverage (operating income ÷ interest expense) and the operating expense ratio (total operating expenses ÷ net revenue).

No benchmark ranges are given for margins because they vary too much by industry to be meaningful without your industry's data.

Using the P&L for IRS Schedule C

Sole proprietors and single-member LLCs report business profit on Schedule C (Form 1040). Choose the IRS Schedule C layout and the template's lines follow the 2025 form:

  • Revenue: line 1 (gross receipts) less line 2 (returns and allowances)
  • Cost of goods sold: Part III. Beginning inventory (35) + purchases (36) + labor (37) + materials (38) + other costs (39) − ending inventory (41) = line 42
  • Expenses: lines 8 through 27b, plus business use of home on line 30
  • Other income: line 6. Net income corresponds to line 31 (net profit or loss).

Schedule C asks for some amounts on a tax basis that differ from your books. Only the deductible portion of meals goes on line 24b, and depreciation on line 13 follows tax rules. Your bookkeeping P&L and your Schedule C won't always match line for line.

Common P&L mistakes

  • Counting owner draws or loan principal as expenses. Neither reduces profit.
  • Expensing a big equipment purchase in one month on your books. That makes one month look terrible and the rest too good. Record it as an asset and depreciate it.
  • Putting overhead in cost of goods sold (or direct costs in overhead). It distorts gross margin, the number most worth tracking.
  • Treating sales tax collected as revenue. It's money you hold for the state, a liability on the balance sheet.
  • Mixing personal expenses into business ones. It overstates expenses and undercuts the statement with lenders and the IRS.
  • Comparing a 9-month period with a 12-month one. Use the same period length, or compare year-to-date with the same months of the prior year (set the length to the same number of months).

How the balance sheet, P&L and cash flow statement connect

The three statements describe the same business from different angles. The profit and loss statement covers a period: did you make money? The balance sheet is a snapshot at the end of the period: what do you own and owe? The cash flow statement explains why cash changed between two balance sheets. Here's how the example bakery's 2025 figures flow between them:

FigureShows up inExample
P&L: net incomeCash flow: first line of operating activities$48,000
P&L: net incomeBalance sheet: equity (current-period net income)$48,000
P&L: depreciationCash flow: added back (non-cash). Balance sheet: accumulated depreciation rises by the same amount$18,000
Cash flow: ending cashBalance sheet: cash and cash equivalents$34,700
Cash flow: loan principal repaidBalance sheet: total loan balances fall$91,500 → $77,500
Cash flow: owner distributionsBalance sheet: subtracted in equity (never an expense on the P&L)$30,000

The bakery earned $48,000 in 2025, yet its cash fell from $38,400 to $34,700. Operations brought in $66,300, but it spent $26,000 on kitchen equipment and a delivery van, repaid loan principal and paid its owners $30,000. Profit and cash are different things, and you need all three statements to see both.

Shortcut: save your balance sheet (with a prior-date column) and your P&L, then click Build from my balance sheet + P&L on the cash flow template. It calculates every operating, investing and financing line for you.

What banks and SBA lenders ask for

  • Three years of history plus a current interim statement. SBA's lending rules for 7(a) loans base repayment analysis, for existing businesses, on “the three most recent years of historical financial information (tax returns or balance sheet with debt schedule and income statement) plus an interim financial statement.” Interim financial statements “must be dated within 120 days of submission to SBA.” (SBA SOP 50 10 8.1, effective Oct. 1, 2026)
  • Balance sheet and P&L dated the same day. SBA's 7(a) submission checklist asks for a “Current Income Statement and Balance Sheet – (both must be dated as of the same date within 120 days of submission to SBA).” Set the balance sheet date and the P&L period end to the same date. (SBA 7(a) Loan Submission Checklist, May 2024)
  • Ratios lenders calculate. The SOP lists current ratio, debt to tangible net worth and debt service coverage among the benchmark ratios. Debt service coverage is EBITDA divided by required principal and interest payments on all business debt. Standard 7(a) loans need at least 1.15:1 and 7(a) Small Loans at least 1.10:1. The balance sheet and P&L templates calculate all three.
  • Projections for new businesses. The checklist asks for “Cash Flow Projections with supporting assumptions which reflect positive cash flow within two years” for all new businesses. SBA's business-plan guidance says that if a business is already established, the plan should include “income statements, balance sheets, and cash flow statements for the last three to five years.” (SBA: Plan your business)
  • A personal financial statement from owners. For 7(a) loans, SBA Form 413 is completed by each proprietor, general partner, LLC managing member, owner of 20% or more, and guarantor. That form is separate from the business statements on this page. (SBA Form 413)

Your lender decides the exact document list. SBA's 7(a) page notes the contents of a loan application “vary depending on the size of the loan and the lender's processing method.” Statements you prepare yourself are normally labeled unaudited. Use the footnote field to say so.

Frequently asked questions

What is a profit and loss statement?
A profit and loss statement (P&L), also called an income statement, shows revenue, costs and expenses for a period such as a month, quarter or year, and the profit or loss left at the bottom. IRS Publication 583 defines an income statement as one that "shows the income and expenses of the business for a given period of time."
Is there a free P&L template in Excel?
Yes. Fill in the template on this page and click "Download Excel (.xlsx)". The workbook has a live formula in every subtotal, margin and ratio, and yellow input cells. It works in annual, quarterly (Q1–Q4 plus total) or monthly (12 months plus total) layouts. "Blank Excel template" downloads the same layout with no amounts. No signup or email.
Should I use cash or accrual figures?
Use the same method as your books and tax return. Cash basis counts revenue when money comes in and expenses when you pay them. Accrual basis counts revenue when it's earned and expenses when they're incurred, even if unpaid. IRS Publication 538 explains both methods and who may use which. Lenders often prefer accrual statements because they match revenue with the costs of earning it, but many small businesses keep cash-basis books.
Are owner's draws an expense on the P&L?
No. For sole proprietors, partnerships and LLCs taxed as partnerships, draws and distributions come out of equity. They don't reduce profit. Wages paid to an S or C corporation owner-employee through payroll are an expense. Distributions or dividends on top of that are not.
Do loan payments go on the P&L?
Only the interest part. Principal repayments reduce the loan balance on the balance sheet and appear in the financing section of the cash flow statement. The template's DSCR ratio compares earnings with total loan payments (principal plus interest), which is how SBA lenders test repayment ability.
How should I record equipment purchases?
On the books, equipment is usually recorded as an asset on the balance sheet and expensed gradually through depreciation, the "Depreciation and amortization" line. For taxes, Section 179 or bonus depreciation may let you deduct much more in the first year. That's why profit on a tax-basis P&L can differ from a book-basis one. Note which basis you use in the footnote.
What income tax rate should I use?
Sole proprietorships, partnerships, most LLCs and S corporations usually pay no federal income tax at the business level. Owners pay it on their personal returns, so choose "None". C corporations pay federal tax at a flat 21% of taxable income (Form 1120 instructions, Schedule J), plus any state corporate tax. The estimate applies the rate to pre-tax income and never goes below zero. Your actual tax depends on taxable income, which can differ from book profit.
Can I use this P&L for my Schedule C?
Yes. Choose "IRS Schedule C (sole proprietor)" under Industry layout. The lines then follow the 2025 Schedule C: gross receipts (line 1), returns (line 2), cost of goods sold (Part III, lines 35–42), expenses (lines 8–27b) and business use of home (line 30). If you enter amounts the way Schedule C asks, such as only the deductible part of meals, net income matches line 31.
What's a good profit margin?
It depends heavily on the industry, so there's no single good number. The SEC's guide notes that "desirable ratios vary by industry." The most useful comparisons are your own trend (turn on the prior-year comparison or the monthly view) and industry figures from your lender or trade association. The template's % of net revenue column shows which costs are growing faster than sales.
Is my data stored or shared?
No. Figures are saved only in your browser's local storage so they're there when you return. Nothing is uploaded. Use Reset or clear your browser data to remove them.

Official Sources

Figures checked against these sources on 2026-10-03