Consignment Inventory Reconciliation Audit

Inspection template for reconciling consignment and truck-stock counts against system records and work-order usage to identify shrinkage, inventory drift, and documentation gaps across field service vehicles.

Audit Scope and Inventory Snapshot

• Vehicle or consignment location identified
  Record the truck number, asset ID, or consignment site being audited.
• Inventory snapshot timestamp matches audit window
  Capture the system snapshot date/time used for reconciliation.
• Item master and unit-of-measure settings verified
  Confirm the item master, pack size, and unit-of-measure mapping are correct for audited SKUs.
• Audit scope includes all consigned and truck-stock items
  Verify the count includes all stocked parts, kits, and high-value items assigned to the vehicle or site.

Physical Count Verification

• Physical count completed for all audited SKUs
  Confirm each audited SKU was physically counted, not estimated.
• Counted quantity recorded
  Enter the physical quantity counted for the selected SKU or count line.
• High-value or controlled items counted separately
  Verify controlled, serialized, or high-value items were counted and recorded independently.
• Expired, damaged, or obsolete stock identified
  Check whether any unusable stock was found and segregated from usable inventory.
• Physical storage condition supports accurate counts
  Verify stock is organized, labeled, and accessible enough to support accurate counting and retrieval.

System Record Reconciliation

• System quantity captured for audited SKU
  Enter the quantity shown in the system for the same SKU and location.
• Variance calculated and documented
  Enter the variance between physical count and system record.
• Negative on-hand balances reviewed
  Check for negative inventory balances or other system anomalies affecting the reconciliation.
• Open adjustments or transfers reviewed
  Verify pending inventory adjustments, transfers, or returns were reviewed before finalizing the audit.
• Reconciliation method documented
  Select the method used to reconcile physical and system quantities.

Work Order Usage and Transaction Review

• Usage tied to completed work orders
  Confirm consumed parts were issued against completed work orders or service tickets.
• Unposted usage identified
  Check whether any parts were used in the field but not yet posted to the system.
• Returned parts documented
  Verify unused or returned parts were recorded and returned to stock or consignment as applicable.
• Serialized item usage matches work-order records
  Confirm serialized parts or devices match the work-order and transaction history.

Variance Investigation and Corrective Actions

• Root cause identified for material variance
  Describe the most likely cause of the discrepancy, such as mis-picks, posting delays, shrinkage, or unit-of-measure errors.
• Corrective action assigned
  Record the owner and action required to resolve the variance.
• Follow-up date scheduled
  Enter the date/time for recheck, adjustment approval, or follow-up audit.
• Inventory adjustment approved per SOP
  Confirm any write-off, adjustment, or transfer was approved according to the applicable SOP and authorization limits.

Closeout and Sign-Off

• Supporting evidence attached
  Attach photos of count sheets, labeled bins, exceptions, or other supporting evidence as needed.
• Inspector comments complete
  Summarize key findings, exceptions, and any unresolved issues.
• Inspector signature
  Inspector signs to confirm the audit was completed accurately.