Physical Inventory Count Sheet preview
Count Sheet with SKU, description, UOM, ABC class, book quantity, dual count columns, final count, variance, unit cost, and recount flag fields for bin-level inventory recording. 1/4

About this physical inventory count sheet template

This Physical Inventory Count Sheet template provides a complete four-sheet workbook for warehouse and stockroom inventory reconciliation. The Count Sheet captures bin-level SKU data with book quantities, two independent count columns, final count logic, variance calculations, unit cost, and ABC classification — all organized for systematic physical counting.

The Variance Queue automatically surfaces discrepancies requiring review, while the Inventory Dashboard consolidates variance values by ABC class for management oversight. A detailed Count Guide & Controls sheet documents the blind count workflow, freeze procedures, recount triggers, materiality thresholds, approval steps, and posting rules so every team member follows the same process.

Every cell, label, and formula is fully editable in WPS Office, Microsoft Excel, and Google Sheets. Adjust the currency format, ABC thresholds, and bin numbering to match your warehouse layout and accounting standards.

4 structured sheets

Count Sheet, Variance Queue, Inventory Dashboard, and Count Guide in one workbook.

Built-in variance tracking

Dual count columns, automatic final count, variance quantity, and variance value calculations.

ABC classification ready

Prioritize recounts by ABC class with dashboard-level variance summaries.

Standard XLSX format

Works with WPS Office, Microsoft Excel, Google Sheets, and Apple Numbers.

Frequently asked questions
The Physical Inventory Count Sheet template is designed for warehouse stock counts, inventory reconciliation, and variance analysis. Customize the sample data, bin locations, SKU lists, and other editable elements in WPS Office for your own inventory process.
Use the native XLSX in WPS Office, Microsoft Excel, or Google Sheets. For Notion workflows, reuse the data structure and count logic in a Notion database; for branded visual reports, adapt the dashboard content in Adobe Express.
Download the template, open it in WPS Office, and replace the placeholder SKUs, bin codes, descriptions, quantities, costs, and other editable cells with your own inventory data.
Yes. Select Download to get the editable XLSX file and open it in WPS Office or another compatible spreadsheet application.
Yes. Adapt it for inventory audits, cycle counting programs, stockroom management, and financial reconciliation. It is available for personal and commercial projects, subject to the applicable template license.