Hi all,
We are finding ourselves frequently reserving groups of tickets for a period before taking payment.
While T-Stats does a great job of finding tickets sold according to their order date, I'd really like to find and analyze orders based on their payment date as it is more pertinent to making financial reporting.
Anyone have a good idea about getting this kind of data either through Tess or T-Stats?
Thanks!
-Jeff
Hi Jeff,
Looking at out of the box answer, you can pull out the element 'Sublineitem Status' under 'Ticket Order Details' in the Tickets cube where you can at least filter on those orders which have been paid. Then, copy that report, change seating status so you can keep an eye on unpaid reservations.
Cheers,
Kevin
Thanks, Kevin, Thats very helpful. It gets me a lot closer.
However, It still doesn't seem to get me to how many seats were PAID on each day, rather how many orders on each day have been paid for.
The hole I'm trying to fill here is that if an order is created during one month, and not paid for until the next month, the revenue comes in and must be accounted for (for tax purposes) in the month during which it the payment was received.
What I have now in TStats is retroactively updating the amounts paid according to the date the order was created instead of when the order was paid.
Anyone have a solution to this problem?
Thanks again!