Holding Inventory on Consignment

April 03, 2018 by in category Accounting, Fishbowl Inventory, Inventory Management, QuickBooks with 1
Home > Blog > Holding Inventory on Consignment

If you’re lucky enough to have suppliers who let you hold inventory on consignment, good for you!

Having inventory that you don’t have to pay for until after it’s sold is great for cash flow. However, if you don’t do things right in Fishbowl, consigned inventory is not so great for your accounting records. In fact, it can make a real hash out of your QuickBooks numbers.

To avoid problems, here’s what you need to do…


1. Bring inventory into Fishbowl at its eventual cost.

Logically, you may think that consigned inventory should be brought into Fishbowl at zero cost. After all, until it sells, the cost to you is zero. But if you bring consigned inventory into Fishbowl at zero cost you mess up your costing layers, making it impossible to calculate an accurate cost of goods sold. To keep these calculations accurate you need to use the eventual cost.

2. Create a “Consignment Allowance” account in.

Bringing consigned inventory in at eventual cost solves the cost of goods sold problem but causes another problem. Unless you take additional steps to compensate, your inventory and accounts payable will both be overstated, because they will include the value/cost of inventory that you have not yet purchased.

The solution to this is to create a new account in called “Consignment Allowance.” The balance in this account should be the value of the inventory received on consignment, for which title has not yet transferred. This is a credit balance account that will offset the inventory asset.

3. Modify the bill created in QuickBooks.

Inventory in Fishbowl automatically creates a bill in QuickBooks. Even though the title in this case has not yet transferred, this bill serves as a “place marker” in QuickBooks to remind you that you have this inventory in your possession.

When this bill is created in QuickBooks, your inventory asset and Accounts Payable accounts are both increased (i.e. the bill creates a debit to inventory and a credit to Accounts Payable).

 

However, at this point in time since you have not taken title to this inventory, you do not owe any money to the vendor for it. You therefore need to modify this automatically-created bill so that you zero out this credit to Accounts Payable. To accomplish this:

  1. Open up the bill
  2. Go to the Expenses tab
  3. Enter the amount of the bill as a negative number, and code this to the Consignment Allowance account.

Once you modify the bill in this way your Accounts Payable balance will be an accurate reflection of what you owe, and your Net Inventory balance will be an accurate reflection of what you own.

4. Enter vendor bill into QuickBooks.

Based on the terms of your contract with the consigning vendor, you will periodically send them a report of what has been sold, and they will respond by sending you a bill.

When you receive these bills, keep in mind that they have nothing to do with Fishbowl or your inventory counts; these are strictly Accounts Payable matters. Do not enter anything from these bills into Fishbowl.

When you receive a vendor bill, enter it into QuickBooks using the Consignment Allowance account on the Expenses tab. Do NOT enter this using the individual inventory items on the Items tab. By the time the items have sold, the sale (and its impact on inventory and cost of goods sold) will have already taken place within Fishbowl. You’re just going into QuickBooks to make your final payment for the inventory to which you took title.

Need help with your Fishbowl Implementation?

Not sure about the right way to do things in the Fishbowl/QuickBooks world?

Give us a call! As Fishbowl Inventory Super Heroes, we’re here for you.

Untitled design (1)

Jeanne Tarazevits
CPA, QuickBooks Maven, Fishbowl Guru

As a Top 100 QuickBooks ProAdvisor and Fishbowl Inventory Super Hero, Jeanne helps businesses change the way they do business by getting their inventory management, accounting and manufacturing systems all working together seamlessly. In providing these services Jeanne draws upon her knowledge as a CPA, her previous experience as an Auditor with Ernst & Young and long-time CFO of a publicly-traded medical device manufacturer, and the expertise gained in the 10+ years she has been working with Fishbowl Inventory.

Related Posts

Recent Posts

SUBSCRIBE TO OUR BLOG
All the Essential Fishbowl Accounting Reports You’ve Been Looking for in One Convenient Controller’s Toolbox

Copy of Copy of Untitled Design (4)-1

 

Learn More