How do I enter & post a regular Inventory?

This article provides information and steps to enter and post a regular inventory through the web browser for Decision Logic’s platform.

Overview

Inventory is a complete list of all the items or raw materials required to prepare dishes, including food, ingredients, prepped items, spices, paper items, cleaning supplies, linens, merchandise, liquor, beverages, etc.  Counting inventory helps track the ingredients coming in and out of your restaurant.

Hot item inventory are daily counts that occur at the beginning of each day before sales are entered into the Point of Sale (POS).  This type of inventory is different from regular inventory.  Check out this article for more information about Hot Item Inventory.

Decision Logic provides two avenues when entering and posting inventory:

Users can add Notes to an Inventory Set which will appear on the web platform and Digital Manager when taking inventory.

Table of Contents

For additional questions or assistance, please submit a support ticket by visiting the Decision Logic Service Center.

Video

Check out this video on entering and posting regular inventory or keeping reading.

 

When to Count & Post Inventory

Each brand determines the frequency stores should count and post regular inventory. For example, weekly, monthly, bi-monthly, quarterly, etc. Stores must have at least two inventories entered into Decision Logic’s platform for reports and variance to populate and be accurate. 

Missed inventory will result in inaccurate data for reporting. This prevents operators from making informed decisions for their store(s). If your store must skip counting inventory, they will still need to Post a zeroed inventory.

Reports that are affected are:

  • Cost of Goods Sold (COGS)

  • Ideal vs. Actual Usage (IvA)

  • Theoretical vs. Actual Usage (TvA)

  • Cost & Variance

  • Shelf Extensions


Typically brands define a ‘week’ as Monday - Sunday, with Monday morning being the day ‘regular inventory' is posted.

For example:

Monday - Sunday is the week defined. Monday is regular inventory day. Operators can count after the closing of business on Sunday or early Monday morning. They will post Monday morning after sales have been imported from Sunday and before sales are entered on the POS Monday morning.

The key takeaway is users should post the morning of the regular inventory day. All sales from the previous day need to be imported into Decision Logic’s platform before posting. 

 

If a brand wants to change the day of their inventory cycle, which is their calendar management, they need to contact the Decision Logic Service Center.

 

 

Enter & Post Inventory

 

Inventory items may be counted in multiple locations. Decision Logic’s platform will sum all the counts entered for items counted in multiple locations. Follow the steps below to enter and post regular inventory.

Navigate to:

Operations > Inventory > Inventory Home

  1. Select a Store if you have access to multiple locations.

  2. Define the Date Range. The results show:

    1. Type of inventory, such as regular or Hot Item Inventory.

      1. Flame Icon:  represents Hot Item Inventory and will appear on the Hot Item Inventory guide.

    2. Date inventory should be taken and posted.

    3. Status of an inventory, such as In-Process or Posted.

    4. Start date of an inventory in process or posted.

    5. Who started the inventory.

    6. When the inventory was Posted.

    7. Who posted inventory.

    8. Any Change Requests submitted.

    9. Action item options.

  3. Click Enter Inventory.

     

  4. Select the Inventory Type ‘regular inventory’.

  5. Select the Inventory Date. Only the dates available to post inventory will appear. Additionally, there is a legend notating the status of post inventory dates for the month.

    1. Red:  The current date.

    2. Light blue:  Inventory is in process and needs completing.

    3. Yellow:  Inventory is in review and needs completing.

    4. Green:  Inventory has been posted.

    5. Dark blue:  Inventory date that is selected.

  6. Click Next.

     

  7. Input the Quantity amount based on the measurement provided.

    1. Users can view Notes if they are entered on the Inventory Set.

  8. Click Review.

  9. Items with quantities outside of the defined variance threshold will appear. If the page is blank, then Decision Logic’s system does not see an error when comparing to the most recent two inventories posted. Review and make changes if needed, and click Post Inventory.

 

Example of blank review page when items are within the defined variance threshold.

 

 

Users who have edit permission can make changes to posted inventories.  Users who do not have edit permissions will need to submit a Change Request to update a posted inventory.  Check out this article on how to submit a Change Request.

 

 

Calculations

Below are calculations configured when entering inventory through the Inventory Home page.

Metric

Formula

Extended Price Total

(Inventory Quantity / Inventory Multiplier) x last received bid file price

Actual Usage

Beginning Inventory + Orders Received - Ending Inventory

 



If you'd like to receive news on software releases and product updates, please sign up for our email list.