Back to the blogBlog

How to Calculate Stylist Commissions Automatically

Lizandro Ruiz4 min read

If you run a salon or barbershop on Booksy or Vagaro, you already solved the easy part: clients book on their own, pay through the platform, everything looks professional. And yet, on the last day of every month, you sit in front of Excel copying transaction by transaction to figure out how much you owe each stylist. Hours you don't bill for, with human error included.

It's not that you haven't gone digital. It's that you went digital halfway: the booking platform charges, but it doesn't tell you how much each person earned.

Why this problem exists

Booksy and Vagaro are designed to fill calendars and collect payments — not for accounting. That's the gap:

  • Booksy has no native QuickBooks integration. Period. If you want that data in your books, you pull it manually or export a report and arrange it yourself.
  • Vagaro does have one, but as a premium add-on. You pay extra for a bridge that, in most cases, only moves total sales — it doesn't calculate individual stylist commissions, or distinguish service from product from tip.

Neither platform knows that Ana charges 40% on services and 10% on products, while Carlos has a guaranteed floor plus 35% on anything above a certain threshold. That logic lives in your head and in a spreadsheet that gets updated by hand every month.

The result: slow month-end closes, stylists sometimes questioning the number because there's no clear audit trail, and you solving an accounting problem with the wrong tools.

The solution: automate the bridge neither platform gives you

The idea isn't to replace Booksy or Vagaro, or pay for Vagaro's add-on. It's to build the bridge yourself with n8n — an automation tool that can talk to both your booking platform and QuickBooks Online (which has an open REST API and a native n8n node).

The flow, in four steps:

1. Extract transactions

n8n connects to your booking platform on a fixed schedule (e.g., nightly or at month-end) and pulls all transactions for the period: who performed the service, what was charged, amount, and whether it was a service, product, or tip. With Vagaro this is done via API; with Booksy, since there's no public API, it's typically solved by automating report exports and processing them with n8n.

2. Classify each line

Not all transactions earn the same commission. The flow separates automatically:

TypeExampleTypical treatment
ServiceCut, color, treatmentCommission per stylist %
ProductShampoo, wax, take-home treatmentDifferent rate, usually lower
TipTip left on the platformGoes directly to stylist, no salon commission

3. Calculate commission per stylist

This is where the business logic lives: an n8n node applies the configured percentage for each stylist and each transaction type. If you have mixed rules (guaranteed floor, volume tiers, bonuses), they're coded once and the flow applies them the same way every month — nobody has to remember Carlos's special rule.

4. Push clean entries to QuickBooks Online

The result — already classified and calculated — is written directly to QuickBooks as journal entries or sales receipts per stylist, ready for your accountant to review instead of rebuild. Since QuickBooks Online has a native n8n node, this is the most straightforward part of the whole flow.

Real example

A salon with 6 stylists and ~300 monthly transactions used to spend 4-6 hours closing commissions every month-end, almost always on a weekend. With the n8n flow in place, that close runs automatically every night: by the last day of the month, the per-stylist report is already assembled and the entries are in QuickBooks. The owner reviews, doesn't calculate.

The gain isn't just time. It's that now every stylist can request their breakdown and there's a single source of truth — not a spreadsheet only you understand.

Where to start

You don't need to automate the whole business at once. Start by mapping your current commission rules (even if they're only in your head) and the export format your platform gives you. With that, a basic n8n flow can be set up in a couple of days of work — not of learning to code.

If you'd rather have someone else build it while you keep taking clients, at Data Quimbaya we set up exactly this kind of flow for small businesses that already went digital but are still stuck in Excel. Reach out or share your story with #retodataquimbaya.

Stay golden ✌️

Every week you wait leaves money on the table.

In 30 minutes I'll show you what to automate first, what it costs, and when it pays back. Free.