How to Run Revenue and Financial Reports in SpaSphere

Generate revenue summaries, payment reports, tax reports, tips breakdowns, and product sales reports in SpaSphere with CSV export for your accountant.

9 min read

SpaSphere's financial reports give you clean, organized data for bookkeeping, tax preparation, and business analysis. From daily revenue breakdowns to staff tip summaries, every report is sortable, exportable, and designed to match what your accountant needs. Access them from Reports > Operational Reports in the SpaSphere admin dashboard.

Why This Matters for Your Spa

Spas that maintain organized financial records save an average of 5-10 hours per month on bookkeeping and avoid costly mistakes at tax time. A misclassified payment or missed refund can create discrepancies that take hours to untangle. SpaSphere generates your reports directly from Stripe transaction data, so numbers match your payment processor records exactly. This eliminates the manual reconciliation that eats up your evenings and ensures your accountant gets clean data on the first pass, saving you $200-$500 in accounting fees per quarter.

Available Financial Reports

SpaSphere offers five financial reports under the Financial Reports accordion group:

ReportWhat It ShowsKey Columns
Revenue SummaryDaily revenue breakdownDate, services revenue, products revenue, tips, discounts, tax, net revenue
Products RevenueProduct sales detailProduct name, quantity sold, revenue, cost of goods, gross profit, margin percent
Payments & RefundsAll transactionsDate, client, amount, payment method, status, refunded amount
Tips ReportTips by staff memberStaff name, tip amount, tip count, average tip, payment method
Tax Collected via StripeTax breakdownTaxable services revenue, taxable products revenue, tax collected, effective tax rate

Running Financial Reports

1

Navigate to Reports

Click Reports in the left sidebar. Ensure you are on the Operational Reports tab (it is selected by default).

2

Set your date range

Use the date range picker in the top-right area. Select a start date and end date, then click Apply. For monthly bookkeeping, use the first and last day of the month. For quarterly tax prep, span three months.

Date range picker showing start date and end date fields with an Apply button
Set precise date ranges to match your accounting periods.
3

Expand the Financial Reports group

Click Financial Reports to expand the accordion. You will see the five report rows listed inside.

4

Select a report to view

Click a report row (e.g., Revenue Summary) to load the data inline. The report renders below the row with two sections:

  1. Summary cards -- Aggregate totals like total revenue, total tips, total tax, total clients, etc.
  2. Data table -- A sortable table with individual rows. Click any column header to sort ascending or descending. Click the same header again to reverse the sort order or a third time to clear it.
Revenue Summary report showing summary cards for total revenue, total tips, total tax, and total appointments, plus a sortable table with daily rows
The Revenue Summary shows aggregate totals at the top and daily detail below.
5

Download the report as CSV

Click the CSV button on the report row to download the full dataset. The CSV includes all rows (not just the 50 displayed in the browser) and preserves the column headers for easy import into Excel, Google Sheets, QuickBooks, or Xero.

Sort by net revenue to find your best and worst days

After loading the Revenue Summary, click the net revenue column header to sort descending. Your highest-revenue days appear at the top. Compare them to your lowest days to understand what drives the difference -- was it a particular service, a promotion, or simply a busy Saturday? This 30-second exercise often reveals patterns that inform scheduling and marketing decisions worth hundreds of dollars per month.

Revenue Summary Deep Dive

The Revenue Summary is the most commonly used financial report. Each row represents one day in your selected date range. Here is what each column means:

  • Date -- The calendar date
  • Services Revenue -- Total collected from service appointments
  • Products Revenue -- Total collected from product sales at checkout
  • Tips -- Total tips collected via Stripe
  • Discounts -- Total discount amounts applied
  • Tax -- Total tax collected via Stripe
  • Net Revenue -- Services + Products + Tips - Discounts (tax reported separately)

Revenue is based on completed payments

SpaSphere calculates revenue from confirmed Stripe payments, not from booked appointments. An appointment that is booked but not yet paid does not appear in revenue reports until the payment clears. Refunded transactions reduce the revenue figure for the day the original payment was made, keeping your records accurate.

Products Revenue Report

If you sell retail products through SpaSphere, the Products Revenue report gives you margin analysis:

  • Product Name -- The product sold
  • Quantity Sold -- Units sold in the period
  • Revenue -- Total sales amount
  • Cost of Goods -- Your cost basis (if entered in inventory)
  • Gross Profit -- Revenue minus cost of goods
  • Margin Percent -- Profit as a percentage of revenue

This report helps you identify your most profitable products, spot items with declining sales, and decide which products to reorder or discontinue.

Tips Report

The Tips Report breaks down gratuities by staff member, making payroll processing straightforward:

  • Staff Name -- The team member who received tips
  • Tip Amount -- Total tips for the period
  • Tip Count -- Number of tipped transactions
  • Average Tip -- Mean tip amount per transaction
  • Average Tip Percentage -- Mean tip as a percentage of service price
  • Payment Method -- How tips were collected (card, cash, etc.)

Use tips data for payroll

Export the Tips Report as CSV at the end of each pay period and import it into your payroll system. This eliminates manual tip counting and ensures every team member receives their correct share. SpaSphere tracks tips at the transaction level, so the numbers are precise and auditable.

Tax Report

The Tax Collected via Stripe report provides the data your accountant needs for sales tax filing:

  • Taxable Services Revenue -- Revenue from services that had tax applied
  • Taxable Products Revenue -- Revenue from products that had tax applied
  • Tax Collected -- Total tax amount collected through Stripe
  • Effective Tax Rate -- Actual tax rate across all taxable transactions
  • Exempt Sales -- Revenue from transactions with no tax applied

This is not tax advice

The tax report shows what Stripe collected on your behalf. It does not constitute tax advice. Tax rates are configured in your Stripe settings and applied at checkout. Always consult your accountant to ensure you are meeting your local tax obligations. SpaSphere does not handle tax filing or remittance.

Payments and Refunds Report

The Payments & Refunds report provides a transaction-level view of all money movement:

  • Date -- Transaction date
  • Client -- Who paid
  • Amount -- Transaction amount
  • Payment Method -- Card type, last four digits
  • Status -- Successful, refunded, partially refunded, or failed
  • Refunded Amount -- If applicable, how much was returned

This report is essential for reconciling your Stripe payouts with your bank deposits. Sort by status to quickly find all refunded transactions in a period.

Frequently Asked Questions

Ready to try this in your spa?

$1 for 30 days. No contracts. We migrate everything for you.