Trans. Detail not tying to PT Summary

Hi Shelley,

Are the revenue amounts higher on the Performance Sales Summary by Price Type Category higher than the revenue amounts on the Transaction Detail report?  If so it may be that there are partially paid tickets somewhere on an order.

The tricky thing about the Performance Sales Summary by Price Type Category report is to understand how it counts tickets.  It will count only those tickets which have been seated and have had at least some payment applied to them.  Most often the payment is made in full, but sometimes there is an order which is partially paid.  In a partially paid order there may be a chance for one ticket (and only one ticket) to also be partially paid. However, and this is the important bit, the Performance Sales Summary by Price Type Category will count the full value of that partially paid ticket.

This means if I create an order for two tickets which cost $25 each I have an amount due of $50.  If I then pay $30 towards that order the first ticket gets fully paid with the first $25 and the second ticket gets partially paid with the remaining $5.  There is still $20 due.  The Performance Sales Summary by Price Type Category report will now display two tickets sold for $50 dollars because it counts the full value of partially paid tickets.

The other quirk that you might be running into is that the report is only counting those tickets if they are seated.  This is especially important at our organization when we are renewing season ticket sales because it is very common for us to create a ticket order and collect payment but not assign seats.  These orders do not show up on the Performance Sales Summary report but of course money has been collected so it will be on the transaction report.

The short of it is that the Performance Sales Summary report is not a Finance report, it is a ticket office report.  It shows how many seats have been assigned and the total value of those seats.  It's still a great report and I use it every day, and accountants can also use it but they need to understand what it's purpose is and how it works.

Finally, you asked about those revenue amounts at the bottom of the sheet beneath the ** Report Totals ** line.  Those are revenue amounts from price maps where the revenue designation was not a ticket revenue.  If you have created a new designation for dynamic pricing or something then it will show up separately from the normal totals.

Good luck.

Jared

This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Finance Forum. You may reply to this message to post to the Finance forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!

Hi Shelley,

Are the revenue amounts higher on the Performance Sales Summary by Price Type Category higher than the revenue amounts on the Transaction Detail report?  If so it may be that there are partially paid tickets somewhere on an order.

The tricky thing about the Performance Sales Summary by Price Type Category report is to understand how it counts tickets.  It will count only those tickets which have been seated and have had at least some payment applied to them.  Most often the payment is made in full, but sometimes there is an order which is partially paid.  In a partially paid order there may be a chance for one ticket (and only one ticket) to also be partially paid. However, and this is the important bit, the Performance Sales Summary by Price Type Category will count the full value of that partially paid ticket.

This means if I create an order for two tickets which cost $25 each I have an amount due of $50.  If I then pay $30 towards that order the first ticket gets fully paid with the first $25 and the second ticket gets partially paid with the remaining $5.  There is still $20 due.  The Performance Sales Summary by Price Type Category report will now display two tickets sold for $50 dollars because it counts the full value of partially paid tickets.

The other quirk that you might be running into is that the report is only counting those tickets if they are seated.  This is especially important at our organization when we are renewing season ticket sales because it is very common for us to create a ticket order and collect payment but not assign seats.  These orders do not show up on the Performance Sales Summary report but of course money has been collected so it will be on the transaction report.

The short of it is that the Performance Sales Summary report is not a Finance report, it is a ticket office report.  It shows how many seats have been assigned and the total value of those seats.  It's still a great report and I use it every day, and accountants can also use it but they need to understand what it's purpose is and how it works.

Finally, you asked about those revenue amounts at the bottom of the sheet beneath the ** Report Totals ** line.  Those are revenue amounts from price maps where the revenue designation was not a ticket revenue.  If you have created a new designation for dynamic pricing or something then it will show up separately from the normal totals.

Good luck.

Jared

This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Finance Forum. You may reply to this message to post to the Finance forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!