P&L STUDIO/BLOG/PL-REPORT-GUIDE
Accounting16 min read

How to build a P&L: data, structure and common mistakes

Step-by-step walkthrough — from source data to a ready P&L statement: structure, worked example and 8 typical mistakes to avoid.

P&L (Profit & Loss) — the profit and loss statement — is one of the three core financial reports alongside the balance sheet and Cash Flow. But while the balance sheet and Cash Flow in small businesses often stay "with the accountant", P&L is the document the owner should read every month and understand without a translator.

The problem is that most owners either rely on an accounting P&L that doesn't answer management questions, or build their own report intuitively — and make mistakes that distort the picture.

In this article — a step-by-step explanation: what data you need, how to assemble a P&L correctly, where mistakes happen most often and how to avoid them.

What P&L is and how it differs from Cash Flow

Before assembling a P&L, it's important to understand what it measures — and what it doesn't.

P&L shows: how much the business earned and spent in a given period. It's a report on economic activity, not on the movement of money.

P&L does not show: how much money actually arrived in the account and where it is now. That's what Cash Flow is for.

The difference is critical. A client ordered a $5,000 service and signed the acceptance act but hasn't paid yet. In the P&L this revenue is already there (if you use accrual accounting). In Cash Flow — not until the money arrives.

That's why a business can show a profit in P&L and at the same time have an empty account. And vice versa — receive a large prepayment that isn't revenue in P&L until the service is delivered.

Understanding this difference is the foundation for building and reading the report correctly.

Accrual vs cash method

The first decision when building a P&L — which method to use to recognise revenue and expenses.

Cash method: revenue is recognised when the money is received. Expense — when the money is paid. Simple to record, but distorts the real picture with payment delays or prepayments.

Accrual method: revenue is recognised when the service is delivered or the goods shipped (regardless of payment). Expense — when it is incurred (regardless of whether the invoice has been paid). More accurate, but requires tracking receivables and payables.

For a management P&L, the accrual method is recommended. It gives a realistic picture of profitability for the period — without distortions from payment delays.

Leave the cash method for Cash Flow, where the actual inflow and outflow of money is what matters.

What data you need to assemble a P&L

Before building the table, collect the source data. Here is the full list with a note on where to get it.

Revenue

What you need: the full list of all goods and services sold in the period — with amount, date and client.

Where to get it:

  • Issued invoices or signed acceptance acts (for accrual)
  • Bank receipts (for cash method)
  • CRM or POS data (for retail)
  • Shipping documents

What to account for: returns and discounts. If a client returned goods or received a discount after the deal was closed — revenue needs to be adjusted. In the report this is shown either as a negative line in revenue ("returns"), or immediately reduces the revenue amount.

Cost of Goods Sold (COGS)

What you need: direct costs tied to producing or delivering the service.

Where to get it:

  • Supplier invoices for goods or materials purchased
  • Payroll for production staff or delivery specialists
  • Contractor invoices tied to specific projects
  • Cost of hosting, licences and infrastructure serving clients (for SaaS or digital services)

Important nuance: in manufacturing and trade, COGS includes not the cost of all materials purchased, but only the cost of those used for the products actually sold. If you bought $7,500 in materials but used only $5,500 (the rest on the shelf) — COGS is $5,500.

Operating Expenses (OpEx)

What you need: all expenses related to the business's activity but not included in COGS.

Where to get it:

  • Bank statement (regular payments: rent, subscriptions, utilities)
  • Payroll (administrative and sales staff salaries)
  • Service provider invoices (marketing, legal, accounting)
  • Expense reports (corporate card spend and travel)

Typical OpEx categories:

  • Personnel (salary + payroll taxes for admin, sales, marketing)
  • Marketing and advertising (budgets, agency fees, tools)
  • Rent and utilities
  • IT and software
  • Legal and accounting
  • Bank fees and commissions
  • Other administrative

Depreciation and amortisation

What you need: monthly charges on fixed assets — equipment, vehicles, intangible assets.

Where to get it: the depreciation schedule from the accounting system or a custom table (asset cost / useful life in months).

For a small-business management P&L, depreciation is often separated out at the EBITDA level and counted separately — to see operating profit both before and after its impact.

Financial income and expenses

What you need: interest on loans and deposits, FX differences.

Where to get it: bank statements, loan agreements (payment schedule), FX difference calculation (more details in our article on multi-currency accounting).

P&L structure: step by step

Once the data is collected, we build the report. Here is the standard structure of a management P&L with an explanation of each line.

Revenue
  – Cost of Goods Sold (COGS)
= Gross Profit
  Gross margin, % = Gross Profit / Revenue × 100

  – Operating Expenses (OpEx)
      Personnel (non-COGS)
      Marketing and advertising
      Rent and infrastructure
      IT and subscriptions
      Administrative expenses
= EBITDA
  EBITDA margin, % = EBITDA / Revenue × 100

  – Depreciation and amortisation (D&A)
= EBIT (operating profit)

  – Financial expenses (interest on loans)
  + Financial income (interest on deposits)
  ± FX differences
= EBT (earnings before tax)

  – Corporate income tax / single tax
= Net Profit
  Net margin, % = Net Profit / Revenue × 100

Three key profit levels worth tracking every month:

Gross Profit — shows the profitability of the product or service before company overhead. If gross margin is low — the problem is in pricing or cost of goods.

EBITDA — shows operating efficiency without the impact of financial structure and accounting policy. This is the metric compared between companies and used for business valuation.

Net Profit — the final result after all costs and taxes. This is what stays with the owner.

Practical example: consulting company P&L

Let's work through concrete numbers. A company delivers B2B services, headcount of 8, two lines of business: strategic consulting and training programmes.

LineConsultingTrainingTotal
Revenue$13,000$7,000$20,000
COGS (consultant salary)$5,250$1,750$7,000
COGS (materials, platforms)$300$950$1,250
Gross Profit$7,450$4,300$11,750
Gross margin57%61%59%
Admin and sales salary$3,625
Marketing$875$1,050$1,925
Office rent$700
IT and subscriptions$350
Other administrative$450
EBITDA$4,700
EBITDA margin24%
Depreciation$200
EBIT$4,500
Interest on loans$300
EBT$4,200
Single tax (5%)$210
Net Profit$3,990
Net margin20%

The report shows straight away: the training line has a higher gross margin (61% vs 57%) even though its revenue is smaller. At scale, the training business is potentially more efficient — and this information lets you make a strategic decision about priorities.

Common mistakes when building a P&L

Mistake 1. Confusing COGS and OpEx

The most frequent and most impactful mistake. If costs that should sit in COGS end up in OpEx — gross margin looks inflated. If OpEx ends up in COGS — the opposite.

Rule of thumb: COGS is a cost that would not have arisen without this specific sale or project. A developer's salary writing code for a specific client — COGS. The same developer's salary maintaining internal tools — OpEx.

Check your P&L: are all lines in COGS truly direct costs of delivery? Are there costs sitting in OpEx that should be in COGS?

Mistake 2. Not including the owner's salary or dividends

The owner "doesn't take a salary" — and there's no expense for them in the P&L. Result: the report shows a profit that doesn't really exist, because it's subsidised by the owner's free labour.

For a management P&L, always include the market value of the owner's role as an expense. If you had to hire someone tomorrow — how much would they cost? That amount belongs on the "Salary" line.

Mistake 3. Mixing recognition methods

One month you recognise revenue on accrual, the next on cash (because of a large prepayment). Result: numbers are incomparable and month-to-month dynamics don't reflect reality.

Pick one method and apply it consistently. If you migrate from cash to accrual — do it at the start of a new financial year and lock it into your accounting policy.

Mistake 4. Not adjusting revenue for returns and discounts

The client returned $750 in goods — but the report's revenue isn't adjusted. P&L shows a higher profit than the reality.

Returns and retroactive discounts should either reduce the revenue line they belong to, or appear as a separate negative line in the revenue block.

Mistake 5. Missing costs of the reporting period

A December contractor invoice arrives in January. The accountant books it in January. In the December P&L this cost is missing — and December looks more profitable than it was.

Under the accrual method, an expense is recognised in the month it belongs to, regardless of the invoice or payment date. Service delivered in December — expense in December.

In practice: at the end of every month run a "tail check" — are all known expenses where the service has been delivered but the invoice hasn't arrived yet accrued as liabilities?

Mistake 6. Putting transfers between accounts into the P&L

Moving money from a current account to a deposit, or between accounts of different legal entities in the group — is neither revenue nor expense. It's a movement of assets inside the business. But sometimes such operations end up in the P&L by mistake and distort the result.

Simple rule: if the total assets and liabilities didn't change as a result of the operation — it doesn't belong in the P&L.

Mistake 7. Looking only at absolute numbers without percentages

Profit grew from $2,000 to $3,000 — good news. But if revenue also grew from $10,000 to $17,500 — margin fell from 20% to 17%. Efficiency dropped despite the higher absolute profit.

Always track three margin metrics as percentages: gross margin, EBITDA margin, net margin. Their dynamics show whether the business is becoming more efficient as it grows.

Mistake 8. Aggregated P&L without a split by line

If you have more than one product, line of business or sales channel — a single aggregated P&L hides the real picture. One line may be subsidising another and you don't know it.

The minimum split: revenue and gross profit by line separately. The aggregated P&L stays, but next to it — a matrix by lines. That matrix is what gives you information for strategic decisions.

How to check that the P&L is done right

A few control checks that help catch mistakes before the report reaches the owner's desk.

Check 1. Consistency with the bank statement. The difference between total bank receipts and P&L revenue must be explained by receivables and prepayments. If the difference isn't explained — there's an accounting error.

Check 2. Comparison with the previous month. Sharp swings (margin jumped or dropped by more than 5 pp without an obvious cause) — a signal to check expense classification or data completeness.

Check 3. Sum of expenses by category. The total of all COGS + OpEx + D&A + financial expenses + taxes must equal the difference between revenue and net profit. If it doesn't — a line is missing or doubled.

Check 4. Documents behind every line. Pick 5–10 random expense lines. Is there a supporting document (invoice, act, statement) for each? Any "no-document" lines — clarify their origin.

How often to build a P&L and what to do with it

P&L is a monthly document. Closing the month and building the report should happen no later than the 5th of the following month. If the report is ready on the 15th — the data has already lost some of its operational value.

What to do with the report once it's built:

Compare against plan (if you have a budget). Which lines materially deviated? Which deviations require action and which just an explanation?

Compare with the previous month and with the same month last year (if available). Are there trends — positive or worrying?

Watch margins. If gross margin dropped — is the cause pricing, sales mix (more low-margin sales) or rising cost of goods?

Identify one or two questions that need a decision. P&L isn't just an archive report. It should lead to a specific management decision or at least to questions worth investigating.

Free P&L template

To avoid building the structure from scratch, we've prepared a ready-made management P&L template in Google Sheets. It includes:

  • Monthly P&L with a split by business lines and by total costs
  • Automatic calculation of gross margin, EBITDA and net margin as percentages
  • Plan/actual comparison and month-over-month dynamics
  • Hints on cost classification (what belongs in COGS, what in OpEx)
  • Protection against typical formula mistakes

Drop in your numbers — get a ready management report.

👉 Download the free P&L template →

Other articles in the series: «How to build a P&L that actually helps you make decisions», «Cash Flow without gaps: 3 rules of a payment calendar», «Financial model for investors: what they actually read in your Excel».

Want to go beyond preparing a P&L and learn how to turn reports into management decisions? Explore the “Read the report. Make the decision.” course. If you need a reporting system designed around your business, see PnL Studio's management accounting and financial modelling services.

Share:
Related service

Management accounting

P&L, accounting policy, expense control and reporting that helps owners make decisions.

Keep reading

Related insights

Ready to get your finances in order?

A 30-minute call — and you'll leave with an action plan for your finance function.

Book a consultation