Reports can filter and total clients by their billing and payments, and list every payment with its gross, tax, fees and net. Use the Billing, Payments and Revenue ready-made questions, ask in your own words, or add Billing fields to any client report.
Steps
- Open Reports.
- Open Ready-made questions and click one, such as Who is past due?, Who is billed in the next 7 days?, What is our monthly revenue by plan? or Whose card expires this month or next?. Or type your own question and click Get answer.
- To add billing to a report, tap the + phrase, then pick a field from the Billing group.
- Click Run again after any change.
Billing fields (billing right now)
- Billing status: Past due, Cancellation scheduled, Billing, Awaiting checkout, Scheduled to start, Canceled or Not billing.
- Plan: the plan the client is billed for. Custom rate means a price set just for that client.
- Price, Billing frequency and Has a coupon.
- Monthly value: the plan price as a monthly amount. Totalling it gives monthly recurring revenue.
- Next billing date and Days until next billing. Use days until next billing in saved reports so they keep looking ahead from today.
- Scheduled billing start and Billing end date.
- Pack sessions left across active session packs.
Clients with more than one plan
A client can hold several plans at once, like a group class membership plus nutrition coaching. Their row still shows once:
- Plan lists every plan, newest first, and Billed lists each plan’s frequency in the same order.
- Price and Monthly value add up all their plans, so totalling Monthly value still gives monthly recurring revenue.
- Billing status shows the plan that needs the most attention. For example, a failed payment on any plan shows Past due.
- Next billing date is the plan that bills soonest.
- A membership paid outside Strix or comped counts as Billing, with its plan, the price you recorded ($0 when comped), its monthly value and its next renewal as the next billing date. Payment fields don’t include it, because Strix records no payments for it.
- Plan is and Billing frequency is match a client with that plan among others, and Plan is not leaves out anyone on it.
- Grouped by Plan or Billing frequency, the client counts under each of their plans, with that plan’s own price and monthly value.
Payment fields
- Amount paid, Payments, Failed payments and Amount refunded count inside the report’s activity period, by payment date.
- Paid all-time, Last payment date and Last payment amount ignore the period.
- Card on file, Payment method type, Card brand, Card expiry (Already expired, This month, Next month or Later) and Card expiry date.
Revenue: one row per payment
Switch Report on to Payments, or click a Revenue question such as What was our total revenue last month?, How much revenue has each product brought in this year?, Which payments were refunded this quarter? or Which coupons have clients used?. Each row is one payment made through Strix in the report’s period, by payment date.
- Date, Client, Plan or product, Category, Coupon, Status and Location. Location is where the payment was billed, or the client’s home location when the payment recorded none.
- Gross: what the client was charged, including tax and after coupons.
- Tax: tax collected. A refund takes back the same share of the tax.
- STRIX fee: the STRIX platform fee, less any of it refunded.
- Refunded and Lost to disputes.
- Net: gross minus tax, the STRIX fee, refunds and lost disputes. Stripe’s processing fees are not taken out.
Gross, STRIX fee and net are always separate columns, and the totals row adds each one up. For revenue by plan or product, category, coupon, location or month, use A breakdown with Total gross or Total net. For revenue each week or month, use A chart over time of Gross or Net. Payment reports include clients you marked inactive, since their payments are still revenue.
Good to know
- Amounts are in dollars. Amount paid is after refunds and disputes and includes memberships, packs, purchases and booking fees. Manual and outside payments are not included.
- For monthly recurring revenue by plan, use A breakdown grouped by Plan, showing Total monthly value.
- For money collected each week or month, use A chart over time of Amount paid.
- Billing status describes billing now, so the activity period does not change it.
- A payment’s refunds show on the payment’s own row, whenever they were made. The client field Amount refunded counts refunds by refund date instead.
- Failed payments are not rows in the Payments report. Use the client field Failed payments.
- Payouts and transfers, Stripe processing fees and Stripe balances are not available in Reports.
- Owners and admins can always use billing and payment fields and the Payments report. The built-in Coach group can too. A permission group with Billing and contact details off under Reports can’t.
Related
- Choose what each coach can see in Reports
- Show a report as a list, count, percentage, breakdown or chart
- What Reports can and can't show
- Save, print, email and export a report
Last updated