Skip to main content

Keg Deposits - Income Account Mapping

Distributor steps for mapping keg deposits in the Income Account Map table: set up empty keg products and Packages Deposits, then full and empty keg income, COGS and deposit accounts. Requires v22.01+.

B
Written by Bailey Naas-Thornton

Minimum Version Required: 22.01

Pre-Conditions

Empty Keg Products

Create a new empty shell product for each size keg that will be sold. When collecting the shell from a customer, this product should be invoiced with a negative quantity.

  • Example Product: Empty 1/2 Keg

Packages Deposits

On the Packages Deposits table, create a new record for each size keg. Creating this record will automatically add the deposit amount on an invoice.

Steps

How to set up Income Account Mapping for Keg Deposits

  1. Using the Universal Search Bar, navigate to the Income Account Map table
    ​
    ​

  2. Click the 'Add Income Account Maps' button
    ​
    ​

  3. Create an Income Account Map for Full Kegs by entering values to all required and applicable optional fields displayed in the ‘Add Income Account Map’ form and click the ‘Add Record’ button when complete.
    ​
    - Company
    ​
    - Income Area
    ​
    - Product Type, Supplier, OR Product
    a. One of these must be filled out. Follow your company’s standard mapping practice.
    ​
    - Income Account
    ​
    - COGS Account
    ​
    - Discount Account
    ​
    - Participation Account
    ​
    - Participation AR Account
    ​
    - Deposit Income Account
    ​
    - Deposit COGS Account
    ​
    ​

  4. Repeat steps 2 and 3 to create an Income Account Map for Empty Kegs
    ​
    NOTE:
    Product Type/Product should relate to an empty keg record
    ​
    ​

Fields And Definitions

Income Account

- Full keg mapping: This is the account that the revenue generated from the liquid being sold will hit.
​
​- Empty keg mapping: The account your company would like to track keg deposits in. Should match the Deposit Income Account on the full keg mapping.
​
​

COGS Account (Cost Of Goods Sold)

- Full keg mapping: The account responsible for the cost of goods sold of the liquid being sold.
​
​- Empty keg mapping: The account your company would like to track the cost of goods sold on keg deposits in. Should match the Deposit COGS Account on the full keg mapping.
​
​

Deposit Income Account

- Full keg mapping: The account your company would like to track keg deposits in. Should match the Income Account on the empty keg mapping.
​
​- Empty keg mapping: Since there is not a deposit associated with the empty keg, this field should not have a financial impact when the keg is returned.
​
​

Deposit COGS Account

- Full keg mapping: The account your company would like to track the cost of goods sold on keg deposits in. Should match the COGS Account on the empty keg mapping.
​
​- Empty keg mapping: Since there is not a deposit associated with the empty keg, this field should not have a financial impact when the keg is returned.

Did this answer your question?