Implementing NetSuite Consignment Inventory Flows Using Transfer Orders and Accrual Accounting

This article is relevant if you are operating a NetSuite-based distribution business and want to implement a consignment inventory model where your company receives goods from suppliers but does not take ownership until the goods are sold.

TL;DR Summary

Consignment inventory flows in NetSuite can be modeled using native constructs such as locations, transfer pricing, and item records without compromising accounting integrity. This article outlines a solution used for a high-scale marketplace client, detailing how to use transfer orders and the gain/loss on transfer pricing feature to track obligations without prematurely recognizing costs.

Background

Consignment inventory offers distributors an attractive financial strategy; by deferring ownership until the point of sale, working capital is preserved. For businesses with significant market power—those operating as major marketplaces or fulfillment hubs—this model enables scalable growth without tying up cash in inventory.  Amazon is the prime example of a marketplace concept and its power as a distributor.

One client approached us with a complex distribution business layered over a custom-built marketplace (similar in concept to Amazon). Vendors listed goods for sale through the electronic platform (independent, but we integrated it with NetSuite), while our client handled fulfillment on consignment terms. The business already had intricate routing logic between locations, optimized to ship goods based on customer proximity. Integrating consignment flows into this environment, while respecting both operational and financial controls, required careful modeling in NetSuite.

Note, I wrote about this model in my earlier article, A NetSuite Consignment Model Using Transfer Pricing for Supplier Obligations and offered up a video discussion.  This article is designed to help through screenshots and alternative architecture diagrams.  Click images to see them full screen.

NetSuite and Consignment Inventory: Platform Capabilities and Patterns

The native NetSuite platform does not offer a pre-configured consignment model; however, its flexible architecture allows one to construct reliable flows that maintain both operational and accounting discipline. The fundamental idea is that goods can be received into a special (logical) inventory location without impacting inventory valuation, and ownership is transferred only when the goods are sold.  The model contemplates the following:

• No immediate ownership: Inventory is held under bailment; no asset is recognized on the balance sheet until a sale occurs.
• Location segregation: NetSuite locations are used to partition consignment inventory from owned inventory.
• Purchase order flexibility: POs can be used to receive items into a consignment location at zero value.
• Triggering liability: Coupling sales orders to trigger transfer orders and their associated costing/pricing mechanisms allows companies to recognize liability precisely when the goods are sold.

We have implemented various patterns to model consignment. In this case, we leveraged transfer pricing capabilities normally used for intercompany operations to drive financial accruals at the moment of fulfillment.  I have written in the past about consignment models that may be valuable to readers:

1. 2023: NetSuite Integrated Multi-Entity Sales Distribution and 3PL Operations: a model where NetSuite acts as a warehouse business connected with a traditional sales organization with 3PL flows.
2. 2021: Automate NetSuite Consignment Sales Obligation Programs:  a consignment model driven by customer invoices or cash sales.
3. 2023: High Performance NetSuite Consignment Sales Applications: a technical orientation with video of the 2021 solution.
4. 2017: Global Logistics Practices for NetSuite Driven Distribution Companies: a model where we send goods we own to a supplier that then manufactures through a multiple-party supply chain.

Our Approach to NetSuite-Based Consignment Programs

The implemented design was enabled by close coordination between our Operations and Accounting practices. The key insight was to use transfer orders between locations to represent the ownership transfer event, and NetSuite’s gain/loss on transfer price feature to create accurate liability accruals. This works well if you are not using NetSuite’s transfer price system for other (conventional) reasons.

Solution Implementation Approach

While there are different models, this one was produced by the following architecture:

1. 1. Enhance Item Record for Consignment Flagging: We configured item records with consignment program attributes. Each item in the program was tied to a single vendor, leveraging the preferred vendor field for clear association.
   2. Predefined Purchase Orders with Zero Value: At contract inception, we used known program quantity and price commitments to create POs.  These were generated with a unit cost of zero and received into a dedicated consignment location. This preserved inventory visibility without affecting the balance sheet.
   3. Transfer Order as Ownership Trigger: During the sales process, the system recognized that the item was consignment-based. This triggered a transfer order from the consignment location to the standard fulfillment location.
   4. Applying Transfer Price as Consignment Cost: We configured a custom transfer price field on the item record to reflect the agreed consignment price. Although the item had zero cost in the source location, the transfer order priced it correctly through our logic. NetSuite’s gain/loss transfer feature was repurposed to book a credit to a liability account (“Consignment Accrual”) and a debit to “Inventory In Transit.”
   5. Item Receipt Captures Inventory Value: When the transfer order receipt was recorded, it moved the item into our standard inventory at the consignment price to debit inventory and to credit “Inventory In Transit.”
   6. Final Fulfillment Drives Cost of Goods Sold: When the item was shipped against the sales order, NetSuite posted standard COGS and inventory entries. Since the item was received at the proper value via the transfer order, the margin was calculated correctly as revenue was at the discretion of the client.
   7. Vendor Bill Automation Using Expense Lines:  We developed a batch-based process to generate vendor bills based on consignment item fulfillments.  These bills referenced expense lines (not item lines) and debited the Consignment Accrual account using metadata from the transfer order fulfillment to ensure accuracy.

Note, in this model, the client had a specific price for the consignment item’s sell-through.  However, it would be just as easy to model a sharing model based on a percentage of the selling price.  The key is to use the sales order as the mechanism to drive the transfer order model.

The consignment model requires several controls to ensure its trustworthy operation.  Thus, the following accompanied the solution.

1. 1. Integrity Controls for Trustworthy Accounting: At month-end, we enforced the following:
      • No consignment location should hold inventory at any cost.
      • All consignment items in transit must be received.
      • All consignment fulfillments must have an associated vendor bill.
      • The consignment accrual account must net to zero or be fully explainable.
   2. Vendor Reporting and Transparency: Given the clean architecture and audit-ready linkages, we produced reports for vendors detailing item performance, fulfillment status, and amounts owed, which is critical for relationship management and trust-building.

NetSuite Leadership and Consignment Solutioning

This solution demonstrates the depth of thinking, technical precision, and accounting rigor that distinguishes our work. It also showcases the value of our unified operations and accounting team approach. The result is not only a robust, scalable design but also a solution that can be replicated or tailored for other clients through our Prolecto Labs initiative.

For executives (CEO, COO, CFO, CIO), this pattern affirms that NetSuite is capable of adapting to business models where standard inventory ownership models don’t apply. With the growing relevance of distributed fulfillment and marketplace-style operations, the ability to manage inventory and liability separately is a strategic differentiator.  NetSuite, in the hands of experts, is quite adaptive to fit creative selling and fulfillment models.

If you found this article relevant, feel free to sign up for notifications to new articles as I post them. If you are ready to implement or evaluate a consignment inventory model in NetSuite, let’s have a conversation.