Standard Costs for Labor and Non-Inventoried items

Acctivate can track “standard” costs for non-inventoried items, including Labor, Other Charges and Fees.  A Standard Cost can be provided for each product for each warehouse.  This allows for cost variations for geographic regions.  For example, the standard cost for labor in California is likely higher than Texas.  The standard cost should be specified in stocking units, usually per-each piece.

The Standard Cost will increase (debit) the Cost of Goods account when the non-inventoried item is on a Sales Invoice, including as a kit component.

Non-inventoried items using the Standard Cost Method may be included as a component of an Inventory Assembly transaction.  In this case, the Standard Cost amount will increase (debit) the inventory value of the assembled, finished goods item.

All accounting transactions, including Standard Cost for Non-Inventoried items must have an offset account.  This is commonly referred to as double-entry accounting.  The offset account for Standard Cost for Non-Inventoried items is defined for each Warehouse.  The offset account will accrue the total standard cost (for each item type) until a General Ledger Journal entry is created to clear this account.

Examples for Labor Charges with Standard Cost.  The location in Acctivate Configuration Management is included in parenthesis.

Transaction Debit Account Credit Account
Sales Invoice Accounts Receivable (Branch) Sales / Income (Product Class, etc.)
Sales Invoice Cost of Goods Sold (Product Class) Labor Cost Offset (Warehouse)
Inventory Assembly Inventory Asset (Warehouse) Labor Cost Offset (Warehouse)

The standard cost offset account is cleared by the actual expense such as payroll or a vendor bill.  The actual expense (e.g., payroll) may not match the standard cost.  This discrepancy usually remains in the original expense account (e.g., payroll expense), but may be adjusted through a General Journal entry as well.  Please consult with your accountant to decide how to account for standard cost variance.

Accounts for Labor:

Transaction Debit Account Credit Account
Payroll Check Payroll Expense Bank Account
Journal Entry Labor Cost Offset Payroll Expense

Accounts for Vendor Bill:

Transaction Debit Account Credit Account
Vendor Bill General Expense Accounts Payable
Journal Entry Non-Inventory Cost Offset General Expense

Another option is to use the Management Cost from the product warehouse.  Management Cost is designed for reporting purposes only and will not post to the General Ledger.  The revenue for the non-inventory or labor charge will post from a Sales Invoice, but there will be no Cost of Goods Sold.  The Cost Method should be set to “None” for this method.  Custom Crystal Reports can be created to use the management cost for non-inventoried items.

Configure Cost Offset accounts for Warehouse(s)
Non-inventoried accounts on warehouse

  1. Open Configuration Management from File menu
  2. Select Warehouse under Inventory section.
  3. Click Edit on toolbar
  4. Select the warehouse
  5. Select the Non-inventoried tab under the Warehouse Accounts.
  6. Specify a G/L account for each Item Type

Set Standard Cost for Item(s)
Standard Cost on Warehouse

  1. Open the Product Information window
  2. Select the Inventory tab
  3. Choose Standard from the Cost Method drop-down
  4. Enter the Std (Standard Cost) value on the right.  NOTE: This is the cost per stocking unit.
Posted in Configuration, Inventory - Last modified on May 22, 2019
Still need help?
Search all content on this site, contact support at 817-870-1311, or create a support ticket.