Cycling studios run on a mix of ride packs, unlimited memberships, and retail sales. The financial model looks straightforward on the surface, but the details add up quickly - especially when you factor in bike maintenance, technology costs, instructor pay, and per-class profitability. A fitness virtual assistant with QuickBooks skills keeps the numbers organized so you can focus on building your rider community.
This guide covers how a VA sets up and manages QuickBooks specifically for indoor cycling studios.
Cycling Studio Chart of Accounts
A properly structured Chart of Accounts captures every way your studio earns and spends money. Your fitness virtual assistant should customize QuickBooks with these categories from the start.
Income accounts:
- Unlimited monthly memberships
- Unlimited annual memberships
- Ride packs (5-ride, 10-ride, 20-ride)
- Single ride drop-ins
- Private and corporate group rides
- Retail sales (apparel, water bottles, cycling shoes)
- Shoe rental fees
- Gift card sales
- Workshop and special event revenue
- Late cancel and no-show fees
Expense accounts:
- Bike maintenance and repair
- Bike replacement (capital expenditure)
- Technology and AV systems (screens, sound, performance tracking software)
- Instructor compensation (per-class and salaried)
- Facility rent and CAM charges
- Utilities (cycling studios use significant electricity for lighting and sound)
- Cleaning and laundry services
- Towel and amenity supplies
- Marketing and social media
- Software subscriptions (booking platform, music licensing, CRM)
- Insurance
- Credit card and payment processing fees
Using Classes for multi-format tracking:
If your studio offers different ride formats - endurance, HIIT, rhythm, strength - your VA can set up Classes in QuickBooks to track revenue and instructor costs by format. This reveals which ride types fill up fastest and which generate the most revenue per seat.
Recurring Billing and Ride Pack Management
Cycling studios depend on predictable recurring revenue. Your VA uses QuickBooks to automate as much billing as possible.
Unlimited membership billing:
- Set up Recurring Transactions for each unlimited member
- Choose monthly or annual billing cycles
- Enable QuickBooks Payments for automatic credit card or ACH charges
- Configure automatic payment failure notifications
- Create a process for membership freezes (pause the Recurring Transaction and note the resume date)
Ride pack Sales Receipts:
Ride packs are prepaid, so your VA records them as Sales Receipts at the time of purchase. Key considerations:
- Each pack size (5, 10, 20 rides) gets its own product/service item in QuickBooks
- The revenue is recognized at purchase since rides are non-refundable at most studios
- Your VA maintains a separate tracker for remaining rides per member (QuickBooks does not count sessions)
- When a pack expires or is renewed, a new Sales Receipt is created
Corporate and group bookings:
- Invoice the company or group organizer with a detailed line-item breakdown
- Apply any negotiated group discount as a line item
- Track corporate revenue in a sub-account or tag it with a "Corporate" Class
Late cancel and no-show fees:
- Your VA creates invoices for these fees based on the booking platform's reports
- A separate income account keeps this revenue visible without inflating ride revenue numbers
Expense Tracking for Bike Maintenance and Technology
Cycling studios have unique ongoing costs. Bikes break down, technology needs updates, and the sensory experience (lighting, sound, screens) demands investment.
Bike maintenance tracking:
Your VA should create a system for tracking per-bike maintenance costs:
- Log each repair or part replacement with the bike number in the memo field
- Categorize routine maintenance (cleats, pedals, resistance knobs) separately from major repairs (flywheel, frame)
- Track warranty claims and vendor credits
- Set up Bank Rules to auto-categorize purchases from bike manufacturers and parts suppliers
Technology expenses:
- Performance tracking software subscriptions (Spivi, QZ, proprietary systems)
- Sound system maintenance and speaker replacement
- Screen and projector costs
- Wi-Fi and networking infrastructure
- Music licensing fees (critical for cycling studios that use curated playlists)
Instructor compensation:
Many cycling studios pay instructors per class rather than a salary. Your VA tracks this by:
- Recording instructor payments categorized to "Instructor Compensation"
- Using Classes to tag payments by ride format if instructors teach multiple types
- Reconciling class counts from the booking platform against payment records
- Processing 1099 forms at year-end for independent contractor instructors
Revenue-Per-Class Reporting
The most important metric for a cycling studio is revenue per class. Your VA uses QuickBooks data combined with class attendance records to calculate this.
How to build a revenue-per-class analysis:
- Pull total ride revenue from the Profit & Loss report for the period
- Divide by the number of classes held (from your booking platform)
- Factor in the weighted value of ride pack riders vs. unlimited members
- Subtract per-class costs (instructor pay, incremental cleaning, music licensing)
Monthly reports your VA should generate:
- Profit & Loss statement with Class breakdown (by ride format or time slot)
- Cash Flow Statement
- Revenue trend - comparing this month to last month and the same month last year
- Membership count and churn rate
- Ride pack sales velocity (are riders buying packs faster or slower than last month)
- Retail sales summary with margins
Quarterly reports:
- Per-class profitability by time slot (6 AM rides vs. noon vs. 6 PM)
- Instructor cost as a percentage of revenue
- Bike maintenance cost per bike
- Marketing spend vs. new member acquisition
- Gift card liability (sold but unredeemed cards represent a liability)
Using Locations for multi-studio tracking:
If you operate more than one studio, your VA sets up Locations in QuickBooks. Every transaction gets tagged with the studio location, enabling side-by-side Profit & Loss comparisons between studios.
Daily VA Tasks for Cycling Studio Bookkeeping
A structured daily routine keeps your books accurate and your cash flow visible.
Morning tasks (15-20 minutes):
- Download and categorize new bank and credit card transactions
- Apply Bank Rules and review exceptions
- Check for failed automatic membership payments
- Process any ride pack purchases from the previous evening
Midday tasks (10-15 minutes):
- Record retail sales if not automatically synced
- Process any corporate group booking invoices
- Handle member billing inquiries
- Record shoe rental revenue
End-of-day tasks (10-15 minutes):
- Reconcile payment processor deposits against QuickBooks records
- Record late cancel and no-show fees from the booking platform
- Flag any discrepancies for the studio owner
- Update the weekly revenue tracker
Weekly tasks:
- Run accounts receivable aging and follow up on unpaid invoices
- Reconcile all bank and credit card accounts
- Review instructor payment records against the class schedule
- Send the owner a weekly financial summary with key metrics
- Back up QuickBooks data
Monthly tasks:
- Close the previous month's books
- Generate Profit & Loss, Cash Flow Statement, and balance sheet
- Review and update Recurring Transactions (new members, cancellations, price changes)
- Calculate revenue per class and compare to targets
- Prepare sales tax filings for retail sales if applicable
For the full scope of work a fitness VA can handle, review the fitness virtual assistant tasks list.
Building a Financially Clear Cycling Studio
Cycling studios thrive when owners understand their numbers at a granular level. Knowing your revenue per class, your bike maintenance costs, and your membership churn rate helps you make better decisions about scheduling, pricing, and expansion.
A fitness VA running QuickBooks daily gives you that clarity. The combination of a well-structured Chart of Accounts, automated Recurring Transactions, smart Bank Rules, and consistent reporting turns raw transaction data into actionable business intelligence.
If you are ready to bring on a VA for your studio, the guide to hiring a fitness virtual assistant covers how to evaluate candidates and set them up for success.
Frequently Asked Questions
How does a VA track ride pack revenue vs. membership revenue in QuickBooks?
Your VA creates separate income accounts for each revenue type - "Ride Pack Sales" and "Unlimited Membership Revenue." Ride packs are recorded as Sales Receipts at purchase. Memberships are billed through Recurring Transactions. This separation makes it easy to see how much of your revenue is prepaid versus recurring when you run a Profit & Loss report.
Can QuickBooks track revenue per class for a cycling studio?
QuickBooks alone does not calculate revenue per class automatically. Your VA combines QuickBooks revenue data with attendance data from your booking platform to calculate this metric. By using Classes in QuickBooks to tag revenue by ride format or time slot, the per-class analysis becomes much more granular and useful.
What is the best way to handle gift card sales in QuickBooks?
Gift card sales should be recorded as a liability (unearned revenue) rather than income. When a gift card is redeemed, your VA moves the amount from the liability account to the appropriate income account. This prevents you from overstating revenue and gives you an accurate picture of how much gift card liability is outstanding at any time.
How should a multi-studio cycling business use QuickBooks?
Your VA sets up Locations in QuickBooks for each studio. Every transaction - income, expense, and transfer - gets tagged with its location. This enables Location-based Profit & Loss reports that compare studio performance side by side. QuickBooks Online Plus and Advanced both support Location tracking.
How often should a cycling studio VA reconcile payment processor accounts?
Daily reconciliation is strongly recommended. Cycling studios process a high volume of small transactions through platforms like Stripe, Square, or MindBody payments. Daily reconciliation catches discrepancies quickly - a missing deposit, a double charge, or a processing fee variance - before they compound into larger problems at month-end.