Reporting Site Income Per Day

DISCLAIMER: This article involves Advanced Customizations, which can be technically challenging to get working and is not part of standard support.  This is programming and must be done precisely or the results can be unpredictable.  This information is provided as a service for those who have the technical skills to work through it -- we cannot help you solve any issues with getting it working.  For more information about Advanced Customizations, see the full documentation:

https://campgroundmaster.com/help/overview32.html

Q: We need a report that gives us our earned income per day.  For example, if a "Seasonal Camper" has paid $3000 and there are 214 nights in our season, the average "earned income" per day is $14.02 for that site.  I did find in the sample Query imports an average daily amount paid, by site type.  This reports the average income on the last day of the stay.  I need a report or query that gives me the average income for the stay for each day of the stay, per site, not just site type.  Is this possible?  Thank you in advance for your assistance.

A: There is a sample query you can import for that: "Sample Query - Total revenue by site, by reservation dates"

It has the same linked-reservation issue as other transaction reports by site (all transactions are reported under the "Linked Master" site for linked reservations), but it does divide it up by day.

See the documentation for importing sample queries:

http://campgroundmaster.com/help/queriessetupdialog.html