Small Business

Session Management for Personal Training

Replacing spreadsheets with automated session and payment tracking, turning 15 minutes of reconciliation per client into a single click.

Phased build·Custom Web AppSquare IntegrationProcess Automation

15x

Faster per-client reconciliation

Per-client matching: 15 minutes manual → one click

100%

Square data automated

All appointments and payments sync without manual entry

4

Workflows replaced

Sync, matching, balance tracking, and low-session alerts

Executive Summary

The Challenge: The owner spent 15–20 minutes per client reconciling Square payments to training packages, tracking remaining sessions, and spotting clients running low: all in spreadsheets that were starting to break under the weight of a growing client base.

The Solution: A custom web app that syncs with Square automatically, tracks session packages, calculates balances in real time, and surfaces clients running low. Matching a Square transaction to a client package went from a 15-minute task to one click.

The Results: A growing business that no longer has to choose between client acquisition and back-office time, and an owner who can spend the recovered hours on training, not bookkeeping.

Interactive Prototype

See how session tracking works

A working prototype illustrating the dashboard, client management, and payment assignment workflows.

Interactive prototype

Session Tracker

Best experienced on a larger screen, or open in a new tab to view at full size.

View prototype

About the Client

Personal Training Business

An independent personal training business with a growing client base and package-based session pricing. The owner runs the entire operation solo: training sessions, scheduling, payment collection, client communication, and the back-office work that ties it all together.

The Challenge

The business was successful, which was the problem. As the client base grew, the back-office work scaled with it: every new package purchase meant another reconciliation, another spreadsheet update, another mental tally of "how many sessions are left." Square handled the payment collection beautifully, but it had no concept of "training packages" or "remaining sessions," so the owner was doing all that bookkeeping by hand.

Fifteen to twenty minutes per client doesn't sound like much, until you're multiplying it by a growing client list every month. Spreadsheet formulas were fraying. Clients were occasionally double-booked against packages they'd already exhausted. And the owner was running out of evenings to keep the back office in sync with the actual business.

Our Approach

We built a custom application that sits on top of Square and turns its raw payment and appointment data into the operational picture a personal training business actually needs.

The core integration is bidirectional and continuous: Square pushes appointments and payments throughout the business day; the app categorizes, allocates, and surfaces them. Payment assignment, matching a Square charge to a specific client's training package, is the moment that used to take 15 minutes; in the new app, it's a one-click action from a dedicated queue of pending matches.

On top of the integration sits the operational layer the business actually runs on: live session balances per client, proactive alerts when a client is running low, and dashboards that highlight clients due for follow-up. The owner gets the front-of-house clarity (who's on the books, who's about to lapse) and the back-of-house automation (no more spreadsheet reconciliation) from a single interface.

Outcomes

Automated tracking that connects to the tools already in use, giving the owner back the time the back office used to consume.

Live Session Balances

Every client's purchased, used, and remaining sessions visible at a glance with color-coded progress indicators.

Square Integration

Appointments, payments, and customer data sync automatically during business hours. No double entry.

One-Click Assignment

New Square payments surface in a dedicated queue. Match a payment to a client package in seconds instead of minutes.

Proactive Alerts

Dashboard highlights clients who are low or out of sessions so the owner can follow up before it becomes an issue.

Looking Ahead

What's Next

With the operational layer in place, the business is positioned to add more clients without proportionally adding back-office time, and to layer in additional features (automated renewal nudges, package recommendations, client-facing portals) as the practice grows.

Key Takeaway

Small-business software doesn't need to be cheap. It needs to fit. The right custom layer on top of tools already in use can recover hours per week that a generic SaaS subscription never would.

Let’s talk

Let’s build something that matters.

Tell us about your mission. We’ll bring the strategy, design, and engineering. One small senior team, start to finish, ready to have something working in weeks.

Rilo Labs

Software for the work that matters. Built end to end by a small senior team.

Contact Us

Email: hello@rilolabs.com

© 2026 Rilo Labs. All rights reserved.