About this goods issue log spreadsheet template
This Goods Issue Log template provides a structured system for recording and tracking every stock issue from request through dispatch. The main log sheet captures SKU, description, warehouse location, request and dispatch dates, requested and issued quantities, unit cost, issue value, department or customer, purpose, and status — all in one organized table with sample entries to guide your data entry.
A dedicated Issue Dashboard sheet aggregates key metrics including total transactions, issued quantity, and issued value, with breakdowns by purpose category for quick operational insight. The third sheet documents the full goods issue controls and workflow, listing each lifecycle stage from Request through Dispatch along with rules, owners, steps, actions, and outputs.
Every cell, label, and sample record is fully editable. Open the template in WPS Office, Microsoft Excel, or Google Sheets and adapt the columns, statuses, warehouse names, and currency format to match your organization's inventory processes.
3 integrated sheets
Log, dashboard, and workflow reference work together for end-to-end goods issue tracking.
Built-in dashboard
Auto-summarized metrics for transactions, quantities, and values with purpose breakdowns.
Full lifecycle workflow
Request, pick, authorize, issue, and dispatch stages with defined rules and owners.
Standard XLSX format
Works with WPS Office, Microsoft Excel, Google Sheets, and Apple Numbers.