Introduction
Every business owner eventually asks the same question — "did we actually make money this month?" — and a profit and loss (P&L) statement is the one report built specifically to answer it. This guide gives you a complete, standard-structure template you can copy directly into Excel or Google Sheets, plus what every line actually means and how to read it once it's built.
Table of Contents
- What a P&L Statement Actually Shows
- The Complete Template Structure
- Revenue: What Actually Goes Here
- COGS vs. Operating Expenses: The Line That Confuses People
- A Worked Example
- Cash vs. Accrual: Which Basis to Use
- How to Actually Read It
- Connecting This to Your Accounting Software
- FAQ
- Conclusion
What a P&L Statement Actually Shows
A P&L statement (also called an income statement) shows a business's revenue, costs, and resulting profit or loss over a specific period — a month, a quarter, or a year. It's one of the three core financial statements every business needs, alongside the balance sheet and cash flow statement — but for most owners checking in on the business day to day, it's the one that gets read most often, since it directly answers "are we profitable."
The Complete Template Structure
Copy this structure directly into a spreadsheet:
| Line Item | Formula / Notes |
|---|---|
| Revenue | Total sales for the period |
| (−) Cost of Goods Sold (COGS) | Direct costs to produce what you sold |
| = Gross Profit | Revenue − COGS |
| (−) Operating Expenses | Rent, salaries, marketing, software, insurance, etc. |
| = Operating Income (EBIT) | Gross Profit − Operating Expenses |
| (−) Interest Expense | Loan interest, credit line interest |
| (−) Taxes | Income tax provision for the period |
| = Net Income | Operating Income − Interest − Taxes |
This structure holds regardless of business size — the difference between a solo consultant's P&L and a 50-person company's P&L is the level of detail within each section, not the overall shape.
Revenue: What Actually Goes Here
Revenue should reflect what was earned during the period (under accrual accounting) or collected (under cash accounting) — not what was invoiced if payment terms mean cash arrives later. For businesses with multiple income sources, break revenue into sub-lines before totaling:
- Product Sales
- Service Revenue
- Subscription/Recurring Revenue
- Other Income (interest earned, asset sales — kept separate from core operating revenue)
COGS vs. Operating Expenses: The Line That Confuses People
This is the single most common structural mistake in a DIY P&L: miscategorizing a cost as an operating expense when it should be COGS, or vice versa.
- COGS: costs directly tied to producing what you sold — materials, direct labor for production, manufacturing overhead, shipping the product to the customer
- Operating expenses: costs of running the business generally, regardless of sales volume — rent, administrative salaries, marketing, software subscriptions, insurance, professional fees
Why it matters: COGS is subtracted first to calculate gross profit — a genuinely important margin figure lenders and investors look at specifically. Miscategorizing a real COGS item as an operating expense inflates gross margin artificially, which can mislead pricing decisions built on that number.
A Worked Example
A service business with $80,000 in monthly revenue:
| Line Item | Amount |
|---|---|
| Revenue | $80,000 |
| (−) COGS (direct labor/delivery costs) | $28,000 |
| = Gross Profit | $52,000 (65% margin) |
| (−) Operating Expenses (rent, salaries, software, marketing) | $38,000 |
| = Operating Income | $14,000 |
| (−) Interest Expense | $800 |
| (−) Taxes (estimated) | $2,800 |
| = Net Income | $10,400 |
This business is genuinely profitable (13% net margin) — but the gap between the 65% gross margin and the 13% net margin shows exactly where the real cost pressure sits: operating expenses, not the core delivery cost. That's precisely the kind of insight a properly structured P&L surfaces that a single "profit" number alone wouldn't.
Cash vs. Accrual: Which Basis to Use
- Cash basis: revenue and expenses recorded when money actually moves — simpler, commonly used by smaller businesses, especially for tax purposes
- Accrual basis: revenue and expenses recorded when earned or incurred, regardless of payment timing — required for GAAP reporting, and generally expected by lenders and investors reviewing your financials
The template structure above works identically for either basis — the difference is purely in when a transaction gets recorded, not how the statement itself is organized.
How to Actually Read It
- Compare month over month, not just against a single period in isolation — a single month's P&L tells you less than a trend
- Watch gross margin stability — a shrinking gross margin over several months usually signals a pricing or direct-cost problem worth investigating before it compounds
- Separate one-time items from recurring ones — an unusual one-off expense (a legal settlement, a large one-time purchase) can distort a single month's net income; note it so trend comparisons stay meaningful
- Check operating expense ratio (operating expenses ÷ revenue) over time — rising steadily while revenue stays flat is an early signal worth addressing
Connecting This to Your Accounting Software
If you're on Zoho Books, QuickBooks, or Xero, a P&L report is generated automatically from your recorded transactions — you don't need to manually build one every month once your chart of accounts is set up correctly. The template above is most useful for: understanding what your software-generated report actually means, building a forecast/projection before transactions exist to pull from, or a quick manual sanity-check outside your main system.
FAQ
None — they're the same document, just different names for it. "Profit and loss statement" and "P&L" are more commonly used in casual business conversation; "income statement" is the more formal accounting term used in GAAP financial reporting. Both refer to the exact same structure and purpose.What's the difference between a P&L statement and an income statement?
Monthly, at minimum, for any business actively managing cash flow or tracking performance. Waiting until year-end to see your P&L means discovering a full year of problems (or a full year of missed opportunities) all at once, instead of catching and correcting trends within a month or two.How often should I prepare a P&L statement?
Gross profit is revenue minus the direct cost of producing what you sold (COGS) — it tells you the margin on the product or service itself, before considering overhead. Net income is what's left after subtracting all operating expenses, interest, and taxes too — the true bottom-line profitability of the entire business, not just the core offering.What's the difference between gross profit and net income on a P&L?
It depends on your accounting method. A cash-basis P&L records revenue and expenses when money actually changes hands; an accrual-basis P&L records them when earned or incurred, regardless of payment timing. Accrual generally gives a more accurate picture of performance for a given period, which is why most lenders, investors, and GAAP reporting require it — but many small businesses under a certain size use cash-basis for simplicity, particularly for tax purposes.Should my P&L be prepared on a cash or accrual basis?
Yes — add a sub-line under Revenue for each stream (e.g., Product Sales, Service Revenue, Subscription Revenue), then sum them into a single Total Revenue line before moving to COGS. The rest of the template structure stays the same; only the revenue section needs to be broken out.Can I use this P&L template if my business has multiple revenue streams?
It varies significantly by industry — a services business might reasonably target 15-25% net margin, while a restaurant might be healthy at 3-9%, and a retailer somewhere in between. Rather than chasing a universal benchmark, compare your own margin trend month over month, and against your specific industry's typical range, not a generic target.What's a healthy net profit margin for a small business?
For a printable version of these templates and more, see our free Chart of Accounts Template too — it's the foundation these categories should map back to.
Conclusion
A P&L statement is only as useful as the categorization discipline behind it — the template structure above is genuinely simple, but getting COGS and operating expenses sorted correctly, consistently, every month, is what actually makes gross margin and net margin numbers trustworthy enough to act on. Once that discipline is in place, this becomes the fastest report in your entire financial stack for answering the one question that matters most.
If you'd like help setting up a P&L that pulls automatically and accurately from your accounting software every month, get in touch for a free consultation.