Package Sales vs. Perf Summary by PT

I am trying to help our folks with some reconciliation issues and keep getting slightly different numbers from different reports.

Can someone describe what would cause differences between the Package Sales Summary report and the Performance Sales Summary by PT Category report.

Specifically I am looking at our non-fixed packages.  We use "audit performances" to build our flex packages and when patrons redeem their tickets they are exchanged into the actual performances (For next year, we will not be doing this. We will be replacing the audit performance with the actual show within the flex package without an exchange which I hope will eliminate some of these headaches.)

 

So the Package Sales report shows more money than the PT Category report and I am having trouble understanding why.

 

Thanks in advance.  This one is headache inducing on many levels.

  • I think part of it is that the Package Sales report doesn't include the exchanged tickets at all, just tickets that are actually part of a package. Whereas Performance Sales Summary's "Package" column actually represents anything with a Subscription price type category, whether it's from a package sli or a single (which exchanges would be).  It also may be partially related to donated seats. I know perf sales summary has a paramater about donated seats, but I'm not sure how the Package Sales Report handles them. Although, I guess in my example that wouldn't explain how the Package Sales Report could end up with MORE money than Perf Sales Summary. It'd be less... unless you have some pricetypes used for packages that do not have Subscription price type category. That could account for it.