Fractional CFO for E-commerce and D2C Brands

The P&L lies. Your business looks profitable — until you realize you've been running a working capital arbitrage machine disguised as a brand. The difference between knowing your numbers and not knowing them is survival.

E-commerce financial planning and analysis

The Inventory Problem Nobody Talks About

I've worked with D2C brands from $2M to $50M in revenue. The consistent pattern: the founder knows they have an inventory problem but doesn't know what to do about it. They know this because they keep having cash flow surprises — months where the bank account drops unexpectedly despite the business being "profitable."


The problem is the cost of goods sold is calculated at the point of purchase, not at the point of sale. You bought inventory six months ago at $12 per unit. Today, your supplier raised prices to $15. But your standard COGS still shows $12 because your accounting system hasn't caught up — and your gross margin looks 25% better than it actually is.

Amazon makes this worse. Amazon's settlement reports take 60-90 days to fully reconcile. When you make a sale today on Amazon, the cash doesn't hit your account for 60 days, and Amazon has been taking fees throughout that period. By the time you try to reconcile Amazon revenue with your accounting records, you've already made inventory decisions based on numbers that were wrong.

The brands that survive are the ones that built a real-time model of inventory economics. The brands that don't make it are the ones whose inventory got ahead of their cash — they kept ordering because the P&L said they were profitable, but the bank account told a different story.

SKU-Level Profitability Is the Answer to the Wrong Question

Most e-commerce founders know they should be looking at SKU-level profitability. They've heard this from investors, from their accountant, from every piece of financial advice aimed at consumer brands. The problem is most of them are calculating it wrong.

The correct calculation for SKU-level profitability:

Revenue per SKU (after returns, after discounts, after Amazon fees) MINUS:
- Cost of goods (at actual, not standard cost)
- Inbound freight and duty
- Storage costs (FBA charges by unit per month)
- Amazon referral fees
- Variable selling costs (wages, packaging)
- COGS-augmenting costs (refunds, damage, write-offs)
= TRUE CONTRIBUTION PER SKU

The number most founders are looking at is revenue minus standard COGS minus shipping out. That's not profitability. That's a rough estimate.

A fractional CFO for an e-commerce brand builds the model that calculates actual SKU-level profitability correctly — and then uses it to make inventory buying decisions. The result: you stop ordering SKUs that look good on the surface but destroy cash, and you double down on the ones that actually produce margin.

This is a real example: a $15M D2C beauty brand I worked with had 340 SKUs. Their accounting system showed them profitable across the board. When we rebuilt the SKU-level P&L with Amazon fees, storage costs, and refund rates properly attributed, we found that 127 of those 340 SKUs were destroying margin. They eliminated the 127, cut inventory carrying costs by 30%, and improved net margin by 6 points in 18 months. All without a single new customer acquisition.

The Amazon Cash Conversion Cycle

When you place a purchase order to your supplier: Day 0. Goods ship from China (21-35 days): Day 0-35. Goods arrive at Amazon warehouse: Day 35-45. Goods sell to customer: Day 45-75 (depending on velocity). Amazon settles payment: Day 105-135 (60-90 day settlement). So the average SKU is paid for on Day 0 but cash is received on Day 105-135. That's a 105-135 day cash conversion cycle. Every dollar of inventory you hold is a dollar you've financed for 3-4.5 months before seeing a return. At 3x annual inventory turns, you're financing 4-6 months of inventory at any given time. A fractional CFO models this and finds where to compress it.

The Capital Raise for Consumer Brands Is Different

Consumer brands raising capital face a different investor landscape than tech. Growth equity investors and revenue-based financing lenders for consumer brands care about specific metrics that most e-commerce founders can't speak to fluently — and can't produce on demand.


Velocity and units per transaction. Not just revenue. If you're selling 500 units/month of SKU A at $50 and 50 units/month of SKU B at $80, which is the more valuable product? Revenue doesn't answer this. Velocity does.

Reorder rate and repeat purchase rate by cohort. A brand with a 30% reorder rate from first-time buyers is worth 2x a brand with 15% at the same revenue, all else being equal. This metric isn't in your standard dashboard.

Trade spend ROI. If you're paying retailers for shelf space, promotional slots, or co-op advertising, you need to know whether that spend is producing incremental revenue or just maintaining existing sales. Most brands can't answer this question.

Fill rate and on-time delivery rate. These operational metrics matter to investors because they signal supply chain reliability.

The fractional CFO who works with consumer brands builds the investor-ready data package before the raise — so when you walk into a growth equity meeting, you're presenting metrics you own and understand, not numbers you scrambled to pull together in the final weeks before the roadshow.

When a D2C Brand Needs a CFO — The Real Triggers

The brand that's looking at $3M revenue and thinking "we should probably get a CFO" — that's usually the right time. But I've also seen brands at $8M-$10M running on QuickBooks and a spreadsheet that one smart person in the company maintains, and the fire is already lit.


Real triggers for bringing in a fractional CFO:

Inventory is creating cash flow surprises more than twice a year. This is the most reliable signal. If you can't predict your cash position 13 weeks forward with reasonable accuracy, your inventory management and cash flow modeling need CFO attention.

You're preparing for revenue-based financing or growth equity. Lenders and investors want to see a financial model with assumptions they can interrogate. If you can't produce one, or if yours has gaps a third grader would catch, the term sheet will reflect their skepticism.

You're adding a new marketplace (TikTok Shop, Faire, a new DTC channel) or a new retail channel. Each new channel has different fee structures, payment terms, and logistics. The financial model for "should we go on TikTok Shop" requires understanding the unit economics per channel, not just total revenue.

You're planning a brand acquisition or have been approached by a PE platform. Due diligence on a D2C brand focuses heavily on the accuracy of reported revenue, Amazon settlement reconciliation, inventory valuation, and the sustainability of the unit economics. A CFO who's been through this before knows where to find the gaps before a buyer does.

Key Takeaways

  • The Amazon cash conversion cycle is 105-135 days — every dollar of inventory is financed for 3-4.5 months before generating return
  • SKU-level profitability must include Amazon fees, storage costs, inbound freight, and refund rates — not just COGS and revenue
  • Inventory standard costs must be updated at each purchase order, not annually, or your gross margin will be systematically wrong
  • Revenue-based financing and growth equity require different metrics than venture debt — know which one fits your model before you pitch
  • A quality of earnings analysis on a D2C brand will focus on Amazon settlement reconciliation — have your CFO build this process first

Frequently Asked Questions

Our Amazon reports don't match our accounting software. Is this normal?

Yes — and it's a persistent problem that most D2C brands live with without understanding. Amazon's settlement reports (the detailed transaction-level data) take 60-90 days to fully reconcile because of their payment structure. Revenue recognized in your accounting system will never perfectly match Amazon's reporting in real time. The fix is a reconciliation process built into your monthly close — not trying to make them match, but understanding and documenting the timing difference.

How do we figure out which SKUs actually make money?

Build a SKU-level P&L that includes: gross revenue (after returns, after discounts, after promos), Amazon fees (referral, FBA, storage), inbound freight and duty, actual COGS (not standard), refund reserve, and any co-op advertising attributed to that SKU. Most e-commerce ERPs don't produce this view natively. It usually requires a spreadsheet or a BI layer on top of your data. The output tells you which SKUs to grow and which to wind down.

We have a healthy bank account but the P&L looks thin. Is that normal?

This is a classic D2C pattern. A large bank balance usually means inventory was purchased in prior periods — you're holding stock that hasn't converted to cash yet. A healthy-looking bank balance on a thin P&L often means inventory is elevated relative to current demand. The metric you want to watch is inventory turns per SKU. If turns are slowing while revenue is flat, you're building inventory faster than you're selling it — and the cash drain is coming.

When should we think about revenue-based financing vs. growth equity?

Revenue-based financing (RBF) is appropriate when you have consistent, predictable revenue (at least $100K/month) and need capital for a specific working capital purpose — typically inventory purchases or a short-term growth investment. RBF doesn't require giving up equity. Growth equity is appropriate when you're at $5M+ revenue and raising to fund a significant expansion, acquisition, or PE-type transaction. The RO conversation is different for each. A CFO helps you model the cost of capital under each scenario.

We're preparing for our first raise. What should we have ready?

Three years of clean financial statements (or however long you've been operating), a 13-week cash flow model, a unit economics model by channel and key product category, an investor deck with a use-of-funds model attached, and a cap table that accounts for all existing equity. Most D2C founders underestimate how long it takes to get these materials investor-ready. Give yourself 90 days.