FareHarbor bookings
Trips, service names, locations, passenger counts, assigned crew, cancellations, and booking-level add-ons.
Useful operational data, but not payroll-ready until roles, rules, and exceptions are reconciled.See how PayCanvas explains a complex payroll run
This sample run shows how booking data, labor time, tips, commissions, adjustments, and exceptions become a traceable payroll output.
Messy source data enters the run.
Orange Coast Watersports operates across Orange Beach and Perdido Marina. The source exports are useful, but they are not payroll-ready by themselves.
Homebase time
Clock-in and clock-out records for hourly crew working Orange Beach and Perdido Marina shifts.
Hours need to be matched to eligible service roles before variable pay can be trusted.Revenue/add-ons
Clover and FareHarbor payment exports with service revenue, photo packages, and sale timing.
Payment exports show money collected, not who should receive a commission.Tips/gratuities
Digital tips and gratuities grouped by trip, service, date, and location.
Tips need pool membership, weighting, location rules, and review before payout.Manual adjustments
Manager corrections for late clock-outs, missed assignments, and one-off payroll notes.
Adjustments should be visible, traceable, and reviewed instead of hidden in a spreadsheet.Rules turn operations into payroll logic.
PayCanvas models the run as explicit, reviewable rules instead of burying variable pay inside a spreadsheet.
Captain pay per passenger
Captains earn a configured rate for eligible passengers on Dolphin Cruise, Jet Ski Tour, and Sunset Cruise bookings.
Observer pay per passenger
Observers receive their own per-passenger rate when assigned to a qualified booking role.
Photo package commission
Crew members receive 20% commission on eligible photo package sales tied to their booking assignments.
Location-based tip pool
Tips are pooled separately for Orange Beach and Perdido Marina, then split by eligible role weighting.
Hourly pay
Homebase hours are multiplied by the employee's hourly rate and shown beside service-based earnings.
Manual adjustment rule
Reviewed corrections are applied as explicit line items with source notes and approver context.
The run resolves into clean employee totals.
This table uses synthetic sample employees only. It shows the shape of a reviewed payroll output, not production payroll data.
| Employee | Hourly | Service Pay | Tips | Commissions | Adjustments | Total |
|---|---|---|---|---|---|---|
| John Carter | $112.50 | $84.00 | $42.18 | $8.40 | $0.00 | $247.08 |
| Maria Lopez | $90.00 | $52.00 | $37.62 | $0.00 | $15.00 | $194.62 |
| Devin Brooks | $68.75 | $38.00 | $24.31 | $12.00 | -$20.00 | $123.06 |
Why did John Carter get paid $247.08?
Every number in PayCanvas should be explainable back to the source data and rule that created it.
SourceHomebase timecard
Rule7.5 hrs x $15/hr
Amount$112.50
SourceFareHarbor passenger counts
Rulecaptain per-passenger rate
Amount$84.00
SourceOrange Beach tip pool
Ruleweighted role split
Amount$42.18
SourcePhoto package sales
Rule20% commission
Amount$8.40
Total payout$247.08
Exceptions are reviewed before payroll is finalized.
PayCanvas keeps unresolved items visible so operators can review the issue, apply the correct rule, and preserve the audit trail.
Booking has revenue but no assigned crew member
A Sunset Cruise payment exists in the revenue export, but the FareHarbor booking row is missing a crew assignment.
Employee has hours but no eligible service role for one booking
A Homebase shift overlaps a Jet Ski Tour, but the employee is not assigned to an eligible service role for variable pay.
Final outputs are ready for review and export.
A completed run gives the payroll team the totals, source references, exception decisions, and audit context needed to move forward.
Employee totalsException logSource referencesExport-ready payroll summaryAudit trail
PayCanvas
Want to see this with your actual pay rules?
PayCanvas is configured around your booking systems, labor data, pay rules, locations, and review process.