Multi Location Stock Reconciliation preview
Reconciliation Register sheet with columns for Date, Location, SKU, Product, Opening, Receipts, Issues, Transfers In, Transfers Out, Expected Qty, Physical Qty, Variance Qty, Unit Cost, Variance Value, Reason, Adjustment Approved?, Status, Owner, and Note. 1/4

About this multi-location stock reconciliation spreadsheet template

This multi-location stock reconciliation template helps inventory controllers, warehouse managers, and finance teams track and reconcile stock across multiple warehouses and retail locations. The four-sheet workbook includes a detailed Reconciliation Register for recording opening balances, receipts, issues, and transfers; an exception queue for flagged variances; a dashboard for location-level variance summaries; and a rules reference guide with formulas and governance thresholds.

Every sheet is fully editable in WPS Office, Microsoft Excel, Google Sheets, and Apple Numbers. Replace the sample SKU data, location names, cost figures, and threshold values with your own inventory records, and the built-in structure will automatically highlight material variances that need investigation or adjustment approval.

4 structured sheets

Register, exception queue, dashboard, and rules guide cover the full reconciliation workflow.

Variance tracking built in

Expected vs. physical quantity comparison with automatic variance value calculation and materiality flags.

Clean dashboard layout

Location-level summaries with variance metrics, decisions, owners, and evidence tracking in one view.

Standard XLSX format

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

Frequently asked questions
The Multi Location Stock Reconciliation template is designed for inventory controllers, warehouse managers, and finance teams to reconcile stock across multiple warehouses and retail locations. Customize the sample text, layout, and other editable elements in WPS Office for your own project.
Use the native XLSX in WPS Office, Microsoft Excel, or Google Sheets. For Notion workflows, reuse the text and structure in a Notion page; for branded visual documents, adapt the content in Adobe Express.
Download the template, open it in WPS Office, and replace the placeholder text, SKU data, location names, cost figures, threshold values, and other editable elements with your own inventory records.
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, month-end stock reconciliation, warehouse performance reviews, and financial reporting. It is available for personal and commercial projects, subject to the applicable template license.