cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Intuit

How to record consignment sales

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 suppliers 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 suppliers and classes

Before you can set up consignors as suppliers 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 suppliers, and assign a class to each consignor for reporting purposes.

 

Turn on Class tracking

To turn the Class tracking feature on:

  1. Select the Settings ⚙ icon.
  2. Under Your Company, choose Account and Settings (or Company Settings).
  3. From the left menu, select Advanced.
  4. In the Categories section, select the pencil (edit) Icon to open the fields for editing.
  5. Select the Track classes checkbox.
  6. Select Save.
  7. Select Done.

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

Enter consignors as suppliers

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

  1. Select Expenses and then Suppliers.
  2. Select New Supplier.
  3. Use the fields in the Supplier information dialog to enter the consignor's information.
  4. Select Save.

Repeat these steps until all consignment suppliers 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. Select the Settings ⚙ icon.
  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.

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. Under Company Settings, 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. Select the Settings ⚙ icon.
    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 Cheque 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 customised report showing a breakdown of your consignment sales and payouts.

To create a custom Consignment Sales/Payout report:

  1. Go to the menu and select 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 Customise.
  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 customisation.
  9. In the Custom report name field, enter Consignment Sales/Payout report.
  10. Select Save.

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

Was this helpful?

You must sign in to vote, reply, or post