COGS and Gross Profits - Advanced / Unallocated Items


Do you have a bar on your COGs report saying "Unallocated"?

The MarketMan COGS report runs on all current inventory items - and calculates how much was spent on each item based on inventory counts, purchases, and transfers. Inventory counts, invoice values, transfers, that can not be connected directly to an inventory item - are grouped.

This report relies on categories heavily, so when we have items with no categories- MarketMan doesn't know where to add them on the report and creates an "Unallocated" bar for you to indicate the costs we don't know where to put. 

 Step 1: Match up your categories - COGs Setup
  1. On your COGs report, click the gear icon on the top right and make sure you're working on the "advanced" mode. 
  2. Add bars to the report as needed by clicking on "Add new"
    You can also change the titles of the existing bars by clicking on the pencil icon:
  3. Drag and drop the POS categories to their reflective bars, on the right side.
    then do the same for inventory categories, on the left.
  4. Save, and refresh the page to see the new breakdown.
    If you still see an "unallocated" bar, head to the next paragraph.
 Step 2: Break down the "Unallocated" - which items are on the list?

To view the list of items, make sure you're closing any COGs breakdown that might be open, by clicking on the X on the top right corner of the breakdown:


Then scroll down to the items table on the bottom, and type the word "unallocated" into the category search box. This will filter to view only the items under the "unallocated" bar:

MarketMan accounts for all inventory movements in the COGS, but if the cost cannot be connected to an active inventory item it will be listed under one of the following options.

  • Unallocated = This means the item doesn't have a category. Make sure to go back into inventory items and add categories to all your items. You can do that in bulk! 
    You should go over new items on a weekly basis to keep your system clean and ready for use!
  • Unallocated - Deleted = This group shows all activity of inventory items that are no longer available for this single buyer or in the chain.

  • Unallocated - Invoice totals = This group shows the differences (if you have any) on invoices- when the items total is different than the total you enter manually at the top. those cannot be allocated to a specific item or category.
    To fix this, click on the calculator to open the logbook for this line, and check out the "purchases" tab. You'll see the list of invoices and can click into them for fixing right from here!

  • Unallocated Invoice rows = This group contains all inventory items added as free text rows in documents, which naturally are not connected to inventory items.
    The same function like invoice totals works here- check your sources to see where it's coming from!
  • Transferred menu items = This group contains all transfers of menu items. Menu item transfer is not broken down to the ingredient level and shows only the value of the transferred Menu item.
    To check the sources list, click on the calculator and navigate to the "Transfers" tab.

  • Transferred sub-recipes = This group contains all transfers of sub-recipes. Sub-recipe transfer is not broken down to the ingredient level.
    To check the sources list, click on the calculator and navigate to the "Transfers" tab.

Was this article helpful?
0 out of 1 found this helpful