Excel Inventory Tracker for Stock In & Out

$12.00

Record stock in and stock out for one location. Check on-hand quantities and low-stock items in Excel. Download a free XLSX sample.

The full edition is awaiting release.

Download sample XLSX10 products · 30 movements

SKU: PS-STOCK-001 Categories: ,

Inside your download

  • Files included

    One XLSX workbook with Stock and Movements worksheets.

    Editable, macro-free and password-free.

  • Excel compatibility

    Tested in Excel for Windows. Uses formulas available in Excel 2016 and later.

    WPS Office compatibility has yet to be verified.

  • Download access

    After payment, use your order email or My downloads.

    No link expiry. Unlimited downloads.

  • Workbook support

    Email the shop with your order number and workbook question.

Description

Stock Desk is an Excel inventory workbook for shops and stockrooms that keep stock in one location. It keeps a list of items on the Stock worksheet and a dated log of receipts and shipments on Movements.

How to track stock in and stock out

  1. On Stock, enter each SKU, its opening quantity and the quantity at which you want to reorder.
  2. On Movements, add one row per receipt or shipment. Enter its date, SKU and quantity. Add the purchase order or shipment reference if you need it later.
  3. Check On hand for the new balance and look for Reorder in the status column. Fix rows marked Check SKU or Check quantity on the movement log before relying on the totals.

A worked example from the workbook

Shipping box BX-101 starts with 100 units. Purchase 001 brings in 20 and Shipment 001 takes out 15, leaving 105. Label roll LB-204 has 12 units left against a reorder point of 15, so Excel marks it Reorder.

Sample and full workbook

  • Sample. Up to 10 products and 30 movement rows. Replace the example entries with a few of your own.
  • Full edition. Up to 250 products and 600 movement rows. Includes the Stock and Movements worksheets in one file.

Both are macro-free .xlsx files designed for Microsoft Excel. This workbook tracks units for one stock location.