How to use this profit and loss template
Start with the annual view for a quick statement, or switch the Columns setting to monthly for twelve columns plus a year-to-date total. The two views are stored separately, so you can keep a detailed monthly P&L and a simple annual one side by side. Rename any line, add rows inside a section, and delete lines you do not use. Gross profit, operating income, net income, and the three margins update as you type.
Download Excel produces a formatted statement in which every subtotal and margin is a formula. Add a row inside a section in Excel and the SUM ranges expand with it. The CSV is a flat export for Google Sheets or your accountant's import tool.
The sample data is a small design studio with $193,500 of annual revenue. Replace it with your own figures, or use the Reset button to restore it at any time.
What a profit and loss statement is
A profit and loss statement (also called an income statement) summarises revenue and expenses over a period and shows whether the business made or lost money. It is the report your tax preparer builds Schedule C from, the first thing a lender reads, and the fastest way to spot a pricing or cost problem.
Where a balance sheet is a snapshot of one day, a P&L is a film covering a month, a quarter, or a year. Net income at the bottom of the P&L flows into retained earnings on the balance sheet, which is how the two statements tie together.
Each line of the P&L, explained
The template follows the standard multi-step format, which separates the cost of what you sell from the cost of running the business.
Revenue
Money earned from your core activity before any costs: sales of products, service fees, retainers, subscriptions. Record it net of refunds and discounts. Sales tax you collect is not revenue; it is a liability until you remit it.
Cost of goods sold (COGS)
Costs that vary directly with what you sell. For a retailer, the wholesale cost of inventory sold. For a contractor, materials and subcontractor labour on jobs. For the design studio in the sample, contractor fees, project-specific software licences, and printing. If a cost would disappear when sales fall to zero, it is probably COGS.
Gross profit and gross margin
Gross profit = Revenue − COGS Gross margin = Gross profit ÷ Revenue
The studio earned $193,500 and spent $49,000 on COGS, for $144,500 of gross profit and a 74.7% gross margin. Gross margin tells you whether your core offering is priced sensibly. If it is thin, cutting overhead will not save you; you have a pricing or supplier problem.
Operating expenses
The costs of keeping the business open regardless of sales volume: rent, salaries, marketing, insurance, software subscriptions, professional fees, utilities, depreciation. Group them the way Schedule C does (see the tax section below) and you save yourself work in April.
Operating income and operating margin
Operating income = Gross profit − Operating expenses
$144,500 − $81,300 = $63,200, a 32.7% operating margin. Operating income (sometimes EBIT) shows how profitable the business is before financing and one-off items. It is the number buyers and lenders focus on because it reflects the operation itself.
Other income and expenses
Items outside normal operations: interest earned, interest paid on loans, gains or losses on selling equipment, grants. Keeping them separate stops a one-time insurance payout or a loan's interest from distorting your operating margin.
Net income and net margin
Net income = Operating income + Other income − Other expenses
$63,200 + $250 − $1,900 = $61,550, a 31.8% net margin. This is the profit that belongs to the owner and, for a sole proprietor, the figure that self-employment tax and income tax are based on.
Gross, operating, and net margin compared
| Margin | Formula | Studio example | What it diagnoses |
|---|---|---|---|
| Gross | Gross profit ÷ Revenue | 74.7% | Pricing and direct costs |
| Operating | Operating income ÷ Revenue | 32.7% | Overhead relative to sales |
| Net | Net income ÷ Revenue | 31.8% | Everything, including debt and one-offs |
Healthy gross margin but weak operating margin means overhead is too high for the volume of business. Weak gross margin with any overhead at all is usually fatal; fix pricing first. To benchmark a single product or job, use the profit margin calculator, which also shows the markup equivalent.
Cash basis vs. accrual basis
The P&L looks different depending on when you recognise revenue and expenses:
- Cash basis records revenue when the customer pays and expenses when you pay them. It is simpler and is what most sole proprietors use for taxes.
- Accrual basis records revenue when you earn it (send the invoice, deliver the work) and expenses when you incur them, regardless of payment. It matches costs to the sales they generated and gives a truer picture of a month's performance.
A business that invoices in December and gets paid in January shows that revenue in different years under the two methods. Pick one, note it on the statement, and stick with it; switching methods for tax purposes requires IRS consent (Form 3115). Businesses whose average annual gross receipts exceed the IRS small-business threshold ($31 million for 2025, adjusted for inflation each year) generally must use accrual; below it, even businesses that carry inventory can usually stay on the cash method (IRS Publication 334).
Reading trends with the monthly view
A single annual figure hides a lot. The twelve-column view exposes:
- Seasonality. The sample studio's revenue dips to $13,500 in January and peaks near $17,400 in June and October. Knowing that lets you build cash reserves before slow months rather than borrowing through them.
- Creeping overhead. Subscriptions, contractors, and marketing tend to grow one small decision at a time. A monthly operating-expense line that climbs while revenue is flat is the earliest warning you will get.
- Margin drift. If gross margin falls from 75% to 68% over six months, supplier costs or discounting have changed even if profit still looks fine in dollars.
- One-off distortions. An annual insurance premium or a big equipment repair lands in one month. Seeing it isolated stops you from over-reacting to a single bad month.
Compare each month to the same month last year rather than to the previous month when your business is seasonal.
Using the P&L for taxes: Schedule C mapping
For a sole proprietor or single-member LLC, Schedule C (Form 1040) is a standardised P&L. If your categories match its lines, tax prep is a copy exercise:
| P&L line | Schedule C line |
|---|---|
| Revenue | Line 1, Gross receipts or sales |
| Returns and refunds | Line 2 |
| Cost of goods sold | Line 4 (computed in Part III, lines 35–42) |
| Advertising and marketing | Line 8 |
| Vehicle expenses | Line 9 |
| Contract labor | Line 11 |
| Depreciation | Line 13 |
| Insurance | Line 15 |
| Loan interest | Line 16b |
| Legal and professional fees | Line 17 |
| Office expense | Line 18 |
| Rent | Line 20b (20a for equipment) |
| Supplies | Line 22 |
| Travel / meals | Lines 24a / 24b (meals 50%) |
| Utilities | Line 25 |
| Wages | Line 26 |
| Software, subscriptions, other | Line 27a, itemised in Part V |
| Net income | Line 31, Net profit or loss |
Net profit on line 31 flows to Schedule SE for self-employment tax and to Form 1040 for income tax. Estimate the combined bill with the self-employment tax calculator. Owner draws are not an expense and never appear on the P&L or Schedule C; they are equity transactions. The expense tracker template uses these same Schedule C categories, so its totals drop straight into the operating expense section here.
Partnerships and S corporations file Form 1065 or 1120-S instead, but the line structure is nearly identical.
Common P&L mistakes
- Counting loan proceeds as revenue or principal repayments as expenses. Only the interest belongs on the P&L. The principal is a balance sheet item.
- Putting equipment purchases in expenses. A $6,000 computer is an asset that is depreciated (or expensed under Section 179) rather than a $6,000 expense in the month you bought it.
- Recording owner draws as salary. For sole proprietors and partnerships, draws are equity, not payroll. Only S corp and C corp owners on W-2 payroll show salary as an expense.
- Mixing COGS and overhead. Putting rent in COGS inflates the apparent cost of each sale; putting materials in overhead hides a pricing problem. Ask "does this cost track sales volume?"
- Ignoring depreciation. Small businesses often skip it and overstate profit. Even a rough straight-line estimate is better than none.
- Forgetting sales tax and tips. Collected sales tax is a liability, not revenue. Tips passed through to staff are not your revenue either.
- Not reconciling to the bank. A P&L built from memory or a shoebox will not match your statements. Reconcile monthly so the year-end statement is trusted by your accountant and lender.
A P&L you update every month, even roughly, is worth far more than a perfect one assembled once a year under a filing deadline.