Skip to main content

Reports - Campground Reservations Report

Written by Andy Hornbeak

The Campground Reservations report is the general-purpose list of bookings — one row per reservation, with the customer, the rig, the space, the dates, the rate, and the status all available as columns. If you are not sure which campground report you need, this is usually the one to start from.

This article assumes you already know the basics of the Sharper reporting module — the Name, Token, Subtotal, column picker, and filter fields. For a full walkthrough of the reporting form itself, see the Sharper Reporting Reference Guide. This article only covers what's specific to the Reservations report.


Why This Report Matters

Most day-to-day questions about the park are reservation questions: who is arriving today, who has not left, which bookings were cancelled and why, what a guest was quoted. Because it carries the widest column list of any campground report, Reservations is the one to reach for when you need to:

  • Build arrivals and departures lists for the office

  • Review cancellations, with reasons, over a period

  • Pull a contact list for everyone booked into a season or loop

  • Check where bookings are coming from, using referral reasons

  • Verify rig dimensions against the spaces guests have been assigned


Reservations, Rent Roll, or Occupancy?

These three cover overlapping ground and are the most commonly confused campground reports:

Report

Use it when you want

Campground Reservations

One row per booking, over any date range — including past, future, and cancelled ones

Campground Rent Roll

The park as it stands today, including empty spaces and what they could earn

Campground Occupancy

Occupancy percentage and average daily rate over a period, calculated per space per night

Reservations is the only one of the three that will show you a booking that has not started yet, or one that was cancelled.


Building a Reservations Report

  1. Go to Reports → Campground → Reservations in the left sidebar.

  2. If a shipped report is close to what you need, use the ⋯ menu → Copy first — shipped reports can only be edited by the Sharper team.

  3. Otherwise click + New and give it a Name, such as "Arrivals This Week."

  4. Add the columns below. The Available list here is long — select the handful you actually need rather than everything, or the report becomes hard to read.

  5. Optionally turn on Dashboard with a short Dashboard Caption for lists you run daily.

  6. Click Save, then Get Report to set a date range and run it.


Recommended Columns

Field

What It Shows

Reservation Reference

The booking reference to quote to a guest

Arrival Date, Departure Date

When the stay is booked to run

Checked In Date, Checked Out Date

When it actually happened. Compare against booked dates to find guests still on site past departure.

Arrival Day Name

The weekday of arrival — useful for spotting demand patterns

Reservation Status, Reservation Custom Status

Where the booking stands, including any custom statuses your park has set up

Customer Name, Cust Email, Cust Phone

Who booked, and how to reach them

Vehicle Name, Vehicle License Plate Number, Vehicle Make, Vehicle Model

The rig — what it is and how to identify it on site

Vehicle LOA, Vehicle Height

Length overall and height, which determine whether a rig fits the space and clears obstructions

Unit Name, Group Name

The space assigned and its loop

Max LOA, Max Height, Max Sqft

The limits of the space — put these beside the rig dimensions to catch a booking that will not physically fit

Adults, Children

Party size, where you record it

Rate Plan Name, Rate Type

The rate applied, and whether it was the product rate or a fixed override

Subtotal, Tax, Total

The booking value

Curr Price Monthly, Curr Price Annual

The rate normalized to a monthly or annual equivalent, for comparing stays of different lengths

Invoicing Frequency, Prev Invoice Date, Next Invoice Date

How and when the reservation bills

Has Auto Pay

Whether payment is collected automatically

Cancellation Date, Cancellation Reason

When and why a booking was cancelled

Referral Reason, Departure Reason

How the guest found you, and why they left — the raw material for retention work

Contract Expiration Date

When the underlying contract runs out, for renewals

Internal Note, External Note

Notes on the booking. Internal notes are staff-only; external notes may be visible to the guest.

Created Date, Created Week

When the booking was taken — use this to measure booking pace rather than stay dates

Is Extra Charge

Whether the row is an add-on charge rather than the base booking — see the warning below

As with the Rent Roll, extra charges appear as additional rows on the same reservation, marked Is Extra Charge = Yes. A booking with two add-ons appears three times, so a row count will overstate your booking numbers and a sum of Total will mix base rent with electric, pet fees, and extra vehicles. Add a filter for Is Extra Charge = No whenever you are counting reservations or totalling space revenue.

Note: There are two sets of customer columns. Customer Name and its related fields are the account the reservation belongs to; the Res Cust fields are the guest details captured on the booking itself, which can differ when someone books on another person's behalf. Use the plain Customer fields unless you specifically want the guest.


Useful Filters

  • Today's arrivals: Field Arrival Date, set to today, with Is Extra Charge = No.

  • Overstays: Field Departure Date operator < today, and Checked Out Date set to is empty.

  • Cancellations in a period: Field Cancellation Date, operator Between, covering the period.

  • Never checked in: Field Checked In Date set to is empty, with an arrival date in the past.

  • Oversized rigs: Field Vehicle LOA, operator >, entering a length that is large for your park — check these against their assigned spaces.

  • Bookings taken last week: Field Created Date, operator Between, covering the week.

  • Contracts to renew: Field Contract Expiration Date, operator Between, today to 90 days out.

Arrivals and departures lists are worth saving with Dashboard switched on, since they are run every morning and the dashboard tile saves rebuilding the filters each time.

Did this answer your question?