Consignment Management with ERP: Stock, Sales, and Reconciliation with Partners

Consignment, or sell-on-behalf arrangements, is very common in Indonesia: small business products are left at souvenir shops and cafes, publishers leave books at bookstores, cosmetics producers leave goods at retail outlets, and suppliers leave stock in distributors' warehouses. For the seller, it is a way into many points of sale without building their own stores. For the host, it is a way to widen the product range without carrying inventory capital.

The problem is that consignment is quietly one of the hardest arrangements to record correctly. The goods are in one party's hands but owned by another. Without tidy records, the seller does not know how much of their stock actually remains in someone else's shop, the shop does not know how much it must pay, and both sides spend a great deal of time on reconciliation and disputes. This article explains how consignment works from both sides and how an ERP keeps it under control.

Summary

• In consignment, ownership of the goods stays with the owner until sold to the end customer; the party holding the goods only stores and sells them
• The ERP must separate own stock from consigned stock, both stock placed with others and stock suppliers place with us
• Key documents: consignment delivery note, periodic sales report, consignment settlement, and return of unsold goods
• Regular reconciliation between system stock and physical stock at the partner's location prevents differences from accumulating
• Consignment margins, risk of damaged or lost goods, and tax treatment must be written into the agreement and discussed with a tax consultant

Two directions of consignment to distinguish

First, you as the owner who places products with another party, for example a producer placing goods at a retail store or a distributor placing goods with resellers. Second, you as the recipient selling a supplier's goods, for example a shop that takes local small business products. Many businesses are in both positions at once. The flows and risks differ, so the ERP must support both.

Outbound consignment: you place goods with another party

When goods are sent to a partner's shop, you do not yet record a sale. What happens is a movement of stock location: from your warehouse to a consignment location in that partner's name. The inventory value remains yours, only separated in reports so it is clear how much is outside. A sale is recognized only when the partner reports the goods sold to the end customer.

The basic flow

1. 01Agreement: selling price, profit share percentage or purchase price to the partner, term, responsibility for damage and loss, and reporting schedule
2. 02Consignment delivery: a delivery note listing items, quantities, and prices, signed by the partner as proof of receipt
3. 03Periodic sales report: the partner sends a list of goods sold, weekly or monthly
4. 04Billing: you issue an invoice based on the reported sales, and the partner pays within terms
5. 05Reconciliation and stock count: system stock is matched against a physical count at the partner's location
6. 06Returns: unsold or damaged goods are taken back and recorded as a return to the warehouse

The weak point is the sales report. If the partner reports late or incompletely, your revenue is delayed and system stock does not match reality. The healthiest way is to integrate the partner's sales data directly, for example through a standard export file imported into the ERP, a simple reporting portal, or even a connection to the partner's cashier system. Integration mechanisms are discussed in the articles on multi-outlet POS systems and B2B customer and supplier portals.

Inbound consignment: you sell a supplier's goods

On the other side, goods received from a supplier do not become your asset. They must not appear as company inventory and do not create a payable until sold. But the system still needs to record their physical presence so cashiers can sell them, the warehouse can count them, and management knows how much of other people's goods is in its custody.

• Receive goods into a consignment location or stock status, separate from own stock
• When goods sell at the cashier or online store, the system automatically records an obligation to the supplier at the agreed price
• Create a periodic settlement report for each supplier: goods sold, amount due, deductions, and remaining stock
• Process payment to the supplier from that report with clear approval, following a flow such as in [purchase approval workflows](/blog/alur-approval-pembelian)
• Record returns of unsold goods to the supplier, including goods damaged in the shop and who bears the loss

The biggest benefit for the host is cash flow: no capital is tied up in stock that may not sell. The risk is shelf space occupied by slow-moving goods. A good system shows the age of consigned stock so non-moving items can be returned early rather than piling up.

What the ERP must record

Separation of stock ownership

Each unit of stock needs an owner attribute. The inventory value report for the balance sheet should include only company-owned stock, including stock placed outside, but not stock consigned by suppliers. Mixing the two is the most common source of financial reporting errors in businesses with consignment arrangements.

Pricing and profit-sharing schemes

Pricing schemes vary: a fixed purchase price per unit, a percentage of the selling price, or tiered rates based on volume. The system must store the terms per partner or supplier and calculate automatically when sales are reported. Price changes need an effective date so old sales do not change with them.

Consistent item codes

Partners often use their own item codes. Without a clear mapping between your codes and theirs, sales reports are hard to match. Discipline in master data, as discussed in ERP master data, solves most of these problems before they arise.

Reconciliation and controlling differences

Differences are the main enemy of consignment. Goods go missing through theft, get damaged in storage, are scanned wrongly, or are sold without being reported. Because the goods are at someone else's location, you cannot watch them daily. What you can do is build a rhythm of checks: periodic physical counts at the partner's location, comparison with system stock, and resolving differences before they grow.

Set in the agreement from the start a reasonable tolerance for differences and who bears differences beyond that limit. An approach to counting without stopping operations is discussed in stock opname without stopping operations. For consignment, cycle counts performed per partner are far more practical than one big annual count.

Impact on cash flow and finance

For the goods owner, consignment holds cash longer: goods have left the warehouse, but money arrives only after they are sold and reported, then billed within terms. In fast growth this can squeeze cash even when sales look good. Monitor the age of consignment receivables and consigned stock turnover separately. A broader discussion of cash monitoring is in ERP and cash flow visibility.

For the host, the opposite happens. Cash is healthier, but obligations to suppliers need monitoring so payments are on time as agreed. Paying small suppliers late, especially small businesses that depend on monthly payments, damages relationships and can send your best products to another shop.

On tax, the treatment of consigned deliveries and sales on behalf of another party may differ depending on the agreement structure and the status of both parties. Consult a tax consultant before settling the scheme, then make sure system invoices and documents follow those rules, in line with the discussion in e-invoicing and tax compliance with ERP.

Consignment and online stores or marketplaces

Businesses selling consigned products online face one extra challenge: stock in the physical shop and online stock come from the same source. If two channels sell the same last unit, customers are disappointed and the goods owner is harmed. Stock synchronization across channels, as discussed in unifying physical store and marketplace stock, is just as important for consigned stock.

Common mistakes

• Recording consignment delivery as a sale so revenue and receivables are booked too early
• Mixing supplier-consigned stock with own stock so inventory value is inflated
• No schedule for physical counts at partner locations, so differences are found only after months
• Agreements without terms on damage, loss, and the deadline for taking goods back
• Partner sales reports arriving in varied formats and being re-keyed manually
• Paying consignment suppliers on estimates instead of verified sales reports

Steps to implement it in an ERP

1. 01Inventory the consignment partners and suppliers with the terms of each agreement
2. 02Create separate consignment locations or stock statuses, per partner for outbound and per supplier for inbound consignment
3. 03Set pricing and profit-sharing rules per partner with effective dates
4. 04Standardize the partner sales report format and prepare a way to import it
5. 05Configure automatic documents: consignment delivery note, invoice from sales report, and settlement report
6. 06Schedule cycle counts per partner and a consigned stock aging report
7. 07Train warehouse, sales, and finance staff so the flow is consistent before adding more partners

Frequently asked questions

When is consignment better than an outright sale? Consignment makes sense for new products untested by the market, seasonal products, or when a partner is reluctant to carry stock capital. An outright sale is simpler and speeds up cash if the partner is willing to buy.

Who bears damaged or lost goods? That is set in the agreement. Generally the party holding the goods is responsible for damage and loss caused by negligence, while unsold goods are taken back by the owner. Write it clearly to avoid disputes.

Does a small business need an ERP for consignment? For a few partners, a disciplined spreadsheet may be enough. Once there are dozens of partners, hundreds of item types, and reports that must be verified routinely, an integrated system saves time and reduces disputes.

How do I manage consignment with many branches? Treat each branch or partner as its own stock location and consolidate at the report level. The principle is in line with multi-branch report consolidation.

Should a host assess its suppliers? Yes. Delivery punctuality, quality, and speed of handling returns deserve assessment, as in supplier management and vendor assessment.

Conclusion

Consignment opens a path to sales growth without large stock capital, but it is healthy only if records are tidy. The key is to separate ownership from stock location, recognize sales only when goods are truly sold, reconcile routinely, and put all terms in the agreement. A properly configured ERP turns this dispute-prone arrangement into a transparent process for both parties.