Month-End Close Automation & Financial Reconciliation3 min readUpdated September 2026

Closing the Books Across a Multi-Location MedSpa Group

Take a medspa group running four locations, each selling a mix of single-visit treatments and prepaid membership packages, with injectors compensated on a commission split and payments running through a merchant processor that carries its own chargeback risk. Here's how that close actually plays out, month by month, and where FloQast or BlackLine change it.

Vendors Covered in this Article

Disclosure: We may earn a commission if you buy through some links on this page. It doesn't change what we recommend.

The Membership Package Sold in January, Used Through June

A client buys a six-month package of treatments in January. The cash lands immediately, but revenue should be recognized as each treatment is actually performed, not all at once at purchase. If a client uses three of six sessions by June and then lets the membership lapse, the remaining deferred revenue needs a documented policy: forfeited, refunded, or extended, and that policy has to be applied the same way every time or the deferred revenue balance on the books stops meaning anything useful to whoever is reading it.

The Injector Commission That Spans Two Pay Periods

An injector's commission is typically calculated on services performed, but if the commission run and the revenue recognition run use different cutoff dates, a treatment performed on the last day of the month can show up in one period's commission expense and a different period's revenue. This group fixed it by aligning both processes to the same cutoff date and building a monthly checklist task to confirm they still match every close, which is exactly the kind of recurring task FloQast is built to track.

The Chargeback That Shows Up Two Months Later

Merchant processors typically allow chargebacks for a window well past the original transaction, meaning a treatment recognized as revenue in March can generate a chargeback reversal in May. Without a specific reconciliation between the merchant processor's settlement reports and the practice management system's revenue, these reversals get missed or booked as a generic expense instead of a proper revenue reversal, which understates the accuracy of every month they touch.

How the Numbers Actually Looked Once Fixed

Once this group standardized the package deferral policy, aligned the commission and revenue cutoffs, and added a monthly chargeback reconciliation, its close time dropped meaningfully, not because it bought a new platform first, but because the three specific breakpoints above were fixed. FloQast was layered in afterward to keep the discipline from slipping as the group added a fifth location, which is the order most single-entity, multi-location practice groups should follow.

When This Group Will Actually Need BlackLine

This group runs one legal entity across its four locations. If it were rolled up under a private equity platform alongside several other independently owned medspa groups, each with its own legal entity and merchant processor, that's the point where BlackLine's consolidation and processor-level transaction matching would replace what a single checklist tool can reasonably track by hand.

What the Wage Data Says About Staffing This

Healthcare support services carry one of the longer payables cycles among the sectors tracked nationally, at roughly 51.5 days relative to sales1, which is worth knowing when benchmarking how fast this kind of practice group should expect to turn around vendor payments. On staffing, the median accountant or auditor salary nationally sits at $83,680 a year2, a useful anchor for a group weighing a second bookkeeper against a close platform's subscription cost.

The Membership Renewal That Nobody Reconciles

Recurring membership fees, billed monthly for ongoing access to discounted treatments, are easy to set up and easy to forget to reconcile once they're running. A membership that's been canceled in the scheduling system but not in the billing system keeps generating deferred revenue that never gets recognized, since no treatments are ever booked against it. A monthly check comparing active memberships in the scheduling system against active billing subscriptions catches this specific mismatch before it accumulates into a real cleanup project, and it's the kind of small, repeatable reconciliation a checklist tool tracks well once the process itself is defined.

Why This Group Didn't Start With Software

It's worth naming directly: this group's first instinct was to shop for a close platform before fixing the package deferral, commission cutoff and chargeback gaps described above. Buying software first would have automated the same broken process faster, not fixed it. Fixing the process first, then automating it, is the sequence that actually worked here, and it's the sequence worth following for most multi-location practice groups facing a similarly messy close, whether the eventual choice is FloQast, BlackLine or simply a tighter version of the same spreadsheet checklist that got them through the fix in the first place.

Fix these breakpoints before shopping for a platform:

  • Set one documented policy for lapsed packages, whether the balance is forfeited, refunded or extended, and apply it every time.
  • Align the injector commission cutoff and the revenue recognition cutoff to the same date.
  • Reconcile merchant processor settlement reports to practice management revenue each month so late chargebacks get caught.
  • Compare canceled memberships in the scheduling system against the billing system to stop orphaned deferred revenue.
Executive Capability Standard

What Good Looks Like

A medspa group closes with prepaid package revenue recognized as treatments are performed against a documented lapse policy, injector commission and revenue recognition aligned to the same monthly cutoff, and merchant processor chargebacks reconciled against original revenue rather than booked as a generic expense.

Building The Capability (5-Stage Skill Ladder)

1. Learn:Pull the deferred revenue balance for prepaid packages and confirm it matches actual unused sessions across a sample of clients.
2. Do Manually:Align the commission calculation and revenue recognition cutoff dates and run the reconciliation by hand for two closes.
3. Delegate:Assign one person ownership of the monthly chargeback reconciliation against processor settlement reports.
4. Automate:Use FloQast to track these three reconciliations monthly across every location as standing tasks.
5. Buy:Move to BlackLine once multiple legal entities or processor relationships need consolidated, transaction-level matching.

How to Get Started

Disclosure: We may earn a commission if you buy through some links on this page. It doesn't change what we recommend.

Frequently Asked Questions

How should a medspa recognize revenue from a prepaid treatment package?

As each treatment is actually performed, not all at once when the package is purchased. The unused portion sits as deferred revenue, and the practice needs a documented policy for what happens to that balance if the client lets the package lapse before using all the sessions.

Why do chargebacks matter more for a medspa than a typical retail business?

Because the window for a client to dispute a charge often extends well past when the treatment was performed and the revenue recognized, so a chargeback can land two or three months after the original transaction. Without a dedicated reconciliation against processor settlement reports, these reversals get missed or miscoded.

Is BlackLine necessary for a medspa group running four locations under one entity?

Usually not yet. A single-entity group with a consistent deferral policy and reconciliation checklist across locations can typically run well on FloQast. BlackLine becomes relevant once multiple legal entities, often from a private equity roll-up, need to consolidate.

Sources

Where we quote a benchmark, we show its source. Other figures in this guide are estimates or general guidance, so check them against your own numbers.

  1. Payables days (AP/Sales x 365) by industry (US). NYU Stern (Aswath Damodaran), Working Capital Ratios by Industry, US, 2026.
  2. Annual wage, Accountants and Auditors (SOC 13-2011), US all industries. BLS OEWS May 2025, 2025.

Related Guides