Why Your Purchasing Team Still Lives in Excel

Your ERP cost half a million dollars. Maybe more.

It runs your transactions perfectly. Purchase orders, invoices, inventory receipts, stock transfers, all handled. The system does what it was designed to do.

So why is your purchasing team still spending the first two hours of every morning in Excel?

The Pattern

I’ve worked with building materials distributors across the country. The ERP varies: SAP, NetSuite, Sage, Microsoft Dynamics. The pattern is always the same.

The purchasing team starts their day by exporting data from the ERP into a spreadsheet. Then they spend the next hour or two manually identifying which items are below safety stock, which purchase orders are delayed, and which warehouses need stock transfers.

They’re tracking hundreds, sometimes 800 or more, inventory exceptions per day. In Excel.

Meanwhile, finance is building their own spreadsheet from a different export. Sales has their own version. Operations has another. The CEO asks for a number and gets three different answers depending on who they ask.

This isn’t a people problem. Your team is smart, experienced, and working hard. This is a data architecture problem.

Why the ERP Isn’t Enough

ERPs are built for transactions, not for intelligence. They’re excellent at recording what happened, a PO was created, an item was received, a transfer was shipped. But they’re not designed to answer the questions your team asks every day:

• Which of my 3,000+ SKUs are below safety stock right now, across all warehouses?
• What’s my exposure on overseas orders with 90-day lead times versus domestic orders arriving in 3 days?
• Which items have been sitting in the wrong warehouse for more than 30 days?
• What should I reorder today, from which supplier, factoring in lead times, current stock levels, and incoming POs?

To answer these questions in most ERPs, you need to export data, clean it, cross-reference multiple tables, and build formulas. Every. Single. Day.

That’s how Excel becomes the operating system for your purchasing team.

The Real Cost

Most distributors don’t realize how expensive this is because the cost is hidden in daily operations. But add it up:

Time cost: If your purchasing team spends 10 hours per week managing spreadsheets at $45/hour, that’s $23,400 per year. For a team of three, that’s over $70,000 in labor spent on data wrangling instead of making purchasing decisions.

Accuracy cost: Manual data handling introduces errors. A mistyped safety stock level, a formula that breaks when someone adds a row, a spreadsheet that references last week’s data instead of today’s. These errors turn into stockouts, overstocks, and missed purchase windows.

Stockout cost: Every stockout is lost revenue. A customer calls to order, your system says it’s in stock, but it’s actually sitting in the wrong warehouse, or it was allocated to another order that nobody updated. The average stockout doesn’t just lose that one sale. It damages the customer relationship and pushes them toward your competitor who had it in stock.

Decision cost: Your leadership team is making decisions based on data that’s 1-2 weeks old. Inventory turns, fill rates, margin by product category: these numbers are calculated quarterly in most distributors, if they’re calculated at all. By the time you see a trend, it’s already cost you months of margin.

What Actually Fixes This

The answer isn’t a better spreadsheet. It’s not a BI tool bolted onto your ERP. And it’s definitely not replacing your ERP. That’s a multi-year, multi-million dollar project that most distributors can’t afford and don’t need.

The answer is a modern data layer that sits on top of your existing ERP.

Here’s what that means in practical terms:

An integration layer that automatically pulls data from your ERP, no manual exports, no scheduled reports, no one logging in to click “download.” The data flows continuously, automatically, every time something changes.

A data warehouse that receives that data and organizes it into clean, validated, business-ready layers. Raw data comes in, gets cleaned and standardized, then gets transformed into the metrics and KPIs your team actually needs. This is called a Bronze/Silver/Gold architecture, it’s the same approach Fortune 500 companies use, scaled down for mid-market operations.

Custom dashboards that your purchasing team, finance team, operations team, and sales team each open every morning instead of Excel. Each team sees the data they need, in the format that makes sense for their workflow, refreshed in real time.

Proactive alerts that notify your team before problems happen, not after. Items approaching safety stock thresholds, POs that are running behind schedule, stock imbalances across warehouses, flagged automatically instead of discovered by accident.

What This Looks Like in Practice

We built exactly this for a national building materials distributor. Multi-warehouse operation, SAP, 3,000+ SKUs across wood, iron, stainless, and aluminum.

Their purchasing team was managing 800+ inventory exceptions daily in Excel. Overseas suppliers with 90-120 day lead times mixed in the same spreadsheet as domestic suppliers shipping in 3-5 days. Stockouts discovered after customers called, not before.

After the implementation:

• Data refreshes in real time, replaced weekly Excel exports
• 0.00% data variance on baseline validation
• Exceptions flagged automatically, no manual hunting
• Proactive alerts before stockouts happen
• Purchasing, finance, operations, sales, and monitoring dashboards, all on the same platform
• The team uses it every morning as their primary operational tool

The entire engagement was 16 weeks from audit to production dashboards. We started with a paid audit that mapped every data flow, identified every bottleneck, and quantified the ROI. The client had a clear report they could act on before committing to the implementation.

How to Know If This Applies to You

If you’re a building materials distributor and any of these sound familiar, you have this problem:

• Your team exports data from the ERP to Excel at least once a week
• Different departments have different versions of the same numbers
• Your purchasing team manages inventory exceptions manually
• You find out about stockouts after the customer calls
• Month-end close takes longer than it should because data lives in spreadsheets
• Your leadership team makes decisions based on data that’s more than a day old

This isn’t a niche problem. It’s universal across building materials distribution. The ERP handles transactions. Excel fills the gap. And the gap keeps getting wider as your SKU count grows, your warehouse count grows, and your team’s time gets more valuable.

The First Step

The fix starts with understanding exactly where your data flows, where the gaps are, and what it’s costing you. That’s what a paid audit does, it maps your entire data landscape in 2-4 weeks and delivers a detailed report with prioritized recommendations and ROI projections.

You get a clear picture of the problem and a concrete plan to fix it, whether you hire us to build it or not.

If your purchasing team is still living in Excel, it’s not because they want to. It’s because nobody has built them a better option.

We build that option.

---

Vinh Truong is the Co-Founder & AI Architect at zenprocess.ai, where he builds real-time operational dashboards and data pipelines for building materials distributors. With 20+ years of enterprise IT and CTO leadership and $80M+ in technology initiatives delivered, he brings Fortune 500 data architecture to mid-market operations. Book a discovery call or read the full case study.