Free Hotel Revenue Pickup Template, Ready to Use

Who this is for: owners, general managers, and revenue managers at independent hotels, hotel groups, motels, resorts, and hostels who track booking pace between reports. Bed & Breakfasts and Parks can use a simplified version further down.

A pickup report isn't a forecast. A forecast projects what occupancy and revenue will likely be for a future period. A pickup report measures something narrower. It's how many new room nights got booked since the last check, for each future stay date. It's the raw pace data a forecast gets built from, not the forecast itself.

‍

What's Included in This Template

• Header info: hotel name, total rooms available, reporting period, report run date
• Daily on-the-books (OTB) tracking: prior OTB, new pickup, current OTB, for each stay date
• Financial metrics tied to that pickup: ADR, room revenue, RevPAR
• Comparison to the same dates last year, with variance
• A pace status flag, so the report tells you something, not just shows you numbers

‍

Key Template Sections

A pickup report has five parts. Skipping the header or the comparison data makes the rest hard to interpret later.

• Header Info: hotel name, total rooms available, the reporting period, and the date this report was run.
• Daily / Date Range Tracking: one row per future stay date, not one row per report.
• On-the-Books (OTB) Data: prior total room nights booked, new pickup since the last report, and the current cumulative total.
• Financial Metrics: ADR, total room revenue, and RevPAR for each date.
• Comparison Data: the same date last year, plus the variance percentage.

‍

Essential KPIs

Room nights, pickup, occupancy, and RevPAR are the four numbers every pickup report needs. Most templates stop there.

‍

Pace Status: Beyond What Most Templates Track

A number alone doesn't tell you whether to act on it. This template adds a status flag next to each date's pickup. It's based on how that pickup compares to the same date last year.

• Ahead of Pace: pickup is running above the same point last year. No action needed.
• On Pace: pickup is tracking within a normal range of last year.
• Behind Pace: pickup is running below last year. This is the signal to review rate or distribution, usually through a revenue management review, not just note it and move on.

A raw pickup number tells you what happened. A pace status tells you whether it matters.

‍

Daily Pickup & OTB Tracker

Run this daily or weekly, depending on how close the stay date is. Dates further out need less frequent checks than dates inside the next two weeks.

‍

Segment Pickup Breakdown

Total pickup can look healthy while hiding a problem in one segment. Break it out before you draw conclusions from the total.

‍

Completed Example

Riverside Inn runs its pickup report every Monday for the next four weekends.

Segment breakdown for that date: 4 transient, 2 corporate, 0 group. The shortfall isn't a group cancellation, transient demand is simply softer than last year. That distinction changes what action makes sense. A rate adjustment fits here, not chasing a lost group booking.

‍

How Do You Use a Hotel Revenue Pickup Template?

Run it on a fixed schedule, not whenever it comes to mind.

• Set a reporting cadence: daily inside the next 2 weeks, weekly beyond that.
• Record OTB before adding any new pickup, so the delta is accurate.
• Flag pace status against last year, not against gut feeling.
• Break out segment pickup before deciding what a shortfall actually means.
• Act on Behind Pace flags within the same week, since pickup problems compound the closer you get to the date.

‍

Common Mistakes to Avoid

• Running the report on no fixed schedule, so pace comparisons become meaningless.
• Recording total pickup without breaking it out by segment.
• Comparing pickup to a gut feeling instead of the same date last year.
• Noting a Behind Pace flag without a follow-up action.
• Treating the pickup report as a forecast instead of an input to one.

‍

Revenue Pickup Templates by Property Type

Every property type benefits from tracking pickup, but the reporting frequency and segment mix should match how the property actually books.

This applies at full detail to Independent Hotels, Hotel Groups, Resorts, and Hostels below. Motels, Bed & Breakfasts, and Parks get a simplified version instead, since they typically book closer to arrival with less segment complexity. Independent Hotels use the template above as-is.

Hotel Groups Pickup Report

Adds the specific property and a portfolio rollup, since pace can vary sharply property to property even in the same group.

Resort Pickup Report

Adds package and amenity pickup, since resort bookings often add ancillary revenue at the time of booking, not just room nights.

Hostel Pickup Report

Tracks beds instead of rooms, and weighs OTA-driven pickup more heavily, since hostel bookings skew short-lead-time and OTA-heavy.

Motel Pickup Report (Simplified)

Drops segment breakdown, since most motel pickup is transient with minimal group or corporate mix.

Bed & Breakfast Pickup Report (Simplified)

Drops daily granularity in favor of a weekly view, since B&B booking windows are typically short and don't need day-by-day tracking.

Parks Pickup Report (Simplified)

Tracks sites instead of rooms, matched to how far ahead campers typically book.

‍

Frequently Asked Questions

1. What's the difference between a revenue pickup template and a forecast?

A pickup report measures new bookings added since the last check, for specific future dates. A forecast projects likely occupancy and revenue using pickup as one of its inputs.

2. How often should a revenue pickup template run?

Daily for stay dates within the next two weeks, weekly for dates further out.

3. What does "pace" mean in a pickup report?

Pace compares current booking pickup to the same point in the booking window last year, showing whether you're ahead of, on, or behind where you should be.

4. Should pickup be tracked by segment or just as a total?

By segment. A healthy total can hide a weak segment, and the fix for a transient shortfall is different from the fix for a lost group block.

5. Is a pickup report the same as an OTB report?

Related but not identical. OTB is the cumulative total booked as of today. Pickup is the change in that total since the last time it was measured.