Suppliers Are Late Again and It's Costing $1,000/Week — How to Track Supplier Delivery Without Software

By Ryne Bandolik · Jobs Done Labs · July 3, 2026

Dave runs production at a 35-person sheet metal fabricator in Ohio. He sources raw materials from 23 suppliers — steel, aluminum, hardware, finishes. Each job needs 3-8 different materials to start, and every Monday morning he stands in front of a whiteboard trying to remember who promised what and when. Alro said the 14-gauge would be here Wednesday. Or was it Tuesday? And was that this week or last week?

Here's the math Dave lives with: 15-20% of purchase orders arrive late. When a supplier misses a date, Dave doesn't find out until the material fails to show up — which means the press brake sits idle at $85/hour, the 4-person welding crew has nothing to weld, and a job that was due Friday is now due next Wednesday. Three hours of unexpected downtime per week × 4 idle workers × $85/hour shop rate = $1,020/week in direct labor waste. Add expedited shipping to recover, overtime to catch up, and late-delivery penalties from customers — at least $40,000 a year vanishing into supplier delivery failures Dave could have seen coming.

Dave looked at supplier management software. SourceDay. Precoro. Lasso. They start at $200-400/month, require supplier onboarding, and are built for procurement departments with dedicated buyers — not for a production manager who's also doing quoting, scheduling, and quality checks. Dave doesn't need a procurement platform. He needs to know, on Monday morning, in under 10 minutes: which suppliers are late, who's due this week, and which jobs are at risk.

The Monday morning blind spot

Every small manufacturer has a version of this problem. The production manager holds the supplier relationship map in their head. They know Alro is usually reliable but has been slipping on aluminum deliveries. They know the hardware supplier in Indiana always pads their lead times by 3 days. This tribal knowledge works — until it doesn't. When the production manager is out sick, in a customer meeting, or simply overloaded, the system collapses into guesswork.

The cost of this blind spot compounds fast:

• Idle labor: Workers standing around waiting for material at full shop rate.
• Expedited shipping: Overnighting material you should have ordered 3 days ago, at 4x normal cost.
• Overtime to catch up: Running Saturdays at time-and-a-half because the week's schedule collapsed.
• Customer trust erosion: Missing promised dates. The customer doesn't care that your supplier was late — they care that you were late.

And here's what the software vendors won't tell you: for a shop with fewer than 50 active POs and one person managing procurement, a spreadsheet is the right tool. The problem isn't the tool — it's that nobody has a system for using it.

The supplier delivery scorecard system

This system uses four spreadsheet tabs — built in Google Sheets or Excel — to replace the mental whiteboard with something visible, shareable, and impossible to ignore on Monday morning. Here's what each tab does:

Tab 1 — Supplier Directory

The master list of every supplier you buy from. Columns: Supplier Name, Contact Name, Phone/Email, Lead Time (standard, in days), Category (raw material, hardware, finishes, packaging), Reliability Notes (free-text — "usually pads lead times by 2 days," "aluminum deliveries slipping since Q2"). This is the reference sheet — build it once, update it quarterly.

Tab 2 — PO Tracker

The workhorse. Every purchase order gets a row. Columns: PO#, Supplier, Material/Part, Job# (which customer job this material feeds), Date Ordered, Promised Delivery Date, Actual Delivery Date, Days Late, Production Impact (which job is at risk if this is late), Status (On Track / Late / Delivered). This is where the Monday morning review happens — sort by Promised Delivery Date for this week, flag anything already late, and identify at-risk jobs before production stops.

Tab 3 — Supplier Scorecard

The accountability tab. One row per supplier. Columns: Total POs, On-Time Deliveries, On-Time %, Average Days Late, Trend (↑ improving, → stable, ↓ declining), Last 5 Deliveries (dates + late/on-time for each). This is the data you use for quarterly supplier reviews — and for negotiating. When a supplier drops below 80% on-time, you bring the scorecard to the conversation. "Your on-time rate was 72% last quarter. Our production stopped 4 times because of late deliveries. Here's what we need from you, and here's the backup supplier we'll use if we don't get it."

Tab 4 — Weekly Risk Report

The dashboard you print every Monday morning. Shows: all POs due this week (sorted by date), any POs already late (red), at-risk jobs (which customer orders depend on late materials), and a summary line: "$X,XXX in shop rate at risk this week from late deliveries." This is the one sheet the owner needs to see. Everything else supports this report.

The 10-minute Monday morning protocol

This is the system in practice. Every Monday at 7:30 AM, before the shop floor starts:

1. Open the PO Tracker. Sort by Promised Delivery Date. Everything due this week — scan for suppliers who historically run late (check the Scorecard tab).
2. Flag late POs. Anything where today's date > Promised Delivery Date and Actual Delivery Date is blank. These are your fires.
3. Identify at-risk jobs. For each late or at-risk PO, look at the Production Impact column. Which customer orders depend on this material? Those are the calls you make today — before the customer calls you.
4. Send proactive check-ins. For every PO due this week from a supplier with <85% on-time rate, send a quick email: "Confirming the 14-gauge aluminum for PO#1247 is still on track for Wednesday delivery. This feeds the Acme order due Friday — let me know if anything changes."
5. Print the Weekly Risk Report. One page. Goes to the owner, the production manager, and anyone who talks to customers. Everyone knows what's at risk, and nobody gets blindsided.

How to calculate the true cost of a late delivery

Most shops only count the obvious cost: the idle hours. But a late delivery is a four-part expense, and missing any part means you're under-counting the damage:

For Dave's shop: one late aluminum delivery last month cost $1,275 in idle labor, $340 in expedited shipping from a backup supplier, and delayed a $45,000 customer order by 4 days. The customer still hasn't placed their next order. That's the real cost of not knowing.

The supplier communication templates

The "checking on delivery status" email (send 3 days before promise date)

The "you're late — what's the new ETA?" call script (day of missed delivery)

The quarterly supplier performance review template

Once per quarter, pull the Scorecard tab and send this to every supplier whose on-time rate is below 85%:

Most suppliers have no idea their on-time rate is 72% — they've never seen it quantified. The scorecard changes the conversation from "you're always late" to "here's the data, let's fix it together." And if they won't fix it, you have the data to justify switching.

How to use the scorecard to negotiate with suppliers

The Supplier Scorecard tab is your leverage. When a supplier drops below 80% on-time delivery for two consecutive quarters, you have two moves:

1. Demand improvement with data. "Your on-time rate was 72% in Q2 and 68% in Q3. That's 11 late deliveries out of 40 POs. Each late delivery costs us roughly $1,200 in idle labor and expedited shipping. We need to see 85%+ in Q4, or we'll need to reallocate volume." You're not angry — you're factual. And the data makes it impossible to argue.
2. Switch with confidence. The Supplier Directory tab already has backup suppliers listed. When you've given a supplier two quarters to improve and they haven't, you're not making an emotional decision — you're following the scorecard. The data tells you when it's time to switch, and it justifies the switch to anyone who asks.

For the supplier that does perform — 95%+ on-time, zero drama — the scorecard is also your retention tool. Send them the data once a year: "Your on-time rate was 97% in 2026. We notice. We appreciate it. Here's more volume."

Integrating with QuickBooks

If you use QuickBooks for purchasing, you can cut your data entry time in half:

1. In QuickBooks, go to Reports → Purchases → Open Purchase Orders.
2. Export to Excel/CSV.
3. Copy the PO#, Supplier, Item, and Expected Date columns into the PO Tracker tab.
4. Manually fill in the Job# and Production Impact columns — those are tribal knowledge QuickBooks doesn't have.

This takes about 5 minutes for 20-30 open POs — and it ensures your PO Tracker is never stale because the source data comes from QuickBooks, not from memory.

When to upgrade from the spreadsheet

The spreadsheet system works until you hit these trigger metrics. When you cross any two of them, it's time to look at lightweight procurement tools:

• 50+ active POs at any given time. The spreadsheet gets unwieldy — too many rows to review in 10 minutes on Monday morning.
• 2+ people managing procurement. Spreadsheets get out of sync when multiple people update them. You need a shared system with version control.
• Multi-site operations. Different facilities ordering from the same suppliers need consolidated visibility, not per-site spreadsheets.
• Supplier portal requirement. Large customers or ISO certification audits require formal supplier management processes that a spreadsheet can't document.

Until then? The spreadsheet is the right tool. Don't let anyone sell you a $400/month platform for a problem a Monday morning protocol can solve.

Do this Monday: build the system in 2 hours