Financial X-ray: How to Assemble a P&L and Unit Economics from Scratch
A step-by-step plan for creating a P&L and calculating unit economics in a startup or small business.
Quick Introduction
A P&L (profit and loss statement) answers a simple question: "Are we making any money at all, or just moving money around beautifully?"
Unit economics answers another question: "Does one client/order/subscription pay for itself, or are we paying for the right to interact with them?"
Both tools are needed not for reporting, but for decisions:
- can we increase marketing;
- is it time to hire people;
- when will the business become profitable with the current model.
If you have a startup, small business, or pet project, you don't need a complex ERP. You need a minimal P&L + unit economics in one table.
Let's break down how to assemble this manually.
Key Principles of a Financial "X-ray"
- Calculate by periods—at least monthly, preferably monthly + cumulative from the beginning of the year.
- Separate variable and fixed costs, otherwise the margin turns into a mess.
- Look at the unit, not just the overall total. An overall plus can hide unprofitable products or segments.
- Numbers → decisions. Each block of the P&L should lead to the question "and what are we doing about this?"
- Simplicity is more important than perfect accuracy. A rough but honest P&L today is better than a polished one in six months.
Minimal P&L Template
Basic structure for a small business or startup:
- Revenue (broken down by products/tariffs/channels)
- Variable Costs (CAC, commissions, packaging, logistics, royalties)
- Gross Profit = Revenue - Variable Costs
- Fixed Costs (hosting, salaries, office, services, admin)
- Operating Profit = Gross Profit - Fixed Costs
Example P&L for a Month (hypothetical SaaS service)
Item | Formula | Comment | Value, ₽ |
|---|---|---|---|
| 1. Revenue | ARPU × number of paying customers | e.g., 1,000 ₽ per month × 300 clients | 300,000 |
Payment system commissions | Revenue × 3% | Acquiring, Stripe, YooKassa, etc. | 9,000 |
Variable support costs | 80 ₽ × 300 clients | Outsourced support by number of tickets | 24,000 |
| 2. Total Variable Costs | Sum of variable items | 33,000 | |
| 3. Gross Profit | Revenue - Variable Costs | What remains from turnover before fixed costs | 267,000 |
Salaries (fixed) | Payroll | Main team: full-time + mandatory taxes | 200,000 |
Hosting and infrastructure | Fixed or semi-variable part | Servers, CDN, third-party services | 40,000 |
Admin and other | Rent, accounting, lawyers, etc. | Can initially be combined into one line | 20,000 |
| 4. Total Fixed Costs | Sum of fixed items | 260,000 | |
| 5. Operating Profit | Gross Profit - Fixed Costs | Basic guide: is the business in the black or not | 7,000 |
Checklist: How to Assemble Your P&L from Scratch
-
Define the period: month (mandatory) + quarter/year (optional).
-
Gather all revenue and break it down by products/tariffs.
-
For each product, list the variable costs:
- commissions;
- packaging and delivery;
- partner bonuses;
- variable support/production.
-
Calculate the gross margin for each product and for the business as a whole.
-
Gather fixed costs:
- payroll;
- rent, communications, software;
- admin, lawyers, accounting.
-
Calculate the operating profit (or loss) for the period.
-
Look at the dynamics: compare with the previous month and the same month last year (if available).
Unit Metrics
Now let's move from the "big picture" to a single unit: a client, an order, a subscription.
Basic set:
- CAC (Customer Acquisition Cost) — cost of acquiring a customer.
- LTV (Lifetime Value) — revenue from a customer over their entire life in the product.
- Contribution margin — how much margin one unit brings.
- Payback period — in how many months (orders) the CAC is recovered.
Table of Key Unit Metrics
Metric | Formula | What it means |
|---|---|---|
| CAC | Marketing expenses / number of new clients | Cost to acquire one paying client on average for the period |
| ARPU / AOV | Revenue / number of clients or / number of orders | Average revenue per user (or order) |
| Variable cost per unit | Sum of variable costs per unit | All costs that grow with the number of orders / clients |
| Contribution margin | Price - Variable cost per unit | How much margin one unit brings before accounting for fixed costs |
| Contribution margin % | Contribution margin / Price | Unit margin in percent |
| LTV (simple model) | ARPU × average number of periods of customer life | How much money a client will bring over their entire relationship |
| LTV:CAC | LTV / CAC | Model efficiency ratio. Goal is more than 3x in a mature business |
| Payback | CAC / contribution margin per period | In how many periods (months / orders) the client acquisition is paid back |
Example: Subscription Service
Let's take a simple case to avoid arguing with Excel.
Conditions:
-
Subscription: 1,000 ₽ per month.
-
Average customer lifetime: 10 months.
-
Variable costs per client per month:
- support — 150 ₽;
- bank commission is 3% of payment = 30 ₽.
-
Marketing for the month: 150,000 ₽.
-
New paying clients for the month: 100.
Step 1. CAC
CAC = 150,000 / 100 = 1,500 ₽ per client.
Step 2. Contribution margin
- Revenue per client per month: 1,000 ₽.
- Variable costs per month: 150 + 30 = 180 ₽.
- Contribution margin per month: 1,000 - 180 = 820 ₽.
- Contribution margin %: 820 / 1,000 = 82%.
Step 3. LTV (simple model)
- ARPU (per month): 1,000 ₽.
- Average lifetime: 10 months.
LTV = 1,000 × 10 = 10,000 ₽.
More accurate models with retention curves can be used, but this is sufficient to start.
Step 4. LTV:CAC and Payback Period
- LTV:CAC = 10,000 / 1,500 ≈ 6.7 — the model is healthy.
- Payback period = CAC / contribution margin per month = 1,500 / 820 ≈ 1.8 months.
So the client pays for themselves in about 2 months, after which it's pure margin to cover fixed costs and profit.
Manual Unit Economics Calculator (plug in your numbers)
Below is a simple "paper" calculator that you can transfer directly to your spreadsheet:
Parameter | Your Data | Hint |
|---|---|---|
Unit Price (Price) | … ₽ | Average check or monthly subscription |
Variable cost per unit | … ₽ | Cost of goods sold, commission, logistics, bonuses |
| Contribution margin | = Price - Variable cost | How much margin one unit gives |
How to Link P&L and Unit Economics
It's important not to consider these things separately.
-
Gross profit from the P&L should be the sum of contribution margins from all units. If it doesn't add up, variable and fixed costs are mixed somewhere.
-
Unit model says the business is "kinda ok," but P&L is in the red—it means:
- fixed costs are too high;
- or the scale is still too small (underloaded).
-
P&L is positive, but unit economics are negative—most often:
- you're living on old or "cheap" clients;
- new clients are acquired at a loss, but their share is still small.
A useful rule:
Look at the P&L once a month, re-check unit economics by segments once a quarter.
Conclusion: What to Remember
-
P&L is a full business x-ray: revenue, expenses, margin, profit.
-
Unit economics is an x-ray of a single deal/client.
-
Start with a minimal structure: revenue, variable, fixed, margin.
-
Apply the manual unit economics calculator and check:
- does the client pay for themselves;
- does CAC not "eat up" all the margin;
- is the payback period adequate.
-
Don't try to build a perfect financial model right away. First—an honest draft, then iterations.
Think about how these templates apply to your current project: where can you already calculate unit economics, and where is even the P&L not being assembled yet. This is usually where the most expensive surprises are hidden.