Run Consignment Inventory Reconciliation Audit — Free

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 critical (required)

Capture the system snapshot date/time used for reconciliation.

Note (optional)

Item master and unit-of-measure settings verified critical (required)

Confirm the item master, pack size, and unit-of-measure mapping are correct for audited SKUs.

Yes No N/A

Audit scope includes all consigned and truck-stock items critical (required)

Verify the count includes all stocked parts, kits, and high-value items assigned to the vehicle or site.

Yes No N/A

Physical Count Verification

Physical count completed for all audited SKUs critical (required)

Confirm each audited SKU was physically counted, not estimated.

Yes No N/A

Counted quantity recorded

Enter the physical quantity counted for the selected SKU or count line.

Note (optional)

High-value or controlled items counted separately critical (required)

Verify controlled, serialized, or high-value items were counted and recorded independently.

Yes No N/A

Expired, damaged, or obsolete stock identified

Check whether any unusable stock was found and segregated from usable inventory.

Yes No N/A

Physical storage condition supports accurate counts

Verify stock is organized, labeled, and accessible enough to support accurate counting and retrieval.

Yes No N/A

System Record Reconciliation

System quantity captured for audited SKU

Enter the quantity shown in the system for the same SKU and location.

Note (optional)

Variance calculated and documented

Enter the variance between physical count and system record.

Note (optional)

Negative on-hand balances reviewed critical (required)

Check for negative inventory balances or other system anomalies affecting the reconciliation.

Yes No N/A

Open adjustments or transfers reviewed

Verify pending inventory adjustments, transfers, or returns were reviewed before finalizing the audit.

Yes No N/A

Reconciliation method documented

Select the method used to reconcile physical and system quantities.

Note (optional)

Work Order Usage and Transaction Review

Usage tied to completed work orders critical (required)

Confirm consumed parts were issued against completed work orders or service tickets.

Yes No N/A

Unposted usage identified

Check whether any parts were used in the field but not yet posted to the system.

Yes No N/A

Returned parts documented

Verify unused or returned parts were recorded and returned to stock or consignment as applicable.

Yes No N/A

Serialized item usage matches work-order records critical (required)

Confirm serialized parts or devices match the work-order and transaction history.

Yes No N/A

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 critical (required)

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.

Note (optional)

Inventory adjustment approved per SOP critical (required)

Confirm any write-off, adjustment, or transfer was approved according to the applicable SOP and authorization limits.

Yes No N/A

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 critical (required)

Inspector signs to confirm the audit was completed accurately.

Get your results

Enter your email — we'll send you a PDF of your filled-out template, plus the occasional MangoScoop newsletter (templates, workflow tips, product updates). Unsubscribe anytime — link is in every email.

Email (required)

Your name (optional)

Run: Consignment Inventory Reconciliation Audit

Audit Scope and Inventory Snapshot

Physical Count Verification

System Record Reconciliation

Work Order Usage and Transaction Review

Variance Investigation and Corrective Actions

Closeout and Sign-Off

Get your results