The Reservation Daily Revenue report spreads reservation revenue across the days it was earned. A three-month contract invoiced in one go is not three months of revenue in the month you billed it — this report breaks that value down day by day, so you can see what each date actually earned.
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 Reservation Daily Revenue.
Why This Report Matters
Marinas and parks invoice on very different cycles — nightly, monthly, seasonally, annually — which makes raw invoice totals a poor guide to how a period actually performed. A big October invoice run does not mean October was a strong month. This report puts every reservation on the same daily basis, which makes it the right tool for:
Comparing revenue between months on a like-for-like basis, regardless of billing cycle
Producing a revenue figure for a period that does not line up with your invoicing dates
Seeing how revenue is distributed across a season rather than across your billing runs
Splitting daily revenue by module, product, or booking type
How Revenue Is Spread
A reservation is broken into one row per revenue date, and how it is divided depends on the booking period behind it — daily stays, monthly long-term arrangements, and seasonal bookings are each apportioned according to their own basis. The result is a Revenue Date column that carries that day's share of the value.
Because a single reservation produces many rows, a row count here is not a count of bookings and a single row's Total is not the value of the reservation — it is one day's portion. Filter and subtotal on Revenue Date, and use the Marina Reservations or Campground Reservations report when you want one row per booking instead.
This report describes revenue as earned. It is not the same as revenue as invoiced, and it is not the same as cash received. For what has actually been billed, use the CRM Invoices report; for money taken, use Settlement Details.
Building a Reservation Daily Revenue Report
Go to Reports → Accounting → Reservation Daily Revenue in the left sidebar.
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.
Otherwise click + New and give it a Name, such as "Daily Revenue by Module."
Add the columns below from the Available panel.
Set Subtotal to Total, and turn on Summarize Report if you want period totals rather than every individual day.
Turn on All Outlets to report company-wide revenue.
Click Save, then Get Report to set your date range and run it.
Recommended Columns
Field | What It Shows |
Revenue Date | The day the revenue is attributed to. This is the column to filter and group on — not the arrival or invoice date. |
Subtotal, Tax, Total | That day's share of the reservation's value |
Module Name | Marina, campground, or booking — group on this to compare how each operation is performing |
Booking Period | Whether the underlying booking is daily, monthly, seasonal, and so on — this is what determined how the revenue was spread |
Duration, Total Duration | The length of the portion and of the whole reservation |
Is Extra Charge | Whether the row is an add-on rather than base rent — filter to No to see slip or site revenue on its own |
Arrival Date, Departure Date | The stay the revenue belongs to |
Reservation Status | Where the reservation stands |
Customer Name, Cust Email | Who the revenue came from |
Product Name, Income Account | What was sold and where its revenue posts — group on Income Account to tie back to the general ledger |
Unit Name, Group Name | The slip or space earning the revenue, and its dock or loop |
Booking Type Name | Lets you separate transient from seasonal revenue |
Created Date | When the booking was taken, for measuring booking pace against revenue earned |
Note: This report is closely related to Deferred Income but answers a different question. Reservation Daily Revenue tells you what a period earned operationally; Deferred Income tells you what has been formally deferred and recognized in your accounts. They will not always agree, and a difference between them is usually a deferral setting rather than a data problem.
Useful Filters
One month's earned revenue: Field Revenue Date, operator Between, covering the month, subtotalled on Total.
Base rent only: Field Is Extra Charge, set to No.
One operation: Field Module Name, set to Marina or Campground.
Seasonal business only: Field Booking Period, set to your seasonal period.
Revenue by account: group on Income Account with Total subtotalled, to reconcile against the general ledger.
One dock or loop: Field Group Name, set to the group.
A saved report filtered to a month, grouped by Module Name and subtotalled on Total, gives you a clean month-on-month revenue comparison that is unaffected by when you happened to invoice.