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 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 ⚙.
    • Select the Gear icon on the Toolbar.
    • Under Lists, select Products and Services.
    • On the Action column of the Product/Service you want to edit, select Edit.
    • 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

Powered by BetterDocs

Leave a Reply

Your email address will not be published. Required fields are marked *

Skip to content