Use the Wholesaler Allotment Pick Up report to see, night by night, how many rooms each Wholesaler holds on allotment and how many it has picked up, next to your house figures and last year's.
Overview
The Wholesaler Allotment Pick Up report is a comma-separated values (CSV) export that shows, for every night in a date range, how many rooms each Wholesaler has on allotment, how many of those rooms its reservations occupy and how many were booked today. Each night also shows the property's house figures and the same night last year, and a totals section at the end adds up the whole range.
A Wholesaler is a Travel Agent record whose Type is set to Wholesaler. You set up a Wholesaler's allotment on the Allotment tab of its record, in the same way as a Travel Agent allotment.
The report has no on-screen preview. Selecting Export to CSV downloads a file named WholesalerAllotmentPickUp_[From date]_[To date].csv (for example WholesalerAllotmentPickUp_20261117_20261130.csv). You can also set up the report as a Scheduled Report.
The Wholesaler Allotment Pick Up report is for reservations and revenue staff who manage wholesaler contracts. Before you start, make sure your Security Profile allows the Wholesaler function under Report Screens > Management Reports.
Please Note! RMS is highly configurable. Some Terminology, User Access & Permissions, Images, Labels, and Functions used in these articles may differ from your setup. For more information, see Understanding RMS Help Centre Articles.
When to use the Wholesaler Allotment Pick Up report
The Wholesaler Allotment Pick Up report suits properties that hold rooms for wholesalers under contract. Run the Wholesaler Allotment Pick Up report before a Wholesaler's release dates, or each morning to check the day's pick-up.
- Monitoring a wholesaler contract - before a release date, the reservations team compares each night's Allotment with Occupied to see how many held rooms are still unsold.
- Checking daily pick-up - each morning, the revenue manager exports the next 30 days to see which nights the Wholesalers and the house booked today.
- Comparing with last year - at the end of the month, the revenue team compares this year's totals with the LY rows and the Variance To LY rows of the totals section.
How to access the Wholesaler Allotment Pick Up report
In the side menu of RMS, go to Reports > Management > Reservations > Wholesaler. The report opens on a tab named Wholesaler Allotment Pick Up.
Choose the Wholesaler Allotment Pick Up report options
The Wholesaler Allotment Pick Up report options below control which nights, properties, Categories and Wholesalers the CSV export covers. The Report Options panel has no More Options section.
| Report Option | Type | Default | Description |
|---|---|---|---|
| Allotment Exists Between | Date range | Today | Sets the nights the report covers, with one CSV row per night. Preset ranges (for example Next 14 Days) and a Custom Range are available. |
| Property | Multi-select | All Selected | Limits the report to the selected properties. Only shown on databases with more than one property. |
| Category | Multi-select | All Selected | Limits the report to the selected Categories. The label follows your property's Category System Label. |
| Wholesaler | Multi-select | None Selected | Limits the report to the selected Wholesalers. Leave it at None Selected to include every Wholesaler. |
| Area Statistics | Dropdown | On |
Filters which Areas are included, based on the Statistics setting held against each Area. Options:
|
The Report Options panel also has three buttons: Export to CSV downloads the file, Schedule sets up a Scheduled Report, and Exit closes the report. When the export finishes, the CSV file downloads to your computer.
Tip! Select the star beside Add Report to Favourites Menu to add the Wholesaler Allotment Pick Up report to your Favourites.
What the Wholesaler Allotment Pick Up column headers show
The Wholesaler Allotment Pick Up CSV file has three parts, in this order:
- A header block with the report name, then Property, Category, Wholesaler, FromDate, ToDate and RunDate (the date the report was run). The Wholesaler line shows (All Selected) when no Wholesaler is chosen.
- A nightly table with one row per night (see Nightly columns).
- A totals section that adds up the whole date range (see Totals section).
The column headers always say Rooms, whatever your property's Area label is.
Nightly columns in the Wholesaler Allotment Pick Up report
The table below lists the nightly columns of the Wholesaler Allotment Pick Up CSV, left to right. The three [Wholesaler] columns repeat for each Wholesaler, headed with its name, in alphabetical order. Where a value follows a wider rule, the Source / Calculation column points to How the report calculates its figures.
| Column | Description | Source / Calculation |
|---|---|---|
| Date | The night the row describes. | Each night in Allotment Exists Between. |
| Total Occupied Rooms | Rooms in the selected Categories occupied that night by any reservation, whatever its source. | Property occupancy for the night. |
| Property Availability | Rooms shown as still available that night. | Total Allotment Rooms minus Total Occupied Rooms minus Maintenance Rooms. |
| Total Allotment Rooms | House Allotment plus every Wholesaler's Allotment for the night. | See House columns and Allotment figure. |
| Reserved Rooms % | Occupied rooms as a percentage of Total Allotment Rooms (0.57 means 0.57%). | Total Occupied Rooms divided by Total Allotment Rooms, times 100. |
| Picked Up Today | Reservations occupying that night that were made on the run date. | See Reservations counted. |
| Maintenance Rooms | Areas out of service for maintenance that night. | Property occupancy for the night. |
| House Allotment | Rooms left for the property to sell that night, outside Guaranteed Wholesaler allotments. | See House columns. |
| House Occupied | Occupied rooms that night, less Guaranteed Wholesaler reservations. | See House columns. |
| House Picked Up Today | Reservations made on the run date for that night, less Guaranteed Wholesaler reservations. | See House columns. |
| [Wholesaler] Allotment | Rooms the Wholesaler's allotment holds that night that have not been released. | See Allotment figure. |
| [Wholesaler] Occupied | The Wholesaler's reservations occupying that night inside its allotment. | See Reservations counted. |
| [Wholesaler] Picked Up Today | The [Wholesaler] Occupied reservations that were made on the run date. | See Reservations counted. |
| LY Same Day Total Occupied Rooms | Total Occupied Rooms for the same date last year. | See Last year figures. |
| LY Same Day Total Allotment Rooms | Total Allotment Rooms for the same date last year. | See Last year figures. |
| LY Same Day Reserved Rooms % | Reserved Rooms % for the same date last year. | See Last year figures. |
Totals section of the Wholesaler Allotment Pick Up report
The totals section of the Wholesaler Allotment Pick Up CSV adds up the nightly figures for the whole date range, so its figures are room nights, not reservations. It has three groups of rows:
- This period - a House row, one row per Wholesaler, and a Total row that adds House and every Wholesaler.
- Last year - House LY, one [Wholesaler] LY row per Wholesaler, and Total LY, for the same dates last year.
- Variance - House - Variance To LY and one [Wholesaler] - Variance To LY row per Wholesaler, showing this period minus last year. There is no variance row for Total.
The table below lists the columns of the Wholesaler Allotment Pick Up totals section.
| Column | Description |
|---|---|
| Total Allotment Rooms | The row's nightly allotment figures added up: House Allotment for House, the Wholesaler's Allotment for a Wholesaler, both for Total. |
| Total Occupied Rooms | The row's nightly occupied figures added up. |
| Total Occupied Rooms Less Allotments | Total Allotment Rooms minus Total Occupied Rooms: the allotted room nights not yet occupied. |
| Percentage Of Booked From Allotment | Total Occupied Rooms divided by Total Allotment Rooms, shown as a decimal (0.08 means 8%). On a Variance To LY row it is the difference in percentage points (8.33 means 8.33 points). |
| Picked Up Today | The row's nightly Picked Up Today figures added up. A 2-night reservation made today counts 2. |
How the Wholesaler Allotment Pick Up report calculates its figures
The Wholesaler Allotment Pick Up report works out its figures from the Wholesalers' allotments, their reservations and the property's occupancy. Each concept below governs more than one column.
Which Wholesalers and allotments does the report include?
The Wholesaler Allotment Pick Up report includes Wholesalers marked Active and their allotments that overlap the Allotment Exists Between range. An allotment set up with Set Permanently counts on every night in the range. Inactive Wholesalers still appear in the Wholesaler option list, but the report leaves them out. A Wholesaler gets its own three columns when it has an allotment in the range or in the same range last year. For allotments held for Travel Agents, see the Travel Agent Allotment Pick Up Report.
How a Wholesaler's Allotment figure is worked out
A Wholesaler's Allotment figure for a night is the number of rooms its allotment holds that night, as long as the night has not been released. The figure is:
- the allotment quantity set for the Category, or, for an allotment set at Area level, the number of Areas assigned to it
- 0 on days of the week that are not ticked under Available For on the allotment
- 0 on nights that have been released: RMS releases a night once the current date is within the allotment's Days Before Release of it
- 0 on nights further ahead than the allotment's Days After Release, when Days After Release is more than 0
Because released nights show 0, a date range in the past shows 0 in every [Wholesaler] Allotment column. Reservations do not reduce the figure, so compare [Wholesaler] Allotment with [Wholesaler] Occupied to see how many held rooms are unsold.
For example, in a report exported on 16 November, an allotment of 2 Lake Cabins from 17 to 30 November with 3 Days Before Release showed 0 for 17 and 18 November and 2 for every night from 19 November.
How reservations are counted against a Wholesaler
The Wholesaler Allotment Pick Up report counts a reservation (booking) against a Wholesaler when the reservation's Wholesaler field names that Wholesaler, its Category matches one of the Wholesaler's allotments, and it stays on nights inside the allotment's dates. The Wholesaler field is on the Reservation screen and in Quick Quote.
- Each night the reservation stays counts once in [Wholesaler] Occupied, from the arrival night to the night before departure.
- Cancelled and No Show reservations are not counted.
- For an allotment set at Area level, the reservation must also be in one of the allotment's Areas.
- When two allotments for the same Wholesaler and Category overlap, the reservation counts against the one with the most Days Before Release.
The Picked Up Today columns count reservations made on the run date shown in the header block. In the example above, a 2-night reservation for 24 to 26 November, made on 16 November, showed 1 in Example Wholesaler Occupied and 1 in Example Wholesaler Picked Up Today on 24 and 25 November.
How the House columns are worked out
The House columns of the Wholesaler Allotment Pick Up report show the rooms the property sells itself, outside Guaranteed Wholesaler allotments:
- House Occupied - rooms occupied that night, less reservations for Wholesalers that have a Guaranteed allotment.
- House Allotment - rooms available that night, less Guaranteed Wholesaler allotments, less House Occupied. It is never below 0.
- House Picked Up Today - reservations made on the run date for that night, less those for Wholesalers that have a Guaranteed allotment.
Areas in an Interconnecting Category are left out of the House columns, but are included in Total Occupied Rooms.
Please Note! A reservation for a Wholesaler whose allotment is not Guaranteed is counted in both the House columns and that Wholesaler's columns, so the Total row of the totals section counts it twice. An allotment that is not Guaranteed is also added on top of House Allotment in Total Allotment Rooms.
How the last year figures are worked out
The last year (LY) figures in the Wholesaler Allotment Pick Up report use the same calendar date one year earlier, not the same weekday: the row for 24 November 2026 compares with 24 November 2025. Because every past night has been released, a Wholesaler's allotment counts as 0 in last year's figures.
Related Reports
- Travel Agent Allotment Pick Up Report - shows how much of each Travel Agent allotment has been picked up, released or remains.
- Group Allotment Pick Up Report - shows pick-up against Group allotments.
Related Articles
- Travel Agents in RMS
- Set up a Travel Agent allotment
- Guaranteed (Deduct) Allotments
- Scheduled Reports
Comments
0 comments
Please sign in to leave a comment.