Hotel pickup report template for revenue teams.
The pickup report is the most time-sensitive view in hotel revenue management. Configure yours below, download it as a CSV, or book a call to talk about automating the comparison step.
Build your version.
Configure the columns and window, then copy or download.
What to actually look for in a pickup report.
The pickup number by itself doesn't tell you much. What matters is the rate of change relative to where you expected to be, and what the demand pattern suggests about pricing opportunity. Here are the three signals worth tracking every morning.
Acceleration on high-demand dates
When a date is showing strong 7-day pickup and still has available rooms, the question is whether your rate is reflecting the demand. Strong pickup at a rate below the comp set midpoint is usually a missed revenue opportunity.
Stall or reversal on key dates
A date that was pacing well but has slowed or reversed — particularly with cancellations outpacing new bookings — is worth reviewing before the demand window closes. Rate strategy may need to adjust, or group business may be masking transient softness.
Soft mid-week patterns
Most properties have structural softness on Sunday and Monday nights. When Tuesday and Wednesday show weak pickup consistently, that's a different problem — demand generation rather than rate strategy. The pickup report is what surfaces this pattern before it becomes a month-end problem.
The most common mistake with pickup reports is tracking too many dates equally. A 30-day view with every date treated as equally important dilutes attention. Most experienced revenue managers focus the daily review on the next 14 days, with deeper attention on the next 7 — where there's still time to act and the pickup signal is most reliable.
Why pickup reports are still manual at most hotels.
The pickup calculation itself is simple: today's on-the-books count minus yesterday's (or last week's) on-the-books count equals pickup. The PMS has both numbers. The challenge is that most PMS systems don't calculate the delta automatically — they produce a snapshot of current OTB, and someone has to compare it against a previous snapshot manually.
That comparison typically means: exporting today's OTB, opening yesterday's or last week's export, and calculating the difference row by row in a spreadsheet. For a single property, it takes 10–15 minutes. For a 10-property portfolio, it takes considerably longer — and the manual calculation introduces inconsistency in how dates are flagged and exceptions are identified.
When the pickup calculation is automated, the comparison is done before the team opens the report. The delta is already calculated. The exceptions are already flagged. The revenue manager starts with the signals rather than building the view that reveals them.
FAQ
What is a hotel pickup report?
A hotel pickup report shows how many rooms have been added to the books over a defined period — typically the last 1, 7, or 30 days — for each upcoming arrival date. It tells the revenue manager whether demand is building, stalling, or reversing on specific dates, which drives rate decisions.
What should a pickup report include?
A useful pickup report should include the arrival date, current rooms on the books, occupancy percentage, 1-day and 7-day pickup, ADR on the books, rate variance versus the comp set, and a flag for dates that need attention. Comparison to the same period last year adds further context for seasonal patterns.
How often should a pickup report be reviewed?
Daily for the next 7–30 days is the standard practice. The pickup story changes overnight — a date that was pacing soft can accelerate quickly, and you want to catch high-demand dates before the window to adjust rate has closed.
Can a pickup report be automated?
Yes. If the PMS produces a scheduled on-the-books report, the comparison step — calculating the delta from yesterday's or last week's snapshot — can be automated. The result is a pickup view that's already calculated when the team starts the morning, with exceptions flagged by rule rather than by hand.
Want this generated automatically each morning?
If your PMS produces a scheduled OTB export, the pickup calculation and exception flagging can almost certainly be automated. Book a 20-minute workflow review and I'll tell you exactly how.