FMCG distribution financial analysis

Find where distributor profit is earned, lost, and trapped in working capital.

A specialist-led financial and commercial audit for FMCG distributors. We reconcile your ERP and spreadsheet exports, trace profit to customers, products, suppliers, salespeople, channels, and inventory, then turn the evidence into a prioritized management plan.

Manual analysis by specialists. No automatic score, no generic benchmark, and no recommendation without supporting evidence.

Audit outputs

Financial baselineReconciled
Leakage & causesQuantified
Decision scenariosModelled
90-day executionPrioritized
Expected impact is kept separate from cash release and from benefits actually realized.

Scope of analysis

One financial truth, examined from every decision angle.

The depth of the audit is determined after we inspect the available data. Missing evidence is disclosed; it is never replaced by invented certainty.

01

Financial truth

Reconcile gross sales, discounts, returns, net sales, COGS, gross profit, direct service cost, operating expenses, and net profit.

02

Customer profitability

Identify accounts that create value, absorb margin, or consume disproportionate delivery, credit, and commercial effort.

03

Product profitability

Assess SKU margin, volume, price realization, purchase cost, returns, stock risk, and role in the wider range.

04

Customer × product

Expose loss-making combinations hidden by profitable customer or product averages.

05

Supplier economics

Measure supplier-linked profit, cost movement, rebates, claims, slow stock, payment terms, and negotiation opportunities.

06

Sales team & channels

Compare profit quality, mix, discounts, returns, collections, and cost-to-serve—not sales volume alone.

07

Inventory & working capital

Locate ageing, excess, expiry exposure, slow movement, overdue receivables, and cash tied up in the cycle.

08

Pricing, discounts & returns

Find weak price realization, uncontrolled exceptions, price dispersion, and repeat return patterns.

How decisions are calculated

A low margin is a signal—not an instruction.

Before recommending “grow”, “reprice”, “renegotiate”, “reduce”, or “stop”, we test the evidence and the commercial dependencies.

1

Reconcile

Match sales, returns, COGS, and gross profit to the agreed ERP or GL control totals.

2

Diagnose

Separate price, volume, mix, cost, discount, return, service, inventory, and financing effects.

3

Check dependencies

Review trend, contracts, strategic range, substitutes, cross-sell, capacity, and relationship risk.

4

Model scenarios

Calculate conservative, expected, and ambitious cases using visible, client-approved assumptions.

5

Approve & track

Assign an owner, deadline, KPI, and locked baseline; then compare expected with realized benefit.

What management receives

Not another dashboard. A decision-ready profit report.

Every recommendation carries evidence, assumptions, confidence, financial impact, ownership, and the next management action.

01

Executive Profit Story

A management-level explanation of what happened, why profit changed, and what deserves attention first.

02

Profit Leakage Map

A quantified map of leakage, recoverable opportunity, confidence, and required validation.

03

Customer & Product Action Plans

Specific grow, protect, repair, reprice, renegotiate, reduce, or review actions.

04

Customer × Product Matrix

The exact account/SKU combinations creating or destroying profit.

05

Supplier Negotiation Packs

Financial baselines, target levers, boundaries, and evidence for major negotiations.

06

Inventory & Cash Opportunities

Ageing, expiry, excess stock, receivables, and cash-release actions—kept separate from profit impact.

07

Three Impact Scenarios

Conservative, expected, and ambitious cases with formulas and approved assumptions.

08

90-Day Action Plan

Prioritized decisions with owners, deadlines, KPIs, and a benefits-realization tracker.

Client data request pack

Files requested after scope approval.

We normally request 12–24 months of raw Excel or CSV exports. Sample files may be shared first; clients do not need to redesign reports for us.

01

Core — required to certify gross profit

Files

  • Detailed sales invoice lines
  • Credit notes / returns detail
  • COGS or item-level cost history
  • GL or ERP sales and COGS summary
  • Customer master
  • Product / SKU master

What this enables

Financial reconciliation, sales and gross-profit truth, customer profitability, product profitability, and customer × product analysis.

If missing: Without transaction-level sales and reliable COGS, we cannot certify the core profit report.

02

Commercial — required for pricing and sales decisions

Files

  • Price lists and price history
  • Discount policy and approval rules
  • Salesperson assignments and targets
  • Channel and territory mapping
  • Customer contracts / agreed terms
  • Return reason codes

What this enables

Price realization, discount leakage, return causes, salesperson and channel performance, and fair commercial comparisons.

If missing: Without policy, history, or assignment data, findings remain descriptive and recommendations are downgraded.

03

Supply chain — required for stock and supplier decisions

Files

  • Inventory snapshot
  • Inventory movements
  • Batch and expiry data
  • Purchase transactions and cost history
  • Supplier master
  • Supplier terms, rebates, support, and claims

What this enables

Inventory ageing, expiry and cash exposure, supplier economics, cost movement, and negotiation packs.

If missing: Without movements, purchases, and supplier terms, we do not claim stock-release value or negotiation economics.

04

Net profit & working capital — required for the full audit

Files

  • Operating-expense ledger
  • Direct logistics and delivery cost
  • Commissions and direct service cost
  • Accounts receivable ageing
  • Accounts payable ageing
  • Payment terms and cost-allocation rules

What this enables

Contribution profit, customer/channel cost-to-serve, DSO/DPO/cash-conversion analysis, and net-profit decisions.

If missing: Without an agreed allocation method, we show gross profit only and do not label a customer or channel net-profitable or loss-making.

Preferred format: one row per transaction or movement, stable customer/product/supplier codes, original column headers, and no manually deleted rows. Passwords and system access are not required for the initial review.

Engagement workflow

From first conversation to measurable action.

01

Confidential scope call

We confirm the decisions management needs, the period, entities, systems, and available evidence.

02

Data-fit review

We inspect sample exports first, identify missing fields, and confirm what the data can and cannot support.

03

Written scope & fee

You receive the included modules, exclusions, timeline, deliverables, and fixed commercial terms before paid work begins.

04

Manual specialist analysis

We map, validate, reconcile, investigate drivers, remove double counting, and document every assumption.

05

Management review

Sensitive actions and scenario assumptions are reviewed with management before becoming recommendations.

06

Report & 90-day plan

We deliver the decision report, action register, and a baseline ready to measure realized benefits.

Confidential first step

Send a sample first. We will confirm what your data can support.

Begin with sample exports or a file list—full data is not required before scope and confidentiality are agreed. We reply with the exact checklist, coverage assessment, missing-data notes, timeline, and fee.

Secure website submission

Free FMCG Data-Fit Review
  1. Complete company and contact details
  2. Choose the management concern
  3. State the ERP and requested period
  4. Upload up to eight sample files securely
  5. Receive a submission reference
Open secure request & upload Do not include passwords, card data, or system credentials.