Reconcile consignment inventory while preserving ownership boundaries

A useful consignment inventory workpaper must let a reviewer reconstruct what entered the schedule, what changed, and what remains open. Record the entity, account, period, currency, source systems, preparer, reviewer, and cutoff. For this workflow, make the location ledger the named control focus. The bookkeeper owns disciplined assembly; the inventory owner keeps authority over ownership and recognition conclusion.

Export the complete population before sorting or cleaning it. Record report names, filters, timestamps, row counts, and control totals. Compare the current population with prior open items and disclose excluded channels or statuses. Preserve the untouched export. A schedule that balances from an incomplete population is still incomplete.

The expected packet includes consignment agreement, location report, sales statement, return record, settlement, and inventory ledger. Give each record a stable reference and capture source, effective date, amount, currency, owner, and approved storage location. Mark unavailable evidence as missing rather than substituting an assumption. Sensitive files should stay in access-controlled systems.

Start from the last reviewed balance, show additions and clearings separately, isolate corrections, and arrive at the current balance. Tie every movement category to its population and evidence references. Keep gross movements visible where netting would hide separate causes or owners. Document formulas, mapping rules, and rounding.

Separate missing records, timing differences, amount mismatches, duplicate records, stale items, and judgment questions. Each exception needs an owner, requested action, due date, age, and financial effect when known. A documented reason is not the same as approval, and silence does not close an exception.

The preparer may reproduce arithmetic, compare observable fields, and draft a question. The preparer should not invent support or decide ownership and recognition conclusion. Route that question to the inventory owner with the evidence reference and the exact decision requested. Record the response and approval under the client policy.

Use named accounts, least privilege, multifactor authentication, and approved storage. Log changes to amounts, mappings, status, owner, and conclusion. Retain the prior value, change reason, person, and time. Reviewers should be able to distinguish a source correction from a workpaper correction.

Reperform the largest items, all manual adjustments, old exceptions, and a mixed sample of ordinary activity. Include cleared, open, and changed-status items. Trace from source to schedule and from schedule back to source. Expand testing when a repeated exception or unexplained mapping appears.

Track evidence retrieval time, first-pass acceptance, exception age, reopenings, and questions routed to the correct owner. Interpret these as workflow signals, not proof of accuracy. A metric should trigger investigation rather than encourage superficial closure. Note unusual volume, system changes, or absent owners.

Retain the scope statement, original exports, evidence index, movement bridge, exception register, reviewer notes, approvals, and change log. Carry forward only genuinely open items. A complete consignment inventory packet explains the population, evidence, movements, exceptions, and decisions without requiring the next reviewer to reconstruct the story from messages.