Tick Sheet Report

This article describes the Tick Sheet report, which displays a date-grid view of reservations over a selected period to support front-desk check-in and occupancy tracking.

Overview

The Tick Sheet report produces a grid where each row represents a reservation and each column represents a day in the selected date range.

A mark in a date cell indicates the reservation is active on that day.

Use it to see at a glance which guests are arriving, in-house, or departing across a given week, and to track check-in, No Show, and Hold status for each reservation.

✎ Please Note: RMS is highly configurable. Some Terminology, User Access & Permissions, Images, Labels, and Functions used in these articles may differ from your setup. CLICK HERE to find out more.

Use Cases

Daily check-in preparation - run the report for the current week to see all active reservations and tick off guests as they check in.
Occupancy overview - view how many reservations overlap each day in a period, with per-day totals in the summary rows.
No-show and hold tracking - enable Include No Show (Reservation) to include reservations with a no-show status, and review the NShow, Hold and HExp summary columns.
Grouped check-in management - group by Category, Company, or Travel Agent to organise the sheet by accommodation type or booking source.

How to Access

Go to Reports > Management > Financial > Tick Sheet.

Report Options

★ Tip: Report build screens default to a common use configuration, and selections can be made as required.

Report Option	Type	Default	Description
Reservation Between	Date range	This Week	The date range for which reservations are shown. One column per day is generated for each day in the range.
Category	Multi-select	All	Limits the report to reservations in the selected accommodation Categories.
Company	Multi-select	All	Limits the report to reservations linked to the selected Companies.
Travel Agent	Multi-select	All	Limits the report to reservations booked via the selected Travel Agents.
Booking Source	Multi-select	All	Limits the report to reservations from the selected Booking Sources.
Group By	Dropdown	No Grouping	Groups rows with subtotals. Options: No Grouping - all reservations in a single list. Category - grouped by accommodation Category. Company - grouped by Company. Purchase Order - grouped by Purchase Order number. Travel Agent - grouped by Travel Agent. Property Name - grouped by property (multi-property databases).
Sort By	Dropdown	Surname	Controls the order of reservation rows. Options: No Sort By - no specific ordering applied. Arrive - sorted by arrival date. Area - sorted alphabetically by Area name. Surname - sorted alphabetically by guest surname (default). Alphabetical - sorted alphabetically.
Sub Group By	Dropdown	No Sub Group	Adds a secondary grouping within each Group By section. Options: No Sub Group - no secondary grouping. Category - sub-grouped by Category. Booking Source - sub-grouped by Booking Source. Group Name - sub-grouped by Group Reservation name. Rate Type - sub-grouped by Rate Type.
View	Dropdown	Detail	Controls the level of detail in the output: Detail - one row per reservation (default). Summary - collapsed view showing group totals only.
New Page Per Group	Checkbox	Off	When enabled, each Group By section starts on a new page. Useful for printing separate sheets per group.
Include No Show (Reservation)	Checkbox	Off	When enabled, reservations with a No Show status are included in the report.
Export To XML	Checkbox	Off	When enabled, exports the report data as an XML file in addition to the standard report output.
Replace Voucher No. with	Checkbox	Off	When enabled, the Voucher No. column is replaced with the value stored in Reservation Spare Field 1. Use this if your property records a custom identifier in Spare Field 1 that is more relevant than the voucher number.

Report Columns

The Tick Sheet uses a date-grid layout rather than a standard column report. Each row represents one reservation. The first four columns identify the reservation, followed by one column per day in the selected date range, and then four status summary columns at the far right.

Column	Description
Res No	The reservation number.
Name	The guest surname.
Area	The accommodation area or unit the reservation is assigned to.
Voucher No.	The voucher number for the reservation. Replaced by Reservation Spare Field 1 if the Replace Voucher No. with option is enabled.
[Day columns]	One column per day in the selected date range, labelled by the day number (e.g., 8, 9, 10...). A mark of 1 in a cell means the reservation is active (in-house) on that day. Empty cells indicate the reservation is not active on that day.
IN	The total number of days the reservation is active within the selected date range. Used to verify the report has captured the correct stay length.
NShow	The number of days the reservation has been recorded as a No Show within the date range.
Hold	The number of days the reservation is on Hold within the date range.
HExp	The number of days the reservation's Hold has expired within the date range.

Summary rows

Four summary rows appear at the bottom of each group (or at the end of the report if no grouping is selected):

Total In - the count of active reservations for each day in the range.
Total Hold - the count of reservations on Hold for each day.
Total No Show - the count of No Show reservations for each day.
Grand Total - the overall totals across all days, plus the aggregate IN, NShow, Hold, and HExp counts.

Related Reports

Rent Accruals Report - prorates accommodation charges to a selected date for period-end matching.
Stock Control Margin Report - analyses the profit margin on stock items.
Arr Dep SO Forecast Report - forecasts arrivals, departures and stay-overs by date.

Related to:

How can we help?