The instructions that follow will help you create a report of all payments that have been taken for bookings that have yet to occur. In this search, each row will represent a payment on a booking in Tripleseat. Some people refer to this as a liabilities report, or a cash-on-hand report. But regardless of what you call it, it provides crucial information to your accountant and whoever manages your business’ financials. Running this report today will tell you how much you should keep “on hand” in case your business goes under tomorrow. Should the unthinkable happen, you will know how much you have to refund all for future booking payments. (Disclaimer – we sincerely hope this never happens! Just a good report to have up your sleeve.)
TO CREATE THIS REPORT:
- Go to Reports.
- Scroll to Booking Payments Report. Click Paid.
- On the next page, click Customize. This will open a popup window where you can further refine your search.
FILTER WHAT PAYMENTS APPEAR - Use the Payment Paid field to filter All dates before today. This will show all payments made before that date.
- Click on the Booking Details tab. This tab allows you to add another layer of filtering to the results. Use the Booking Start Date field to filter for all events one day after the payment cutoff (so all bookings that start after tomorrow).
CUSTOMIZE THE COLUMN DATA - Click on Columns. This is where you can select what information you’d like to see in the results.
- Run Report.
Because of steps 4 and 5, only payments made before the payment cutoff for future bookings will appear in the results. That way, if you had to close your doors tomorrow you can know exactly how much you are liable for.