Workflow: Calculating Guide Payroll (Reporting)

1. Export the Report

• Download the full trip report from GoGuide.

2. Focus on These Columns

• Trip Cost — Total value of the trip used for payroll calculation.
• Personnel — Guides assigned to the trip (may be multiple).
• Booking ID — Used to group payments and avoid duplicates.
• Trip Date — Helps filter by pay period.
• Order ID — Use to filter out cancelled or draft trips.

3. Filter Out Cancelled Trips

• In the Order ID column, remove any rows marked Cancelled or Draft.
• Keep bookings with statuses like: Booked, Accepted, or Scheduled.

4. Identify Guides

• Use the Personnel column to determine which guides were assigned to each trip.
• If multiple guides are listed (comma-separated), they will split the payout equally.

5. Use Trip Cost to Calculate Payroll

• Base all payroll on the full Trip Cost (not the payment or invoiced amounts).
• Apply the guide payout percentage (e.g., 50%).

6. Split by Number of Guides

• Count the number of guides listed for each Booking ID.
• Divide the guide payout portion evenly among them.

💡 Example: 
Trip Cost: $1,000 
Guide Cut: 50% = $500 
Two guides: $500 ÷ 2 = $250 per guide

✅ Optional: Add Context or Summarize

• Include Trip Title, Assets, or Group Size for context if helpful.
• Use pivot tables or filters to view total guide pay per person across a date range.