cancel
Showing results for 
Search instead for 
Did you mean: 
alicewndr17
Level 2

How to set up Consignment as the Consignor

Hi, I have my first Consignment and I am the Consignor. Do I set the Consignee up as a Customer? We ship them xxx amount of products for their inventory and then they send us a report of their sales monthly, minus their fees, etc... then payment to follow shortly thereafter. 

 

Right now I have them set up as a Customer, then when I sent the products to them, I created an invoice. As they sell of some of our products and send us payment, I apply that towards the invoice which of course would still leave a balance until everything is sold. 

 

I have separate item #s assigned for this Consignee and the income account pointed to Consignment Sales. I currently have amounts listed in there for an invoice I recently created. 

 

But then I see in the Chart of Accounts, there is a Consignment Payouts... however, nothing is in there even though I did apply a partial payment to one of the invoices. 

 

I am worried I set this up all wrong and wanted to fix it before I get in too deep. 

 

Thank you for your help!

15 Comments 15
Nick_M
QuickBooks Team

How to set up Consignment as the Consignor

Hi there, alicewndr17. 

 

Thanks for dropping by the Community, I'm happy to help, what you're going to want to do is set them up and record them as vendors and classes, follow along below for the steps:

 

If you sell items on consignment, you can track and generate a report that shows consignment sales you have made and how much you have paid out to consignors.

 

There are four basic steps to this procedure:

  1. Set up consignors as vendors and classes.
  2. Set up consignment income accounts and items.
  3. Record consignment sales and payouts.
  4. Create consignment reports.

The following sections will guide you through the steps needed to complete this process.

Tip:Don't like tracking consignments manually? If you use QuickBooks Online Plus, you can use the built-in inventory feature to make it easier to track consignment sales.

 

1. Set up consignors as vendors and classes:

 

Before you can set up consignors as vendors and classes, you should make sure you have turned on the Class tracking feature. Follow the steps in the following section to turn the feature on, then enter the consignors as vendors, and assign a class to each consignor for reporting purposes.

 

Turn on Class tracking

To turn the Class tracking feature on:

  1. Go to Settings ⚙.
  2. Select Account and Settings.
  3. Select Advanced.
  4. In the Categories section, select Edit ✎ to open the fields.
  5. Select the Track classes checkbox.
  6. Select Save and close.
  7. Select Done.

Class tracking is enabled. The next step is to set up your consignors as vendors.

Enter consignors as vendors

To enter your consignors as vendors, perform the following steps for each of your consignment vendors:

  1. Select Expenses, then Vendors.
  2. Select New Vendor.
  3. Use the fields in the Vendor information dialog to enter the consignor's information.
  4. Select Save and close.

Repeat these steps until all consignment vendors are set up.

The next step is to set up your consignors by Class.

Set up consignors by Class

You can assign each of your consignors to a Class for reporting purposes.

  1. Go to Settings ⚙.
  2. Under Lists, choose All Lists.
  3. Select the Classes item to open the Classes page.
  4. Select New.
  5. Enter the consignor's Name in the Class dialog.
  6. Select Save and close.

Repeat these steps for each of your consignors to set up reporting for your consignors. The next step is to set up the accounts and items that will let you track consignment sales.

 

2. Set up consignment income accounts:

 

Once the consignors are set up, you can create two accounts to help track consignment sales and payouts:

  1. Select Chart of Accounts.
  2. Select New.
  3. In the Account dialog, select Income from the Account Type drop-down list.
  4. From the Detail type drop-down list, select Sales of Product Income.
  5. In the Name field, enter Consignment Sales.
  6. Select Save and Close. You are returned to the Chart of Accounts.
  7. Select New.
  8. In the Account dialog, select Income from the Account Type drop-down list.
  9. From the Detail type drop-down list, select Sales of Product Income.
  10. Enter Consignment Payouts in the Name field.
  11. Select the Is sub-account checkbox and select the Consignment Sales income account you just set up.
  12. Select Save and Close.

The accounts are set up. The next step is to create a Sales item for consignment sales.

Set up Consignment Sales item

Now that you have your accounts set up you are ready to set up the Consignment Sales item.

  1. Go to Settings ⚙.
    1. Select the Gear icon on the Toolbar.
    2. Under Lists, select Products and Services.
    3. On the Action column of the Product/Service you want to edit, select Edit.
    4. Select Save and close.
  2. Select New.
  3. In the Product/Service information panel, select the Service item.
  4. Enter information about the service in the appropriate fields.
  5. In the Income Account drop-down list, select Consignment Sales.
  6. Select Save and Close.

The Consignment Sales item is set up, and you are ready to record consignment sales and payouts.

 

3. Record consignment sales and payouts:

 

You are now set up to sell consignment items and pay consignors.

As you create invoices or sales receipts and record payouts, remember the following:

  • Sales: When you create an Invoice or Sales Receipt, be sure to use the Consignment item for the sale, and to select the appropriate consignor in the Class field..
  • Payouts: When you record a payment Check to a consignor, be sure that the Consignment Payout account is used to record the payout amount, and that the consignor's Class is listed on the same line as the payout account.

4. Create a consignment report:

 

After you have set up consignors and properly recorded sales and payouts, you can create and save a customized report showing a breakdown of your consignment sales and payouts.

To create a custom Consignment Sales/Payout report:

  1. Go to Reports.
  2. In the Business overview section, select the Profit and Loss by Class report to open it.
  3. In the Income section, locate the Consignment Income item and select the amount in the Total column for it.
  4. In the Transaction Report, select Customize.
  5. Set the Report period date range to include all the sales and payouts you want to report on.
  6. In the Rows/Columns section, select Class from the Group by drop-down list.
  7. Select Run report.
    The report is re-run with your settings.
  8. Select Save customization.
  9. In the Custom report name field, enter Consignment Sales/Payout report.
  10. Select Save and close.

This report is now available at any time from the Custom reports tab, available from the Reports page.

The report groups sales, payouts, and ending income by each of the consignors, as well as the total income by all. Non-consignment sales are grouped under the Not Specified class

 

Before doing this, I would recommend reaching out to an accountant as they would be able to make sure everything set up correctly. Thank you for your time and have a nice afternoon. 

alicewndr17
Level 2

How to set up Consignment as the Consignor

But I am the Consignor... so I would set myself up as a Vendor? Would the Consignee be set up as a Customer then? How to track sales if I am the Consignor? Is it the same as you listed?

Fiat Lux - ASIA
Level 15

How to set up Consignment as the Consignor

@alicewndr17 

To consign means to place goods or stock in the inventory of another party, but retaining ownership until the products are sold and the consignee is not required to pay for the goods until after they have been sold. The consignee can even decide to return any leftover stock without worrying about monetary repercussions. QBO has limited features for consigner to manage this operation and you should consider an inventory management app.

 

You should monitor consignment sell-through rates (the percentage of stock that a consignment channel sells) and make decisions based on accurate data only when you use a good consignment inventory management system. The app is designed to assist wholesalers and retailers keep track of consignment stock. You can track exact consignment inventory at a particular location, keep an eye on movements and fluctuations of consignment inventory, and receive up-to-date reorder notification for each consignment channel, giving ultimate visibility for all involved in the consignment supply chain. You will treat consignment inventory as a location. Then you can create a stock transfer to bring products in and create sales orders from that location as they are sold.

 

alicewndr17
Level 2

How to set up Consignment as the Consignor

We are not tracking inventory at the moment. Not sure if this is acceptable but I'll probably just set up the Consignee as a Customer and since I am not tracking inventory, I'll just create an invoice as payment is received for goods sold. That way I have something to apply the payment towards and also able to see what products were sold. 

 

 

NaturalSkin
Level 2

How to set up Consignment as the Consignor

This is not correct accounting. When you create an invoice, you are recording a sale. Consignment is not recognized as income until the consignee sells it. Until then it should be a consignment asset. You are overstating your income, COGS and A/R and understating your inventory.

alan0083
Level 2

How to set up Consignment as the Consignor

i have the same issue and I think you didn't answer the other user's question. We are the consignor which means that the inventory is ours until the consignee sells it.

Fiat Lux - ASIA
Level 15

How to set up Consignment as the Consignor

---

alan0083
Level 2

How to set up Consignment as the Consignor

Thank you! in addition to consignments, i also sell on shopify. if this works, it would be awesome!

Fiat Lux - ASIA
Level 15

How to set up Consignment as the Consignor

@alan0083 

Yes it also supports Shopify.

KK46
Level 1

How to set up Consignment as the Consignor

I followed your steps but it is only showing me the class. Under expenses vendors isn't an option. 

Candice C
QuickBooks Team

How to set up Consignment as the Consignor

Good afternoon, @KK46

 

Thanks for joining in on the thread. I want to make sure that you're able to get through all of these steps so that you're able to get back on track. 

 

I can provide a visual to help you locate the "Vendors" tab in the expenses page of your QuickBooks Online (QBO) account. Here's how: 

 

  1. Go to the Expenses tab on the left-hand menu bar. 
  2. Choose the Vendors option at the top of the page. 
  3. Hit New Vendor

 

 

       4. Type in all the information need and tap Save and Close when done. 

 

That's all there is to it! Also, before doing these steps that my colleague provided, I recommend consulting with your accountant just to be sure this would be best for your business. 

 

Let me know if this helps. I want to ensure that you're taken care of. Should you need any further assistance, don't hesitate to ask. The Community and I are always here to lend a helping hand. Bye for now! 

alihassandxb7
Level 1

How to set up Consignment as the Consignor

 For example X is consigner and Y is consignee. Then who will be the vendor? Is it X or Y?  that we should create under Expenses?

alihassandxb7
Level 1

How to set up Consignment as the Consignor

 For example X is consigner and Y is consignee. Then who will be the vendor? Is it X or Y?  that we should create under Expenses?

DivinaMercy_N
QuickBooks Team

How to set up Consignment as the Consignor

Thanks for joining this conversation, @alihassandxb7.

 

You can set up as the vendor when creating expenses since they are the consignor. The Consignor or seller sends the goods to a buyer or consignee. They also keep the ownership of the product until it is sold. To do so, please follow these steps:

 

  1. Go to the Expenses menu and choose Vendors.
  2. Click the New vendor button.
  3. Enter the necessary details and Save.

 

Once done, you're now ready to create an expense transaction.

 

For additional details about tracking consignment sales, check out this article: How to record consignment sales.

 

Also, in QuickBooks Online (QBO), monitoring your business expenses and accounts payable is a breeze. The program has ready-made vendor reports you can open at any time and customize depending on your business needs. 

 

I'm always here if you need further assistance setting up vendors in QBO. Feel free to post a comment below to notify me of your response. Take care always. 

alihassandxb7
Level 1

How to set up Consignment as the Consignor

It means, me being a consigner, I am sending goods on consignment. Should I still add myself as a vendor on my same company? Please clarify if is it good to go?

And also If you can show an illustration on how to record a consignment transaction in consigner's Book? 

Sign in for the best experience
Ask questions, get answers, and join our large community of QuickBooks users.
Sign In / Sign Up

Need to get in touch?

Contact us