Fitness Studio Bookkeeping: Reconcile Prepaid Class Packs

Track sessions sold, used and refunded across a January promotion. Use the free class-pack tool to check remaining credits and their illustrative value.

LiveFixPro Bookkeeping Editorial Team

11/15/20265 min read

In the first week of January a studio sells ten-class packs faster than staff can prepare the welcome emails. By the end of the month, a teacher’s attendance sheet says one member used four visits, the booking app shows three and the front desk remembers giving a complimentary make-up. The original card payment is easy to find. The unfinished work is explaining what the member still owns. Fitness studio bookkeeping starts by keeping the unit schedule and the money schedule connected.

Prepaid class-pack checker

Count the sessions that are still owed

Choose one pack type, one branch or defined group of branches, and one closing date. Start with unused paid sessions at the opening, add new paid sessions issued, then subtract paid sessions redeemed and paid sessions removed for documented refunds or approved cancellations. Compare the result with the paid credits remaining in the booking system. A ten-pack sold counts as ten units. An attendance counts as one, even when two staff members record it. Keep complimentary visits in a separate schedule so a giveaway cannot look like a paid obligation.

In the tool’s example, 40 paid sessions are open, 90 more are issued, 66 are used and four are removed. The expected ending balance is 60 sessions. If the booking system shows 58, it shows two fewer than expected. At an illustrative $18 allocated per unit, the 60 sessions represent $1,080 on this schedule. The dollar result is meaningful only if that value applies to the cohort you entered. A ten-pack sold for $180 and one sold for $150 belong on separate calculations if you want to compare values. Round only after calculating the totals.

Build a pack history your front desk can explain

Give each pack an internal identifier and record the purchase date, amount paid, units issued, pack type and location. Connect redemptions to an attended class or the specific evidence your approved cancellation policy uses. Keep a separate field for manual changes and who approved them. A member who books two future classes may appear to have fewer available bookings in an app even though no class has been attended. Document whether the report uses booked seats or consumed credits before comparing it with your attendance-based schedule.

Square’s appointments documentation describes a package history with purchases, redemptions and manual changes to remaining quantity. Your own booking system may use different names. Find the equivalent history and export or save a copy at the close. A screenshot of the current customer balance alone cannot explain what changed after the close. Square’s package management guide.

Follow one member through a refund and a make-up

Suppose a member buys a ten-pack for $180 and attends four classes. Six paid sessions remain before other changes. Staff then refund the value of two unused sessions under the studio’s policy and cancel those two credits. The schedule now shows four paid sessions remaining. Save the refund reference and the two-unit removal together. If the processor refund exists but all six credits remain bookable, the studio may deliver visits it has already refunded. If the credits disappear before an approved refund is sent, the member has a different concern that needs action.

Now suppose a teacher gives the same member one complimentary make-up after a schedule change. Track that single visit separately as a service promise. Giving it the $18 value of a paid session would make the original cash look larger than it was. A front-desk view can display five available visits while the accounting support distinguishes four paid credits and one courtesy visit. That distinction is particularly useful if the member later requests a refund or moves to a new branch.

Match units to money without guessing revenue

The unit schedule answers how many paid visits remain. The processor report shows what customers paid and what the studio refunded. The books follow the business’s accounting method and approved revenue policy. Pair the schedule with the relevant balance in the books only after the person responsible confirms which packs and basis it covers. A single blended price can disguise a real discrepancy when promotions, different classes, fees or free sessions are mixed together.

At month-end, separate single paid drop-ins, recurring memberships, class packs, gift cards and promotional credits. A membership that permits unlimited visits has no fixed number of deliverable pack units, so this tool is inappropriate for that cohort. A gift card redeemable for several services also needs its own value-based schedule. If a pack expires, retain the governing terms and applicable review before treating the balance as released. Passing a calendar date by itself does not settle every financial or customer obligation.

Design a weekly check staff will actually run

Pick a closing time after the last class has posted attendance. Export the beginning and ending pack counts, new sales by product, attendance or policy-based redemptions and refund adjustments. Check a member who attended, one who cancelled and one whose balance changed manually. If a branch’s attendance sheet arrives late, leave a named exception. Updating all unit balances from an incomplete attendance export may look efficient while making tomorrow’s correction harder to trace.

When the tool shows a difference, work through the most likely record mismatch first. A gap of ten could be one omitted pack sale. Two might be a refunded pair of sessions still sitting in the booking app. An apparent gap of one at two branches could be the same member whose class was moved. Look for evidence of the change before adjusting the customer record. Save a note explaining the corrected reference and the report version you reviewed.

What to ask LiveFixPro to automate

An AI-assisted workflow can compare the sales export, attendance history and manual adjustments, then present candidates for review. In a pilot, use two packs with similar names, a refunded session and a cross-branch redemption. Ask the workflow to show which source contributed each number. Staff retain control of membership changes, customer communications, refunds and unusual classifications. A manager should be able to reconstruct a single member’s closing balance from the same records even if the automation is paused.

Measure how long the front desk spends explaining disputed balances and how many manual changes lack a reason. Review any proposed automation beside the existing process for one promotion cycle. If the studio can answer faster without sacrificing the audit trail, it has a concrete reason to extend the setup to another branch or offer. If the underlying product names are inconsistent, fix the catalog before purchasing more integrations.

A quick handoff for the next front-desk shift

Leave a closing note with the pack cohort, report cutoff, expected units, system units and the references being reviewed. Include the last attendance export that was checked. If tomorrow’s instructor reports a late attendance correction, the incoming manager can reopen that specific session instead of recounting the entire promotion. A member standing at the desk should receive one consistent answer even when the underlying records need a review.

Explore the bookkeeping guides and free tools

Start with the complete small business bookkeeping guide

Catering event deposit tracker · Event deposits and final invoices

Retail refund reconciliation tool · Returns, store credits and cash refunds

Florist stem inventory checker · Documented stem waste and stock counts

Vacation rental payout matcher · Multi-listing settlements and bank deposits

Browse all bookkeeping resources · Explore LiveFixPro bookkeeping services

Book a free bookkeeping and automation consultation · How an AI workforce handles everyday business tasks

Mailing address: 701 Tillery Street Unit 12-1904, Austin, Texas 78702, United States

Contacts

+1 914-639-6759

support@livefixpro.com

Privacy · Terms · Refund Policy

Free Tools· Bookkeeping directory

Get in touch

LiveFixPro Bookkeeping & Accounting Services LLC is an independent firm. Intuit, QuickBooks, and QuickBooks ProAdvisor are registered trademarks of Intuit Inc. used with permission under the QuickBooks ProAdvisor Agreement.