Excel workbookOfficial Zeyto

Stock Count Sheets and Reorder Planner

An Excel workbook for shops, workshops, distributors and warehouses that count by hand and order from a few suppliers.

Count stock blind and reorder at the right time.

At a glance

  • FormatExcel workbook
  • DeliveryInstant download
  • In the box3 files, 160 KB
  • Works withMicrosoft Excel 2016 or later, Google Sheets or LibreOffice Calc

How it works

  1. BuyPay on Stripe’s secure page.
  2. DownloadYour order page opens at once with a secure link.
  3. Open and useOpen the workbook in Excel and start from the example.

What you get

  • Excel workbook with 8 sheets, up to 300 items
  • ABC classification and reorder points
  • Suggested order quantities by pack size
  • Printable blind count sheet
  • Count variance report with investigate flags
  • Worked example and sample CSV
Files and sizes (3)
  • stock-count-sheets-and-reorder-planner.xlsx155 KB
  • stock-items-sample.csv1.1 KB
  • README.txt4.4 KB

3 files, 160 KB in total. You download them from your order page after payment.

What it does not do

  • You do the counting and copy results into any stock system by hand.
  • Nothing posts to your accounts.
  • It does not connect to a stock system, it assumes average usage (seasonal items need a usage period that reflects.

After you buy

  • Instant downloadYour order page opens right after payment with a secure link for each file. The link is emailed to you too.
  • A fresh link any timeLinks last 48 hours. Enter your order reference and the email you paid with and we will send a new one.
  • Help is one email awayWrite to support@zeyto.app with your order reference. The team answers every enquiry.
  • Fix, replace or refundIf a file is damaged, will not open, or is materially different from its listing, tell us within 7 days of the sale and we will fix it, replace it or refund you.

Find my purchasesContact the Zeyto teamMarketplace terms

Full refund wording

Digital downloads (files, templates, skill packs, guides) are delivered straight away, so they are not refunded once downloaded. If a file is damaged, will not open, or is materially different from its listing, tell us within 7 days of the sale and we will fix it, replace it or refund you.

Applies to products sold by Zeyto itself. None of this takes away rights you have under UAE law.

About this product

Stock problems usually come from two things: not knowing when to reorder, and not checking the shelf against the system. This workbook helps with both.

Read the full description

Stock problems usually come from two things: not knowing when to reorder, and not checking the shelf against the system. This workbook helps with both.

You list your items with unit cost, usage, lead time and on-hand quantity. The workbook ranks them by usage value and assigns A, B and C classes, works out average daily usage, safety stock, a reorder point and an order-up-to level, and shows which items to reorder now and how many to order, rounded to your pack size. A blind Count Sheet hides the system quantity so that counters do not just confirm it. After counting, the Count Variance sheet shows the difference in units and value for each item, flags the ones to investigate and gives a count accuracy.

What is inside:

  • A Setup sheet for the usage period, ABC limits, review period, safety days and count tolerances
  • An Items sheet for up to 300 items with all the calculations
  • A printable Count Sheet, a Count Variance sheet, a Reorder List and an ABC Summary with advice for each class
  • A Worked Example with 12 fictional items (3 flagged items, 2 to reorder now)
  • stock-items-sample.csv with the 12 items
  • Instructions sheet and README

Who it is for: shops, workshops, distributors and warehouses that count stock by hand and order from a few suppliers.

What it is not: it does not connect to a stock system, it assumes average usage (seasonal items need a usage period that reflects the season) and it does not post anything to accounts. If you use Zeyto for stock, you can use this for the physical count and ABC analysis alongside it and copy counted quantities across by hand. No import is built in.

Requirements: Microsoft Excel 2016 or later, Google Sheets or LibreOffice Calc.

Questions

Who is it for?
Shops, workshops, distributors and warehouses that count by hand and order from a few suppliers.
What do I need to use it?
Microsoft Excel 2016 or later, Google Sheets or LibreOffice Calc.
How do I get it?
Pay on Stripe, then download from your order page at once. Links last 48 hours: ask for a fresh one with your order reference and email.
What if the file is wrong?
If a file is damaged, will not open, or is materially different from its listing, tell us within 7 days of the sale and we will fix it, replace it or refund you. Read the terms.

Stock Count Sheets and Reorder Planner: AED 109

Pay once, download at once.

Damaged, will not open or not as listed? Tell us within 7 days and we fix it, replace it or refund you.

Questions before you buy? Contact the Zeyto team. This is sold by Zeyto (Emeron Infospace FZE) itself, not by an independent seller. See the marketplace terms.

Not sure it is the right one?

Works well with

Other official products that cover the same ground or finish the job.