Skip to work
← KINO LABKO

15 / DATA

Sales Comparison

ERP sales order diff to revenue change detection

92% time saved

SALES COMPARISONPREVIOUSCURRENTDELTASTYLE-00001,000STYLE-00001,000—STYLE-00012,400STYLE-00013,000+600STYLE-00021,800STYLE-00021,800—STYLE-00035,000STYLE-00034,200−800STYLE-00041,200STYLE-00041,200—SO PULL MM/DD 09:00 · MM/DD 09:002 CHANGES DETECTED

PROBLEM

Order data keeps moving, and there was no way to catch a change as it happened. A quantity cut or a shipping delay found late threw off the revenue plan and the reporting with it.

THE OLD PROCESS

  1. 01Pull the sales order report from the ERP
  2. 02Put it beside the previous file
  3. 03Compare with spreadsheet formulas
  4. 04Eyeball the rows that differ
  5. 05Write it up and share it

WHAT I BUILT

  • Two reports in, every difference out — quantity, dates, added and deleted lines alike
  • Only the changes are reported, not the whole file