The Financial Cockpit gives you a consolidated view of your financial activity. It helps you track what you have billed, what you have collected, what remains unpaid, and how payments reconcile with sales. You can use it to monitor revenue, export accounting-ready reports, analyse product performance, understand tax amounts, and identify clients with outstanding debt.
It helps you answer questions like:
How much have I billed, and how much have I actually collected?
What explains the gap between my sales and my payments?
Which products or product categories generate the most revenue?
How much tax have I billed or collected over the period?
Which clients owe money to the studio?
How are payments distributed across payment methods?
When will the money I collected reach my bank account?
💡Two key definitions before you start
Sale: a product purchased by a client, excluding gift cards. Sales are tied to products and invoice dates, and they should match the back-office Purchase report when the same time filters are applied. For example, a class pass, appointment pass, subscription, or retail product purchase is a Sale; a gift card purchase is not counted as a Sale in this cockpit.
Payment: a money transfer received by the studio. Payments are not necessarily tied to a Sale. Gift card redemptions and credit account payments are excluded because they do not represent a new money transfer to the studio.
Get started: select your filters
The main reporting period is based on the relevant financial date for each tab:
Sales-based tabs use invoice-based accounting, meaning revenue is recognised when the sale is invoiced.
Payments can be analysed from payment date or invoice date, depending on the selected view.
The filters at the top of the page apply across the cockpit:
Date: the time period for your analysis
Product: filter to one or more specific products
Product Type: filter by product category/type
Tax Included / Tax Excluded: switch eligible metrics between tax-included and tax-excluded amounts
Compare With: the benchmark period used for period-over-period comparisons
Group By: the time granularity for charts and reports
💡 Most of the cockpit uses invoice-based accounting: reports are based on Sales and revenue is recognised when invoiced, even if unpaid. For a cash-based view of money received by the studio, use the Payments tab.
1. Overview
Get a consolidated view of your sales performance and export a customisable sales report.
Key metrics
The KPI tiles summarise the main sales metrics for the selected period:
Metric | Definition |
Gross Sales | Product prices as seen by clients, before applying any discounts. |
Revenue | Amount billed to a client. It can be displayed including or excluding taxes. Different from the amount paid out from online transactions. |
Amount Collected | Amount effectively received and tied to Sales during the selected period. Useful for unpaid reporting and computing taxes actually collected. |
Number of Sales | Number of sales included in the selected period. |
Tax Billed / Tax Collected | Tax billed on sales, or tax effectively collected from received amounts. |
Sales Funnel
The funnel shows how your sales move from gross sales to revenue and collected amounts. It helps you understand what is deducted at each step, such as discounts, refunds, fees, taxes, and unpaid amounts.
Use the selected metric and comparison period to see how your financial performance evolves over time.
Sales Report
The report builder lets you export invoice-based accounting metrics such as:
Gross Sales
Revenue including or excluding taxes
Amount Collected including or excluding taxes
Number of Sales
Tax billed or collected
You can aggregate the report by product, product type, or without aggregation, and group results over time according to the selected reporting period.
The download button lets you export either:
Raw data, based on the back-office purchase report
Built report, using the selected aggregation, filters, and displayed metrics
Sales Forecast
⚠️ The forecast needs at least 12 months of sales history to project from. If your studio has less than that, the View switch does not appear and the sales trend stays on Comparison.
The sales trend has a View switch. Comparison shows the selected period against a benchmark period. Forecast projects where your revenue is heading if your current trend continues.
The forecast chart shows four series alongside your actual revenue:
Series | What it shows |
Revenue Including Tax | Your actual billed revenue, for periods that have already happened. |
Forecast | The projected revenue for periods that have not closed yet. |
Low Estimate / High Estimate | The range around the forecast. It widens the further ahead you look, because a projection becomes less certain with distance. |
Secured Revenue | Revenue already contracted for a future period, such as a subscription due to renew. |
Two controls apply to this chart: Forecast Period sets how far ahead you look, and Group By switches between Week and Month (default: Month).
💡 The gap between Secured Revenue and Forecast is the revenue you can still expect to earn before the period closes.
Sales & Payment Reconciliation
Sales and Payments do not always match. Sales are tied to products and invoice dates, while Payments represent money transfers received by the studio and are not always tied to a sale.
This section explains the gap between what you billed and what you received. For example:
A gift card purchase creates a payment but not a sale.
A gift card redemption creates a sale but not a payment.
Account balance movements can create sales or payments that do not appear in both reports.
Unpaid invoices create sales without full collection.
For each invoice, the reconciliation follows this logic:
Payments + Account Balance Decrease - Giftcard Sale + Giftcard Redemption + Unpaid + Other Regularisation = Revenue
💡 Since the payment report currently exists including tax only, the reconciliation section is most meaningful when amounts are displayed including tax.
🔨 How is the forecast calculated? The forecast is built only from your studio's own sales history. It looks at how your revenue has changed over time, both the overall trend (growing, stable or slowing) and the patterns that come back every year, such as a quiet summer or a busy January. It then carries those patterns forward. It only learns from months that are finished, so a month still in progress doesn't pull the projection down. It never goes below the revenue you have already secured for a period.
How far can you trust it? The forecast is most reliable for the next one to three months, and for studios whose revenue is fairly steady from month to month. Further ahead, treat it as a sense of direction (up, flat or down) rather than a target. It only knows your past, not your plans: a new class schedule, a promotion, a price change or a closure won't show up until it's in your sales. It is recalculated every day, so the figures can move a little from one day to the next.
2. Payments
Monitor all money transfers received by the studio and analyse how clients pay.
Unlike the Overview tab, which is based on Sales, this tab focuses on effective cash movements. It can be used to track incoming cash flow, export payment data, and understand payment method distribution.
Payments
The KPI tiles summarise the main payment metrics:
Metric | Definition |
Payments | All money transfers to the studio. Unlike Amount Collected, Payments are not necessarily tied to a Sale. |
Average Payment | Average value of positive payments. Negative payments such as disputes and refunds are excluded to better represent the average transaction amount. |
Number of Payments | Total number of payments counted in the selected period. |
The download button lets you export the payment report for the selected filters.
Payment Breakdown
Use Breakdown Payments by to choose how your payments are split: by Collection Status (default) or by Payment Method.
Payment Method shows which methods clients use most often and how much payment volume each one represents. Tooltips may include additional details such as number of payments and transaction fees.
Collection Status shows whether the money has reached your bank account yet:
Status | What it means |
Paid out | The money has reached your bank account. |
Paid out before tracking | The money reached your bank account, but before we started tracking payouts individually, so we cannot show you which payout it travelled in. Applies to payments collected before 2025. |
Payout in transit | Sent to your bank, not arrived yet. |
Payout failed | Your bank rejected the payout. The money returns to your balance and is included in a later one. |
Awaiting payout | Collected, not yet included in a payout. |
Collected manually | Cash, check, bank transfer, or a card entered in the back office. This money never goes through a payout. |
Collected via PayPal | PayPal collects and settles on its own rails, outside your payouts. |
💡 How to use it: Collection Status answers "of the money I collected this month, how much has actually reached my bank?" without leaving this tab. The Payouts tab then explains an individual payout.
3. Payouts
Follow your money from a client's payment to your bank account.
Only money that bsport collected on your behalf travels through a payout, whether that was an online checkout or a card reader connected to bsport. Money you collected another way never appears here: cash, check, bank transfer, credit account, PayPal, or a card machine of your own.
The tab has three parts, top to bottom. Upcoming Payout covers money you have collected that has not been paid out yet. Past Payouts explains the payouts you have already received, one at a time or across a period. Payout Report and Payout Detail are the exportable lists underneath.
Upcoming Payout
Three cards, each counting payments from the last 2 months:
Metric | Definition |
Estimated Next Payout Amount | Payments from the last 2 months that have not been paid out yet, after processing fees. |
Estimated Next Payout Arrival | When your next payout should reach your bank account, estimated from the time between your last two payouts. |
Payments Awaiting Payout | How many payments from the last 2 months have not been paid out yet. |
⚠️ The arrival date is an estimate built from your own payout history, not a commitment from your payment provider. If your payouts are irregular, read it as an indication rather than a date.
Past Payouts
Use Display to choose what you are looking at. Reporting Period shows every payout in the period you selected. Latest Payout shows only the most recent one.
In Reporting Period you can narrow further to specific payouts with the Payout filter. It clears whenever you change Display.
Payout Breakdown
A payout is rarely the same amount as the sales behind it. This chart shows what was added and removed along the way to the amount your bank received:
Gross Charge - Processing Fee + Net Refund + Net Transfer + Fee Adjustment + Other = Payout Amount
Category | What it covers |
Gross Charge | What your clients were charged, before fees and refunds. |
Processing Fee | The fee your payment provider charges on those payments. |
Net Refund | Refunds settled in this payout. |
Net Transfer | Transfers in or out of your balance. |
Fee Adjustment | Fees credited back to you, for example after a failed direct debit. |
Other | Everything remaining, so the categories always add up to the payout amount. |
The cards beside the chart show the Payout Amount that reached your bank, the Gross Charge Amount behind it, the Payout Status, and the Arrival Date.
Payout status | What it means |
Pending | Created, not yet sent to your bank. |
In transit | Sent to your bank, not arrived yet. |
Paid | The money has reached your bank account. |
Failed | Your bank rejected the payout. The money returns to your balance and is included in a later payout. |
⚠️ A few payouts have no breakdown available. The payout amount is still correct, but the categories are empty because the payout could not be matched with the payments behind it.
Payout Report and Payout Detail
Payout Report lists the payouts you selected. Payout Detail lists what each one was made of, payment by payment.
Both can be downloaded as Excel, CSV or PDF, and both let you choose which columns to include with the Columns control before you download.
⚠️ Payout Detail can include payments from outside your reporting period. A payout settles money collected over the days before it, so some of those payments fall before the period you selected.
4. Products
Analyse sales performance by product or product type.
This tab is based exclusively on Sales, meaning it reflects invoiced product activity rather than payment or cash collection behaviour. Gift cards are excluded because they do not represent a standard product sale in the sales reporting model.
Sales per Product over Time
This chart shows how products or product types contribute to Sales over time. Use it to identify seasonality, trends, and changes in product mix across the selected period.
Sales per Product
This ranked chart shows the top products or product types by Sales. You can:
Switch between product and product type grouping
Choose whether to display tax-included or tax-excluded values
Use the Top N filter to focus on the highest-performing products
The details table provides the same aggregation in a format that is easier to review or export.
💡 How to use it: compare your top products with their evolution over time to understand whether revenue is concentrated on a few products or spread across your catalogue.
5. Tax
Track taxes generated from Sales over the selected period.
The Tax tab is based on Sales data, meaning it reflects tax amounts derived from invoiced product activity rather than cash collection alone.
Collected Taxes
This section displays the evolution of taxes over time. You can switch between:
Tax Billed: tax amount billed on sales
Tax Collected: tax amount collected from amounts received on sales
Tax Report
The report builder lets you aggregate tax metrics by product, product type, or tax rate, and export their evolution over time.
Use this tab to review tax amounts for accounting purposes and to understand how tax collection differs from tax billing when some sales remain unpaid.
6. Client Debt
Identify clients with outstanding debt and understand how debt is calculated.
Debt is computed from two components: unpaid invoices and the client account balance.
debt = unpaid invoices - account balance
Client Debt
This section displays the list of clients in debt, with debt split between unpaid invoices and account balance.
It also includes Recent Debt, which still accounts for client account balance but only counts unpaid invoices issued in the last two months.
Use this tab to identify clients who owe the studio the most money and prioritise follow-up or reconciliation.
7. Billing Locations
Break down your sales, revenue, taxes and payments by billing location.
This tab mirrors the reports from the other tabs, with your billing locations as an extra dimension. It's the fastest way to produce per-entity figures — for accounting, for a franchise, or simply to compare how each billing location performs — without having to filter the whole report one entity at a time.
💡The Billing Locations tab is only available if you have at least one billing location set up. Sales and payments that are not attached to any billing location are grouped in a column labelled "—".
Sales Trends by Billing Location — pick a metric (amount collected, gross sales, revenue incl. taxes…) and see how it is distributed across your billing locations over the reporting period.
Sales Breakdown — the same exportable sales report as in the Overview tab, with one column per billing location. Group it by product, by product type, or not at all, and choose the metrics to display.
Revenue per Product by Billing Location — see which products drive revenue in each billing location.
Tax Report — group and export your tax data by product, product type or tax rate, broken down by billing location, on tax billed or tax collected.
Money received by the studio — all payments received per billing location over the period, by invoice date or payment date, and optionally split by payment method.
Key definitions
Term | Definition |
Sale | A product purchased by clients, excluding gift cards. Any metric reporting on Sale should match the back-office Purchase report with the same time filters. |
Gross Sales | Product prices as seen by clients, before applying any discounts. |
Discounts | Any coupon amount applied to a sale. Can be negative in certain cases. |
Revenue | Amount billed to a client. Can be expressed including or excluding taxes. Formula: Revenue including taxes = Gross Sales - Discounts. |
Amount Collected | Amount effectively received, tied to Sales on a given period. Different from Payments received on a period. |
Payments | All money transfers to the studio. Unlike Amount Collected, Payments are not necessarily tied to a Sale. Gift card redemptions and account balance payments are excluded, as they do not represent a money transfer to the studio. |
Tax Billed | How much tax was billed on a sale. Revenue including taxes = Revenue excluding taxes + Tax Billed. |
Tax Collected | Tax amount collected from the amount received on Sales. Amount Collected including taxes = Amount Collected excluding taxes + Tax Collected. |
Average Order Value | Average billed amount; the average product price bought by clients. |
Client Debt | Debt is computed from outstanding unpaid invoices and the client account balance: debt = unpaid invoices - account balance. |
Payout | A transfer of collected money from your payment provider to your bank account. One payout usually groups many client payments. |
Processing Fee | The fee your payment provider charges on online payments. It is deducted before the payout reaches your bank. |
Collection Status | Whether a payment has reached your bank account, is still on its way, or was collected outside your payment provider. |
Awaiting payout | Money you have collected online that has not been included in a payout yet. |
Best practices
Use the Financial Cockpit regularly to:
Monitor sales performance: track gross sales, revenue, and collected amounts over time.
Understand collection gaps: use reconciliation to explain why billed revenue differs from money received.
Export accounting reports: download built sales, payment, and tax reports with the right aggregation.
Optimise your product catalogue: identify the products and product types that generate the most sales.
Follow up on debt: review the Client Debt tab to identify clients with unpaid invoices or negative balances.
Track incoming money: use the Payouts tab to see what is on its way to your bank account and what has already arrived.
Data freshness
Data on this insight is refreshed hourly.
Permissions
The financial cockpit is available to all pricing plans