Upload & Validate CSV
Upload Staff Sales CSV
Drop your CSV file here
or browse to select a file
Required columns: staff_name, date, total_sales, hicaps_sales, cash_sales, eftpos_sales, gift_card_sales, hours_worked, num_services_provided, add_on_sales
Required CSV Format
| staff_name | date | total_sales | hicaps_sales | cash_sales | eftpos_sales | gift_card_sales | hours_worked | num_services_provided | add_on_sales |
|---|---|---|---|---|---|---|---|---|---|
| John Doe | 2024-01-15 | 200 | 100 | 50 | 50 | 0 | 8 | 8 | 80 |
Calculation Logic
service_sales = total_sales - add_on_sales
commission = service_sales × commission_rate%
final_payout = MAX(daily_guarantee, commission)
reconciliation: total_sales = HICAPS + Cash + EFTPOS + GiftCard