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.
- Excel with live formulas
- 12-month, quarterly or annual
- Prior-year comparison
- 9 industry layouts incl. Schedule C
- Margins, EBITDA, DSCR
- No signup
| 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.1Debt service coverage (DSCR)
- FY 2025
- —
- FY 2024
- —
EBITDA ÷ loan payments (principal + interest) for the same period
Source: SBA SOP 50 10 8.1Operating 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
- 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.
- 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.
- 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).
- 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.
- 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.
- Income taxes. Choose your business type. Pass-through businesses usually show none. C corporations can estimate tax at a rate or enter it.
- 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.
FY 2025 ended Dec 31 | FY 2024 ended Dec 31 | |||
|---|---|---|---|---|
| Revenue | ||||
| Retail bakery and café sales | 412,000 | 368,000 | ||
| Wholesale and catering | 96,000 | 74,000 | ||
| Less: Returns, discounts and comps | (3,500) | (3,000) | ||
| Net revenue | 504,500 | 439,000 | ||
| Cost of goods sold | ||||
| Ingredients | 128,000 | 113,000 | ||
| Packaging | 14,500 | 12,800 | ||
| Production wages (bakers) | 72,000 | 64,000 | ||
| Total cost of goods sold | 214,500 | 189,800 | ||
| Gross profit | 290,000 | 249,200 | ||
| Operating expenses | ||||
| Salaries and wages (counter and admin) | 88,000 | 79,000 | ||
| Payroll taxes and benefits | 21,500 | 19,200 | ||
| Rent | 54,000 | 52,000 | ||
| Utilities and phone | 14,200 | 13,100 | ||
| Insurance | 6,400 | 6,000 | ||
| Advertising and marketing | 9,800 | 8,500 | ||
| Card processing and bank fees | 11,300 | 9,900 | ||
| Repairs and maintenance | 5,200 | 4,100 | ||
| Professional fees (accounting, legal) | 4,800 | 4,500 | ||
| Office, software and supplies | 3,100 | 2,900 | ||
| Depreciation and amortization | 18,000 | 16,000 | ||
| Total operating expenses | 236,300 | 215,200 | ||
| Operating income (loss) | 53,700 | 34,000 | ||
| Other income | ||||
| Interest income | 300 | 200 | ||
| Total other income | 300 | 200 | ||
| Other expenses | ||||
| Interest expense | 6,000 | 6,800 | ||
| Total other expenses | 6,000 | 6,800 | ||
| Net income (loss) | 48,000 | 27,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:
| Figure | Shows up in | Example |
|---|---|---|
| P&L: net income | Cash flow: first line of operating activities | $48,000 |
| P&L: net income | Balance sheet: equity (current-period net income) | $48,000 |
| P&L: depreciation | Cash flow: added back (non-cash). Balance sheet: accumulated depreciation rises by the same amount | $18,000 |
| Cash flow: ending cash | Balance sheet: cash and cash equivalents | $34,700 |
| Cash flow: loan principal repaid | Balance sheet: total loan balances fall | $91,500 → $77,500 |
| Cash flow: owner distributions | Balance 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?
Is there a free P&L template in Excel?
Should I use cash or accrual figures?
Are owner's draws an expense on the P&L?
Do loan payments go on the P&L?
How should I record equipment purchases?
What income tax rate should I use?
Can I use this P&L for my Schedule C?
What's a good profit margin?
Is my data stored or shared?
Official Sources
Figures checked against these sources on 2026-10-03- SEC: Beginners' Guide to Financial Statements — assets = liabilities + equity; the three cash flow sections; ratio definitions
- IRS Publication 583, Starting a Business and Keeping Records — income statements, balance sheets and supporting records
- IRS: How long should I keep records? — 3, 6, 7 years or indefinitely depending on the situation
- SBA SOP 50 10 8.1 (effective Oct. 1, 2026) — historical statements, 120-day interim rule, ratio benchmarks, debt service coverage
- SBA 7(a) Loan Submission Checklist (May 2024) — same-date income statement and balance sheet; projections for new businesses
- SBA: Plan your business (financial projections) — 3 to 5 years of statements for established businesses
- SBA Form 413, Personal Financial Statement — form version 05-24, OMB expiration 08/31/2027
- SCORE Financial Management Workbook — current, quick and debt-to-equity ratio guidance (pp. 53–54)
- IRS Schedule C (Form 1040), 2025 — line numbers used by the Schedule C layout
- IRS Instructions for Form 1120 (2025) — Schedule J: taxable income × 21%
- IRS Publication 538, Accounting Periods and Methods — cash vs. accrual method
Related Resources on This Site
Related by industry
Helpful guides
- SOC 2SOC 2 compliance guide for small business
- CertificationHUBZone certification guide
- Workers' Compworkers compensation insurance by state
- General Liabilitygeneral liability insurance