Placeholder SKUs

Mango Report
Help Center

Search:

Contents

IndexBookmarkPrint

Home > PDF Reports > Office Exceptions > Placeholder SKUs

Placeholder Value and Fastener Dump SKU review - Office Exceptions
This is an annual report (contained in December's report run) showing:

Placeholder SKU inventory value (typically for the fastener department).
The margin assigned to your fastener dump SKU (the SKU you ring loose fasteners to).
Vendor Minimum P.O. Line amount (only if it's under the recommended minimum).

Please consult with your owner/CPA before making changes to Placeholder value and/or Dump SKU margin as these changes will affect the store's financial reporting.

Placeholder Value Review

Many stores use "placeholder" SKUs to estimate the value of a class of inventory where stock information (quantity on hand) is not kept at the SKU level. Since these Keep Stock Info = N SKUs (Codes tab of Inventory Maintenance) do not have a QOH value, corresponding inventory value (QOH * Cost) is zero dollars. To compensate for this lack of inventory value, stores create a single SKU to represent (or hold) the inventory value for this class of SKUs. Placeholder SKU value should be checked periodically as part of a good inventory valuation process. For example, many stores will use a single placeholder SKU to represent the inventory value of the entire fastener department, for which each individual SKU's Keep Stock Info is set to N.

Caution: adjustments to placeholder SKUs have a dollar-for-dollar change in cost-of-goods-sold and therefore taxable gross profit. Make adjustments with owner/CPA approval.

Setting up Placeholders

Setting Up Placeholder SKUs

What is a Placeholder SKU?
A Placeholder is a special type of SKU which does not represent a specific item, rather it is set up specially to represent (or hold) the inventory value for an entire class or category of inventory for which stock information is not kept. For example, many stores do not keep inventory (QOH's are blank) for their Fastener department so they set up a single "placeholder" SKU which holds the inventory value for the entire department.

Why?
Ending inventory reported by Mango and your Eagle (Business Advisor and RIV) is calculated by multiplying quantity-on-hand times cost for each SKU in your inventory file. If an entire class of SKUs are set to Keep Stock Info = "N" then their quantity-on-hands are blanked out and therefore have zero inventory dollar value. In this case, your store can prop up its inventory with a placeholder SKU so inventory dollar value is not under-reported on its balance sheet.

How?
It's important to set up a Placeholder SKU in a way that Mango can identify so that it does not get reported on your Count Sheets, Cost Exceptions or your Overstock Report! Below are a few rules to follow when setting up Placeholder SKUs.

(optional) SKU = FASTENER (FASTENER is the default SKU for fastener department placeholder. You can continue to use your own SKU if different, or if setting up for a non-fastener class).
Set Rep. Cost and Avg. Cost to $500.00 and Retail to $1000.00.
Last Received and Last Sale date must be blank.
If a Fastener Placeholder then put it in a Fastener Class 580. Or, if the SKU is representing Ace Warehouse inventory then set the appropriate class.
Set the SKU's Location to INVAL
Use Qty on Hand (times cost) to determine the Placeholder's total Inventory Value. For example, to represent $15,000 of inventory then you would set QOH to 30 (30 x $500 = $15,000).

Note: if $500 is too high of an average cost increment then you can use a lower Avg. and Rep. Cost, but keep them above $100.

Special Case - Fastener Speciality Drawers

Pitfalls

Rental - Rental SKUs that carry an inventory balance need to have the location code of "RENT". These SKUs will be specially classified in Mango and will not show up in Obsolete value, Count Sheets, will be treated as Excluded Shrink.

Important - Placeholder SKU
Changes to your store's inventory value (through Placeholders or otherwise) which do not have corresponding sales or receipts will directly affect the store's Cost of Goods Sold equation and therefore its Gross Profit. Adding to net inventory value will generate a one-time Gross Profit event and lowering value will create a loss. Take care before setting up or changing Placeholder SKUs to make sure your owner, bookkeeper, and/or CPA is in sync with this change. Your bookkeepers may already be compensating for this inventory by making adjusting entries.

Many stores will set up a "Dump SKU" to handle both the purchasing and selling activity to the covered class of SKUs. Make sure this SKU is set to Keep Stock Info = N so that it does not accumulate inventory value.

SKUs showing up on this report have a placeholder signature (high static inventory value without a Last Receipt date).

Steps to process report
1) Determine if the listed SKU is a placeholder.
2) If it's not a placeholder (it is a sellable item) then enter an estimated Last Receipt date in Inventory Maintenance (this will keep the SKU from showing up on this report in the future).
3) If it is a placeholder SKU then review its associated inventory value in Mango's Excel IVA report.

If it is a fastener or bulk placeholder then use Mango's Excel IVA report to make sure it is categorized correctly.
If it is classified as type "Fasteners" (or bulk) under the Fast & Bulk tab of Mango's IVA report then it is classified correctly (see example below).
Look at cell F:7 in the IVA's Overview tab. If this percentage is close to 8% then your fastener and bulk values are likely good (for a typical non-lumber store).
If your store is outside this range then consider revaluing your fastener or bulk departments. Please contact us for guidance before going about this!

4) To adjust your placeholder's value, increment or decrement its quantity on hand in Inventory Maintenance using QOH * Cost to estimate its best value (Rep. Cost and Avg. Cost should be made the same).
5) After you have reviewed your placeholder, update its Last Physical Date in Inventory Maintenance to indicate the date the value was reviewed.

Example

Dump SKU Margin Review

Vendor Minimum P.O. Line Amount