ERP Consulting and the 6-Hour Spreadsheet: Why Your Management Team Can’t Agree on Numbers

It’s the most common complaint a consultant hears. I once sat through a long Tuesday meeting where the sales director said revenue was $2.4 million for the quarter, the operations manager said $2.1 million, and the finance controller argued it was $2.2 million. All three were looking at the same company. All three were right.

Why three people can be right at once

Those reports came from different sources. The sales director counted what was ordered. Operations counted what was shipped. Finance counted what was invoiced. For a services business, the gaps come from timing — a job billed in February for work done in January, a credit note that hasn’t landed anywhere yet. This is a reporting design problem, and it’s solved before anyone touches the system.

ERP Consulting always starts with a favorite exercise: write down five key metrics and define each one in writing. No screens. A company that says “gross margin” but doesn’t specify whether freight is included has a definition problem, not a data problem. Until the definitions line up, every dashboard is a story written by different authors.

  • Define your top five metrics in 50 words or fewer; if it takes more, the term is too vague
  • Set one authoritative report per metric — not one per department
  • Pick a single time basis (“shipped in January” or “invoiced in January”) and never mix them in the same table

The math that convinced the CFO to act

That same company, before any system change, ran a visibility exercise. It asked all three managers to compare notes on a single big customer. The mismatch on that one account was $178,000. Nothing was wrong with the accounting. The report timestamps just didn’t align. An ERP Consulting blueprint effort that took 90 minutes gave the CFO the pattern, and more importantly, a decision rule she could enforce.

She adopted one simple convention: every report tracks sales by the date of invoice and cost by the date of shipment. Within a month, roughly 70% of the disagreements in management meetings disappeared.

Test it this week: ask three of your managers to each pull one number — say, accounts receivable over 60 days — then compare what they bring back. If the answers differ by more than 2%, you don’t have a software problem; you have an authority problem. The value of ERP Consulting doesn’t start after implementation. It starts with these tiny definitions that everyone can agree on today.