Why do the Sales report and Total Revenue Report not match?

 If comparing the Sales and Total Revenue Reports, there might be discrepancies between the two.  This Knowledgebase outlines the legitimate differences in the way the reports work that can cause discrepancies.
  1. The Sales Report uses the Order date as the date filter on the report, while Total Revenue and Payments uses the payment date as the date filter on the report.  An order that has a payment date different than the order date (for example, an advanced sale or group sale) could cause a difference between the reports.
  2. The Sales Report only includes Sales Methods (Daily Sales, Advanced Sales, Group Sales, Online Sales), while the Total Revenue Report includes all sales methods and back office payments by default.  If the revenue is back office it will not be included on the Sales Report and can cause a difference.  Eliminate this problem by unmarking the box for back office on the Total Revenue Source filter.
  3. The Sales Report totals include the totals of all orders, regardless of whether they have been paid, but the Total Revenue Report only includes payments.  Therefore, any unpaid orders will not be included on the Total Revenue Report.
  4. Quantity on the Sales Report indicates how many items/tickets were sold (excluding refunds) while quantity on the Total Revenue Report indicates how many orders and refunds were processed.  For example, if there is an order with two adult tickets, the Sales Report would indicate a quantity of 2, but the Total Revenue Report would indicate a quantity of one, as this was one order with one payment.
  5. Group Sales prepayments are moved from the Group Sales Payments line (Unearned Revenue) to the revenue line as soon as they are checked in, but in the Total Revenue Report you have the option to mark and see revenue that has moved from unearned to earned.  If you do not mark the checkbox on the Total Revenue Report to show revenue that has moved from unearned to earned, the Sales Report and Total Revenue Report would not match if you had group sales prepayments.

Environment

 3.11.526

Was this article helpful?