VMIConsignmentInventory Reconciliation

Consignment shows stock on both sides but never ties? Unify ownership and the consumption booking point first

The supplier said there are still two hundred units in the consignment warehouse, the workshop said they used them up in the morning; the finance department said this batch hasn't been recorded as accounts payable, the warehouse manager said the goods were shelved a long time ago. Consignment was originally meant to reduce inventory pressure, but it ended up becoming three sets of parallel accounts.

Updated 2026-08-13 ~8 min read Manufacturing digitalization · SRM · Supplier

What you'll take away

  • The contract and system should first clearly specify: the timing of transfer of goods ownership and title, the point when it can be consumed, the trigger for invoicing—missing any of the four points will create chaos.
  • Consumption only recognizes audit events (work order material issuance / line-side deduction / same-source reporting reversal), prohibiting end-of-month estimates and supplier self-reports
  • The invoicing trigger is hard-coded to choose one of three options, and the same supplier and the same warehouse are prohibited from running two sets in parallel.
  • Both parties' portals have the same available quantity and in-transit quantity; differences are visible on the same day, and closing should go through reporting loss/claim/adjustment consumption
  • Before clarifying the consignor, consignment and own-stock warehouses must not be mixed in the same picking strategy

One shelf, three conflicting stories

The consignment warehouse is labeled with the supplier's tag. The warehouse manager issues materials according to 'usable'; the ERP still shows 'pending settlement'; the supplier portal shows 'customer has not used'. In case of material shortage, all three parties will each refresh their own screens—the argument shifts from delivery time to 'who actually has the materials'.

Consignment/VMI moves the inventory location forward and the settlement point backward. When the location is moved forward but the settlement point is not clearly defined, the site will simultaneously feel that 'it looks like there is stock' and 'it can't be used on the accounts.' Each additional set of parallel accounts adds another opportunity for 'favor smoothing'; after smoothing three times, both trust and auditing are damaged.

Write four points into the contract—and into fields

problemCommon optionsConsequences of not writing clearly
Who owns the goods?Supplier / Main Factory / Segment TransferDisputes over inventory loss, insurance, and scrapping responsibilities
When does ownership transfer?Put on shelves / Quality inspection release / Consumption confirmationMismatch between posting date and invoice date
Where can it be used up?Available after release / Sent to the line sideThe available quantity for the whole warehouse does not match
When will the invoice be issued?Write-off of consumption according to consumption / reconciliation confirmation / inventory postingExcel 'translation' system for accounts payable staff

Policy appendices can be short, but system fields must be executable. With only policies and no events, warehouse management will still issue materials based on intuition. If any one of the four points is inconsistent between the contract and system fields, someone will definitely use Excel as a 'translation layer' at the end of the period.

Consumption: events first, estimates out

Reliable sources (by priority):

  1. Work order material issuing scan (bind work order with materials);
  2. Line-side quota deduction (with feedback);
  3. Production reporting reversal (must be originated from MES).

Out of stock: At the end of the month, 'approximately how much was used,' suppliers' salespeople verbally report numbers, and the received quantity is directly counted as consumption.

Random inspection: randomly select a consignment payable and see if you can click to find the consumption timestamp and business order number within one minute. If you can’t, it means invoicing by estimation. Reversals must come from the same source: if MES reporting is modified but WMS edge is not, the available quantities on both sides will grow independently; which side to take as the standard must be fixed and cannot be decided by the on-duty staff on the spot.

Invoice trigger: pick one mode, never mix

ModeForSystem Key Points
Invoice by consumptionHigh-frequency standard partsGenerate settlement sheet from consumption event summary
Issue invoice based on account reconciliation confirmationAmount-sensitive, highly controversialThe invoice can only be issued after both parties have confirmed.
Inventory Posting Consumption Write-offA few 'nominal consignment, but actually recorded' contractsReversal entries should be clear; do not mix with invoices for pure consumption in the same physical warehouse.

For the same supplier and the same warehouse, two sets of triggers run in parallel, and accounts payable should definitely return to Excel after three months. Any changes in the model must announce the effective date, and it should be clearly stated whether historical data is recalculated. Take three samples each before and after the switch: the trigger type on the settlement sheet must match the contract, and it cannot be 'the new model is active, but the old inventory is still estimated according to the old rules.'

UoM, QC, and the consumable sequence

The main factory counts by pieces, suppliers by boxes; at the production line by kilograms, in the warehouse by bags — when the conversion is not frozen, discrepancies appear as 'a little difference every day.' Freeze before going online: inventory units, consumption units, conversion rates, and whether splitting is allowed. The effective date is required for conversion rate changes, and manual adjustments are prohibited on the day of inventory counting.

If receiving still requires IQC:The consumable points must be used after release.Once put on the shelf, consumption occurs immediately, and quality inspection is conducted afterwards, which may result in both accounting and physical rollbacks of 'consumed but returned' items. Consignment items are categorized into 'Pending Inspection' and 'Available' statuses, and consumption events are only allowed on available items. When a quality inspection fails and the items are returned to the supplier or claimed for compensation, it is necessary to reverse the previously incorrectly triggered consumption — without a reversal path, finance can only cover it with adjustment entries.

Who owns replenishment and safety stock

VMI often states 'supplier responsible for replenishment,' yet there is no consumption curve or replenishment suggestion visible to the supplier in the system. The result is: the main factory blames the supplier for stockouts, and the supplier blames the main factory for not providing forecasts. The minimum agreement:

  • The main factory releases consumption and availability (daily or per shift);
  • The supplier responds according to the agreed replenishment lead time and maximum/minimum inventory;
  • If material shortage occurs because the main factory did not release consumption on time, the responsibility code belongs to the main factory; if it is because the supplier did not replenish according to the suggestion, it belongs to the supplier.

Without 'who should replenish, according to what signal,' consignment will only turn into a free warehouse for the main factory. Replenishment suggestions can be rough—rolling three-day consumption, minimum stock only—but they must be visible to both parties, and the reason code for stockout must be recorded as 'signal not sent' or 'no response'.

Variances visible same day; close via one of three paths

Minimal set of rules:

  • The difference in available quantity for both sides can be viewed daily/each shift;
  • Automatically generate differential to-dos above the threshold;
  • Inventory discrepancy mandatory reason codes (theft/loss, measurement, mixing, missed scanning);
  • Closure path: Loss report / Claim / Adjustment of consumption — Silent data modification is prohibited.

Consignment inventory must be counted according to the owner's instructions, and it is forbidden to roughly split it with self-owned stock. Before closing a profit and loss inventory, the supplier side should be able to see pending discrepancies (through the portal or reconciliation package). If the main factory unilaterally changes the available quantity and the supplier discovers it only in the next period, it is a trust killer.

Mixing consigned goods with owned goods is an accident-prone practice. At a minimum: isolate goods by owner, prioritize allocation for the specific owner, and conduct inventory by owner. FIFO/FEFO is effective, butCargo owner correctness takes precedence over batch correctness。

An exit playbook beats a go-live checklist

Supplier exit or project termination: how to buy out/return remaining consignment, how to handle goods in transit, and how to lock accounts for unsettled consumption. VMI without an exit plan usually ends up as 'the goods remain, the contract is gone, and neither side dares to move.' On the exit date, new consumption and new replenishment should be frozen, unsettled accounts and pending discrepancies should be cleared first, and then the buyout price or return shipment can be negotiated—if the order is reversed, the final discrepancy can hang for half a year.

One shelf, one supplier, three SKUs

Forced consumption event postings and daily differences are visible. Over a two-week period, look at: the consistency rate of available quantities on both sides, the number of payables without order numbers, and the duration for closing differences. If the consistency rate is not improving, first check whether consumable points and invoicing triggers are being mixed—expanding SKUs only multiplies confusion by the number of part numbers. If the number of payables without order numbers is not zero, it indicates that invoicing is still bypassing consumption events; if the duration for closing differences is abnormally high, it is most likely because reason codes can be left empty or closing does not require supplier visibility.

The indicators have been poor for two consecutive weeks. First, freeze further position expansion, then go back and check the four-point fields and event sources—don’t use 'another inventory check' to cover up bookkeeping errors.

In-transit, transfer, and multi-warehouse consignment

Consignment doesn't just stop at one shelf. Goods that have been sent by the supplier but not yet shelved, inter-warehouse transfers, and moves between the line side and storage—all these stages must retain the owner of the goods. Whether goods in transit are counted as available to the supplier or in transit for the main factory must be consistent between both parties; if one party counts it as available and the other does not, material shortages will repeat the shelf story.

When consigning multiple warehouses, consumption events need to carry the storage location and plant information. If the group consolidated invoicing ignores the plant dimension, reconciliation with branch plants will not match. Before the transfer is confirmed as completed, consumption in the target warehouse is prohibited—otherwise, it will result in 'the vehicle is still on the way, but the accounts have already deducted consumption'.

Pre-pilot expansion self-test: After the same material is moved from storage to line-side transfer, check whether the owner and consumable status remain continuous; if at any stage it changes to 'self-owned' or 'no owner', mixed picking and invoicing errors will occur within a week.

Close invoice disputes—do not push them to next period

When the consumption has been recorded and the supplier has objections to the unit price or tax rate: freeze the invoicing of the settlement sheet and leave the consumption event unchanged. After the dispute is resolved, generate an adjustment line (to make up the difference or offset), and it is forbidden to directly change the historical consumption quantity for price negotiation. If quantity and price are changed together in one line, no one can clearly tell how much was consumed after three months.

The tax rate/tax-included basis changes must be announced with an effective date; consumption before the effective date follows the old basis, and afterwards follows the new basis. If mixed into the same settlement sheet, it is the second most common 'both sides are correct' scenario in consignment reconciliation.

  • SRM supply solution
  • Arrival and In-Transit Coordination
  • Reconciliation, invoicing, and payment with the same key
  • Two-way confirmation for multi-warehouse transfer

FAQ

Quick answers on this topic—still stuck?Contact

What is the difference between VMI and consignment?

Names are often used interchangeably. What really needs to be clarified is whether the responsibility for restocking, ownership of goods, and invoicing triggers are included in the contract and recorded in the system. If these three points are unclear, any terminology will lead to confusion in the accounts.

Whose scan counts as consumption?

It should be based on the main factory business events (material issuance/online deduction), and the supplier can see the feedback. Supplier's estimated consumption being invoiced again is the biggest pitfall in consignment reconciliation.

Can a consignment warehouse run FIFO?

Yes, but the consignor must be quarantined first: we need to clarify whose goods are correct before discussing the batch sequence.

Who bears inventory shortage?

The contract writes default rules; the system issues discrepancy reports to handle claims or losses. An oral 'split fifty-fifty' will inevitably lead to disputes after three months.

How to pick a small pilot batch?

High consumption frequency, single measurement unit, fixed line-side position. Materials with frequent unit conversions and frequent changeovers are not suitable for the first batch.