As of January 1, 2024, California has required the implementation of Redemptions on Invoices. These are additional charges for recycling based on volume and container type.

Please see here for more information: https://calrecycle.ca.gov/bevcontainer/wine-spirits/

Vinosmith supports automatically calculating the redemption values for products sold and adding these as line items to Invoices. 

The current implementation was done with support for California, but ostensibly, it could be leveraged by other States / Authorities that require similar behavior.

Tutorial Video

 

How Does It Work?

The result is the automatic insertion of non-inventory "wines" (products)  on Invoices with a currency and quantity amount based on sibling products that contribute to that calculation.

For example, assume you have a glass bottle of 750ML product sold as a 12-pack. According to the CA program, this product has a redemption value of $0.10/bottle. So, if you sold 1 case (12 bottles) of this product, a non-inventory line-item charge of $1.20 should be added to the invoice.

Vinosmith automates the calculation and insertion of this non-inventory item. 

Note: Exempt from Accounts

You can exempt Account(s) from participating in this system by editing the account and toggling their Redemption Enabled flag. Any accounts not enabled for redemption will not have these calculations applied to their invoice. This flag is enabled by default for all Accounts.

This flag can be set one at a time by manually editing an account, or it can be set in batch via the Excel export/import flows.

Getting Started

General steps to activating this feature:

  1. Create one or more Redemption Entries 
  2. For each Product you sell: link it to a single Redemption Entry
  3. Create one or more Non-Inventory Wines that reflect a Redemption Entry
  4. Configure each Supplier

Because Vinosmith groups multiple Supplier Wines across different Invoices, you will need to create Supplier-specific Wines that are, in turn, reflections of each Redemption Entry. Vinosmith provides an automated mechanism for Step 2 above, but if you already have products in your portfolio for this purpose, they can be leveraged.

Step 1: Create one or more Redemption Entries

The first step is to create the top-level redemption entries. You will likely only have 1-3 of these entries for CA.

Navigate to the Wines tab and locate the Redemption Entries: Manage link. 

Proceed to create each entry with a clear and concise name and the per-unit Rate. 

Step 2: For each Product you sell, link it to a single Redemption Entry

Every Product (Wine) you sell that must be included in this calculation must be linked to a single Redemption Entry. 

This is required because when you sell a "Pinot Noir 750ML," Vinosmith needs to know what product reflects this Redemption Entry that needs to be added to that specific Supplier Invoice.

You can link a Wine to a Redemption Entry in multiple ways:

  1. Manually via Edit Wine
  2. Via Wine Properties Excel Import, use the Redemption Entry: Name column.
  3. On the web, use Batch Edit (wines tab, click Batch Edit on the left).

Step 3: Create one or more Non-Inventory "Wines" for each Supplier

Note For Quickbook Integrations - This item must also be created in your Quickbooks for batching invoices. You can create the redemption item in Quickbooks to sync to Vinosmith.  Please edit the item once in Vinosmith to the below-recommended settings.  If you decide to create the item in Vinosmith first, that's fine too.  All you would need to do is create the item in QuickBooks and then map the item. 

In Step 1, you might have created a Redemption Entry like "Bottle / Glass" at $0.05 / unit. Then you linked that Redemption Entry to one of your Pinot Noir 750ML SKUs. Vinosmith needs to know which other non-inventory item should be added to the invoice as a sibling when that product is ordered.

To achieve this - for the same Supplier as the Pinot Noir 750ML, you need to create a new product with these strongly recommended settings:

  1. Inventory Item = unchecked (meaning it is a non-inventory Item)
  2. Orderable by Reps = unchecked (meaning Reps cannot add it to an Order themselves)
  3. Admin Only? = checked

These settings are not required, and the system will work equally without them set this way; it is just a recommendation.

So, you would create a new Wine under the Supplier, ostensibly with the same/similar name as the Redemption Entry, but that's not required. 

This is the product that is added to invoices and is customer-facing.

IMPORTANT: these wines must have an inventory record created for each warehouse you will be invoicing. Create an inventory record with an arbitrarily high quantity.

TIP: A bottle size called "unit" is available for you to use as these non-inventory products. When rendered on invoices, the display will be "1/unit," which is probably more aesthetically pleasing than "1/750ml".

Step 4: Configure each Supplier

Steps 3 and 4 are similar. If you created a Supplier Wine reflecting a Redemption Entry, you most likely want that Supplier enabled for this calculation. But it is a distinct step. Navigate to each Supplier, click Edit and check the box for Redemption Enabled?

After the Supplier has been redemption-enabled, all Redemption Entries and these Supplier-specific "wines" must be mapped. Locate the Redemption Entry Mappings section when viewing the Supplier details. Click Manage in the upper right of that section.

On the mapping screen, you are prompted to choose the single Redemption Entry and map it to the (non-inventory) Wine you created in Step 3. 

Map all that is necessary. It's possible not all redemption entries need to be mapped for this Supplier.

Note on Convenience

Steps 3 and 4 can be tedious if you have a non-trivial number of Suppliers. Both of these can be fully automated within Vinosmith on initial setup.

To have Vinosmith automatically perform Steps 3 and 4:

  1. Create the Redemption Entry
  2. Go back to the Redemption Entry; click Edit on the left
  3. When editing, at the bottom of the edit screen are two buttons. 
  4. The left-most button for Step 1: Add to all Suppliers will perform Steps 3 and 4

That flow will create a non-inventory wine under each supplier with an identical name for the redemption entry.

On that same screen on the right side is a button for Step 2: Attach to all Wines. This flow should be taken carefully; you will likely only do it once.

That flow will link this Redemption Entry to ALL wines, overwriting any current setting. 

This would be useful if the bulk of your products would fall under a generic Redemption Entry (say glass bottles) and you have a handful of products that are a different RE, say a Keg. In this case, you would click that button, and this RE would get linked to ALL of your Products (kegs included). You can now manually edit that much smaller set of products for the Kegs and manually set their Redemption Entry to a different value.

Reporting

All of our reports exclude non-inventory items by default. We do provide an option to include non-inventory items on the report.

RA40 - CRV / Redemption Entry Sales is a simple report calculating a Supplier's CRV sales and units.