Deposit Reports

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 totals, and other financial details. These reports help track and reconcile deposits by breaking down sales transactions, tax amounts, and payment methods.
Whether monitoring daily cash flow or auditing deposits, these reports provide essential financial transparency for accurate record-keeping and reporting.

Advance Ticketing Details

  1. Reports > Deposit > Advance Ticketing Details
The Advanced Ticketing Details Report displays Advanced or Matured ticket sales for the selected date. This means it only includes tickets purchased on that specific date.
  1. Advanced Sales – Tickets purchased for future showtimes.
  2. Matured Sales – Tickets originally purchased as Advanced Sales but have since been picked up.
You will be prompted with a Date selection, as well as a toggle to display Advanced and/or Matured sales.
After selecting the appropriate settings, you can select View to display the report.



  1. Report Breakdown
    1. Advance Ticket Details – Displays information such as the film name and showtime date/time associated with the purchase.
    2. Ticket Type – Displays the name of the ticket sold for the showtime.
    3. Ticket Net – The base price of the ticket before sales tax is applied.
    4. Tax 1 and Tax 2 – Tickets can have up to two separate tax amounts assigned. This section breaks them out individually.
    5. Ticket Price – Displays the total price per ticket, including any applicable taxes.
    6. Sold – The number of tickets sold for the showtime.
    7. Net Sales – The total sales amount before tax, calculated by multiplying the Ticket Net by the number of tickets sold.
    8. Tax – The total amount of tax collected for the sales.
    9. Gross Sales – The final total after tax, which includes both Net Sales and collected taxes.


To see Advanced Sales over a range of dates:
  1. Go to Actions > Advanced Ticket Search > More Options
  2. Select the desired date range, movie title, or other filters
Notes
Note: The Advanced Ticket Search window is not a report, but its data can be exported.
For a report that only includes Advanced Sales before a specific date:
  1. Navigate to Reports > Tickets > Advanced Sales

API Sales

  1. Reports > Deposit > API Sales
The API Sales Report provides a breakdown of sales generated through a specific API or third-party service.
This is useful for seeing specific sales data from some of the common third party integrators with RTS: Fandango, MobileMovieGoing, TheaterToolkit, BoxOffice, Atom, and more.
  1. Report Types
    1. Summary – Displays the total sales from each selected location for the specified date range.
    2. By Month – Breaks down total sales per month for each selected location.
    3. By Day - Breaks down total sales per day for each selected location.
    4. If a selected location or month does not appear in the report, it means the total sales for that selection is zero.
  1. API Fee Calculation
    1. Checking the Include Percent Calc box and entering a percentage will apply an API fee calculation to the report.
    2. The default API fee is 2.75%, but this can be adjusted to any value.
    3. The calculated fee amount is displayed and reflected in the Final Total.


API Sales Report - Report Type: Summary


API Sales Report - Report Type:  By Month


API Sales Report - Report Type: By Day



Average Guest Count

  1. Reports > Deposit > Avg Restaurant Guests
The Average Guest Count Report calculates the average number of guests using Tabs in Restaurant Mode for any enabled day.
  1. Key Details:
    1. To generate an average guest count, more than one day or a period longer than one week must be enabled.
    2. If only one day is selected, the average guest count and total guest count will be the same.
    3. The report displays hourly guest counts in both numerical and graphical formats.
    4. It also factors in the layout type in Restaurant Mode to show Net Sales for different table areas.
Notes
If Include Details is set to TRUE, the report will display guest count, net sales, and location for each employee.
This data is further broken down by table location, based on the layout in Restaurant Mode.
  1. Hours to Include Configuration:
    1. The Hours to Include Config lists all available hours.
    2. Users can uncheck specific hours to exclude them from the report.
    3. Example: If 8 AM tickets should not appear, unchecking 8 AM will make the report start at 9 AM.

Average Guest Counts With Graphical Display

Include Details Option with Additional Data Breakdowns


Bank Deposits (Cash/Credit Deposit)

  1. Reports > Deposit > Bank Deposit
    1. Select either Cash Deposit or Credit Deposit
  1. The Cash Deposit Report provides a record of each deposit made, including:
    1. The total deposit amount
    2. The date and time of the deposit
  2. The Credit Card Deposit Report details batch amounts for each credit card deposit submitted to the payment processor, including:
    1. The date and time of the batch submission.
    2. A breakdown by Visa, MasterCard, Discover, and separately, American Express.
    3. The last four digits indicating the batch number.
Notes
Note: Most locations using EMV/Secure Card Readers will have two separate processing accounts:
  1. Retail Transactions (in-person sales)
  2. Online/ECOMM Transactions (e-commerce sales)
As a result, there may be multiple Credit Card Deposit entries per day, with separate amounts for each processing account.


Credit Card Deposit Report Example


Bank Deposit Report Example



Comp Details

  1. Reports > Deposit > Comp Details
The Comp Details Report provides a detailed breakdown of all comps issued within the selected date range.
It includes:
  1. Time – When the comp was applied
  2. Receipt – The transaction number associated with the comp
  3. Type - The reason for the comp (e.g., Employee Discount, Server Error, etc.)
  4. Amount – The total value of the comp
  5. Comp User – The employee who performed the comp
  6. Tab User - The Employee who finished the tab if using Restaurant Mode.
  7. Reason – Any additional explanation provided for the comp (if applicable)

Comp Usage

  1. Reports -> Deposit -> Comp Usage
The Comp Usage Report provides a general overview of how employees are applying comps within the system.
It helps identify usage patterns and monitor discount activity.
    1. Report Breakdown
      1. Entry Time – The date and time when the comp was applied.
      2. Comp Type – The name of the comp used (e.g., Employee Discount, Server Error).
      3. Comped Item – Displays the item name if an individual item was comped instead of the full order.
      4. Comped Tab – Indicates TRUE if the entire order was comped, or FALSE if only a portion was.
      5. Authorizing Employee – The employee who applied the comp to the order.



Concession Hourly

  1. Reports > Deposit > Concession Hourly
The Concession Hourly Report displays sales data broken down by specific time intervals throughout the day.
These time segments and subtotals help analyze concession performance during different parts of the day.
  1. Configuring the Report
    1. Time sections and subtotal groups are configured through the Configure Groups window in RTS.
    2. You can customize:
      1. The time ranges used in the report (e.g., 11am–2pm, 2pm–5pm).
      2. The subtotal categories shown in the report.
  2. Web Reporting Limitation
    1. Group configuration and settings cannot be edited in Web Reporting. These adjustments must be made directly within RTS.
  3. Setting Up Subtotals and Items
    1. Subtotal categories are created in Setup > Concessions > Subtotals
    2. Items are assigned to subtotal groups via Setup > Concessions > Items



Concession Summary Report

  1. Reports -> Deposit -> Concession Summary
The Concession Summary Report is used to compare sales of concession items over various time periods.
This report helps identify trends and performance across different intervals.
  1. Loading the Report
    1. To display concession item data in the Concession Summary Report, you must first click the Load Data button.
    2. This action will populate the list of available Subtotals and Items based on the selected time range.
  2. Selecting Data to View
    1. To view a Subtotal, simply check the box next to its name.
    2. To view specific Items within a Subtotal:
      1. Click the + (Plus) icon next to the Subtotal to expand the list.
      2. Check the boxes next to the individual items you wish to include.
  3. View Options
    1. The report can be viewed by:
      1. Day
      2. Week
      3. Month
      4. Year
      5. Total Summary
    2. Once you select the Report Type view option, click View to generate the report.





Concession Totals

  1. Reports >  Deposit > Concession Totals
The Concession Totals Report provides a summary of concession sales broken down by category.
  1. For each selected category, the report displays:
    1. Units – The total quantity of items sold
    2. Sales – The total dollar amount of sales in that category
  1. Category Setup
    1. The categories listed on the right side of the report can be customized in RTS:
      1. Setup > Concessions > Subtotals – Create and manage subtotal categories
      2. Setup > Concessions > Items – Assign concession items to specific subtotal groups



  1. Reports > Deposit > Credit Card Search
The Credit Card Search Report is used to locate credit card transactions using the last four digits of a card number.
  1. How to Use the Report:
    1. Initial View:
      1. When the report window opens:
      2. The Transaction Details panel (right side) and the Date and Time panel (bottom left) will both be empty.
  2. Search by Card Number:
    1. Enter the last four digits of the card number.
    2. Select the Card Type.
      1. If the card type is unknown, choose "All Types".
    3. Click the Find button to search.
  3. View Results:
    1. Matching transactions will appear in the Date and Time panel (bottom left).
    2. Select a date/time entry to display its details in the Transaction Details panel (right side).
    3. Each new selection will add to the list, so you may need to scroll down to view all entries.
  4. Clearing Results:
    1. Click the Clear button to remove all transaction details.
    2. Alternatively, uncheck a date/time in the left panel to remove that specific transaction from the details view.
Notes
Tip: If the last four digits of the card number are not known, but you do know the date and time of the transaction, use the Sales Log Report instead.
It shows all credit card transactions for a specific day, allowing you to match transactions based on timing.



Deposit Breakdown

  1. Reports > Deposit > Deposit Breakdown
The Deposit Breakdown Report provides a more detailed view than the Bank Deposit Report.
  1. For each deposit within the selected date range, this report displays a breakdown of:
    1. Cash Sales
    2. Credit Card Sales
    3. Ticket Sales
    4. Concession Sales
This allows for a clearer understanding of where deposit amounts are coming from and how sales are distributed across different categories.


Discount Details

  1. Reports > Deposit > Discount Details
The Discount Details Report provides a list of all discounted transactions within a selected time period. This report is useful for tracking discount usage and monitoring employee activity.
  1. Report Breakdown:
    1. Date: The date and time the discount was issued.
    2. Station: The Station Number where the transaction was completed.
    3. Issuing Employee: The employee who applied the discount.
    4. Amount: The value of the discount applied to the transaction.
    5. Item Name: The specific item that received the discount.
    6. For: The employee who received the discount.




Employee Contest / Item Sales By Employee

  1. Reports > Deposit > Employee Contest / Item Sales By Employee
Both the Employee Contest and Item Sales by Employee reports display a breakdown of sales by item, showing how many of each item was sold by each employee.
These reports are useful for tracking employee performance and identifying top sellers for specific items.
  1. Configuring Item Groups
    1. To control which items appear in these reports:
      1. Click the Configure Item Groups button within RTS.
      2. From there, you can select or group specific items to track in the report.
Notes
Note: Item Group configuration cannot be done in Web Reporting. This setup must be completed in the RTS software.






Gift Card Station Sales

  1. Reports > Deposit > Gift Card Station Sales
The Gift Card Station Sales Report provides a breakdown of gift card sales and redemptions by station type.
  1. It shows the total dollar amounts of gift cards that have been sold or redeemed at the following types of stations:
    1. Ticket-Only Stations
    2. Concession-Only Stations
    3. Combo Stations – stations that sell both tickets and concessions
This report helps identify where gift card transactions are occurring across your operation and provides insight into usage trends by station type.



Location Item Sales

  1. Reports > Deposit > Location Item Sales
The Location Item Sales Report is used to compare concession item sales across different locations.
This report focuses on units sold (quantities), not dollar amounts.
  1. Key Features:
    1. Shows the number of units sold per selected item for each location.
    2. Does not display dollar sales.
    3. To view dollar amounts, use one of the following reports:
      1. Concession Summary Report
      2. Concession Hourly Report
      3. Concession Totals Report
  2. Using the Report:
    1. Click the Load Items button to populate the item list on the right side.
    2. Select the items you'd like to include in the report.
    3. After selecting, you can save these items to an Item List for easy use in future reports.
Notes
Note: Item List Configuration must be done in RTS. This feature is not available in Web Reporting.
Once an Item List is configured, only those items will appear by default when the report is opened.
To view all concession items again, simply click the Load Items button.




Kitchen Times

  1. Reports > Deposit > Kitchen Times
The Kitchen Times Report provides the average time it takes for a ticket sent to the kitchen to be cooked.
This helps track kitchen efficiency and identify any delays in food preparation.
  1. The Hours to Include Config allows users to select which hours should be included in the report.
  2. All available hours will be listed, and users can uncheck specific hours to exclude them from the report.
    1. Example:
      1. If you don't want 8 AM tickets to appear, simply uncheck 8 AM.
      2. The report will then start at 9 AM.
  3. Include Details Option:
    1. If the Include Details option is set to TRUE, the report will display the following for each ticket within the selected time range:
      1. Items – The items included in the ticket
      2. Sent Time – When the ticket was sent to the kitchen
      3. Finish Time – When the ticket was completed
      4. Time in Minutes – The total time it took to complete the ticket
      5. Amount of Items – The number of items on the ticket
Tickets will be listed starting from the longest ticket time to the shortest, helping you identify tickets with the longest preparation times.






Pass Log

  1. Reports > Deposit > Pass Log
The Pass Log Report is used to track the activity of passes (free movie tickets) within a specific date range.
This report provides a detailed view of all pass transactions, helping you monitor the usage of complimentary tickets.
  1. Key Features:
    1. Activity Overview: Shows the details of all passes issued during the selected date range.
    2. Employee Processing: At the bottom of the report, you’ll see:
      1. The number of passes each employee has processed.
      2. A total count of passes for the entire date range.




Deposit Recap Daily/Weekly

  1. Reports > Deposit > Deposit Recap Weekly/Daily
The Deposit Recap Report provides a breakdown of total income for the selected day or week.
The report helps track sales and compare calculated and actual deposit amounts.
  1. Daily Report:
    1. Shows sales for each relevant Subtotal Category for the current day.
  2. Weekly Report:
    1. Displays the same information as the Daily Report but broken down by each day of the week, with weekly totals at the end.
  3. Key Metrics:
    1. Conc Percap: The average concession sale amount per person.
    2. Ticket Percap: The average ticket sale amount per person.
    3. Other Percap: The average sale amount for other items per person.
    4. Total Percap: The sum of Conc Percap, Ticket Percap, and Other Percap.
    5. Calculated Deposit: The system-calculated deposit amount based on sales data.
    6. Actual Deposit: The actual deposit amount being made.
    7. Over/Under: The difference between the Calculated Deposit and Actual Deposit. A negative value will appear in parentheses.
    8. Shift Attendance: The total number of people in attendance for all movies during the time range for the deposit.
    9. Daily Attendance: The total number of people in attendance for the day.




Sales By Classification

  1. Reports > Deposit > Sales By Classification
The Sales By Classification Report provides a detailed overview of sales for individual items, grouped by classification.
Classifications can include concession items or ticket types, depending on the setup.
Classifications can be created and configured in Setup -> Classifications.
  1. Key Features:
    1. Multilocation Support: The report can display sales data for multiple locations.
      1. When multiple locations are selected, each location’s data will be shown sequentially within the same report.
    2. Units Sold: Shows the number of items sold for each classification.
    3. Sales Amount: Displays the total sales (before tax) for each classification.




Sales Log

  1. Reports > Deposit > Sales Log
The Sales Log Report provides a detailed list of all transactions that have been tendered.
It helps track sales, refunds, and cash drawer openings during a specific time period.
  1. Key Features:
    1. Transaction Type Indicators:
      1. Yellow Type: Indicates a transaction made to open the cash drawer.
      2. Red Type: Indicates a negative transaction (e.g., Void Transaction/Refund) or clearing of items from the selling screen (Void Register/Clear Register).
    2. Loading Transactions:
      1. The Load Button must be clicked to display the transactions for the selected date range.
    3. Transaction Details:
      1. Clicking on a specific transaction will display further details, such as the tickets or concession items sold during that transaction.
    4. Filters:
      1. Additional filters can be set and applied to narrow down searches for specific transactions.
    5. Find By Receipt Number:
      1. Use the Find By Receipt Number option to search for a specific transaction by its receipt number.
    6. Exporting Sales Log:
      1. If you wish to print or download the sales log for a specific date range, this option can be found under Actions > Exports > Sales Log.


Tax By Subtotal

  1. Reports > Deposit > Tax by Subtotal
The Tax by Subtotal Report provides a detailed breakdown of taxes applied to each subtotal category.
This report helps track tax amounts for different categories based on their settings.
Notes
Note: This report is intended to be used only when the concession item tax is included in the base item price. The report does not use any set tax tables or fee items.
  1. Key Features:
    1. Hide Non-Taxed Subtotals:
      1. If the "Hide Non-Taxed Subtotals" box is checked, any subtotal category with no tax percentage set will not appear in the report.
    2. Tax Settings:
      1. Use the Tax Settings Button to modify the tax percentages for the subtotal categories.
    3. Setup Information:
      1. Subtotal Categories can be configured in Setup > Concessions > Subtotals.
      2. Items can be assigned to these categories under Setup > Concessions > Items.



Hourly Ticket Sales Log

  1. Reports > Deposit > Ticket Hourly
The Ticket Hourly Report provides a detailed breakdown of both current and advanced ticket sales for each hour within the selected time range.



Tip Reporting

  1. Reports > Deposit > Tip Reporting
The Tip Reporting Report provides a detailed breakdown of tips received by each employee.
  1. It includes the following information:
    1. Employee: The name of the employee.
    2. Tips: The tips received for each tender.
    3. Total Sales: The total sales amount for that employee.
  2. The Add Misc Tips option allows you to manually enter additional tips under the Misc Tip column to a user for the report to include in it's data.
This report helps track tip distributions alongside sales performance.




Tip Share Reporting

  1. Reports > Deposit > Tip Share Reporting
If a location utilizes tip share, the Tip Share Reporting provides a detailed breakdown of how tips are distributed among employees.
This includes the share percentage and the departments involved in tip sharing.
  1. Key Features:
    1. Tip Breakdown: Displays how tips are shared between employees based on the configured tip-sharing rules.
    2. Configure Tip Share: The Configure Button allows you to set up the percentage of tips and departments that share in the tip distribution.





Deposit Total

  1. Reports -> Deposit -> Total
Please see the Article that goes over this report in more detail here:
  1. Reports - Deposit Total

Void/Refund Summary

  1. Reports > Deposit > Void Summary
The Void Summary Report provides a breakdown of voided transactions during a specific period.
It can show either summary information or a more detailed breakdown of the voided entries in each transaction.
  1. Key Features:
    1. Voids vs. Refunds:
      1. The report can be filtered to show:
        1. Voids (using the Void button in the register),
        2. Refunds (using the Refund window),
        3. Or both.



Waste Details

  1. Reports > Deposit > Waste Details
The Waste Details Report displays a list of items that have been marked as "wasted"—items removed from inventory but not sold.
This report helps track inventory loss and maintain accurate stock records.
  1. Wasting an item may be necessary for reasons such as:
    1. The item was dropped or damaged
    2. It is past its sell-by date
    3. It is otherwise unsellable
  2. How to Waste an Item:
    1. Items can be marked as wasted by navigating to:
      1. Actions > Stations > Waste Item

    • Related Articles

    • "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 ...

    • Daily or Open Ticket Report

      Daily or Open Tickets Report Reports > Ticket > Daily / Open The Daily or Open Ticket Report provides detailed insights into ticket sales for a specific day or date range. This report can be used to track various aspects of ticket sales, including ...

    • Ticket Reports

      Ticket Reports This article covers the available reports under Reports → Tickets. These reports provide detailed insights into ticket sales, attendance, revenue, and performance trends. These reports help theatres analyze ticketing data for a variety ...

    • 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 ...

    • Station Reports

      Station Reports This article details the Station Reports section under Reports → Stations. These reports provides valuable insights into the individual performance and transactional data for each station and are designed to track a wide range of ...