OrdersmithyFree toolsOpen PO Health CheckDownload
Free · Download

Your download is starting

Check your downloads folder. If nothing happens in a few seconds, use the button below.

Open_PO_Health_Check.xlsx71 KB · Excel 2019 or Microsoft 365, Google Sheets, LibreOffice Download again

While it downloads

Three steps to your first answer

  1. 1

    Open it

    Double-click to open in Excel, or upload it to Google Drive and open with Google Sheets.

  2. 2

    Paste your open lines

    One row per PO line: supplier, item, quantities, order, ship and arrival dates, and the last supplier update.

  3. 3

    Chase the flagged ones

    Late and at-risk lines get a next action and a follow-up date. Copy the matching message, in English or Chinese, and send.

Seven more follow-ups, in English and Chinese: How to chase a late supplier

When you're ready for more

The Inventory Control Kit

Reorder points, ABC-XYZ, dead and excess stock, a supplier scorecard with real lead times, a purchase plan and PO drafts — one workbook, up to 500 products. One-time $39.

See the kit — $39 Free: Reorder Point Calculator