Finding outstanding Security Deposits

Top  Previous  Next

 

Assuming you use the recommended method for handling security deposits (e.g. for electric deposit, key deposit, etc), i.e. you use Charge transactions with a category of Security Deposit, here's how you can find out if someone has a security deposit outstanding:

 

Start with the Transactions detail report.  If you're not sure how to get back to that after using a summary report, see here:

http://campgroundmaster.com/news/gettingbacktothetransactio.html

 

Then filter it --

- click More Filters, select the Security Deposit category.

- You may want to include only checked-in reservations, so go to Site/Reservation filtering (from More Filters), and select only "Checked In" under the Status filter.  However if you take security deposits even before they check in, then also select Pending, Confirmed, and Guaranteed.

- Select an appropriate date range, e.g. far back enough to include deposits from the oldest current reservation.

 

OK / Close the filter dialogs to get back to the main screen.  That should show all security deposit charges, both adding and subtracting.  If the total at the bottom is not $0, then you have one or more that did not balance out, which should mean an outstanding deposit.  You should then sort by Site (click the header), so any refunded security deposits would be next to the original charge, and it will sub-total $0 for the site if they balance.  So any non-zero subtotals will indicate an outstanding deposit.

 

You can make it even easier to find them by going to Summary options now, select Group total for each: "Site", and Summarize period: "None".  Click OK and you have a neat list of sites and any with outstanding balances will be obvious.  You can go back to Summary Options and Save the report under memorized reports so you don't have to do all of this every time.

 

 

Update: If you want a "fancier" solution using a Query, which can be brought up quickly when needed instead of going through all of the steps above, you may want to try the Advanced Customizations solution to finding unmatched security deposits:

https://campgroundmaster.com/help/reporting-unmatched-security-d.html

 


Page URL https://CampgroundMaster.com/help/findingoutstandingsecurityd.html

Campground Master Home