Finance

“Numbers don’t match between our systems”

Numbers that match across your entities.

A group view of working capital and ROCE, with each subsidiary side by side, can be built per customer. We map your ERP and accounting systems into one model, with every value traced to its source.

Talk to us

The problem

  • Different entities use different ERPs.
  • Consolidated reporting takes weeks of Excel work.
  • Sales says one number, finance reports another.

Who this is for

  • CFO
  • CEO
  • PE Investors

Questions you can answer

  • What is our consolidated gross margin?
  • What is our true working capital position?
  • Which specific channels are driving the group profit?

Answers

What is our consolidated gross margin?

built per customer
Sources needed
  • ERP revenue
  • ERP purchase cost
Calculation
Gross margin % = (revenue − COGS) ÷ revenue × 100
What you see
Group Financial Overview

What is our true working capital position?

built per customer
Sources needed
  • ERP inventory
  • Accounting receivables
  • Accounting payables
Calculation
Operating working capital = inventory + trade receivables − trade payables
What you see
Working Capital

Which specific channels are driving the group profit?

built per customer
Sources needed
  • Booked sales
  • COGS
  • Shipping
  • Returns
  • Agreed channel allocation
Calculation
Channel contribution = booked revenue after discounts − allocated COGS − shipping − returns costs
What you see
Channel performance table

Are there discrepancies between our systems?

built per customer
Sources needed
  • ERP
  • Accounting
Calculation
Value matching
What you see
System reconciliation flags

How Dataloader solves it

  1. Connect systems We pipe in your ERP, accounting, and POS systems.
  2. Map the group The Observatory maps different underlying schemas into one logical group model.

Group Financial Overview

What you see

Consolidated performance table.

Illustrative
  • vs Last Year
  • vs Target
Consolidated performance table. Illustrative example. Figures are not customer data.
MetricGroup TotalEntity AEntity BVariance vs Budget
Revenue
Gross Margin
EBIT
Working Capital
Illustrative | Accounting updated 06:15 | ERP updated 06:30 Illustrative example. Figures are not customer data.

KPI definitions

Gross margin %

Formula
(booked revenue − COGS) ÷ booked revenue × 100
Inputs
  • ERP/accounting revenue
  • Purchase cost from ERP/accounting
Missing data
Requires ERP or accounting revenue and purchase cost.

Budget pacing variance

Formula
(actual YTD − plan YTD) ÷ plan YTD × 100
Inputs
  • Accounting actuals
  • Finance plan
Missing data
Requires accounting actuals and finance plan.

Business case

Consolidation capacity savings

  • Monthly manual FTE days saved
  • Average cost per finance FTE
  • Calculation: Annual hours saved × loaded hourly cost; deduct service costs and report cash released separately.

Customer result

Illustrative

Illustrative scenario: post-M&A consolidation.

Industries where this matters

Frequently asked questions

Do we need to change our accounting software?

No. We read from your existing systems.

Numbers that match across your entities.