Inventory Adjustment Form Excel Template for Stock Counts

Keep your stock count reviews organized with the Inventory Adjustment Form Excel Template. Compare recorded on-hand quantities with physical counts, identify differences, and review items that fall below your reorder levels in one structured worksheet.

The form includes 49 prepared item rows and 15 columns covering item details, stock quantities, reorder planning, and discontinued status.

FEATURES
- Quantity discrepancy formula: actual item count minus recorded on-hand quantity.
- Discrepancy flag for nonzero quantity differences.
- Reorder flag when recorded on-hand quantity falls below your entered reorder level.
- Fields for item number, last order date, item name, vendor, stock location, and description.
- Fields for reorder level, days per reorder, and item reorder quantity.
- A Yes selection for discontinued items.
- Filterable Excel table with conditional row highlighting and a color key.

HOW TO USE
1. Enter your item details and recorded stock quantities.
2. Add physical item counts and your reorder planning values.
3. Review calculated discrepancies and reorder flags.
4. Use the results to guide your inventory review and adjustments.

SUITABLE FOR
Retail stockrooms, small business inventory reviews, warehouse count checks, and office supply tracking.

FILE CONTENTS
One Excel .xlsx workbook with an Inventory Adjustment Form worksheet and a disclaimer worksheet. The form is supplied blank for your own inventory records. A spreadsheet application is required to use the file. This is a digital template; no physical item is included.