Connected Performance
Payments

Payments Analytics & Reporting

Read the payments dashboard: what Expected, Collected, Pending and Overdue actually mean, monthly overview, revenue sources, revenue per location, upcoming payments and CSV exports.

Overview

Payments > Analytics is the revenue dashboard. It's admin-only and shows collections performance, revenue by source and location, and upcoming charges.

Every number on this page has a precise definition, and several of them are easy to misread. This page spells them out.

How To

Read the four headline cards

CardWhat it counts
Expected this monthEverything actionable this period: scheduled, pending, processing, paid, failed, retrying and refunded payments.
CollectedPaid and refunded payments. The sub-line shows the collection rate and the net figure after refunds.
PendingScheduled, pending, processing and retrying payments, with a count.
OverduePayments in Failed status, with a count.

Three definitions to internalize:

  • "Collected" includes fully refunded money. Refunds only reduce the Net collected figure.
  • "Overdue" means Failed, not "past its due date". A payment scheduled for last week that hasn't been attempted is Pending, not Overdue.
  • "Expected this month" isn't always this month. If the current calendar month has no activity at all, the figure falls back to the most recent month that did. The label doesn't change, so an inactive organization sees last active month's numbers.

The four cards have no date control — they always use the current period.

Read collection performance

A three-segment bar for Collected / Pending / Overdue, each clickable through to a filtered transactions list.

Note the footer percentage uses a different denominator than the Collected card: the footer is collected ÷ (collected + pending + overdue), while the card is collected ÷ expected. The two percentages will disagree, and both are correct for what they measure.

Read the monthly overview

"Expected vs collected" over the last 3, 6 or 12 months.

This chart combines transactions and invoices, which means:

  • An invoice and the payment that settles it can both be counted.
  • "Overdue" here means invoices in Overdue status and transactions in Failed status.
  • Transactions are bucketed by their scheduled date; invoices by their due date.

This chart will not tie out exactly with the headline cards. Use the cards for period totals and the chart for trend.

Read revenue sources

Where collected revenue came from over the last 3, 6 or 12 months. Products are bucketed by membership plan name, credit package name, bookings (by location when facility payments are enabled), memberships, invoices, then one-time payments. Only paid and refunded transactions count, net of refunds. See all opens a paginated view.

Revenue sources buckets by processed date, while the monthly overview buckets by scheduled date — so the same payment can land in different months across the two cards.

Read revenue per location

Only appears when facility management is enabled and you have more than one location. Choose a source:

SourceHow revenue is attributed
BookingsThe session's location. Amounts are net of refunds and bucketed by session date, not payment date.
MembershipsThe plan's assigned locations, split evenly when a plan covers several.
Credit PackagesSame even-split rule as memberships.

Products with no assigned location land in a No location row, which links to the plan or package list so you can assign one.

This report excludes invoices, one-time payments and processing surcharges.

Read upcoming payments

The next charges due in the next 7, 14 or 30 days, showing three at a time with See all upcoming for the rest. Statuses are re-labelled for readability: anything in progress shows as "Pending", anything due within two days shows as "Due soon", everything else "Scheduled".

Export data

CSV export is available on Transactions, Invoices, Customers and Memberships. Each offers current page or all records, and generates the file in your browser.

PageColumns
TransactionsTransaction ID, Customer, Date, Status, Type, Method, Source, Total Spend, Surcharge
InvoicesID, Invoice #, Customer, Status, Due Date, Total
CustomersCustomer, Email, ID, Payment Method, Created, Total Spend, Payments, Credits

No card data is ever exported — payment method is a display label only.

Individual invoices can be downloaded as PDFs from the invoice page.

Find other financial views

  • Customer detail — lifetime spend, active plan, transaction history, invoice history, credit ledger.
  • Plan detail — active members, monthly revenue for that plan, total members, average tenure.
  • Credit History — the full credit ledger for one customer.

Tips

  • Reconcile from Transactions, not from the dashboard. The dashboard is designed for at-a-glance trend; the transaction list is the ledger.
  • Each widget has its own independent date selector, and none of them change the four headline cards. Check which control you actually moved.
  • Dashboard amounts are rounded to whole dollars. Small totals can appear as "$0". Everywhere else shows cents.

Troubleshooting

"Expected this month" looks like last month's number. The current month has no activity, so the figure fell back to the last active month.

The two collection percentages disagree. Different denominators — see "Read collection performance" above.

The chart doesn't match the cards. The chart merges invoices and transactions and buckets on different dates. Expected behaviour.

Refunded money still shows as collected. By design. Use the "Net collected" figure to see revenue after refunds.

A payment that's weeks past due shows as Pending, not Overdue. Overdue means Failed. A payment that hasn't been attempted yet is Pending.

Revenue per location isn't showing. It requires facility management to be enabled and more than one location.

Revenue for a shared plan looks wrong per location. Plans covering several locations are split evenly across them. That's the documented rule, not an attribution error.

"Failed to load payments data." One of the underlying queries failed. Reload the page; if it persists, contact support.

  • Transactions, Refunds & Retries
  • Organization Reports
  • Payments Troubleshooting

Referenced by

On this page