Consignment Inventory Tracker preview
Consignment Register sheet with columns for product, consignor, location, quantities, costs, commission, and settlement due tracking. 1/4

About this consignment inventory tracker spreadsheet template

This Consignment Inventory Tracker helps businesses manage consignment stock across multiple locations and suppliers. The four-sheet workbook includes a detailed Consignment Register for recording product movements, a Settlement Queue for tracking payments due to consignors, a summary Dashboard for at-a-glance performance metrics, and a Lists & Guide reference sheet with built-in formulas and control rules.

Every cell, column header, and formula is fully editable in WPS Office, Microsoft Excel, and Google Sheets. Replace the sample product data, consignor names, and location labels with your own inventory records, then let the pre-built calculations handle ending quantities, inventory values, commissions, and settlement amounts automatically.

4 structured sheets

Register, settlement queue, dashboard, and reference guide in one workbook.

Automated calculations

Pre-built formulas for ending quantity, inventory value, commission, and settlement due.

Multi-location tracking

Monitor consignment stock and sales across stores and online channels.

Standard XLSX format

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

Frequently asked questions
The Consignment Inventory Tracker template is designed for tracking consignment stock levels, sales, commissions, and settlement payments across multiple suppliers and 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 database; for branded visual documents, adapt the content in Adobe Express.
Download the template, open it in WPS Office, and replace the placeholder product names, consignor details, quantities, costs, and other editable elements 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 retail inventory management, supplier settlement tracking, multi-location stock reporting, and financial reconciliation. It is available for personal and commercial projects, subject to the applicable template license.