Profit and loss statement template: the format, a worked example, and how it ties to your balance sheet
By the BizDocs Studio team · Updated
- •A profit and loss statement (P&L, or income statement) lists revenue, then subtracts cost of goods sold, operating expenses and other expenses to reach net income for a period.
- •Standard order: net revenue, cost of goods sold, gross profit, operating expenses, operating income, other income and expense, income tax, net income. Show each line as a % of net revenue.
- •Lenders want the P&L next to a balance sheet and a prior-year comparison. Net income for the year is what links the two: it flows into equity.
- •If your balance sheet does not balance, the usual cause is something that changed cash but not profit: owner draws, loan principal, equipment purchases or inventory.
A profit and loss statement answers one question: did the business make money over a period, and where did it go. It is the first thing a lender, landlord or prospective partner asks for, usually alongside a balance sheet and last year's numbers for comparison.
This guide shows the standard P&L format, walks through a full year for a sample gift and home goods shop, and explains how the P&L connects to the balance sheet and the cash flow statement, which is where most free templates fall apart.
The standard profit and loss format
Every P&L follows the same order, whatever the business. Revenue comes first, costs are subtracted in layers, and each subtotal tells you something different.
| Line | What goes in it | What it tells you |
|---|---|---|
| Gross sales | Everything you sold, by product or service line | Demand |
| Less: returns and discounts | Refunds, coupons, employee and loyalty discounts | Leakage at the register |
| Net revenue | Gross sales minus returns | The base for every % on the statement |
| Cost of goods sold | Merchandise or materials you sold, freight-in, shrink | What the product itself cost |
| Gross profit | Net revenue minus cost of goods sold | Money left to run the business |
| Operating expenses | Wages, rent, utilities, insurance, marketing, card fees, depreciation | The cost of being open |
| Operating income | Gross profit minus operating expenses | Whether the business itself makes money |
| Other income and expense | Interest earned, interest paid, one-time items | Financing and unusual items |
| Net income | After other items and any income tax | The bottom line |
Sole proprietors, LLCs, partnerships and S corporations usually leave the income tax line empty because profit passes through to the owners' personal returns. C corporations record their own income tax. Ask your accountant which applies to you.
Worked example: a year at a small gift shop
The sample in our template is a gift and home goods shop with a small online store, on a fiscal year that runs July to June so the year closes after the holiday season. Here is its P&L for the year, with the prior year beside it.
| This year | % of revenue | Prior year | |
|---|---|---|---|
| Gross sales | $630,304 | 102.3% | $574,504 |
| Less: returns and discounts | $14,004 | 2.3% | $13,944 |
| Net revenue | $616,300 | 100.0% | $560,560 |
| Cost of goods sold | $296,566 | 48.1% | $274,122 |
| Gross profit | $319,734 | 51.9% | $286,438 |
| Operating expenses (incl. $9,632 depreciation) | $259,694 | 42.1% | $248,153 |
| Operating income | $60,040 | 9.7% | $38,285 |
| Net other income (expense), mostly loan interest | ($5,613) | (0.9%) | ($7,145) |
| Net income | $54,427 | 8.8% | $31,140 |
Revenue grew 9.9%, but net income grew 74.8%. Why: gross margin improved from 51.1% to 51.9%, and operating expenses grew only 4.7% because most of them (rent, wages, insurance) are fixed. That is operating leverage, and it shows up only when you put two years side by side.
Gross sales show as 102.3% because every percentage is measured against net revenue. That is normal.
How the P&L ties to the balance sheet
A P&L covers a period. A balance sheet is a snapshot on one day: what the business owns (assets), what it owes (liabilities), and the difference (equity). Assets always equal liabilities plus equity.
Net income is the bridge. Equity at the end of the year is equity at the start, plus net income, plus anything the owner put in, minus anything the owner took out. If you type equity in by hand, the balance sheet will drift out of balance the first month you forget a draw.
Equity at the start of the year: $91,930 ($25,000 member's capital + $66,930 retained earnings)
+ Net income from the P&L: $54,427
+ Member contribution in October: $5,000
- Member draws during the year: $48,500
= Equity at year end: $102,857
Total assets $208,291 = liabilities $105,434 + equity $102,857. Balanced.
Accumulated depreciation works the same way: last year's balance plus this year's depreciation expense from the P&L. Our template calculates both, so the only balance sheet numbers you type are the ones you can read off a statement: bank balances, receivables, inventory, loan balances, card balances, payables.
Monthly P&L, a balance sheet that balances, cash flow, ratios and break-even in one file.
Then the cash flow statement
Profit is not cash. The shop earned $54,427 but cash rose only $2,153. The statement of cash flows (indirect method) starts with net income and adjusts for everything that moved cash without touching profit.
| Section | Sample shop, year | What drives it |
|---|---|---|
| Operating activities | $58,993 | Net income, plus depreciation, plus or minus changes in receivables, inventory and payables |
| Investing activities | ($3,180) | New POS hardware |
| Financing activities | ($53,660) | Loan principal repaid, owner contribution, owner draws |
| Net change in cash | $2,153 | Cash went from $45,300 to $47,453, matching the balance sheet |
When the ending cash on this statement matches the balance sheet, you know the three statements are consistent. That check is the fastest way to catch a missing entry.
Break-even and a sales forecast from the same numbers
Once expenses are tagged fixed or variable, break-even is one formula: fixed costs divided by contribution margin %. The sample shop's fixed costs average $19,603 a month and variable costs (merchandise, card fees, shipping, bags) run 53.0% of revenue, so contribution margin is 47.0% and break-even is $41,708 a month.
Average monthly sales were $51,358, so the margin of safety is 18.8%. January ($30,534) and July and August fell below break-even, which is normal for a shop that earns its year in November and December. A sales forecast by product line, built on last year's months with a growth % per line, shows whether next year's slow months are covered.
Mistakes that make a P&L misleading
- Booking the whole loan payment as an expense. Only the interest belongs on the P&L. Principal reduces the loan on the balance sheet.
- Putting owner draws on the P&L. For sole proprietors and LLC members, draws are equity, not wages.
- Expensing a large equipment purchase in one month and also listing it as a fixed asset. Pick one, with your accountant's guidance, and record depreciation if you capitalize it.
- Using purchases instead of cost of goods sold. If you hold inventory, cost of goods sold is beginning inventory plus purchases minus ending inventory.
- Comparing a partial year with a full prior year. Compare the same months.
- Leaving returns and discounts buried in revenue. Show them so you can see the leakage.
- Handing a lender a P&L with no balance sheet. They will ask for both, plus a current interim statement.
Build it yourself, or start from ours
Any spreadsheet can hold a P&L. The hard part is keeping the P&L, balance sheet and cash flow statement tied together month after month. Our Profit & Loss, Balance Sheet & Break-Even workbook for Excel and Google Sheets does that: an editable chart of accounts, a 12-month P&L with prior-year comparison, a balance sheet whose equity is calculated and checked every month, an indirect cash flow statement, a one-page-each print set, key ratios, break-even and a sales forecast. It ships with the gift shop used in this guide so you can see every number before you enter yours.
Frequently asked questions
What is the difference between a P&L and a balance sheet?
A P&L shows revenue, expenses and profit over a period, such as a month or a year. A balance sheet shows what the business owns and owes on a single date. Net income from the P&L flows into equity on the balance sheet.
Should I use cash or accrual basis?
Many small businesses keep cash-basis books; lenders often prefer accrual because it matches costs to sales. Use whichever your bookkeeping uses and label it. On cash basis, leave receivables and payables off the balance sheet.
How often should I prepare a profit and loss statement?
Monthly. It takes a few minutes once your bookkeeping is current, and it lets you see a margin problem in weeks instead of at tax time.
What do lenders look for in a P&L?
Lenders typically ask for year-end statements for recent years plus a current interim P&L and balance sheet. They look at revenue trend, gross margin, whether profit covers loan payments, and ratios such as current ratio and debt-to-equity. Requirements vary by lender and loan program.
Is a P&L template enough for my taxes?
No. A P&L is a management and lending report. Your tax return has its own forms and rules. Give your accountant the statements, not the other way round.
This guide is general information for US small businesses, not legal advice. Rules vary by state and city; have a local attorney review contracts and notices before use.
Monthly P&L, a balance sheet that balances, cash flow, ratios and break-even in one file.