Good afternoon Tessiturians!
We recently had a reporting mystery here that had us going around in circles trying to reconcile and we think we have, but were wondering if anyone could help us explain the WHY.
The day prior to a performance we ran the Performance Sales Summary by PT report and found that one price type had 7 seats at $574.20 but the same line the next day had 7 seats at $370.80. A difference of $203.40. Meanwhile, the total number of seats and income reported for Discount sales remained the same.
After investigating for a while we found that 2 seats had been donated prior to the running of the second report. The amount of the donation matches the missing funds. Why would the number of seats remain the same, the price type income drop, but the discount income remain the same?
We run the report to include donated seats and find this a bit confounding.
Any help or insight would be greatly appreciated. This case also highlighted the fact that the Performance Sales Summary by PT ticket income does not match the Box Office Statement for ticket income, nor the GL Summary...
Cheers!Short
Hi there Christopher,
I recently had the same inconsistencies when running our consortium's custom settlement summary (which is based on the Performance Sales Summary by PT Category report, I believe) and the Mode of Sale Analysis report.
I think you're on the right track and I thought the same thing immediately when I noticed the difference between the two reports equaled that of the donated seats. The report's help document states that:
If the {Include Resold Seats?} parameter is set to ‘Yes’, then any donated tickets that have been resold are included in the sold totals, and any donated tickets that have not been resold are counted in the available tickets column.
In terms of transactions, the money was moved off of the performance and onto the account. If you selected the parameter to include the donated (resold) seats, it includes the "extra inventory" created by the donation.
Gotta love ticketing reports. :)