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:
| Report | What It Shows | Key Columns |
|---|---|---|
| Revenue Summary | Daily revenue breakdown | Date, services revenue, products revenue, tips, discounts, tax, net revenue |
| Products Revenue | Product sales detail | Product name, quantity sold, revenue, cost of goods, gross profit, margin percent |
| Payments & Refunds | All transactions | Date, client, amount, payment method, status, refunded amount |
| Tips Report | Tips by staff member | Staff name, tip amount, tip count, average tip, payment method |
| Tax Collected via Stripe | Tax breakdown | Taxable services revenue, taxable products revenue, tax collected, effective tax rate |
Running Financial Reports
Navigate to Reports
Click Reports in the left sidebar. Ensure you are on the Operational Reports tab (it is selected by default).
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.

Expand the Financial Reports group
Click Financial Reports to expand the accordion. You will see the five report rows listed inside.
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:
- Summary cards -- Aggregate totals like total revenue, total tips, total tax, total clients, etc.
- 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.

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.