Consignment Brand Inventory Reconciliation Form

This form is used to compare physical consignment inventory with the store system and the brand's records on a defined cadence. It creates a single record for the count, any variance found, and the approval trail. Use it when you need a repeatable reconciliation process instead of ad hoc email updates or spreadsheet notes.

The cadence depends on the consignment agreement and how quickly stock moves, but the template includes a reconciliation cadence field so you can standardize it. Many teams use weekly, monthly, or per-delivery checks. The key is to keep the cadence consistent enough to catch shrink, mis-scans, and transfer errors before they compound.

The person who performs the count should submit the form, and a manager, inventory lead, or brand representative should review it. The review and approval section makes ownership clear and creates an audit trail. If the store and brand both need visibility, you can route a copy to each side after submission.

A variance is any difference between the physical units counted and the units shown in the store system or brand record. The template supports variance type, variance units, and an explanation field so you can classify whether the issue is a count error, receiving issue, transfer mismatch, damage, or shrink. That makes follow-up easier than a simple yes/no discrepancy flag.

It supports a clear audit trail by capturing who submitted the count, who reviewed it, what was found, and what action was taken. That is useful for internal controls, inventory governance, and dispute resolution between the store and the brand. If your process involves PII or customer-linked items, keep the form limited to the minimum necessary data.

Common issues include mixing count methods, leaving the variance explanation too vague, and skipping the corrective action field after a mismatch is found. Another pitfall is counting by SKU in one section and by loose units in another without stating the method. The template works best when the count method is consistent and clearly documented.

Yes. You can add fields for department, vendor, bin location, lot number, or serial number if your consignment process needs them. You can also use conditional logic so variance fields appear only when a mismatch is present, which keeps the form shorter and easier to complete.

Yes. The form can be connected to inventory, ERP, or ticketing tools so submitted counts create a follow-up task or update a reconciliation log. It also works well with notifications to the reviewer when approval is needed. If you use integrations, keep the field mapping simple so the physical count, system count, and brand record remain easy to compare.