Getting a List of Advance Deposits
Top  Previous  Next

The Transactions tab view can be a very powerful reporting tool if you know how to use the filtering. All of the options available are probably pretty daunting at first, but once you try a couple things it will begin to make sense.

One of the things you may want to do for an upcoming season is get a list of all deposits received for reservations. We'll make the assumption that you only care about deposits on reservations (not credits on customers without reservations), and you only need to see the reservations not yet checked in, since deposits for checked-in reservations are no longer an issue.

Here are the steps for getting this report:

1. Click on the Transactions tab view, and make sure the "Summarized" box is not checked.  
2. Click on "More Filters"  
3. Click "Reset All".  
4. Select "Deposit" under Transaction Types.  
5. Select "All Dates" in the Dates box.  
6. Click "Sites/Reservations".  
7. Hold the Ctrl key down and select "Pending", "Confirmed", and "Guaranteed" under Reservation Status.  
8. Click OK twice to save the filter and back out of the dialogs.  

This will show all deposits for upcoming reservations, assuming of course that you don't have any old reservations left as pending by mistake. (To make sure it doesn't report old reservations, you can also filter by the reservation starting date in step 7).

You can change the Detail Options if you need to show or hide some of the fields, and you can sort by customer name to avoid the gaps between each date.

Another useful thing you can do is to Summarize the report, for instance to show deposit totals for each Site (for seasonal parks, this is a good way to see which sites are delinquent in their deposits). There are a couple ways to do this. A quick way is to sort by the Site column first, then check the Summarize box. It will know that you're requesting a Site summary due to the currently sorted column, and so that's what it will summarize by -- showing the total deposits for each site. Another way to do this is to go into Summary Options, select Site under "Group total for each", then click OK. The results will be the same.

Hopefully this simple example will give you some other ideas of what you can achieve with filtering.

Page URL http://CampgroundMaster.com/snews/gettingalistofadvancedepo.html

Campground Master Home