|RV Park Help|
The Report Generator produces 12 types of reports; Guest, provides a report of the selected Guest's Billing over the selected Dates, perfect for a Year End accounting of the Guest's expenditures; Guest List is a list of either Current or All Guests with their addresses and phone numbers; Occupancy Report provides a List for Today of Occupied and/or Vacant Sites; Tax/Revenue contains ALL revenues collected for Tax preparation over the Dates specified (this report can be exported to an Excel Spreadsheet); Advertising provides a count of the Typess of How a Guest Heard about your Park; Rental Percentages to show what percentages of your Sites are rented by Types of Rentals for today; Inventory/Reorder Point Report is a quick way to determine what Other Charge Items may need reordering and what is in your Inventory; Other Charges Sales Report to assess the Other Charges and their taxes; the Deposit Report, pulls any OtherBilling that has the word "Deposit" in it to determine what Deposits have been charged and refunded between any 2 dates; the UnOccupancy Report uses the Guest & GuestHistory tables to determine how many days each site is not occupied (and occupied) from Arrival & Departure dates using From/To dates; the Projected Weekly/Monthly Income report estimates the Weekly and monthly rent income by looking at Guests in the Park during the next Billing cycle (this is just an estimate); the Outstanding Balance Report is a snapshot of the Outstanding Balances of Guests, any Monthly, Weekly, Daily, 3/6/12 Month billed Guests that will soon have their Bill due, as well as Electric and Other Charges as checked; and the EMail List creates a list of emails for you to Copy & Paste into an Email. The Panel looks like this:
If the Time Frame dates are available, Double Clicking on a date field will produce a Calendar for easier entry. The default dates are the first of the current year through today's date. You can output a Screen Print, Text file, print to the default printer, create a CSV (comma separated values delimited file for Excel or other Spreadsheet program), or if you are outputting a Tax/Revenue Report or Inventory/Reorder Point Report there is also an MS Excel, you can also output an Excel Spreadsheet. If you print to a file, remember to change the file name.
When running a Tax/Revenue Report, you can elect to Filter the Report with either of the QuickBooks fields; Account and/or Type. This can be helpful if you operate a Park with RV Sites and Mobile Home Sites, for example. If you have set the sites with a different Account and/or Type, each time the Rent is collected, the Billing record will be set to those values defined in the Site panel.
Projected Weekly/Monthly Rental Income - This report projects the Rental Income based on the following criteria:
1) Looking at future reservations and current Guests within the next Week and next Month. They are separated in a Weekly & Monthly projection.
2) This is looking at Rent Only, i.e. the electricity and "other charges" that may be on their Bills are not considered.
3) Discounts (15% off) and/or Rate Adjustments ($15 Seniors Discount) were included.
4) The Weekly list is JUST for one Week (after Today) ... same with the Monthly list for JUST a month (30 days) after Today
5) The Guest MUST have an Assigned Site, but may not have made their first payment, they just will be doing so within the next 7 or 30 days.
6) The Rent is only "Summer" rates, that is, it doesn't figure seasonal rates.
NOTE: The Guest "Bill" has NoDateYet as a LastPaid date. That is what a future reservation would look like.