Reports: Payments | bsport

The Payments report shows you the money coming in: every payment you took, what it cost you in fees, and when it reached your bank. Two further views cover disputed payments and the instalments you are scheduled to collect.

New to Reports? How to use a Report covers the buttons and controls.

It helps you answer questions like:

How much did I take last month, and what did it cost me in fees?
How are people paying: card, cash, direct debit?
Which of my team is taking the payments, and at which desk?
Am I being disputed, and am I winning those disputes?
How much am I due to collect from instalment plans next month?

What this report replaces

This report replaces four back-office reports:

Payments and In-studio payments are both the Payments view.
Dispute is the Disputes view.
Instalments is the Payment Plans view.

Use the Report Scope switch at the top to move between the views. They describe different things, so their columns and filters have little in common.

Before you read the numbers

The reporting period. On the Payments and Disputes views the date range filters on when the payment was taken. On the Payment Plans view it filters on the instalment's due date, which is a date in the future for anything not yet collected. The default is the last 6 months.

The comparison. Each KPI box compares the period you have selected against the equivalent earlier period.

What's always excluded. On the Payments view, two kinds of record never appear, whatever you filter on:

Payments that never completed, such as a refused card, a duplicate, or a charge that has not gone through yet.
Payments settled from a client's credit account. Those move a balance the client already had with you rather than bringing new money in, so counting them would inflate your takings. This is the same rule the back office applied.

On the Payment Plans view, cancelled instalments and instalments on an invoice that was later reversed are left out.

Payments

Set Report Scope to Payments. One row is one payment. An invoice paid half in cash and half by card gives you two rows; an invoice paid in four instalments gives you four.

The KPIs

KPI	What it shows
Number of Payments	How many payments you took in the period.
Amount Received	What they came to, including VAT / sales tax.
Transaction Fees	What those payments cost you in processing and provider fees.
Average Payment	The average value of a payment in the period.

💡 Refunds appear as payments with a negative amount, so Amount Received is already net of anything you gave back.

Columns

Column	What it shows
Invoice ID	A short form of the invoice this payment settles. Click it to open the invoice in the back office.
Invoice Number	The sequential invoice number you use for accounting.
Paid At	When the payment was taken. This is the date the reporting period is based on. For card payments it is the last status update; for payments you record by hand it is the date you entered.
Invoiced At	When the invoice behind the payment was issued.
Amount	The value of the payment. Negative for a refund.
Transaction Fees	What the payment cost you: processing, on-the-fly and provider fees combined. Cash, cheque and bank transfer carry none.
Payment Method	How it was paid: Cash, Payment Card, Sepa, Check, Bank Transfer, Apple Pay and so on.
Payment Channel	Online for card, SEPA and subscription card payments; In-studio for everything else. This is the same split the back-office In-studio payments report used.
Payment Engine	Who processed it: stripe for anything taken online, bsport for anything you recorded at the desk, or paypal.
Products	What was on the invoice, listed by name. This describes the whole invoice, so it repeats on every payment against it.
Product Types	The kinds of thing on that invoice, such as Standard Pass, Appointment Pass, Gift Card or Product.
Payment Note	The note attached to the payment.
Used Gift Card	True when the payment was made from a gift card being redeemed.
Client Name	Who paid. Click the name to open their profile in the back office.
Client Email	The client's email address.
Author Email	The staff member who raised the invoice. Blank when the client raised it themselves.
Billing Location	The billing location the invoice was issued from.
Billing Location Address	That billing location's address.
Payout ID	The payout this payment's money travelled in. Blank for anything not taken online.
Payout Status	Where that payout is: Pending, In transit, Paid once it has reached your bank, Failed or Canceled. Awaiting payout means the money is collected but not yet in a payout, which is normal for anything taken since your last one. Blank for payments taken at the desk, since they never travel through a payout.
Payout Created At	When the payout was raised.
Payout Arrival Date	When the money is expected to reach your bank. It allows for weekends and bank holidays. This is an expectation rather than a confirmation, so use Payout Status to see whether it actually landed.
Is Paid Out	True only when the payout has reached your bank. Cash, cheques and anything taken at the desk show False, since they never went through a payout at all.
Invoice Type	The kind of invoice the payment settles.

⚠️ Products and Product Types describe the invoice, not this particular payment. An invoice for a pass and a water bottle paid in two instalments shows both items on both rows, so do not read a payment row as telling you what that payment bought.

💡Payout Status set to Awaiting payout is your money in flight: collected online, not yet transferred. Filter on it to see what is coming.

Filters

Filter	What it does
Payment Method	One or more payment methods.
Invoiced At	Payments whose invoice was issued in a date range. This is separate from the reporting period.
Amount	Limits to payments whose value falls in a range. Set a maximum below 0 to isolate refunds.
Client Email	One or more specific clients, by email address.
Author Email	Payments on invoices raised by one or more specific staff members.
Payment Channel	Online or In-studio.
Product Types	Payments against invoices containing one or more kinds of product.
Used Gift Card	True for gift card redemptions, False for everything else.
Transaction Fees	Limits to payments whose fees fall in a range.
Invoice Type	One or more invoice types.
Payment Engine	stripe, bsport or paypal.
Billing Location	Payments on invoices from one or more specific billing locations.
Payout ID	Everything that travelled in one specific payout, which is how you reconcile a single bank credit.
Payout Status	Where the money is on its way to your bank.
Payout Created At	Payouts raised in a date range.
Dispute Status	Applies to the Disputes view: Pending, Lost or Won.

Group By

Group by	Use it to answer
Payment Period	How your takings move over time. Choose the step: day, week, month, quarter or year.
Payment Method	How your clients actually pay, and what each method costs you in fees.
Product Types	What your money comes from.
Client	Who spends the most.
Payout ID	How your taking is distributed in your payout.
Payout Status	How much has landed in your bank and how much is still in flight.
Invoice Period	The same trend, but by when the invoice was issued rather than when it was paid.
Payment Channel	The split between money taken online and money taken at the desk.
Author Email	How much each member of your team is taking.
Billing Location	Takings by site.
Payment Engine	The split across processors.

Grouped rows give you:

Summary column	What it measures
Number of Payments	How many payments fall into the group.
Total Amount	What they came to.
Total Transaction Fees	What they cost you in fees.
Average Payment	The average value of a payment in the group.

Disputes

Set Report Scope to Disputes. One row is one dispute: a client has challenged a payment with their bank, and the amount has been taken back off you while it is resolved. The amounts are negative, because the money went out.

The KPIs

KPI	What it shows
Number of Disputes	How many disputes were raised in the period, whatever their outcome.
Total Disputed Amount	The amount under dispute, including VAT / sales tax.
Total Transaction Fees	What those disputes cost you in fees, on top of the amount itself.
Number of Clients	How many different clients raised them.

Columns

The Disputes view offers Short Invoice Id, Invoice Legal Identifier, Paid At, Invoiced At, Price, Transaction Fees, Payment Engine, Products, Product Types, Payment Note, Client Name, Client Email, Author Email, Billing Location, Billing Location Address, Payout ID, Payout Status and Payout Created At, all with the same meanings as on the Payments view, plus one of its own:

Column	What it shows
Dispute Status	How it ended: Won when you kept the money, Lost when it went back to the client, Pending while it is open.

⚠️ Lost means you lost the dispute and the money left your account. Won means you kept it. It is the studio's point of view, not the client's.

Group By

Group by	Use it to answer
Dispute Status	How many disputes you are winning.
Payment Period	Whether disputes are becoming more frequent.
Invoice Period	Which billing periods attract disputes.
Product Types	What gets disputed.
Client	Whether the same client keeps disputing.
Payout Status	Where the disputed money sits.
Payment Engine	Which processor the disputes come through.
Billing Location	Which site attracts them.

Grouped rows give you:

Summary column	What it measures
Number of Disputes	How many disputes fall into the group.
Total Disputed Amount	What they came to.
Total Transaction Fees	What they cost you in fees.
Average Dispute Amount	The average value of a dispute in the group.

Payment Plans

Set Report Scope to Payment Plans. One row is one scheduled instalment, so an invoice split into four payments gives you four rows. A row exists as soon as the plan is set up, before any money moves.

The KPIs

KPI	What it shows
Number of Payment Plans	How many instalments fall due in the period.
Total Billed Amount	What is scheduled to be collected, whether or not it has been.
Total bsport Fee	The fees charged on the instalments actually collected.
Average Payment Plan	The average scheduled amount per instalment.

Columns

Column	What it shows
Short Invoice Id	A short form of the invoice being paid off. Click it to open the invoice in the back office.
Invoice Legal Identifier	The sequential invoice number you use for accounting.
Due Date	When the instalment is scheduled to be taken. This is the date the reporting period is based on.
Invoiced At	When the invoice behind the plan was issued.
Billed Amount	The scheduled amount of the instalment.
Bsport Fee	The fees charged on the payments attached to this instalment. Blank while no payment has been attempted.
Payment Status	Where the instalment stands: Paid, Pending for one not yet due, Unpaid when the charge failed, or Dispute.
Status	The underlying state of the scheduled charge: Pending, Registered, Error or Canceled.
Is Disputed	True when the client has disputed a payment on this instalment.
Payment Method	How the instalment is set to collect.
Payment Engine	Who processes it: stripe or bsport.
Products	What was on the invoice, listed by name.
Product Types	The kinds of thing on that invoice.
Client Name	Who is paying. Click the name to open their profile in the back office.
Client Email	The client's email address.
Author Email	The staff member who raised the invoice.
Billing Location	The billing location the invoice was issued from.
Billing Location Address	That billing location's address.

💡 Payment Status set to Unpaid is the list to work through: instalments whose charge failed and which will not retry on their own.

Filters

Filter	What it does
Status	Pending, Registered, Error or Canceled.
Billed Amount	Limits to instalments whose scheduled value falls in a range.
Invoiced At	Instalments whose invoice was issued in a date range.
Payment Status	Paid, Pending, Unpaid or Dispute.
Payment Method	One or more collection methods.
Payment Engine	stripe or bsport.
Client Email	One or more specific clients, by email address.
Author Email	Instalments on invoices raised by one or more specific staff members.
Product Types	Instalments against invoices containing one or more kinds of product.
Bsport Fee	Limits to instalments whose fees fall in a range.
Is Disputed	True for instalments with a dispute against them.
Billing Location	Instalments on invoices from one or more specific billing locations.

Group By

Group by	Use it to answer
Due Period	What you are due to collect month by month, which is your cash forecast.
Payment Status	How much of your scheduled collection is actually going through.
Client	Which clients have the most outstanding.
Payment Method	Which methods collect most reliably.
Payment Engine	The split across processors.
Product Types	What people pay for in instalments.
Author Email	Who is setting the plans up.
Billing Location	Scheduled collection by site.

Grouped rows give you:

Summary column	What it measures
Number of Payment Plans	How many instalments fall into the group.
Total Billed Amount	What they are scheduled to collect.
Total bsport Fee	The fees on the ones actually collected.
Average Payment Plan	The average scheduled amount in the group.

Matching your old back-office reports

Payments

To reproduce it: set Report Scope to Payments and set the date range to the same period you used before.

Where your old columns are now. A / means the column does not exist on that side.

Name of the column in legacy reports	Name of the column in legacy Excel file export	Name of the column in the new report (and downloaded file)
Invoice ID	Invoice ID	Invoice ID
Author	Author	Author Email
Full transaction date	Complete payment date	Paid At
Transaction date	Payment date	Paid At
Time of transaction	Payment hour	Paid At
Price	Amount	Amount
— (no English label)	Payment status	/
Transaction fees	Transaction fee	Transaction Fees
Payment method	Payment method	Payment Method
Products	Purchases	Products
Transfer	Transfer	Payout ID
Transfer: date	Date of issue of the transfer	Payout Created At
Transfer: status	Transfer: status	Payout Status
Payment note	Payment note	Payment Note
First name	First name	Client Name
Last name	Name	Client Name
Email	Email	Client Email
Address	Address	Billing Location Address
Billing group	Billing group	Billing Location
Studio	Franchisee	/
Legal invoice identifier	Invoice number	Invoice Number
/	/	Invoiced At
/	/	Payment Channel
/	/	Payment Engine
/	/	Product Types
/	/	Used Gift Card
/	/	Payout Arrival Date
/	/	Is Paid Out
/	/	Invoice Type

What's different

The three date columns are now one. The old report had Complete payment date, Payment date and Payment hour. Paid At carries all of it.
The time-of-day window has gone. If you need to filter on the hour in a spreadsheet, see Splitting date and time in Excel.
A few more payments are included. The old report only counted payments attached to certain kinds of invoice. Here the test is simply whether the payment completed, so payments against invoices migrated from another system now appear where they used to be dropped.
First name and Last name are merged into the single Client Name column.
The old Payment status column has no equivalent: the Payments view only ever shows payments that completed, so every row would read the same value.

In-studio payments

To reproduce it: set Report Scope to Payments and set the Payment Channel filter to In-studio. That leaves out card, SEPA and subscription card payments, which is exactly what the old report excluded, so your figures should line up. Everything under Payments above applies here too.

Where your old columns are now. A / means the column does not exist on that side.

Name of the column in legacy reports	Name of the column in legacy Excel file export	Name of the column in the new report (and downloaded file)
Invoice ID	Invoice ID	Invoice ID
Legal invoice identifier	Invoice number	Invoice Number
Author	Author	Author Email
Full transaction date	Complete payment date	Paid At
Transaction date	Payment date	Paid At
Time of transaction	Payment hour	Paid At
Price	Amount	Amount
Payment method	Payment method	Payment Method
Products	Purchases	Products
Payment note	Payment note	Payment Note
First name	First name	Client Name
Last name	Name	Client Name
Email	Email	Client Email
Billing date	Billing date	Invoiced At
Address	Address	Billing Location Address
Billing group	Billing group	Billing Location
Studio	Franchisee	/
/	/	Transaction Fees
/	/	Payment Channel
/	/	Payment Engine
/	/	Product Types
/	/	Used Gift Card
/	/	Payout ID
/	/	Payout Status
/	/	Payout Created At
/	/	Payout Arrival Date
/	/	Is Paid Out
/	/	Invoice Type

Dispute

To reproduce it: set Report Scope to Disputes and set the date range to the same period you used before.

Where your old columns are now. A / means the column does not exist on that side.

Name of the column in legacy reports	Name of the column in legacy Excel file export	Name of the column in the new report (and downloaded file)
Invoice ID	Invoice ID	Short Invoice Id
Author	Author	Author Email
Full transaction date	Complete payment date	Paid At
Transaction date	Payment date	Paid At
Time of transaction	Payment hour	Paid At
Price	Amount	Price
Transaction fees	Transaction fee	Transaction Fees
Dispute status	Status of the dispute	Dispute Status
Products	Purchases	Products
Transfer	Transfer	Payout ID
Transfer: date	Date of issue of the transfer	Payout Created At
Transfer: status	Transfer: status	Payout Status
Payment note	Payment note	Payment Note
First name	First name	Client Name
Last name	Name	Client Name
Email	Email	Client Email
Address	Address	Billing Location Address
Billing group	Billing group	Billing Location
Studio	Franchisee	/
Legal invoice identifier	Invoice number	Invoice Legal Identifier
/	/	Invoiced At
/	/	Payment Engine
/	/	Product Types

What's different

The three date columns are now one, as on the Payments view.
A few more disputes are included, for the same reason: the old report only looked at disputes on certain kinds of invoice.
First name and Last name are merged into the single Client Name column.

Instalments

To reproduce it: set Report Scope to Payment Plans and set the date range to the same period you used before.

Where your old columns are now. A / means the column does not exist on that side.

Name of the column in legacy reports	Name of the column in legacy Excel file export	Name of the column in the new report (and downloaded file)
Invoice ID	Invoice ID	Short Invoice Id
Author	Author	Author Email
Billing date	Billing date	Invoiced At
Due date	Due date	Due Date
Price	Amount	Billed Amount
Transaction fees	Transaction fee	Bsport Fee
Payment status	Payment status	Payment Status
Payment method	Payment method	Payment Method
Products	Purchases	Products
First name	First name	Client Name
Last name	Name	Client Name
Email	Email	Client Email
Studio	Franchisee	/
Address	Address	Billing Location Address
Billing group	Billing group	Billing Location
/	/	Invoice Legal Identifier
/	/	Status
/	/	Is Disputed
/	/	Payment Engine
/	/	Product Types

What's different

Instalments of zero now appear. The old report dropped any instalment for no money. If your row count is slightly higher, this is why.
Bsport Fee covers every attempt. The old Transaction fee column showed the fee on one payment. Where a charge failed and was retried, this figure now adds up all of them and will be higher.
First name and Last name are merged into the single Client Name column.

Downloading

The download gives you exactly what you are looking at: your columns, your filters, your date range, and the summary view if you are grouped. Available as Excel, CSV or PDF.

Data freshness

On Report pages, data is refreshed on an hourly basis.

Permissions

Access follows your existing back-office report permissions. Everyone who can see this report sees the whole company; use the Billing Location filter or group by Billing Location to narrow it down to one site.

Related articles