Skip to content

We've built 200+ tools — open your toolbox, there's something in here you probably need.

← TemplatesWholesale & distribution

Free Purchase Order Tracker (Excel, KES): orders, deliveries and on-time tracking

A wholesaler lives on stock arriving on time, and a forgotten order is a stockout waiting to happen. This free purchase order tracker keeps every PO in one place: log the order, its value, its expected date and its status, and open or closed, days outstanding and an on-time flag are worked out for you.

Choose free basic or KES 500 premium · opens in Excel or Google Sheets
Prefer Google Sheets? You don't need Microsoft Excel →
  1. Download the file above.
  2. Open Google Drive, then New → File upload and choose the file.
  3. Right-click it in Drive → Open with → Google Sheets. It becomes a fully editable Google Sheet — every formula and tab intact — and works on your phone too.

The .xlsx format opens free in Google Sheets, LibreOffice, or Excel for the web — no paid software required.

What's inside

  • Every PO logged with status, value and expected delivery
  • Open or closed, days outstanding and on-time worked out for you
  • An outstanding-orders view with a red LATE flag past the due date
  • Order value and on-time deliveries totalled on the summary
  • KES throughout; only the yellow cells accept typing
  • Works in Excel, WPS or Google Sheets, on a phone too

The tabs

  • Start Here (guide)
  • Suppliers
  • Purchase Orders
  • Outstanding
  • Summary

Yellow cells only. You type in the yellow cells; the rest are locked formulas. Gridlines are off and it prints clean on A4.

Basic vs Premium

The free version does the job. The premium does more of it.

The free basic workbook above is a complete, formula-driven template you can use forever. The premium upgrade adds the extras that turn record-keeping into a management tool.

Basic — Free

  • The core sheets and formulas, in KES
  • Works in Excel or Google Sheets, on your phone
  • Yours to keep, no sign-up

Premium — KES 500

  • A dashboard of orders by status and by supplier with an on-time rate, drawn as bars
  • A per-supplier analysis of spend, outstanding value and reliability
  • A printable A4 one-page purchase order for any PO
  • Kiswahili labels alongside English (Oda, Muuzaji, Inatarajiwa)
Get Premium — KES 500 · Excel (.xlsx) ↓Pay once via M-Pesa (Kenya) · yours to keep · opens in Excel or Google Sheets

On Suppliers, list each supplier once with a contact person, phone and email. On Purchase Orders, log each order with its PO number, date, supplier, a short item summary, value, expected delivery and a status, and fill the date received when it arrives. The Outstanding tab then lists every order not yet fully received, oldest first, with a LATE flag once it is past its expected date.

The Summary counts your orders, their value, what is still outstanding and how many deliveries came on time. Yellow cells are your only inputs and the rest is locked formulas. The premium version adds a dashboard, a per-supplier reliability analysis and a printable A4 one-page purchase order you can send straight to the supplier. Opens in Excel, WPS or Google Sheets.

Do it online instead

Track orders, stock and money with Biashara Yangu

Open the free tool →

Custom work

Need a template made just for you?

Can't find the exact workbook, or want one branded and built around how your business actually runs? We build custom Excel & Google Sheets — bespoke financial models, dashboards, sector trackers, data clean-up and automation. Need it in English or Kiswahili, or another language? Just ask. Tell us what you need and we'll quote.

Frequently asked questions

Is the basic version free?

Yes. The basic purchase order tracker is free to download and keep. The premium upgrade, with a dashboard, a per-supplier analysis and a printable purchase order, is an optional KES 500.

How does the late flag work?

Each order carries an expected delivery date. While an order is still open and today is past that date, the Outstanding tab flags it LATE in red, so you know exactly which suppliers to chase first.

Can I see how reliable each supplier is?

The free version shows on-time and late delivery counts on the summary. The premium analysis goes further, ranking each supplier by spend, outstanding value and on-time delivery rate.