Case Study // Decision Infrastructure Financial Visibility Architecture

First Decision-Grade
E-Commerce
P&L

The e-commerce division of a $1B+ industrial technology company was scaling across four sales channels with zero financial visibility. Revenue was fragmented. Costs were buried in generic ledger accounts. Leadership couldn't answer the most basic question... "Are we actually making money?"

The Evidence

Diagnostic Tools and
Governance Frameworks

The P&L intervention produced diagnostic tools and decision-making frameworks that bridge the gap between fragmented financial data and leadership confidence.

Diagnostic Tool
P&L Project
Brief
Forensic assessment of the financial visibility gap. Documents the core problem, scope, current state, ownership model, open risks and unchallenged assumptions. Built to force organizational honesty about what the numbers could and couldn't support.
View Tool →
Governance Framework
P&L v1.0 Cutoff
Definition
Defines the hard and soft requirements a P&L must meet before leadership can use it for decisions. Includes the litmus test... if leadership hesitates when asked a resource allocation question, the P&L isn't ready.
View Framework →
The Situation

No Financial Visibility
Across Four Channels

The e-commerce parts business generated revenue through four distinct channels... a primary storefront, two third-party marketplaces and a B2B aggregator. But there was no unified financial picture. Revenue data lived in separate platform dashboards. Cost of goods sold was tangled with corporate overhead. Platform fees and shipping expenses were buried in generic GL accounts that told leadership nothing about channel profitability.

The team had been operating on manual spreadsheets... static, backward-looking and maintained by whoever had bandwidth that week. When the VP of E-Commerce was asked to justify increasing ad spend or expanding marketplace presence, the honest answer was: "We think it's working, but we can't prove it."

This wasn't a reporting inconvenience. It was a structural blocker. Every growth lever... marketing investment, marketplace expansion, OEM partnerships, loyalty programs, pricing optimization... was gated behind a financial instrument that didn't exist.

→ Leadership asks "Is this channel profitable?"
→ Team checks fragmented platform data
→ Numbers don't reconcile across sources
→ Decision gets deferred or made on instinct
→ Cycle repeats next quarter
Pressure Points Surfaced

What the
Diagnostic Found

A forensic audit of the existing financial infrastructure revealed structural gaps that no amount of spreadsheet polish could fix.

Red
No Single Source of Financial Truth
Revenue, COGS and operating expenses lived in four different systems with no reconciliation layer. The same dollar could appear in two reports or none.
Red
Formula Errors in Core Metrics
The existing spreadsheet showed #ERROR! fields in Net Sales, Total COGS, Gross Profit and Net Profit. The math itself couldn't be trusted.
Red
COGS Not Validated Against Transactions
Cost of goods sold was partially inferred, not locked to actual transaction data. Gross margin was directional at best.
Caution
Shipping Economics Invisible
Shipping revenue and shipping expense were both present but allocated differently... making it impossible to determine whether fulfillment was a profit center or a cost sink.
Caution
Corporate Costs Flowing Into E-Commerce
Overhead expenses from other business units were silently dumped into the e-commerce GL with no explanation or allocation methodology.
Caution
Platform Fee Allocation Unclear
Shared platform costs (the primary storefront served multiple business units) were charged entirely to e-commerce without a defensible split.
Red
No Executive-Ready View
There was no single summary showing Net Sales, Gross Margin %, Operating Margin % and top cost drivers. Finding the numbers required archaeology across tabs and files.
The Approach

Building the Machine
That Didn't Exist

The intervention wasn't a dashboard project. It was financial architecture... building the measurement system, the data mapping, the governance standards and the organizational agreement on what "e-commerce profitability" actually means inside a $1B+ enterprise.

Phase 01
Define the
Structure
Researched P&L architecture, defined revenue sources, COGS components, operating expense categories. Mapped every GL account to its proper line. Coordinated with Finance and Accounting to create new GL accounts where the existing chart of accounts couldn't distinguish e-commerce costs from corporate overhead.
Phase 02
Map the
Data Sources
Identified where every dollar originated (storefront, marketplaces, B2B aggregator) and where every cost was recorded. Built the reconciliation logic connecting platform reports to internal accounting systems. Exposed the gaps... including platform fees buried in generic accounts and shipping costs allocated to the wrong business unit.
Phase 03
Build in
Looker
Translated the spreadsheet architecture into a live, self-serve dashboard. Revenue by category, SKU and channel. Gross margin and contribution margin. Freight and fulfillment costs. Marketing spend and return. Monthly and quarterly views with drill-down filters. Real-time... not a static snapshot updated whenever someone had bandwidth.
Principle
Define
Decision-Safe
Created the v1.0 Cutoff Definition... a governance framework that specified exactly when the P&L could be trusted for resource allocation decisions. Hard requirements (zero formula errors, complete revenue, explicit COGS). Soft requirements (overhead allocation declared, interest treatment documented). A litmus test tied to the actual questions leadership needed to answer.
The Outcome

What the P&L
Architecture Produced

6
Cross-functional
departments aligned
4
Revenue channels
unified
1st
Decision-grade P&L
for e-commerce
18+
GL accounts mapped
and reconciled

The shortest version... an e-commerce operation running blind across four channels got its first unified financial picture. The P&L dashboard went live in the company's BI platform, giving leadership real-time visibility into revenue, margins, cost drivers and channel profitability. It became the gate for every growth decision that followed... ad spend increases, OEM expansion, marketplace strategy, pricing optimization. The measurement system that didn't exist became the prerequisite for everything that came next.

Back to The Warehouse