Client Project · Financial Analysis
Finding the Money in the Invoices — a Vendor Cost Diagnostic
For Dr. Hotellato Zrt., a Hungarian hotel-supply distributor: turned a year of raw incoming-invoice data into an executive dashboard that separates real vendor price hikes from currency noise, catches duplicate billing, and surfaces where the business is actually growing.
~5×
Growth line vs. prior-year run-rate
Hundreds
SKUs price-audited
Real vs. FX
True price hikes isolated from currency
Duplicates
Double-billing caught automatically
What this means for you
Could you say, today, which of your vendors' price increases are real and which are exchange-rate noise? This answers that from data you already have — no new system, no extra work for your team.
The Problem
Dr. Hotellato Zrt., a Hungarian hotel-supply distributor, was watching its margin quietly compress year over year and couldn't see exactly why. The answer was buried in a year of incoming vendor invoices — thousands of line items, in multiple currencies, across hundreds of products.
By hand, it's unanswerable: is a product costing more because the vendor raised the price, or because the exchange rate moved? Are we paying the same invoice twice? Which product lines are actually growing? Nobody has time to comb a spreadsheet that size — so the questions just went unanswered.
The Solution
A diagnostic that reads the raw invoice export and answers those questions automatically — delivered as an executive dashboard ownership can actually read, not a wall of numbers.
Raw Invoice Export
SKU Normalization
Price vs. FX Split
Duplicate Scan
Margin Analysis
Executive Dashboard
What It Found
Real price hikes, separated from currency noise
Comparing every product's unit price across the year — adjusted for the exchange rate it was actually bought at — showed that most of the apparent "price increases" were currency movement, not the vendor charging more. That's the difference between chasing a dozen pointless renegotiations and knowing the handful that are real.
A growth line running ~5× hotter than last year
A coarse category bucket was hiding how fast one product line was moving. Reclassifying it product-by-product surfaced a current run-rate compounding roughly 5× faster than the prior year's actual — which turned a hedged, cautious recommendation into a confident growth bet.
Duplicate billing, caught automatically
A detector flags invoice pairs from the same vendor, for the same amount, submitted days apart — the double-billing that hides in plain sight in any large accounts-payable ledger.
The Result
- ✓ An executive dashboard ownership uses to see cost and margin drivers directly
- ✓ Real vendor price increases separated from currency swings — no wasted renegotiations
- ✓ A fast-growing product line surfaced and re-strategized around
- ✓ Duplicate-invoice risk monitored automatically, every run
Tech Stack
| Layer | Technology |
|---|---|
| Analysis Engine | Python (pandas) over the client's raw incoming-invoice export |
| Price Model | SKU-level weighted-average unit price × FX rate — isolates real price change from currency movement |
| Anomaly Detection | Same-vendor / same-amount / near-date duplicate-invoice matcher |
| Output | 6-tab Excel workbook + standalone HTML executive dashboard |
Let's Talk
I take on 3 new clients per month.
The businesses that move first win. Let's find where you're leaving 20+ hours a week on the table.
Book Your Free Audit● Capped at 3 new clients per month — the audit call is how you claim a slot