Staff Reports, Earnings Waterfall, and Commission Calculation

Overview

Staff Reports show how your team is performing — bookings, revenue they generated, hours worked vs. booked, payroll, and goals.

Navigation: Reports → Staff Reports. Owners and managers with the right permission see every staff member's report; a staff member without that permission sees only their own report automatically.

How to use it: Use the branch/period filter at top. Tap the info icon ("How these numbers are calculated") at any time to open a full glossary explaining every money metric and its exact formula — the same glossary is used for the business-wide view and for each individual's report, so the numbers are always defined consistently.

Top-row metrics (business-wide): Tips, Utilization Rate, Total Staff, Hours Worked.

The Staff Earnings Waterfall

This is the core "sales hierarchy" for staff performance, shown as a step-by-step build-up:

Step: 1 — Metric: Full Price Value (GMV) — Meaning: The full list price of every service delivered, before any discount or allowance — what the work was worth at full price.
Step: 2 — Metric: − Discounts — Meaning: Promotional or manual discounts applied to services, including this staff member's proportional share of any cart-level (whole-order) discount.
Step: 3 — Metric: − Membership & Package Allowance — Meaning: The gap between a service's list price and what was already prepaid for it when the client bought their membership or package — that amount was already recognized as revenue at the time the membership/package itself was sold, so it's backed out here to avoid double-counting.
Step: 4 — Metric: = Gross from Earnings — Meaning: Service earnings after discounts and prepaid allowances — the headline revenue figure, and the basis for commission (see "How commission is calculated" below).
Step: 5 — Metric: − VAT — Meaning: The tax portion of Gross from Earnings.
Step: 6 — Metric: = Net Revenue — Meaning: What the business keeps from services before other costs, with VAT removed.

Retail sales sit beside this waterfall, and are never mixed into it:

Product Sales — retail revenue from products this staff member sold.
Membership Sales — revenue from memberships they sold.
Sales Discounts — cart discounts applied to those product/membership sales.
Total Sales = Product Sales + Membership Sales − Sales Discounts (including VAT). Net Sales = the same, with VAT excluded.
Total incl. Sales = Gross from Earnings + Product Sales + Membership Sales − Sales Discounts (everything this person brought in).
Total Net = Net Revenue + Net Sales (all revenue, VAT excluded).

Other metrics on this screen: Tips (never included in revenue or commission — they're paid entirely to the staff member separately), Hours Worked, Hours Booked, Utilization Rate, Bookings Completed, Unique Clients, Services Count.

Below the waterfall: a Payroll section (Total Earned, Total Paid, Total Pending, per staff member), a Booking/Services chart, a Goals section (booking goals and revenue goals, when set for staff), and a full Staff Summary Table.

Individual Staff Report: the same figures — Payroll, Utilization, Revenue Breakdown (the same earnings waterfall), a Bookings Log, and a Clients card — scoped to one staff member. Reached by tapping a staff member from the Staff Reports list, or shown automatically to a staff member viewing their own report.

How commission is calculated

Whatever commission plan your business uses, it always starts from the same underlying revenue figure per staff member — essentially Net Revenue from the waterfall above, calculated service-by-service:

A service covered by a package is valued at the share of the package price that was allocated to it.
A service covered by a membership is valued at the prepaid amount recorded when the membership was sold (already net of that membership's own discount).
A regular, full-price service is valued at its price after both its own discount and its share of any cart-level discount.

Tips are always excluded — they go 100% to the staff member separately — and VAT is always excluded. Cancelled or voided bookings, and any deleted service lines, never count toward commission.

From that same revenue base, WAJ supports three ways to calculate the actual commission amount, depending on how your business has set up its commission plans:

Per-item commission — each service, product, membership, or gift card sale carries its own commission rate or fixed amount (set per item or per rule), and the total is simply the sum of those.
Tiered — progressive — your revenue is split into brackets, and each bracket's own rate applies only to the slice of revenue that falls inside it, the same way progressive income tax works. For example, with brackets of 5% up to the first tier, 8% for the next slice, and 10% above that, a staff member with 35,000 in revenue would earn 5% on the first slice, 8% on the next, and 10% only on the remainder above that — not 10% on the whole 35,000. (A "fixed" variant of this plan instead awards a flat bonus each time a threshold is crossed.)
Tiered — salary-based — your business sets a base salary; commission is only calculated on the revenue above that salary (the "excess"). Unlike the progressive plan, the entire excess is taxed at a single rate — whichever bracket the total excess falls into — rather than being split slice-by-slice.

Whatever a staff member ultimately gets paid is their total commission earned, minus any deductions recorded against them, and the Payroll section tracks this as Paid or Pending for each person (a cancelled payment entry doesn't count toward either).

Utilization Rate: booked time vs. worked time

Utilization Rate = Hours Booked ÷ Hours Worked. The two halves of that formula are measured independently, and it's worth knowing exactly what each one counts:

Hours Worked comes from the staff member's actual shift/clock times for the day — how long they were scheduled or clocked in to work.
Hours Booked only counts the duration of appointments that were actually checked out (completed) — not appointments that were merely booked, confirmed, cancelled, or no-showed.

This is an important distinction from the booking counts you'll see elsewhere on this and other reports (like "Bookings Completed" or the pie chart on Booking Reports), which include appointments in every status. So a busy day full of bookings that later get cancelled will show up in your booking counts, but won't move the needle on Utilization Rate the way a fully checked-out day would.

Attendance Reports

What it is: Clock-in/out and shift-adherence tracking for your team.

Navigation: Reports → Staff Reports → Attendance Reports.

Metrics: Absence Days, Total Staff, Total Shifts, an Attendance Rate widget, Daily Stats, Overtime Hours, and Minutes Late — plus a full attendance table (scheduled vs. actual start/end times, status, notes) that can be exported.

Notes & limitations

Commission plan setup (creating plans, assigning them to staff, and configuring tiers) is covered separately in the Commission Plans topic — this topic covers how the underlying revenue figures and commission amounts are calculated once a plan is assigned.