erpkaizen

Measuring the value

Measuring the ROI of a single source of truth

Has a measurement 21/09/2026 About 9 min
5
Comparing the number of reconciliation paths when every department keeps its own figures, against one shared source of truth.

Reconciliation cost does not grow with the number of departments — it grows with the number of PAIRS that must be cross-checked. Drag the slider to see how fast that count runs away.

Fragmented data across departments is usually treated as a technical inconvenience. Seen through a finance lens, it is a silent tax eroding cash every day.

Estimated cash recovered per year

All it needs is headcount and department count. Revenue, orders, receivables and inventory are derived from those with ordinary ratios — every one of them editable.

Total people in the company
Count the places keeping a separate copy: sales, warehouse, accounting, purchasing…

Derived from your scale

Annual revenue (VND)
Orders / year
Average receivables (VND)
Average inventory value (VND)
Assumptions — click to see and change every number

Scale and labour

Orders

Receivables

Inventory

Which leak is biggest Hover a bar to see how that number is built
A. Reconciliation tax
B. Duplicate entry
C. Collection delay
D. Stock mismatch
A. Reconciliation tax
B. Duplicate entry
C. Collection delay
D. Stock mismatch
Total cash recovered / year

This is an estimate, not a promise. It only means anything if you take a real baseline before you change anything — see the three-step path at the end.

When sales keeps its own tracker, the warehouse runs on bin cards or a personal spreadsheet, and accounting sits on separate software, the company pays in three currencies: wasted hours reconciling, interest on money collected late, and losses from stock that is not where the system says it is.

This piece gives the method and the formulas to turn those "intangible" benefits into real cash — the kind of number you can defend in front of a board. And because this site does not believe in numbers you cannot check, the estimator above lets you enter your own scale, change every assumption, and see each step of the arithmetic.

How the estimator derives everything from scale

The first version of this estimator had a mistake worth naming, because it is the easy mistake to make when quantifying anything: receivables, inventory value and order volume were left as free-standing inputs. All three are revenue-scale quantities, not headcount-scale ones — so tripling the headcount moved the total by a few percent. The output looked detailed while the two fields that mattered most barely steered it.

The fix is to chain them, each link an ordinary finance ratio you can check yourself:

Revenue = headcount × revenue per employee
Orders / year = revenue ÷ average order value
Receivables = revenue × DSO ÷ 365
Inventory = revenue × (1 − gross margin) ÷ turns

All four leaks then scale with size: A with the number of department pairs and order volume, B with the people re-keying and the orders keyed wrong, C with receivables, D with orders lost and inventory held. Move headcount from 60 to 200 and the total goes from roughly 815m to roughly 2.7bn đ — proportionate, instead of the +22% the first version produced.

Every link in that chain is an editable field. If your revenue per employee is nothing like the default — and distribution is nothing like manufacturing — change that field before reading the total.

1. Four cash leaks caused by fragmented data

  1. The reconciliation tax. Accounting, the warehouse and sales lose dozens of hours a week opening files, comparing rows, and arguing about whose number is right.
  2. Duplicate-entry waste. One document gets typed again by each department. It costs hours, and it raises the error rate, which costs invoice cancellations and re-issues.
  3. Cash and decision latency. Receivables that do not agree push the reconciliation statement one to two weeks past close. Money arrives later, which means more interest paid.
  4. Book and physical stock diverging. Sales commits against phantom stock and orders get cancelled; conversely the warehouse believes it is out and over-orders, tying up capital.

2. Four formulas that turn this into cash

A. Reconciliation tax → evaporated payroll

Annual reconciliation cost = Σ (hours per month × loaded cost per hour) × 12
Loaded cost per hour = real pay (gross + social insurance + allowances) ÷ 176 hours
Example inventory accountant 15 h/month (pay 12m ≈ 68,000 đ/h) = 1,020,000 đ · receivables accountant 15 h/month (15m ≈ 85,000 đ/h) = 1,275,000 đ · chief accountant reviewing 6 h/month (30m ≈ 170,000 đ/h) = 1,020,000 đ · storekeeper and sales admin 20 h/month = 1,500,000 đ. Total ≈ 4,800,000 đ/month → 57,600,000 đ/year.

The estimator models this differently, and the difference is the point: instead of adding up people, it counts the pairs of departments that must be cross-checked. Four departments is six pairs; six departments is fifteen. Reconciliation cost does not grow with the number of departments, it grows with the number of pairs — which is why a company that "only added one more team" finds month-end got noticeably longer.

B. Duplicate entry → surplus hours and rework

Waste = (orders per year × re-keying time per order × hourly cost) + cost of fixing errors
Example 2,000 orders/month, accounting and the warehouse spend 3 minutes re-keying each = 100 hours/month ≈ 7,000,000 đ. A 1% typo rate (20 orders/month) at roughly 150,000 đ per cancellation and re-delivery = 3,000,000 đ/month. Total ≈ 10,000,000 đ/month → 120,000,000 đ/year.

C. Collection delay → saved cost of capital

With one consistent system the receivables statement goes out on the 1st instead of the 15th. Days saved cut straight into interest.

Cost of the delay = average receivables × (annual rate ÷ 365) × days late
Example average receivables 20bn đ, borrowing at 8%/yr, 13 days saved: 20,000,000,000 × 8% ÷ 365 × 13 ≈ 57,000,000 đ/month. Interest saved ≈ 684,000,000 đ/year.

This is usually the largest line, and the one most often missing from an ERP proposal — because it does not belong to any department. It belongs to the balance sheet.

D. Stock mismatch → tied-up capital and lost orders

Loss = (value over-bought × carrying cost rate) + gross profit lost to stock-outs
Example four orders a month cancelled because the system showed stock the warehouse did not have, losing 4 × 5,000,000 = 20,000,000 đ/month of gross profit. Over-buying 300m đ of materials at 15%/yr carrying and capital cost = 45,000,000 đ/year. Total ≈ 285,000,000 đ/year.

3. Summary

Estimated for a company with 50–100bn đ of revenue:

BottleneckNature of the wasteRecovered per year
Month-end cross-checkingWasted hours50–80m đ
Repeated manual entrySurplus steps and rework100–140m đ
Late receivables reconciliationCash sitting out in the market200–600m đ
Stock and books divergingTied-up capital and lost orders150–300m đ
Total cash benefit500m – 1.12bn đ / year

4. A three-step path to measuring it for real

  1. Take a baseline before you improve anything. Record how many days close currently takes, time the meetings spent resolving mismatches, note the cancellation rate caused by stock errors, and your DSO. Without this step every later number is an anecdote.
  2. Lock the point where data is created. Eliminate the habit of exporting to Excel and working outside the flow. Configure approvals and validation so data is entered once, at source.
  3. Audit again after 90–180 days. Compare close time, interest saved and hours freed, against the same group of people and the same season as the baseline.

Improving an ERP until it holds a single source of truth is not technology spending. It is the act of recovering money the business is already dropping each year, through the gaps in its own operations.

The example figures illustrate a company with 50–100bn đ of revenue. They are not taken from any client's system.

Read next