Skip to content

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

LeadAfrik
← TemplatesWholesale & distribution

Free Stock Reorder Calculator (Excel, KES): reorder points and quantities

Ordering too late means empty shelves and lost sales, ordering too early ties up cash you need elsewhere. This free reorder calculator finds the line: enter your current stock, average daily sales, minimum level and supplier lead time, and it works out your days of cover, your projected stock when the order would land, and an automatic REORDER NOW flag the moment a line will drop below its safety floor.

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

  • Days of cover worked out from current stock and daily sales
  • Projected stock at lead-time end, per product
  • Reorder quantity up to your target level, computed for you
  • Automatic REORDER NOW flag in red when a line will run short
  • KES throughout; only the yellow cells accept typing
  • Works in Excel, WPS or Google Sheets, on a phone too

The tabs

  • Start Here (guide)
  • Reorder Calculator
  • 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 reorder dashboard with order value by supplier, drawn as bars
  • A supplier analysis totalling units and value to order per supplier
  • A printable A4 purchase list grouped by supplier
  • Kiswahili labels alongside English (Kuagiza, Salio, Muuzaji)
Get Premium — KES 500 · Excel (.xlsx) ↓Pay once via M-Pesa (Kenya) · yours to keep · opens in Excel or Google Sheets

On Reorder Calculator, list each product with its supplier, unit cost, current stock, minimum (reorder) level, a target level to fill up to, average daily sales and the supplier lead time in days. It computes the demand over the lead time, your projected stock at lead-time end, days of cover, and a reorder quantity that brings you back up to your target.

When projected stock falls below your minimum the Action column flags REORDER NOW in red, and the Summary counts how many lines to order and the total order value in KES. Yellow cells are your only inputs. The premium version adds a dashboard, a supplier analysis and a printable A4 purchase list grouped by supplier, ready to send. Opens in Excel, WPS or Google Sheets.

Do it online instead

Track stock and reorders automatically 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.

Request a custom template or Excel service →Email info@leadafrik.com

Frequently asked questions

Is the basic version free?

Yes. The basic reorder calculator is free to download and keep. The premium upgrade, with a dashboard, a supplier analysis and a printable purchase list grouped by supplier, is an optional KES 500.

How does it decide when to reorder?

It projects your stock forward over the supplier lead time using your average daily sales. If that projected stock falls below your minimum level, the line is flagged REORDER NOW in red and a reorder quantity up to your target level is worked out.

What if I do not know my exact daily sales?

Use a fair estimate to start, for example a week of sales divided by seven. As you refine the figure the days of cover and reorder quantities update on their own, so you can tune it over time.

Tools & templates you may need

Wholesale Inventory Management →Purchase Order Tracker →Supplier Management System →Sales & Invoicing System →Customer Credit Tracker →Daily Cash Flow Tracker →Business Profit Dashboard →Delivery & Dispatch Log →VAT & Tax Tracker →Biashara Yangu — free shop-books app →All templates →

Available in English, with Kiswahili labels in the premium version. Need it in another language, or a custom build? Email info@leadafrik.com.