Most ecommerce operators I talk to know their revenue number cold. They can tell you yesterday's sales, last month's top SKU, and their best-performing ad campaign. But ask them what their true cost per order is — including packaging, merchant fees, returns, and that Shopify app subscription they forgot about — and you get silence or a rough guess. I've been there. It took building a structured Excel cost tracking system to finally see the full picture, and what it revealed changed how we advise clients here at Helion 360.
This post walks you through the system I use: what tabs to build, what formulas matter, and why getting obsessive about cost visibility is one of the highest-leverage moves an ecommerce brand can make.
Why Most Ecommerce Brands Are Flying Blind on Costs
The problem isn't laziness — it's fragmentation. Your COGS live in your supplier invoices. Shipping costs sit in ShipStation or your carrier dashboard. Ad spend is in Meta and Google. Fulfillment fees come from a 3PL invoice. Returns processing is buried in your customer service tool. No single platform aggregates all of this into a clean cost-per-order view.
That's the gap Excel fills. Not because it's the most sophisticated tool, but because it's flexible enough to pull everything together in one place, and nearly every operator already knows how to use it.
The Four Core Tabs Every Ecommerce Cost Tracker Needs
1. Master Cost Register
This is your foundation. Every recurring and variable cost gets logged here with a category tag. I typically use these categories:
- COGS — product cost, inbound freight, duties
- Fulfillment — pick/pack, 3PL storage, packaging materials
- Shipping — outbound carrier costs, dimensional weight surcharges
- Platform & Tools — Shopify, apps, payment processing fees
- Marketing — ad spend, influencer fees, email platform costs
- Returns & Chargebacks — restocking, refund processing, fraud losses
- Overhead — team salaries allocated to ecommerce, software, office
Each row has: Date, Vendor/Source, Category, Amount, Notes, and a Month column for easy pivot table filtering. Simple, but this discipline alone is more than most brands maintain.
2. Monthly P&L Summary Tab
This tab pulls from the Master Cost Register using SUMIF formulas to aggregate costs by category and month. Alongside it, you manually enter (or link from your store dashboard) your gross revenue and units sold for the same period. The result is a clean monthly view showing:
- Gross Revenue
- Total COGS → Gross Profit & Gross Margin %
- Total Fulfillment + Shipping costs
- Contribution Margin (Gross Profit minus Fulfillment/Shipping)
- Total Marketing Spend → Contribution after Marketing
- Overhead → Net Operating Profit
This cascade matters. Gross margin feels great until you subtract fulfillment. Contribution margin after marketing is the number that actually tells you whether a product line is viable.
3. SKU-Level Cost Card Tab
This is where most brands skip ahead and pay for it later. Every SKU should have its own cost card that includes: unit cost, inbound freight per unit (total freight ÷ units received), packaging cost, average fulfillment fee per unit, average outbound shipping cost, payment processing fee (typically calculated as a % of average selling price), and an allocated return rate cost.
The formula I use for True Unit Economics is straightforward:
Net Revenue per Unit − (Unit Cost + Freight per Unit + Packaging + Fulfillment + Shipping + Processing Fee + Return Allowance) = Contribution per Unit
Once you have contribution per unit, divide it by net revenue per unit to get contribution margin per SKU. This is the number your buying decisions should be based on — not just sell-through rate or gross margin.
4. Break-Even & Scenario Planner Tab
This tab is where the system earns its keep for decision-making. I build a simple input table where you can toggle: units sold, selling price, ad spend, and any cost variable. The output shows break-even units, break-even revenue, and projected net profit at different volume scenarios.
It answers questions like: If I run a 20% off promotion, how many additional units do I need to sell to maintain the same dollar profit? Or: If my 3PL raises pick fees by $0.50, what does that do to my margin at current volume? Building this as a live scenario planner — not a static report — is what separates a useful tracking system from a historical archive.
Three Formulas That Do Most of the Heavy Lifting
- SUMIF — aggregates costs from the Master Register by category or month:
=SUMIF(CategoryColumn, "Fulfillment", AmountColumn) - IFERROR with VLOOKUP — pulls SKU costs into the cost card tab without breaking when data is missing
- Simple % formulas for margin — Gross Margin % = (Revenue − COGS) / Revenue. Contribution Margin % = Contribution / Net Revenue. Keep these visible at all times.
What This System Revealed for Our Clients
When we built this tracker for a mid-size apparel brand, their reported gross margin was 62%. Solid, right? After accounting for packaging (they used premium boxes), 3PL pick fees, outbound shipping subsidies they offered customers, and a 14% return rate — their true contribution margin after fulfillment dropped to 31%. That's not a margin problem you can ad-spend your way out of. It's a structural cost problem that required renegotiating 3PL rates and adjusting their free-shipping threshold.
For another client selling supplements, the SKU-level cost card revealed that their hero product — their highest-volume SKU — had a contribution margin 8 points lower than a secondary SKU they barely promoted. Shifting marketing budget toward the higher-margin product improved overall profitability without growing revenue at all.
Tips for Keeping the System Usable Long-Term
- Update weekly, review monthly. The Master Register loses value fast if it's only updated quarterly.
- Create a cost input ritual. Every invoice that comes in gets logged same day. Assign this to one person.
- Version control your file. Save a new copy at the start of each quarter. Cost structures shift; you want a historical record.
- Don't over-engineer it. I've seen brands build incredibly complex Excel models that nobody updates. Simplicity you actually maintain beats sophistication you abandon.
When to Graduate Beyond Excel
This system works extremely well up to roughly $5M–$10M in revenue. Beyond that, the manual data entry becomes a bottleneck and errors creep in. At that point, tools like Finaloop, Treyd, or a proper ERP with cost accounting modules make sense. But even then, the mental model you build running your own Excel cost tracker makes you a far better interpreter of whatever tool you upgrade to.
The goal was never to live in Excel forever. It was to understand your business deeply enough that no cost catches you by surprise.