Getting the booking system to agree with the books
The booking system knows what was sold, to whom, by whom and what is still owed. The accounting system knows what hit the bank. Neither is wrong; they answer different questions, and something has to tie them together.
What the booking system holds
- Sales by service, provider, room and client
- Membership status, billing dates and failed payments
- Outstanding package units and member credit balances
- Gift card issuance and redemption
- Retail sales and, usually, inventory on hand
- Tips, discounts and comps
That is nearly everything needed to run the business. What it does not reliably produce is a set of accounting entries that respect the difference between cash received and revenue earned.
Where the two diverge
| Gap | What happens |
|---|---|
| Deferred revenue | Most integrations post the full sale to revenue. Memberships, packages and gift cards all land as income on the day they are sold. |
| Processor settlement | A day's sales arrive in the bank net of fees, sometimes across several deposits and a day or two later. Gross sales, fees and deposits all have to reconcile. |
| Tips | Collected with the sale, paid out through payroll. They pass through a liability account rather than touching revenue. |
| Refunds and voids | Handled differently by every system. Some reverse the original sale; some post a negative sale in the current period. |
| Inventory | Booking-system inventory and general ledger inventory drift steadily unless someone reconciles a physical count. |
| Multi-location | A gift card sold at one site and redeemed at another needs a settlement mechanism between them. |
The monthly tie
- Gross sales per the booking system equals gross revenue plus the movement in deferred balances.
- Deposits per the bank equals gross sales less processor fees, less tips paid out, plus or minus timing at the period boundary.
- Outstanding package, membership credit and gift card balances per the booking system equal the deferred revenue and gift card liability accounts.
- Retail inventory per the count equals the inventory account.
- Provider compensation per the commission report equals provider cost in the general ledger.
Done every month they take under an hour. Left for a year they take a week, and the answers are worse.
Choosing and configuring
The platforms differ more in depth than in kind. Mindbody and Vagaro are strong on scheduling and membership for studios and smaller spas. Boulevard and Zenoti go deeper on multi-location operations, inventory and reporting, with Zenoti aimed at larger chains. Medspas frequently add a clinical system such as Aesthetic Record or PatientNow alongside, which means a third source of truth to reconcile.
Whichever you run, the configuration decisions that matter for accounting are the same:
- Does the integration post a daily summary or individual transactions? A summary is almost always easier to reconcile.
- Does it post membership and package sales to revenue or to a liability account? If revenue, that is the manual entry you now own.
- Are service categories mapped to the right revenue accounts, and does the mapping survive someone adding a new service?
- Are tips mapped to a liability rather than to revenue?
- Do refunds reverse the original period or hit the current one?
Get the mapping right once at setup and the monthly work is a reconciliation. Get it wrong and it is a re-coding exercise every month, forever.
Frequently asked
Which booking system is best for accounting?
None of them removes the deferred revenue work. Boulevard and Zenoti export more usable accounting detail and handle multi-location better; Mindbody and Vagaro are lighter and fine for a single site. The configuration matters more than the choice.
Should we use the built-in QuickBooks integration?
Usually yes, configured to post a daily summary rather than individual transactions. Check what it does with memberships, packages and tips before trusting it — most post the full sale to revenue, which is the entry you then have to correct.
How long should the monthly reconciliation take?
Under an hour for a single location with clean mapping. If it takes a day, the mapping is wrong or the reconciliation has been skipped for several months.
Do we need a separate clinical system in a medspa?
Usually, for charting and consent. It adds a third system to reconcile, so map which system is the source of truth for revenue before going live — typically the booking or POS system, with the clinical system carrying the record rather than the money.
Related
The monthly close for a spa or medspa
A close checklist built around deferred revenue, inventory and utilisation, and the small set of numbers worth looking at when it lands.
Read →A chart of accounts for a spa or medspa
Structuring the books so service and retail separate by construction, deferred revenue is visible, and margin reports fall out of posting.
Read →Memberships and packages: what you have actually earned
Why membership and package money is a liability rather than revenue, how to move it as it is delivered, and what happens when nobody does.
Read →