You're Tracking 50 Purchase Orders in WhatsApp and a Spreadsheet Nobody Updates — Here's the PO Tracking System That Tells You What's Arriving This Week in 5 Minutes
It's Monday morning. You open Shopify and see an order for SKU-284 — the blue one that sells 15 units a week. Your inventory says 3 left. You're pretty sure you ordered more three weeks ago from the supplier in Shenzhen. You search your email for "PO-2847." Six results. Four different conversations. One email from May 28 says "shipped!" Another from June 2 says "delayed 2 weeks." You don't know which one is current. You open WhatsApp — 47 unread messages across 6 supplier chats. Somewhere in there is the tracking number you need.
This isn't a hypothetical. On Reddit's r/procurement, operators running $500K–$3M product businesses admit they track 30–100 open POs across WhatsApp groups, email threads, and "a spreadsheet that nobody updates." They're not bad operators. They're operators who outgrew their systems at around $500K and nobody told them there's a better way.
Why spreadsheets break at 30+ POs
Most product businesses cross the spreadsheet-breaking threshold at around $500K in revenue. Before that, 10–15 open POs are manageable in a single Excel file. After that, five things go wrong:
- No single source of truth. Updates come from email ("shipped!"), WhatsApp ("delayed 2 weeks"), supplier portals, and phone calls. The spreadsheet is the last to know — and often 2 weeks out of date.
- Formatting chaos. The spreadsheet was started by the founder in 2023. Three team members have added their own columns, color codes, and status nomenclature. "SHIPPED??" and "shipped?" mean different things. One person uses green for "received" and another uses green for "ordered."
- No proactive alerts. You don't know a PO is overdue until you go looking. And you only go looking when a customer asks why their order hasn't shipped and you realize the inventory never arrived.
- Supplier communication is siloed. The shipping notice is in Gmail. The commercial invoice is a PDF in WhatsApp. The packing slip is in the box. Three documents, three locations, zero cross-referencing.
- Payment timing is disconnected from receiving. The invoice arrives by email, gets forwarded to "pay this" without checking whether the shipment actually arrived — or arrived complete. You discover you paid for 500 units when 320 arrived three weeks later when someone finally opens the box.
The 3-tier PO tracking system
You don't need $500/month procurement software. You don't need to move your suppliers to a vendor portal they'll never log into. You need a system that gives you a single view of every open PO and tells you what's arriving this week. Here's how to build it.
Tier 1 — Free
Google Sheets Master PO Tracker
Three hours to set up. 30 minutes a week to maintain. $0/month.
Create ONE spreadsheet with these four tabs:
Tab 1 — "Open POs": PO # | Date Created | Supplier | Items Ordered | Qty | Unit Cost | Total | Expected Ship Date | Actual Ship Date | Carrier | Tracking # | Expected Arrival | Actual Arrival | Status | Notes. Status values: Draft, Sent, Acknowledged, In Production, Shipped, In Transit, Received, Inspected, Approved, Paid. Conditional formatting: red if Expected Arrival is past due and Status ≠ Received; yellow if Expected Arrival is within 7 days; green if Status = Received and Inspected.
Tab 2 — "Supplier Directory": Supplier Name | Contact Name | Email | WhatsApp | Payment Terms | Standard Lead Time (days) | Minimum Order | Last Order Date | Notes. When a supplier changes their WhatsApp number, update it ONCE here.
Tab 3 — "This Week": A FILTER view of Tab 1 where Expected Arrival is within the next 7 days AND Status ≠ Received. Print this every Monday morning or pin it as a browser tab.
Tab 4 — "Overdue": FILTER view where Expected Arrival < TODAY and Status ≠ Received. Review every Monday and Wednesday. This is your escalation list.
The key discipline that makes this work: Status must be updated within 24 hours of any change. No exceptions. If a supplier emails "shipped!" — the spreadsheet gets updated TODAY. This one rule is the difference between a PO system and a PO graveyard.
Tier 2 — Automation-lite
Google Sheets + Apps Script + Gmail
One day to set up. $0/month. 5 minutes/day to review the digest.
A Google Apps Script that runs daily at 7am:
- Scans Gmail for shipping notifications from known suppliers (by sender email patterns you define).
- Extracts PO reference, tracking #, and estimated delivery from the email body using regex patterns.
- Auto-updates the corresponding row in "Open POs" tab — Actual Ship Date, Carrier, Tracking #, Status → "Shipped" or "In Transit."
- If no matching PO found (new tracking without a known PO), adds to an "Unmatched Tracking" tab for your review.
- Generates a daily digest email:
Good morning. Here's your PO status for June 18: ✅ 2 POs shipped in the last 24 hours 📦 3 POs arriving this week: Wed: PO-2891 from Acme Corp (2 boxes, 150 units) Thu: PO-2887 from BetaSupply (1 pallet) Fri: PO-2901 from GammaCorp (500 units) ⚠️ 1 PO overdue: PO-2847 from DeltaMfg (was due 6/13 — 5 days late, last update from supplier: "will ship next week") 💰 4 invoices due this week ($18,200 total)
Supplier communication templates you can copy-paste:
PO acknowledgment request: "Hi [Name], confirming receipt of PO-[#] for [qty] units of [product]. Please confirm ship date by [date]. Our PO tracker reference is PO-[#] — please include this in all correspondence. Thanks!"
Status check (7 days before expected ship): "Hi [Name], checking in on PO-[#] scheduled to ship [date]. Please confirm status and updated ETA. Thanks!"
Overdue escalation (3 days past expected ship): "Hi [Name], PO-[#] was scheduled to ship [date] and we haven't received tracking. This is now impacting our inventory availability. Please provide updated ETA and tracking by end of day. If there's an issue, let's solve it — happy to discuss partial shipments or alternatives."
Tier 3 — Full automation
What Jobs Done Labs builds
Single dashboard. Every PO from every supplier. Color-coded. Auto-alerts. $2K–4K one-time.
One screen showing every open PO across every supplier:
- Green: On track — expected arrival confirmed, tracking active.
- Yellow: Approaching ship date — supplier hasn't confirmed yet.
- Red: Overdue — past expected arrival, no update from supplier.
- Gray: Received and inspected — closed.
Auto-follow-up engine: PO acknowledgment reminder at day 2 — status check at 7 days before expected ship — overdue alert at 3 days past expected ship — escalation to supplier management at 10 days overdue.
Invoice matching: Auto-compare supplier invoice vs PO vs actual received quantities. Flag discrepancies before payment. "Invoice says $12,400 for 500 units. PO says $12,400 for 500 units. But we only received 380 — hold payment until discrepancy resolved."
Cash flow forecasting: "You have $24,800 in POs expected to arrive next month. Your projected cash balance on those dates is $31,000. You're clear — with $6,200 headroom."
Supplier performance tracking: On-time delivery %, quality acceptance rate, average lead time accuracy (actual vs promised). Use this data to negotiate better terms with reliable suppliers and put underperformers on notice with real numbers.
How the options compare
| Approach | Setup time | Monthly cost | Alerts | Best for |
|---|---|---|---|---|
| WhatsApp + chaos | 0 (already happening) | $0 | None | Nobody. This is what you're escaping. |
| Tier 1: Google Sheets Master | 3 hours | $0 | Manual (weekly review) | 10–50 open POs, 1–2 people |
| Tier 2: Sheets + Apps Script | 1 day | $0 | Daily email digest | 30–100 open POs, 2–3 people |
| Precoro / Procurify | 2–4 weeks | $300–600 | Yes | 100+ POs, dedicated procurement team |
| Tier 3: Jobs Done Labs custom | 2–4 weeks | $200 maintenance | Full dashboard + auto-alerts | 50–500 POs, growth-stage operators |
The Tier 3 custom build costs $2K–4K one-time. That's paid for by preventing two rush-order emergencies and a single major stockout — events that happen 2–3 times per year in businesses tracking POs across WhatsApp.
Frequently asked questions
What PO numbering system should I use?
Use the format PO-YYYY-NNN — e.g. PO-2026-042 for your 42nd PO of 2026. Clean, sortable, searchable. Avoid supplier-prefixed schemes (ACME-001, BETA-001) — they create conflicts when you change suppliers. Avoid date-only schemes (06182026-01) — they're unreadable. Don't restart numbering each year; sequential across the company lifetime. If you're starting mid-year, pick up from your last existing PO or start at PO-2026-001.
How do I get suppliers to actually acknowledge my POs?
Most suppliers ignore POs because they receive them as casual emails with no structure. Fix: (1) Send the PO as a PDF attachment — it signals "this is a real order, not a conversation." (2) Include a 48-hour acknowledgment deadline in the email body: "Please confirm receipt and ship date by [date+2 days]." (3) If no response in 48 hours, follow up with the escalation template above. (4) For repeat offenders, add acknowledgment terms to your supplier agreement: "Orders not acknowledged within 3 business days may be subject to cancellation." Suppliers who consistently fail to acknowledge POs are the same suppliers who miss ship dates — the acknowledgment rate IS a leading indicator of reliability.
How do I handle partial shipments in my tracker?
A single PO can arrive in 2–4 partial shipments over several weeks. Don't create separate PO numbers for each — that breaks the audit trail. Instead, add a "Qty Received" column and a "Qty Remaining" calculated column. PO status stays "Partially Received" until the last shipment arrives. Add a "Shipments" sub-table or separate tab with Shipment Date | PO # | Items | Qty | Carrier | Tracking # | Condition. The real risk: paying the full invoice after receiving only half the shipment. Always match invoice against actual received quantities before approving payment.
Should I pay before or after receiving the shipment?
After receiving and inspecting — whenever possible. For new suppliers or suppliers with inconsistent quality: 30% deposit with PO, 70% after receiving and inspection. For established suppliers with perfect track records: Net 30 from receipt is standard. Never pay 100% upfront for a first order from a new supplier — no matter how urgent. If you must pay before receiving (common with overseas suppliers), tie payment to the bill of lading or shipping confirmation, not the PO — at least you know the goods left the factory. And always inspect within 48 hours of arrival so you can dispute before the payment window closes.
What if my supplier doesn't give me tracking?
This is more common than you'd think with overseas suppliers who use freight forwarders. The PO tracker still works: update Status to "Shipped" on the supplier's confirmed ship date and set Expected Arrival = Ship Date + standard transit time for that lane (e.g., ocean freight China → US West Coast = 14–21 days port-to-port + 5–7 days to your door). When the shipment arrives, backfill the Actual Arrival date. Over time, you'll build accurate lead time data per supplier — which is actually more useful for planning than tracking numbers. But make tracking numbers a requirement in your supplier agreement: it costs them nothing and dramatically reduces your "where is it?" anxiety.
When should I stop using a spreadsheet and switch to software?
The spreadsheet breaks at roughly 200 open POs or 3+ people updating it. Signs you've outgrown it: spending 2+ hours/week hunting for status, discovering supplier delays through stockouts instead of the tracker, two people updating the same row with conflicting info, or you can't answer "what's arriving this week?" without opening 4 different apps. At that point, you have three options: add Google Apps Script automation (Tier 2, $0/month), buy dedicated PO software ($300–600/month), or build a custom command center with Jobs Done Labs ($2K–4K one-time). The right choice depends on order volume and whether you have bandwidth to implement software. Most businesses under $3M/year do fine with Tier 2.
Free PO workflow audit
We'll map your current PO process across every supplier, identify the 3 biggest revenue-leakage points (late shipments, stockouts, rush-order premiums), and give you a 1-page blueprint plus the Google Sheets Master PO Tracker template — free, 15 minutes, no obligation.
Book your audit →