Roll med-spa treatment packages from sale to completed visit

Published October 5, 2026. This guide concerns bookkeeping preparation. It is not medical, accounting, tax, legal, privacy, advertising, or regulatory advice.

A med spa may collect cash today for a package of laser, facial, or injectable services delivered over several months. The point-of-sale system records the sale, the payment processor records a settlement, the scheduling platform records visits, and the ledger records financial treatment. If the team books the full settlement from the bank and never follows the remaining package units, refunds and unused value become difficult to explain.

Build the rollforward around a package ID rather than a patient's name. The core fields are location, package type, sale date, approved unit count, gross price, discount, tax if applicable, processor transaction, starting unused value, visit dates or completion events, units used, authorized transfers, refunds, adjustments, and ending unused value. Keep clinical detail out of the bookkeeping file. The identifier should allow an authorized reviewer to trace to the source system without exposing more health information than the task needs.

The U.S. Department of Health and Human Services provides HIPAA resources for professionals. Applicability and required safeguards depend on the organization and activity, so an authorized privacy owner should define access, storage, retention, and disclosure rules. A remote bookkeeper should receive only approved fields through named access, use approved storage, and avoid downloading patient lists to personal devices or general-purpose folders.

Separate financial evidence from treatment decisions. A bookkeeping preparer needs evidence that the approved service event occurred, not a diagnosis, photographs, or clinical narrative. If the scheduling export cannot provide a minimal completion status, ask the system owner for an approved report rather than broadening access to the clinical record. Document which system supplies the authoritative completion event.

At implementation, reconcile the prior closing package register to the ledger balance and the source system's unused package report. Preserve differences as opening exceptions. Do not rewrite customer history to make the total agree. For each month, calculate opening unused value plus new package sales and authorized additions, less value assigned to completed visits, refunds, transfers out, and approved expirations, to reach closing unused value.

Unit counts and dollar values both matter. A six-visit package discounted to $900 is not necessarily reduced by the menu price each time. Use the company's approved allocation rule, keep the math visible, and route unusual combinations or bonus services for review. The bookkeeper applies the documented method; the controller or qualified adviser approves the accounting policy and any change to it.

Suppose package MS-2481 contains four sessions and sold for $1,120 after a discount. The schedule shows one completed session in September, a second appointment marked “rescheduled,” a third appointment completed in October, and a $280 approved refund after the client moves away. Under the approved equal-allocation rule, the rollforward removes $280 for each completed session and $280 for the refund, leaving $280 unused. A rescheduled appointment does not count as usage merely because it occupied a time slot.

The processor settlement for the refund may appear days after the approval. Keep approval date, processor initiation date, settlement date, fee treatment, and bank trace separate. If the original payment is disputed, link the dispute to the package but do not also record an ordinary refund unless evidence shows both occurred. Duplicate recovery is a specific exception, not a reason to net all payment activity.

Package transfers, service substitutions, complimentary visits, membership benefits, and location moves can break a simple unit schedule. Give each event a reason code, source reference, initiating employee, approver, and effective date. Preserve the original package and create linked movement lines rather than overwriting it. A substitution from one service to another may require a value decision that the medical director, operations owner, and finance reviewer must approve.

The FTC maintains current health claims guidance. Marketing claims and refund terms are outside a bookkeeper's authority. The schedule should reproduce the approved policy version and observable transactions, not infer what a customer was promised. Escalate cases where the signed terms, point-of-sale description, and staff notes conflict.

Tie package sales and refunds to processor activity and cash; tie package creation, usage, transfers, and expirations to the operating systems; and tie the approved monthly movements to the general ledger. A bank tie-out alone cannot prove visit usage, while a package-unit tie-out cannot prove settlement completeness. Review new package types, manual adjustments, negative balances, unusually old balances, and packages with activity after an approved refund.

If the spa changes its scheduling or point-of-sale platform, preserve an export from the old system and define how every open package maps to the new one. Compare package counts, unused units, unused value, refunds in progress, and customer identifiers before accepting the converted opening balance. Record packages that cannot be matched as conversion exceptions rather than creating generic opening credits.

Run both systems in parallel for an approved test window when practical, and have the responsible owner sign off on conversion totals. After cutover, watch for visits posted to the old platform, duplicate package IDs, and refunds initiated in one system but settled in another. The migration file should explain these cross-system events without expanding the bookkeeper's access to clinical records.

Close with source snapshots, the package rollforward, processor bridge, exceptions, authorized decisions, and ledger tie-out. Track unmatched sales, completion events awaiting import, refund settlement age, negative packages, and manual adjustments. These measures reveal handoff problems, not clinical or financial performance. If you want a Philippines-based bookkeeping role to maintain the schedule under your privacy and approval model, review Offshore Bookkeepers' services and contact the team.