How to Model Unit Economics for an Ottawa E-commerce Store
Table of Contents
- Why Revenue Growth Can Be Misleading
- The Core Unit Economics Formula
- Costs E-commerce Owners Commonly Miss
- CAC, LTV, and the Ratio Between Them
- How Ledgerive Helps Model Your Unit Economics
- Spreadsheet Guesswork vs a Built Model
- Key Metrics Your Model Should Surface
- Using Unit Economics to Decide When to Scale
- Frequently Asked Questions
- Conclusion
1. Why Revenue Growth Can Be Misleading
It's one of the most common traps in e-commerce: sales climb month over month, the bank balance looks healthy, and the founder feels confident scaling ad spend further. Then, at some point, cash gets tight even though revenue is at an all-time high. The usual culprit isn't fraud or bad luck — it's that nobody actually calculated whether each order was profitable once every real cost was included.
Unit economics answers a simple but uncomfortable question: if you strip away the noise of total revenue and total expenses, does a single sale make money or lose money? For an Ottawa store selling into a competitive market with rising shipping, ad, and platform costs, this question matters more than almost any other financial metric, because it determines whether growth makes the business stronger or simply accelerates a cash problem.
Building this model properly is exactly the kind of work our financial modeling services are built for — translating your store's real cost structure into numbers you can actually act on.
Not Sure If Your Orders Are Actually Profitable?
Get a free consultation on modeling your store's unit economics.
2. The Core Unit Economics Formula
At its simplest, unit economics starts with contribution margin — what's left from a single sale after subtracting the costs that scale directly with that sale:
| Line Item | What It Represents |
|---|---|
| Selling Price | What the customer pays for the item |
| Cost of Goods Sold (COGS) | Product cost, including landed cost if importing |
| Payment Processing Fees | Percentage and per-transaction fees charged by your payment provider |
| Shipping & Fulfillment Cost | Packaging, pick-and-pack labor, and carrier shipping cost per order |
| Marketplace or Platform Fees | Commission or listing fees if selling through a third-party marketplace |
| Contribution Margin | What remains after the above — the amount available to cover marketing and overhead |
Contribution margin is the number that matters most for scaling decisions, because it tells you how much room you actually have to spend on customer acquisition before a sale stops being worth making.
Ready to See Your Real Contribution Margin?
Let's build your store's unit economics model together.
3. Costs E-commerce Owners Commonly Miss
Ledgerive consistently sees the same cost categories left out of homemade unit economics spreadsheets:
| Cost Often Missed | Why It Gets Overlooked |
|---|---|
| Returns and refunds | Treated as a rare exception rather than a recurring cost of doing business |
| Payment processing fees | Small percentage per transaction that adds up unnoticed across volume |
| Packaging materials | Bought in bulk and rarely allocated back to individual orders |
| Software and app subscription costs | Fixed monthly fees not divided across order volume |
| Customer service and support labor | Time spent on pre- and post-sale support rarely tracked per order |
| Currency conversion and cross-border fees | Easy to miss when sourcing product internationally |
Where Homemade Unit Economics Models Go Wrong
Illustrative distribution based on common gaps observed in self-built e-commerce unit economics spreadsheets.
These gaps compound quickly, which is why unit economics work best when built alongside clean, current books. As covered in our guide on bookkeeping mistakes Brampton small businesses make, a model is only as reliable as the underlying data — costs that aren't tracked properly in your books can't be reflected accurately in a unit economics model either.
4. CAC, LTV, and the Ratio Between Them
Contribution margin tells you how much room you have to acquire a customer. Two more figures complete the picture:
- Customer Acquisition Cost (CAC) — total marketing and sales spend divided by the number of new customers acquired in that period
- Customer Lifetime Value (LTV) — the total contribution margin a customer generates across all their orders, not just the first one
- LTV-to-CAC Ratio — a widely used sanity check comparing how much a customer is worth against how much it costs to acquire them
A store that only looks at first-order profitability can wrongly conclude it's losing money on every customer, when in fact repeat purchases make the relationship profitable over time. Conversely, a store with high repeat-purchase assumptions but low actual retention can look healthier on paper than it really is. Modeling both first-order and lifetime economics side by side avoids both mistakes.
5. How Ledgerive Helps Model Your Unit Economics
Ledgerive builds unit economics models tailored to your store's product mix, fulfillment method, and acquisition channels. Core services include:
5.1 Order-Level Cost Modeling
Our financial modeling services build a complete picture of true cost per order, including the categories most spreadsheets miss.
5.2 CAC and LTV Analysis
We model acquisition cost against realistic lifetime value assumptions, grounded in your actual repeat purchase data.
5.3 Bookkeeping Foundation
Our bookkeeping services keep the underlying cost and revenue data accurate, so the model reflects reality rather than assumptions.
5.4 Fractional CFO Support for Scaling Decisions
Our Fractional CFO services help translate the model into real decisions about ad spend, pricing, and growth pacing.
5.5 Business Plan Support for Financing or Investment
Raising capital or seeking financing? Our business plan services build the narrative around a unit economics model that lenders and investors can trust.
Also read:
Business Plan Services for Franchise Owners in Oakville
Bookkeeping Mistakes Brampton Small Businesses Make
The Medical Clinics Bookkeeping Playbook for Ontario Owners
Fractional CFO vs Controller for a Mississauga Business
6. Spreadsheet Guesswork vs a Built Model
| Factor | DIY Spreadsheet | Professionally Built Model (Ledgerive) |
|---|---|---|
| Cost Completeness | Often misses returns, fees, and fixed cost allocation | Built to capture every real cost per order |
| CAC/LTV Accuracy | Estimated or ignored entirely | Grounded in actual acquisition and retention data |
| Scenario Testing | Rarely stress-tested against different ad spend levels | Modeled across multiple scaling scenarios |
| Decision Confidence | Guesswork dressed up as a spreadsheet | Numbers you can actually act on |
| Time Investment | Hours of owner time, often abandoned mid-build | Built efficiently by an experienced team |
For most Ottawa e-commerce owners, the value of a properly built model is avoiding the far more expensive mistake of scaling ad spend into a negative-margin product line.
7. Key Metrics Your Model Should Surface
| Metric | Why It Matters |
|---|---|
| Contribution Margin Per Order | Shows what's left to cover acquisition and overhead |
| Customer Acquisition Cost (CAC) | Tracks the true cost of winning a new customer |
| Customer Lifetime Value (LTV) | Reflects the full value of a customer relationship, not just one sale |
| Return/Refund Rate | A hidden cost that directly erodes margin if untracked |
| Break-Even Ad Spend Per Order | Shows the ceiling for acquisition spend before a sale becomes unprofitable |
| Repeat Purchase Rate | Drives how much of your LTV assumption is realistic versus optimistic |
8. Using Unit Economics to Decide When to Scale
A properly built unit economics model isn't just a diagnostic tool — it's a decision-making framework. Use it to:
- Set a maximum CAC based on contribution margin and target LTV-to-CAC ratio before increasing ad spend
- Identify which products or channels are actually profitable and worth scaling versus which are quietly losing money
- Model the cash flow impact of scaling, since growth often requires upfront inventory and ad spend before revenue catches up
- Test pricing changes against the model before rolling them out, to see the real margin impact
- Set guardrails for the team so marketing spend decisions are grounded in the same numbers finance is using
Without this framework, "scale it" and "kill it" decisions tend to be made on gut feel — which works until it doesn't.
Ready to Scale With Confidence?
Book a free discovery call with Ledgerive's team.
9. Frequently Asked Questions
1. What is unit economics in e-commerce?
Unit economics measures the profit or loss generated by a single order or customer once every relevant cost — product, shipping, fees, and acquisition — is accounted for, rather than looking only at total company-wide revenue and expenses.
2. What costs should be included in a unit economics model?
A thorough model typically includes cost of goods sold, payment processing fees, shipping and fulfillment costs, returns and refunds, marketplace fees where applicable, and customer acquisition cost.
3. What's a good LTV-to-CAC ratio for an e-commerce store?
There's no universal number that fits every business, since the right ratio depends on your margins, payback period tolerance, and growth stage — this is best evaluated against your specific model rather than a generic benchmark.
4. Why does my store look profitable in total but lose money on individual orders?
This often happens when fixed costs, returns, or acquisition spend aren't allocated down to the order level, masking unprofitable products or channels within an overall positive revenue picture.
5. How often should an e-commerce store update its unit economics model?
Many stores benefit from reviewing the model monthly, or whenever a major cost input changes — such as a shipping rate increase, a new ad platform, or a pricing change — since stale assumptions can lead to scaling decisions based on outdated numbers.
10. Conclusion
Revenue growth feels good, but it's not the number that tells an Ottawa e-commerce owner whether the business actually works. Unit economics — a clear, complete picture of profit or loss per order and per customer — is what separates confident scaling decisions from expensive guesswork. Building this model properly means capturing every real cost, not just the obvious ones, and pairing first-order economics with realistic lifetime value assumptions. Whether you're deciding how much to spend acquiring the next customer or trying to understand why cash feels tight despite strong sales, Ledgerive's financial modeling services are built to give Ottawa store owners numbers they can actually act on.
Start With a Free Unit Economics Consultation
Let Ledgerive's team help your Ottawa e-commerce store scale with confidence.