The deal is closed. Your customer agrees to keep your product stocked on their shelves, pay as they consume, and reorder through you. The pallet leaves your dock on a Tuesday.
Four months later, you have no clean answer to three simple questions: How much of that product is still sitting there? How much has it been used? And how much do they actually owe you?
That is the quiet cost of running consignment inventory management on a spreadsheet and a good relationship. It works until it does not, and by the time it stops working, you have already written off stock, over-ordered replacements, and had a tense phone call with a customer who insists their numbers are right.
What Does Consignment Inventory Actually Mean for a Distributor?
Let's be clear about what we're talking about, because "consignment" gets stretched to cover arrangements that are not really consigned at all.
Under a true consignment arrangement, your product is physically stored at the customer's facility, but you still own it. It sits on your balance sheet. No sale is recorded when the pallet leaves your warehouse. The sale is recorded when the customer reports consumption, which is also when the invoice is generated, and revenue is recognized.
This model shows constantly in industrial distribution, medical and mobility supply, specialty hardware, and any business where the customer wants zero friction at the point of use. It keeps your product in front of the buyer and shortens their purchasing cycle. It also quietly spreads your inventory across locations you cannot see, and that is where the trouble starts.
Why Do Spreadsheets Always Fail at Consignment Tracking?
Here's the thing: the spreadsheet works fine when you have one consignment customer and one SKU. It breaks the moment the program grows.
Take a distributor who believes they have 400 units on hand. What the spreadsheet does not know is that 150 of those units are split across three customer sites, and two of those customers have been consuming faster than they have been reporting. Real available stock is closer to 230. Meanwhile, a buyer has already cut a purchase order for another 100 units because the system said inventory was low.
That is working capital burned on product you did not need, and it is only one symptom. The bigger problem is that general ledger entries, consumption reports, and replenishment decisions are all living in different places. Nobody has a single source of truth. Reconciliation becomes a monthly scramble, and reconciliation errors become write-offs.
Consignment is not a tracking problem you can outrun by being more careful in Excel. It is a systems problem, and it needs to live inside the same database as the rest of your inventory, purchasing, and financials.
How Does Acumatica Handle Inventory Sitting at a Customer Site?
The mechanic that makes consignment work cleanly inside is the virtual warehouse. A virtual warehouse is a logical location, not a physical building, that the system treats exactly like any of your own facilities. Each customer consignment site gets its own virtual warehouse.
Once that is set up, the flow gets simple:
- You ship product to the customer's location, and the system records a transfer from your main warehouse to that customer's virtual warehouse. No sale, no revenue, no change in total inventory value.
- The customer reports consumption on whatever cadence you've agreed on. That triggers the sale, the invoice, and the GL posting automatically.
- Stock at the customer site drops below a threshold you define per item, per location. The system flags it and generates a replenishment transfer without anyone picking up a phone.
Because inventory, sales, purchasing, and financials all sit on the same platform, there is no reconciliation step between modules. When consumption is posted, the cost of goods sold, on-hand quantity, and customer balance all updates in the same transaction. You close the month from one system, not three.
Which Customers Actually Belong on a Consignment Program?
This is the question most distributors skip, and it is the one that separates a profitable consignment program from a slow-bleed one. Not every customer should be on consignment, and a good ERP setup cannot fix bad customer selection.
A useful way to think about it is to sort potential consignment customers on two axes: how predictable their consumption is, and how much volume they run through you. High volume with predictable usage is where consignment pays for itself. Predictable consumption means your replenishment triggers fire when they should. High volume means the working capital you have parked at their site is earning its keep in account retention and order velocity.
A low-volume customer with erratic consumption is a different story. That is the profile most likely to sit on your stock for six months, report sporadically, and generate returns when a contract changes. It is not a character flaw on their part. It is a mismatch between the arrangement and the reality of how they buy.
Before you set up another virtual warehouse, ask: is this customer's consumption predictable enough to define a reorder point, and is their volume high enough to justify the working capital sitting at their site? If the answer to either is no, a standard stocking agreement is almost always the better fit.
NOTE: If you are already running a consignment program and half your sites fall into the low-volume, low-predictability quadrant, that is a conversation worth having before you shop for new software. Sometimes the fix is contractual, not technical.
What Quietly Breaks a Consignment Program Over Time?
Even with the right software and the right customer mix, a few recurring issues will erode a consignment program if nobody pays attention to them:
- Consumption reporting that drifts. Your ERP is only as accurate as the data the customer sends back. Set an explicit reporting cadence in the contract, not in a handshake. For larger customers, push for EDI or a shared portal so consumption posts without a human in the middle.
- Costing and GL decisions made too late. Decide at setup whether consigned inventory rolls up into your main inventory asset account or gets tracked in a subaccount, and how it is valued at the customer location. Fixing this later means reclassification entries and a lot of apology emails to your controller.
- Returns with no clean process. Product Contracts end. Slow movers come back. Your system needs a defined return-transfer path that moves stock back to your main warehouse at the right cost layer, without creating orphaned GL entries or phantom on-hand quantities.
None of these are exotic problems. They are just the places a consignment program slowly loses money if the setup is sloppy.
[IMAGE: Inventory manager reviewing a dashboard with location-based stock levels]
Frequently Asked Questions
Does consignment inventory the same as vendor-managed inventory (VMI)?
No. The two often get mixed up, but they answer different questions. Consignment is about ownership: you own the stock until the customer consumes it. VMI is about responsibility: you manage the replenishment of stock the customer already owns. A program can be one, the other, or both at once.
When does revenue get recognized on consigned stock?
Revenue is recognized when the customer reports consumption, not when the product physically ships. Until consumption is posted, the inventory stays on your balance sheet at cost.
Does consignment inventory belong in the same GL account as regular inventory?
It depends on how your controller wants to see it. Many distributors track consignment stock in a separate subaccount under the main inventory asset account. That keeps visibility without fragmenting the balance sheet. The decision should be made at the setup.
Ready to Put Real Visibility Behind Your Consignment Program?
If your team is still chasing consumption reports and reconciling customer stock on a spreadsheet, the gap between what your books say and what is actually sitting at customer sites is almost certainly wider than you want it to be.
has been helping distributors across the US set up Acumatica for the way their business actually runs, including consignment, virtual warehouses, replenishment rules, and the GL treatment that goes with them.
To walk through how your consignment program would look in Acumatica or call 860-485-0910 x4 to talk to someone on our distribution team.
CAL Business Solutions is an Acumatica and Microsoft Dynamics 365 Business Central implementation partner serving distribution, manufacturing, brick & block, and professional services businesses across the United States. Our team helps distributors configure consignment, virtual warehouses, and multi-location inventory inside Acumatica so stock at every customer site is tracked accurately and the financials follow automatically.