How a small business can prepare a profit and loss statement (PnL): which lines it includes, how to fill in a monthly template, a sample calculation, and mistakes that make the profit in the report differ from reality.
KelyanMedia editorial team · Updated November 13, 2026

PnL (profit and loss), or a profit and loss statement, shows how much a business earned over a period after all expenses. It is a management report for the owner: it answers whether the business makes a profit and where that profit is lost.
Money in the account and profit often do not match. A client may pay later, and a large equipment purchase does not mean the month was a loss. PnL helps you separate these things.
In short: what you need to know
- EssenceRevenue minus all expenses for the period equals profit. The report goes from top to bottom: from revenue to net profit.
- PeriodFor a small business, it is convenient to prepare a PnL once a month and compare months with each other.
- DifferencePnL shows earnings, while the movement of money through your accounts is tracked in a separate cash flow statement.
What lines make up a PnL
There are only a few lines. The key is that each expense goes into the same line every month, otherwise months cannot be compared.
| Line | What it includes | What it shows |
|---|---|---|
| Revenue | Sales of goods and services for the month | How much the business sold |
| Cost of goods sold | Purchase of goods sold, materials, piece-rate pay for production | How much the goods sold cost |
| Gross profit | Revenue minus cost of goods sold | How much of sales is left to cover other expenses |
| Operating expenses | Salaries, rent, advertising, communications, services, delivery | How much it costs to run the business |
| Operating profit | Gross profit minus operating expenses | Whether the core business is making money |
| Interest and taxes | Loan interest, taxes on profit or income | Mandatory payments beyond running the business |
| Net profit | Everything that is left | Month result for the owner |
← Swipe to scroll the table →
How to fill in the report for a month
A spreadsheet is enough to start: rows from the list above, columns by month.
- Choose a period and a rule: record revenue in the month when the goods were delivered or the service was provided, even if payment comes later.
- Collect sales for the month from the cash register, CRM, or accounting software.
- Calculate the cost only of the goods that were sold, not of everything purchased.
- Split expenses into lines: salaries, rent, advertising, other. Add new types of expenses as a separate line, not under "other".
- Spread large purchases that last several years, such as equipment, across the months of their service life.
- Calculate subtotals and net profit, then each line's share of revenue.
- Compare with the previous month: which line grew faster than revenue.
To understand where the revenue in the first line comes from, it helps to break down sales by channel and manager. We cover this in the article sales analytics: which numbers to check every week.
Sample PnL for a small business
The numbers are notional and chosen for easy calculation. They do not reflect the typical profitability of any industry.
| Line | Amount, notional units | Share of revenue |
|---|---|---|
| Revenue | 1 000 | 100% |
| Cost of goods sold | 400 | 40% |
| Gross profit | 600 | 60% |
| Salaries | 250 | 25% |
| Rent | 80 | 8% |
| Advertising | 70 | 7% |
| Other expenses | 50 | 5% |
| Operating profit | 150 | 15% |
| Loan interest | 10 | 1% |
| Taxes (the amount comes from your accountant) | 20 | 2% |
| Net profit | 120 | 12% |
← Swipe to scroll the table →
This example shows where to look next: if revenue grows next month and advertising takes a noticeably larger share, profit may not grow along with sales.
Common mistakes in the report
Typical mistakes happen when money movements that are not income or expenses end up in the report.
- a loan repayment is recorded as an expense: only the interest goes into the PnL, not the debt itself;
- money the owner took out is recorded as a business expense;
- the entire stock purchase is written off in the month of purchase;
- a prepayment for next month is recorded as revenue for the current month;
- personal and business expenses are mixed on one card;
- lines are named differently in different months, so the comparison loses its meaning.
Important
In this article, PnL is described as a management report for the owner. It does not replace official accounting and tax reporting. Check accounting procedures, taxes, and mandatory forms with your accountant.
FAQ
How is a PnL different from a cash flow statement?
Can you keep a PnL in an ordinary spreadsheet?
How often should you prepare the report?
Next steps
Want to build reports without merging spreadsheets by hand: see IT optimisation for business.
You see that advertising is eating your profit: learn about integrated online marketing.
Still have questions: call +998 33 339 33 34.
Discuss report automation →
