Inventory Reports

Inventory Reports

Inventory Reports In RTS

This article provides an overview of the various reports available in RTS under Reports > Inventory.
The Inventory Reports in RTS provide comprehensive insights into the status and movement of your inventory, allowing you to track stock levels, sales, and costs effectively. These reports help streamline inventory management, identify trends, and ensure accurate stock control. From tracking sales and inventory discrepancies to assessing costs and remaining stock, these tools support efficient decision-making across various operational levels.

Circuit Details

  1. Reports > Inventory > Circuit Details
The Circuit Details Report provides a comprehensive breakdown of inventory details and sales across locations in the chain. This report helps track inventory levels and sales performance at various locations, giving insights into stock requirements for future periods based on recent sales data.
  1. Set Report Item:
    1. Using this button, you can select Subtotals and individual Items to specify what appears in the report. This feature allows you to customize the data displayed, ensuring the report shows only the most relevant and needed information for your analysis.
  1. Breakdown:
    1. Include Inventory Checkbox: When selected, this option displays the counts of inventory items, helping to track how much stock is available across different locations.
    2. Include Sales Details Checkbox: When selected, this option shows the sales of each inventory item (measured by unit, not dollar amount). This allows users to analyze sales trends and stock performance in detail.
    3. Weeks/Days Stock Needed: The last two columns in the report show the amount of stock that would be needed for a specified number of weeks or days (based on the user's customization). This is calculated using sales data from the last week, Year-to-Date (YTD) sales, and per-day sales.
This report can be customized to show inventory and sales data for different time periods, helping users plan inventory needs based on historical sales performance.




Count Sheet

  1. Reports > Inventory > Count Sheet
The Inventory Count Sheet report displays a comprehensive list of all items in the selected station. This report can be printed and serves as a helpful guide for staff during physical inventory counts. It ensures that inventory checks are conducted efficiently and accurately, allowing for clear tracking of stock levels across different locations.



Conc Sales Vs. Inv

  1. Reports > Inventory > Conc Sales VS. Inv
The Concession Sales vs. Inventory report compares sales data to inventory usage for concession items.
If the "Only Show PerCap Items" checkbox is unchecked, the report displays non-PerCap items (items without the PerCap setting enabled).
When the checkbox is checked, the report focuses only on items with the PerCap setting enabled, functioning the same way as the Sales vs. Inventory (PerCap) report.
  1. Breakdown:
    1. Concession – Individual item, grouped by subtotal.
    2. Begin – Inventory count at the beginning of the selected date range.
    3. Received – Quantity of items received or returned during the date range.
    4. Transf – Quantity of items transferred out via Receive or Return.
    5. Spoil – Total quantity wasted during the date range.
    6. Adjust – Adjustments made via the Correct Inventory function.
    7. Ending – Ending inventory count for the date range.
    8. Term – Quantity sold through terminals/stations.
    9. Phy – Quantity physically removed from inventory (Term - Adjust).
    10. Term ($) – Revenue calculated from Term quantity sold × item price.
    11. Inv ($) – Inventory value removed (Phy quantity × item price).



Cost

  1. Reports > Inventory > Cost
The Inventory Cost report displays the current cost of inventory remaining, broken down per item.
  1. This includes:
    1. Case Size - The number of units in a case.
    2. Case Cost – The cost of a full case of the item.
    3. Per Item Cost – The cost of a single unit.
    4. Inventory Remaining – The quantity currently in inventory.
    5. Remaining Cost – The total cost of the remaining inventory (Cost Per Item × Inventory Remaining).
You can use the Edit Case Size button to adjust the number of items per case. This is helpful for ensuring accurate cost tracking.
Notes
Note: The Edit Case Size feature is not available in Web Reporting.




Cost On Hand

  1. Reports > Inventory > Cost On Hand
The Cost On Hand report shows the total cost of the inventory currently on hand for each location. This provides a quick overview of how much inventory value is present across the circuit.


 

Current Details

  1. Reports > Inventory > Current Details
The Current Details report runs automatically when selected from the Reports menu—it does not have any additional options.
This report provides a detailed view of the current inventory for each stock room and station.



Inventory Remaining

  1. Reports > Inventory > Inventory Remaining
The Inventory Remaining report shows the quantity of each item left in the theater’s inventory and estimates how many days that inventory will last.
The days remaining are calculated based on the item’s sales over the past 35 days by default, though this time frame can be customized by the user.



Order Lookup

  1. Reports > Inventory > Order # Lookup
The Order # Lookup report allows you to view inventory movement based on a specific memo or order number from Actions > Stock/Inventory > Receive or Return.
To use the report, select a date range and click the Load Memo button to display available memo/order numbers.
Then, select the desired entry to view detailed inventory activity associated with that order.




Terminal Sales Vs. Inventory

  1. Reports > Inventory > Terminal Sales vs. Inventory
The Terminal Sales Vs. Inventory report compares item sales recorded at the terminal with actual inventory movement. It helps identify discrepancies between expected and actual inventory usage, allowing for better oversight of shrinkage, spoilage, or data entry errors.
The PerCap items checkbox filters the report to only show items that have the "Use to Calculate Percap" setting enabled. This setting can be managed under Setup > Concessions > Items > Settings.
  1. Breakdown:
    1. Type – Subtotal Category
    2. Item - Name of item.
    3. Price – Sale price per item
    4. Begin – Inventory count at the beginning of the selected date range
    5. Received – Total amount received or returned during the date range
    6. Transf – Quantity transferred out during Receive or Return
    7. Combo – Number of items sold as part of a combo
    8. Spoil – Total quantity of items wasted during the date range
    9. End Count – Inventory count at the end of the date range
    10. Inv Sold – Quantity removed from inventory due to sales
    11. Term Sold – Quantity sold at the terminal
    12. Diff – Difference between Inv Sold and Term Sold
    13. Term $ – Terminal sales value (Term Sold × Price)
    14. Inv $ – Inventory value sold (Inv Sold × Price)
    15. O/S $ – Over/Short amount (difference between Inv $ and Term $)
    16. Spoil $ – Spoiled inventory value (Spoil × Price)
    17. Sales % – Percentage of sales the item contributes to its Subtotal Category

    • Related Articles

    • Deposit Reports

      Deposit Reports This article provides an overview of the various reports available in RTS under Reports > Deposit. The Deposit Reports section consolidates a wide range of sales data, offering insights into daily revenue, payment types, deposit ...

    • Monitor Reports

      Monitor Reports This article details the reporting monitors available under the Reports > Monitors section in RTS. These monitors are designed to provide at-a-glance, real-time (or near real-time) insights into various aspects of your theatre's ...

    • "Deposit - Total" Report

      Deposit Total Report The Deposit Total Report is a comprehensive summary of your location’s most relevant sales data, organized by either Deposit Close or Date Range. Each section of the report covers a different aspect of sales and operational ...

    • Mag Card Reports

      Mag Card Reports This article provides an overview of the various reports available in RTS under Reports > Inventory. This section covers reports related to magnetic stripe cards, including gift cards, loyalty cards, and membership cards. These tools ...

    • Future Kitchen Order Monitor

      Future Kitchen Orders Monitor Reports > Monitors > Future Kitchen Orders Monitor The Future Kitchen Orders Monitor is used to view and manage kitchen orders that are scheduled for future showtimes. This is helpful for planning prep work, ensuring ...