Home/Blog/Profit and Loss Statement Template
Accounting

Profit and Loss Statement Template: How to Build and Read Your P&L

P&L Structure, Sample P&L Table, and Key Ratios from the P&L

Profit and Loss Statement Template: P&L Structure, Sample P&L Table, Key Ratios from the P&L, Common

The profit and loss statement is the one report almost every business produces, and it is frequently structured in a way that tells nobody anything.

The usual fault is a single flat list of costs. Without direct costs separated from overheads there is no gross margin, and without gross margin there is no way to see whether the underlying model works.

This covers how the statement should be structured, a worked example, the ratios worth reading from it, how the lines differ by type of business, monthly against annual views, and where it misleads.

The profit and loss statement (P&L), also called the income statement, summarises your business's revenue and expenses over a period. It tells you whether the business is profitable and where money is being made or lost.

P&L Structure

Revenue minus COGS equals Gross Profit. Gross Profit minus Operating Expenses equals Operating Income. Add/subtract Other Income and Expenses to get Net Income Before Tax. Subtract income tax to get Net Income.

A statement that lists every cost as one operating block cannot tell you anything. Split direct costs from overheads first. Gross margin is the figure that shows whether the model works, and it disappears in a flat list.

Abhinav Gupta, CPA, CA, MBA · LinkedIn

Sample P&L Table

Line ItemAnnual ($)% of Revenue
REVENUE
Product / Service Revenue1,200,000100%
Less: Returns and Allowances(20,000)-1.7%
Net Revenue1,180,00098.3%
COST OF GOODS SOLD
Direct Materials(280,000)-23.7%
Direct Labour(120,000)-10.2%
Total COGS(400,000)-33.9%
GROSS PROFIT780,00066.1%
OPERATING EXPENSES
Salaries and Wages(320,000)-27.1%
Rent and Occupancy(60,000)-5.1%
Marketing and Advertising(80,000)-6.8%
Technology / Software(24,000)-2.0%
Professional Services(18,000)-1.5%
Other Operating Expenses(18,000)-1.5%
Total Operating Expenses(520,000)-44.1%
EBITDA260,00022.0%
Depreciation and Amortisation(30,000)-2.5%
OPERATING INCOME (EBIT)230,00019.5%
Interest Expense(15,000)-1.3%
NET INCOME BEFORE TAX215,00018.2%
Income Tax (25%)(53,750)-4.6%
NET INCOME161,25013.7%
Profit and Loss Statement Template: P&L Structure, Sample P&L Table, Key Ratios from the P&L, Common
Profit and Loss Statement Template: How to Build and Read Your P&L

Key Ratios from the P&L

RatioFormula
Gross Margin %Gross Profit / Net Revenue
Operating Margin % (EBIT Margin)Operating Income / Net Revenue
EBITDA Margin %EBITDA / Net Revenue
Net Profit Margin %Net Income / Net Revenue

Common Line Items by Business Type

Business TypeKey COGS Items
Product / ManufacturingRaw materials, direct labour, factory overhead
SaaS / SoftwareHosting, support, third-party API costs, onboarding
Professional ServicesDirect labour (staff time on client work), subcontractors
RetailCost of merchandise, inbound freight, shrinkage
Restaurant / FoodFood and beverage cost, direct kitchen labour

Monthly vs Annual P&L

A monthly P&L reveals seasonal patterns and month-over-month trends. An annual P&L gives the full-year picture for tax filing, investor reporting, and year-over-year comparison. Build both in your accounting software.

Pro Tip: In QuickBooks Online, run Profit and Loss > set date range > compare to prior period. This gives you current month, prior month, and variance in one view.

Where a Profit and Loss Statement Misleads

A completed template can be arithmetically perfect and still give the wrong impression, and three causes account for most of it. Knowing them makes the difference between reading the statement and trusting it.

Cut-off is the first. Revenue recorded in the wrong month, or a cost that arrived late and landed in the following one, moves profit between periods without anything real changing. It corrects itself over a year, which is exactly why it is dangerous: the month you are looking at is wrong and the annual figure is right, so nobody notices.

Owner costs are the second. In an owner-managed business the profit figure depends heavily on what the owner chose to take and how, and a statement showing a low salary is showing a cost the business would have to pay somebody else. Anyone valuing the business will add it back, so it is better to see it. The third is one-off items sitting in ordinary lines, where a single large recovery or write-off makes a month look like a trend.

  • Read three months together rather than one, which removes most cut-off noise without any extra work
  • Show owner remuneration on its own line, at a rate you would have to pay a replacement
  • Pull genuinely exceptional items out into their own line rather than leaving them to distort a category
  • Check the largest three movements against last month every time, since that is where an error will be if there is one
Talk to a bookkeeperWant Books You Can Rely On?

Book a free consultation and we will get the numbers straight.

Book a free consultation

Frequently Asked Questions

What is the difference between gross profit and net profit?

Gross profit is revenue minus cost of goods sold, it measures production efficiency. Net profit (net income) is what remains after all expenses, interest, and taxes, it is the true bottom line.

Where can I get a free P&L template?

QuickBooks, Xero, and Wave all generate P&L reports automatically from your accounting data. For a standalone template, SCORE (score.org) offers free Excel P&L templates for small businesses.

How often should I review my P&L?

Monthly at minimum. Review gross margin trend (are input costs rising?), operating expense ratio (is overhead growing faster than revenue?), and net margin trend. Flag any category that changes more than 10% month-over-month.

How should the template change as the business grows?

It should gain detail where decisions are made and nowhere else. The usual progression is to split revenue by line or channel once you have more than one, then to separate the direct costs that move with each, then to break out the overheads large enough to argue about. What does not help is a chart of accounts with hundreds of lines nobody reads, which makes the statement longer without making it more useful.

Should the template show comparatives, and against what?

Yes, and against two things: the same period last year, and the budget or forecast. Last year tells you whether the business is moving. Budget tells you whether it is moving the way you planned, which is a different question and usually the more actionable one. A statement showing this month alone gives you a number with nothing to measure it against, and it is the comparison rather than the figure that prompts a decision.

Abhinav Gupta

Written by

Abhinav Gupta, CPA, CA, MBA

Abhinav works with business owners across the US on industry-specific bookkeeping, from dental practices and restaurants to construction and e-commerce. He writes about what each trade's books actually need. Connect on LinkedIn

Share this article

Free consultation

Want Books You Can Rely On?

Book a free consultation and we will get the numbers straight.

Reply within one business day A real accountant reads it No obligation