Skip to main content

Why revenue statistics and order totals don't match

You may notice that the numbers in the Revenue overview don't match the totals in the Orders section. In most cases this isn't a bug — the two views use different filtering logic. Here are the most common reasons and how to verify them.

How revenue statistics work

Revenue statistics only include orders with the payment status Paid. Orders in other statuses are not counted towards total revenue:

  • Orders with a status of Unpaid or Awaiting payment are shown separately as expected revenue, but are not included in total revenue.

  • Orders with a status of Cancelled are not counted in total revenue. However, if a cancellation fee was kept, that amount appears separately in revenue — in the class, course and workshop tables.

  • Orders with a status of Blocked (Waitlist) are also excluded.

  • Waitlist orders paid by card or PayPal have a status of Paid and are included in revenue. If no spot opens up and the payment is automatically refunded, the order changes to Cancelled and is removed from revenue. This may cause a temporary discrepancy.

The order list, on the other hand, displays all orders regardless of payment status.

Which date revenue is counted by

Summary statistics (the Σ revenue card, the monthly chart and the pass and membership summaries) count a payment on the day it was actually paid — not on the day the order was created. The numbers therefore match your Stripe or bank statements, and historical months no longer change retroactively when a client pays an older order.

The orders list, by contrast, sorts orders by their creation date. An order created at the end of one month and paid at the beginning of the next will therefore appear in a different month in each view — that is expected behaviour, not a bug.

The class, course and workshop tables show the earnings of sessions held in the selected period. For courses and workshops you will find two amounts: Paid (in period) — what was received within the selected period — and Paid (total) — the overall economics of the whole course or workshop.

Common reasons for discrepancies

  • Payment date vs. order date — revenue is counted by payment date, while the orders list uses the order creation date. An order paid in a different month than it was created will appear in a different period in each view.

  • Cancelled or refunded orders — they appear in the order list but are not included in revenue statistics.

  • Unpaid or pending orders — you can see them in the order list, but they don't count towards total revenue.

  • Different time period — make sure both views are set to the same date range.

  • Cancellation fees — if a booking was cancelled with a fee, the fee amount appears as a separate item in revenue.

How to investigate the discrepancy

  1. Set the same time period in both the revenue statistics and the orders section.

  2. In the orders section, filter by payment status — check which orders are Cancelled, Unpaid, or Awaiting payment. These are the ones excluded from statistics.

  3. Check orders with cancellation fees — these appear as separate items in revenue.

  4. After identifying the differences, the totals should match.

Tip: If the numbers still don't match after checking, export your orders to CSV or Excel and compare them with the revenue breakdown. This makes it easier to identify the specific orders causing the difference.

Did this answer your question?