On this page
Quick Overview
Separate reported consignment use, physical movements, ownership, and billing approval in a reviewable stock reconciliation.
Consignment stock creates two related questions: where are the goods, and what event makes their use billable? A customer usage statement may answer the second question only after it has been checked against the physical movement record and the agreement. Treating every count difference as consumption can turn an inventory discrepancy into an unsupported charge.
A useful reconciliation keeps ownership, physical quantity, reported use, and billing status separate. The worksheet should make disagreements visible for the inventory, account, and finance owners. It should not decide the commercial treatment on their behalf.
Define the boundary of the consignment account
Identify the customer site, stock owner, storage scope, items, units, and statement period. Record which events the agreement treats as consumption, transfer, return, loss, or another category. The authorized commercial and finance owners should confirm the billable trigger and supporting evidence.
Do not assume all stock at the customer's premises is consigned. Purchased stock, samples, and returnable demonstration items may sit nearby. If a location contains multiple ownership classes, the physical count and usage statement need enough detail to separate them. Otherwise a mathematically balanced total can still allocate stock to the wrong owner.
For product identity, GS1's GTIN guidance (opens in a new tab) describes trade-item identification. The ownership and customer-site dimensions must be maintained separately from the product identifier.
Build the movement bridge
Start with the previously accepted closing balance. Add documented deliveries and approved transfers in. Subtract accepted usage, authorized returns, and approved transfers out. Keep unresolved adjustments on separate lines rather than folding them into consumption.
Record both event date and posting date when they differ. A delivery physically received before period end but posted afterward can explain a timing difference. The agreed cutoff determines which period should contain it; the assistant should preserve the evidence and ask the owner to apply that rule.
| Component | Supporting record | Review question |
|---|---|---|
| Opening stock | Prior accepted reconciliation | Was the starting balance approved? |
| Deliveries | Receipt acknowledgment | Did this site receive the goods? |
| Usage | Customer statement and required evidence | Does it meet the agreed trigger? |
| Returns | Authorized return and movement record | Did stock actually leave? |
| Closing count | Dated physical count | Does the scope match the ledger? |
| Difference | Reconciliation calculation | Is the cause established? |
Explain an illustrative five-unit difference
Suppose the accepted opening balance is 200 units. During the period, the site receives 80 units, reports 55 units of approved consumption, and returns ten units with the required evidence. The expected closing quantity is 215 units: 200 plus 80, less 55 and ten.
The physical count reports 210 units. The five-unit difference is an unresolved discrepancy. It is not automatically five additional units of billable consumption. The reviewer checks for a missed delivery correction, an unrecorded transfer, a return timing issue, a count error, or another supported explanation.
If the customer later supplies an accepted usage record for the five units, the authorized owner decides how to apply it to the statement and billing period. If the difference is a loss, the agreement may call for a different disposition. Preserve that distinction rather than changing the usage line merely to make the bridge balance.
Compare statements at the item and location level
An overall total can conceal offsetting errors. One item may be short while another is over, or one location may have received stock intended for another. Reconcile at the level needed to preserve item identity, ownership, and any required lot or serial traceability.
Keep the customer's original item codes alongside the distributor's mapped SKUs. Confirm units before comparing quantities. A statement of ten cases is not comparable to ten individual units without an approved pack relationship. If the mapping is uncertain, isolate the affected rows instead of accepting the entire statement as reconciled.
The inventory ownership transfer guide is a related reference when a documented event changes ownership. A physical move alone should not be treated as proof that title or billing status changed.
Prepare a decision packet for unresolved rows
For each discrepancy, show the expected quantity, counted quantity, difference, source references, and missing evidence. Assign the person who can resolve the underlying question. A warehouse contact may confirm a count; an account owner may confirm customer acceptance; finance may determine the billing treatment.
Use a review date tied to the business's statement and billing cycle. A proposed follow-up time is a coordination measure, not permission to invoice when the time expires. If evidence remains missing, the owner must decide how to handle the period close under the approved procedure.
Maintain a communication log that records the exact question and response. Repeatedly asking for “confirmation” without identifying the disputed row tends to produce answers that cannot close the case. Send a clear comparison and request the specific record or decision needed.
Keep reconciliation and billing approvals distinct
A quantity bridge can be complete while an invoice remains unapproved. Record both states. The administrator can prepare accepted usage for finance, but should not imply that a balanced worksheet authorizes a charge or resolves a contractual dispute.
At closeout, retain the accepted statement version, movement bridge, physical count evidence, disposition of differences, and finance handoff. If a later correction arrives, link it to the original period rather than silently replacing the closed file. The reviewer should be able to reconstruct what was known at each decision point.
Review recurring causes separately: late statements, missing receipts, wrong units, mixed ownership, and unsupported adjustments suggest different corrective actions. Start with a small account or item group so the procedure can be checked before its scope expands.
Frequently asked questions
Can a customer statement replace a physical count?
That depends on the approved control and agreement. A usage statement and a physical count answer different questions. Record which evidence is required for the period and escalate missing evidence rather than treating the documents as interchangeable.
Should every discrepancy stop all billing?
The authorized finance and account owners should decide whether uncontested rows can proceed. The worksheet should separate supported usage from unresolved rows so that decision is possible without hiding the discrepancy.
Inventory records support can maintain the movement bridge and statement follow-up. Request a consultation with the current statement format and ownership rules to define the administrative role.