Handle Consignment Inventory

By definition, consignment inventory is inventory stocked in your warehouse, but still owned by your vendor.

The following steps are not intended for tracking inventory at your customers’ locations. Please contact our support team to discuss customer consignment.

In order to track consignment inventory in ACCTivate!, you will need to setup a separate consignment warehouse. This warehouse should be used solely for the purpose of tracking the quantity on hand for the consigned inventory. By setting up the warehouse and processing like below, you will only see an affect on your general ledger once you’ve sold the consigned inventory and created a vendor bill for the amount owed. The following steps outline how to setup the new warehouse, as well as track the consigned inventory through the entire process.

Setup a Consignment Warehouse

  1. In your accounting software, setup a new GL account for the consignment inventory called “Consignment Adjustments” with the account type set to Expense.
  2. Run a synchronization, if in QuickBooks, to bring the new account into the list in ACCTivate!.
  3. Open ACCTivate! and navigate to Configuration Manager (File > Configuration Management).
  4. Select Inventory > Warehouse
  5. Click the New button.
  6. Enter the new warehouse information, such as WarehouseDescription, and Name fields, in a way that sets the consignment warehouse apart from your other warehouses.
  7. In the Warehouse Accounts section, select the new Consignment Adjustment account to all but the Issue GL Account specification.
  8. When you are finished setting up the consignment warehouse, click the Save button. The new warehouse should look something like the screen shot below:
    Consignment Warehouse

Create and Receive Purchase Order for Consignment Vendor

  1. Create a new Purchase Order for the vendor in which you will be tracking the consignment inventory.
  2. Change the Ship To address on the Purchase Order to be the newly created Consignment Warehouse.
  3. Enter the products you wish to track in the Detail tab of the Purchase Order with the price the vendor will charge you once the products are sold.
  4. Receive those products into your Consignment Warehouse. Since both the Inventory and Purchases GL Accounts match, the receipt transaction will net at zero in your general ledger.
    purchase order

 

Selling from the Consignment Warehouse

  1. Create a new Sales Order to sell the consigned inventory to your customer.
  2. Schedule the amount your customer is ordering out of the Consignment Warehouse
  3. When ready, invoice the order.
    sales invoice

Create Vendor Invoice for Sold Quantities from Consignment Inventory

  1. Open the original Purchase Order used to receive these items into your inventory when you receive the Vendor Invoice for the consigned inventory
  2. Click Invoice
  3. Override the Approved Quantity to reflect what’s been sold to your customer.
  4. Click Save and Create Invoice after entering all pertinent information (Invoice Number, Invoice Date, etc.)
    po invoice 1

As you can see, the only difference between processing consignment and regular inventory transactions is the warehouse used. Assigning the proper accounts to the warehouse is key to this process. Below are two screen shots:  one shows the receipt, cost of goods sold, and vendor payable while the other shows the revenue side of the transactions.cost side
Received 50 of the Consignment Product at $20.00 each:

  • Debit Consignment Adjustment Account for $1,000.00
  • Credit Consignment Adjustment Account for $1,000.00

Invoiced 5 of the Consignment Product from Vendor at $20.00 each after selling to your customer:

  • Debit Consignment Adjustment Account for $100.00
  • Credit Accounts Payable Account for $100.00

revenue side1
Invoiced 5 of the Consignment Product for $100.00 each:

  • Debit Accounts Receivable for $500.00
  • Credit Revenue/Sales Income for $500.00
  • Debit Cost of Goods Sold for $100.00
  • Credit Consignment Adjustments Account for $100.00

This leaves a liability to your vendor via the Vendor Bill, as well as adds to your Income based on the difference between the sale price and vendor cost.

 

Posted in Inventory - Last modified on June 2, 2014Lauren Stine
Still need help?
Search all content on this site, contact support at 817-870-1311, or create a support request.