Written by: Karol Sobieraj, Founder & CEO, Digital Colliers
You run 15 systems and still wait two days for one answer. That's the shape most DTC finance and ops teams are stuck in right now. The stack grew fast between 2020 and 2023, and nobody went back to wire the pieces together properly. So every Monday, somebody exports CSVs and rebuilds reality in a spreadsheet.
The 15 systems, roughly
Count the tools a mid-size DTC brand actually touches in a normal week. It's not hard to hit fifteen.
- Shopify or the storefront platform
- A separate B2B or wholesale channel
- Amazon Seller Central
- Meta Ads Manager
- Google Ads
- TikTok Ads
- Klaviyo or the ESP
- The 3PL or WMS
- ShipStation or the shipping layer
- Loop, Returnly, or the returns portal
- Gorgias or the support desk
- NetSuite, Xero, or QuickBooks
- A subscription tool like Recharge
- A review or UGC platform
- A BI layer, or more often, a Google Sheet pretending to be one
Each one is fine on its own. The problem is they all describe the same order slightly differently, and none of them agree on margin.
Where they disagree, and why it matters
Shopify says an order is £84. The 3PL logs it two days later with a different SKU code. Meta claims the sale, Google claims the sale, Klaviyo claims the sale. The returns portal quietly writes off 20% of it a month later. Finance sees the deposit net of fees a week after that.
So when you ask "did that campaign make money," you're stitching five timelines together by hand.
The math underneath is unforgiving. Online return rates sit around 19 to 20% of gross sales, and UK apparel routinely runs 25 to 40%. Customer acquisition cost across DTC has climbed roughly 40% since 2023, and Meta CPMs kept pushing up through 2024 and 2025. Meanwhile UK eCommerce grew about 3% in 2024. Single-digit top line, double-digit cost inflation, and a returns tail that eats the difference. That's the squeeze.
The consequence shows up in SKU economics. Roughly 30% of SKUs at a typical multi-channel brand lose money per order once returns and ad spend are counted honestly. Most operators can't see which 30% until the quarter's over. By then you've reordered the losers.
What the reconciliation actually costs
Walk into a DTC finance function on a Monday and you'll see the same pattern. An analyst pulls seven exports. A junior finance hire cleans SKU mappings. Someone in ops reconciles the 3PL against Shopify. A growth lead re-attributes ad spend because the platforms triple-count.
Add it up honestly and it's usually one to two full-time equivalents burning their week on reconciliation. Not analysis. Reconciliation. The analysis happens in the last two hours on Friday, on stale data, right before the exec meeting where someone asks a question that requires re-running the whole thing.
The hidden cost isn't the salary. It's the decisions you don't make because the number arrives too late to act on. You keep spending on a losing ad set for another week. You reorder a SKU you should've killed. You discount a cohort that was going to repurchase anyway.
What shipping the join looks like
The operators pulling ahead in 2026 aren't buying a new dashboard. They're doing the boring middleware work everyone deferred.
In practice that means four things:
- One canonical order record, keyed by order ID, that every system writes into or reads from. Not a BI view stitched on top. An actual source of truth.
- SKU and channel mappings maintained as code, reviewed on PRs, not as a shared spreadsheet with three tabs called "final_v2."
- Landed margin calculated per order, per SKU, per channel, refreshed hourly. Ad spend, fees, shipping, and a returns reserve baked in from day one.
- Alerts on the deltas that matter. SKU margin turning negative. Return rate spiking on a size. CAC drifting past LTV on a channel.
None of this is glamorous. It's schema work, pipeline work, and a small amount of finance logic written down carefully. Teams that ship it stop guessing. Teams that don't keep hiring analysts to paper over the gap, and the gap widens every quarter costs climb faster than revenue.
The left-behind risk
Here's the uncomfortable part. If your competitor sees SKU-level margin by Tuesday morning and you see it by the following Monday, they've made six pricing and inventory decisions before you've made one. Compounded over a year, that's the difference between a brand that survives the margin squeeze and one that quietly runs out of working capital.
The fifteen-system tax is optional. Most teams just haven't decided to stop paying it yet.

