Close out every commission check in minutes
Reconcile supplier checks against your bookings line-by-line, flag short-pays, accept adjustments, and pay your advisors what they actually earned — without a single spreadsheet. Built for host agencies running on Disney, Universal, and cruise commissions.
The check came in. Now the work begins.
Disney sends a single check for forty bookings. Royal Caribbean sends one for twenty-seven. Universal pays you weeks after the trip wrapped. Your job as the agency owner is to match each line on the commission statement to the booking it's for, decide whether it's the amount you expected, and figure out what every advisor on your team is owed.
Most host agencies do this in Excel. It takes hours. Mistakes compound. Advisors get paid late. Pixie Dust's commission reconciliation module collapses that entire workflow into a check-by-check screen that knows about every booking in your CRM.
1. Log the check
When a supplier check arrives, open the Commission Reconciliation screen and enter the basics: supplier name, check number, check date, gross amount. That's it for setup — the system already knows which bookings are eligible to be paid out from this supplier.
Each check carries its own status: pending, in-progress, accepted, or recalled. So if a supplier ever sends a follow-up correction, you have full history of what was reconciled when.
2. Reconcile line by line
The reconciliation screen lists every booking you expected this supplier to pay for. For each line, the system shows the expected commission (calculated from the booking) next to a field where you enter the actual amount paid on this check.
Match? Tap accept and move on. Short-pay? The system flags the variance and lets you either accept it as the new actual or open an adjustment line item to chase the supplier for the difference.
Over time, the variance flags become a quality signal: you'll see which suppliers consistently short-pay, which advisors' bookings have unusual delta patterns, and which destinations deserve a second look at how you're quoting commission.
3. Pay advisors what they earned
Once a check is fully reconciled, the system automatically computes each advisor's share based on the actual amount paid — not the originally projected amount. The advisor payout report shows exactly what they earned on this check, on every check this month, this quarter, and year-to-date.
Export the payout report to CSV for your bookkeeping tool of choice, or generate 1099-NEC ready advisor summaries at year-end. Your advisors get paid on what actually landed in the agency account, and you stop being the bottleneck.
Reports that actually help
Three views, one button each:
- Projected Income — what you expect to receive from open bookings, broken out by supplier and travel date.
- Commission Earned — what you've actually been paid, filterable by date range, advisor, and supplier.
- Past Due — trips that completed but haven't been paid out yet. Hand this list to whoever chases suppliers.
Each report exports to CSV in one click. Tax-time exports include advisor-level subtotals formatted for 1099-NEC preparation.
How It Works
Supplier check arrives — log the basics into the Commission Reconciliation screen
Match each line to the booking it pays for; flag short-pays and adjustments
Accept the check to finalize advisor payouts at actual paid amounts
Export payout reports or 1099-NEC summaries at month-end or year-end
Frequently Asked Questions
Who can access commission reconciliation?
Commission reconciliation is included on Pro and Premium Host Agency plans. It's available to agency owners and managers — the people who actually need to close checks — not to individual advisors. Advisors see their own payouts on the standard commission dashboard.
Do I need to import my supplier statements?
No. The reconciliation screen already knows which bookings are eligible for each supplier because you tracked them in the CRM. You enter the check total and reconcile line by line against the bookings already in your system.
What happens if a supplier sends a follow-up correction?
Open the original check, recall it, edit the affected line items, and re-accept. The full history is preserved — every advisor payout calculation references the version of the check that was active when it was generated, so corrections don't silently rewrite history.
Can advisors see their reconciliation status?
Advisors don't see the agency's reconciliation workspace, but their own payout dashboard reflects what's been finalized. Once a check is accepted, advisors see updated earnings tied to those bookings.
Is this different from regular commission tracking?
Yes. Every plan tier includes per-booking commission tracking — the projected amount you expect to earn on each trip. Commission reconciliation is the next step: matching that projection against the actual supplier checks that come in, weeks or months after the trip. Most agencies do this in Excel today.
Will this work for cruise commissions paid weeks after sailing?
Yes. Each booking carries a travel-end date and a projected commission. When the cruise line check lands months later, you reconcile against those bookings using whatever lookup the supplier provides (PNR, booking number, client name — whatever's on the statement).
Stop reconciling commissions in Excel.
Pro Host Agency starts at $30/seat/month. 30-day free trial. No credit card required.
Start Free TrialReady to See the Difference?
Plans from $9.99/month for solo agents. Scalable plans for host agencies.
See Plans & Pricing