1. The Gap Between “Earned” and “Received”
Most travel agent CRMs treat a booking as “commissionable” the moment it hits the right status. The booking is confirmed, the trip is paid in full, the trip ends — somewhere along the way the system marks the commission as earned and moves on.
But here's what nobody talks about: the supplier hasn't actually paid you yet. Disney typically pays commission roughly 60 days after travel completes. Cruise lines pay ~30 days after final payment. Universal often takes 30–45 days post-travel. By the time the money lands, you've already worked dozens of other trips, and the connection between “the Smith family package from March” and the lump-sum direct deposit that hit in May is… not obvious.
Reconciliation is the process of closing that loop — taking the actual money you received and proving, line by line, which booking it came from. Without it, three things go wrong:
- •Underpaid commissions go unnoticed because nobody compared expected to actual.
- •Bookings that should have paid but never did sit in “earned” status forever, inflating your books.
- •Bonus checks, co-op marketing payments, and override commissions show up unattributed and you can't tell who earned what.
For solo agents, this manifests as “I think I'm doing fine?” For agencies with multiple advisors, it manifests as real money lost — you can't pay your advisors what they're owed if you don't know what came in.
2. What a Reconciliation Workflow Actually Looks Like
The mental model: a supplier sends you a payment (a paper check, an ACH deposit, an EFT, whatever). That payment is one big number — say, $4,827.50 from Disney Destinations. Reconciliation is the act of breaking that number into individual line items and matching each line to a booking in your CRM.
In Pixie Dust CRM, every supplier payment lives as a Commission Check with four states it moves through:
- PENDINGYou recorded the check arrived but haven't matched any bookings yet.
- RECONCILEDSome line items are matched. The amount reconciled is tracking against the check total.
- ACCEPTEDThe check is fully reconciled and locked. Bookings associated with it can flow into the next agent payout period.
- RECALLEDA previously accepted check that's been reopened (correction, supplier dispute, etc.) — only allowed when none of its bookings have been paid out yet.
The status flow is the safety net. You can't accidentally pay an advisor for a booking whose commission check is still in pending. You can't silently change a check that already fed a payout because the system blocks the recall when downstream payouts exist.
3. Handling Discrepancies (Because They Happen)
The interesting part of reconciliation is when expected and actual don't match. Pixie Dust CRM treats every line item as a comparison: the booking expected a commission of $X, and the actual amount applied from this check is $Y. The difference is the discrepancy.
Discrepancies bucket into four severities so you can scan a list and immediately spot what needs your attention:
- •None — expected and actual match within rounding.
- •Minor — less than 1% off. Usually a rounding artifact or sub-cent rebooking adjustment.
- •Notable — 1–10% off. Worth a look. Could be a promo discount that retroactively reduced commission.
- •Major — more than 10% off. Pick up the phone — something is wrong on the supplier side.
You can still accept the check with a discrepancy — the actual amount is what gets recorded, and the difference is logged as a note on the booking. That's honest accounting. The trap to avoid is silently “fixing” the expected commission to match the actual; you lose the audit trail of what the supplier owed you and what they paid.
4. Unclaimed Line Items and Non-Booking Revenue
Real-world commission checks don't always tie back to a clean list of bookings in your system. Two common cases:
Unclaimed line items
The supplier's statement lists a booking number you don't recognize. Maybe an advisor booked it outside the CRM. Maybe it's a renamed reservation. Maybe it's a past-agency leftover. You still got paid for it — you just can't link it to a booking record.
Unclaimed line items let you record the amount, the supplier booking reference, and which advisor should get credit for payout purposes — without forcing you to fabricate a fake booking just to balance the check.
Bonuses, overrides, and co-op
Suppliers periodically pay you for things that aren't tied to a single booking: volume bonuses, override commissions for hitting a tier, co-op marketing reimbursements, promotional incentives. These show up on the same check as regular commission and need to be reconciled too.
In Pixie Dust CRM these live as Company Adjustments — you create the expected line ahead of time (“Disney Q1 2026 volume bonus, expected $1,200, assigned to Sarah”) and link it to the check when the money arrives. The adjustment becomes a regular line item against the check total, and Sarah sees it on her next payout.
5. Parsing a 3-Page Disney Statement Without Typing 47 Numbers
The slowest part of reconciliation by far is data entry. Disney's commission statements arrive as PDFs (or sometimes Excel) with 30–100 line items per check. Typing each one in by hand is the kind of work that makes you question your career choices.
Pixie Dust CRM includes a statement parser: drop the PDF in, the system extracts the line items, and you confirm matches against your bookings before it commits. You still review every row — AI is a typist, not a fiduciary — but you're reviewing instead of transcribing.
Most of our agents knock out a 60-line Disney statement in about 5 minutes this way. Doing it by hand was a 45-minute job that used to get postponed for weeks.
6. Why This Matters Even More If You Run an Agency
For solo agents, reconciliation prevents leakage. For agencies with multiple advisors, it's the foundation of every payout you make.
Without it, your payout flow looks like this: an advisor sells a $5,000 trip, the booking is marked completed, you owe them their split. You pay it. Three weeks later you discover the supplier paid $4,200 instead of $5,000 because of a promo. You just overpaid your advisor by $80–$160 (depending on the split). Multiply that across 200 bookings a month.
With reconciliation gating the payout, the rule becomes dead simple: commission is only payable to an advisor once the supplier check has been accepted. Your payout periods generate cleanly. The advisor sees only what they're actually owed. The check status doubles as your audit trail when an advisor asks “why was my payout different from what I expected?”
7. End-to-End Workflow: From Mailbox to Bank
Here's the full loop the way most of our agencies run it:
- Check arrives. Direct deposit, paper check, EFT — doesn't matter.
- Record the check. Sender (Disney Destinations), check number, amount, date, notes. Status: pending.
- Parse or enter the line items. Drop the statement in for AI parsing or add lines manually. Each line links a booking to the actual amount paid.
- Resolve discrepancies. Anything more than ~1% off gets flagged. Note the reason on the booking (“promo retroactively applied”, “reservation modified”) so you have context next time.
- Add unclaimed lines and adjustments.Anything on the check that doesn't map to a booking, plus any expected bonuses or overrides.
- Accept the check. The status moves to accepted, the bookings are now eligible for the next payout run.
- Run the payout. Advisors get paid based on checks that have been accepted. Anything still in pending or reconciled stays in the queue until next time.
The discipline this enforces is the whole point. You always know which checks are open, which are awaiting acceptance, and which money you've been paid but can't yet pay out.
Frequently Asked Questions
How often should I reconcile commission checks?
As they come in, ideally within a few days of receiving the deposit. The longer you wait, the harder it is to remember context (“why was this $80 short?”) and the harder it is to dispute discrepancies with the supplier. A weekly cadence works well for most solo agents; agencies with high volume often reconcile within 24 hours of the deposit.
What if a supplier check covers a refund / clawback?
Negative line items are part of normal reconciliation — record the amount as the actual (negative) value linked to the original booking. The check total still has to balance, so the negative line subtracts from the unreconciled amount the way a positive line adds to the reconciled amount. Your audit trail captures both the original commission earned and the clawback.
Can I reconcile a check before it clears my bank?
Yes — reconciliation is about matching expected to actual, not about cash availability. You can record a deposit you've been notified about (e.g. via supplier portal) and reconcile line items against it before the funds technically hit the bank. The accept step locks it in for payout; whether you wait for cleared funds before running the payout itself is an agency policy decision.
What happens if I accept a check and then realize it's wrong?
If none of the bookings in the check have been included in a payout yet, you can recall the check, fix the lines, and re-accept. If a payout has already been generated against any of those bookings, the system blocks the recall — you have to either reverse the payout first or file an adjustment in the next period. This is intentional: payouts are real money moving to advisors and should not be quietly modified after the fact.
How is this different from just tracking commissions in my CRM?
Tracking is “what should I be paid?”. Reconciliation is “what was I actually paid, and from which booking?”. Most CRMs handle the first part. The gap between the two is where money quietly disappears — underpaid commissions, supplier statement errors, missing bonus payments — and reconciliation is the system that closes it.
Do I need this if I'm a brand-new agent with five bookings?
Not urgently. With five bookings you can keep track in your head. The pain hits somewhere around 30–50 bookings per year, when it stops being possible to remember which checks covered which trips. If you're building toward that volume anyway, learning the workflow on a small portfolio is much easier than retrofitting it on a year's worth of unreconciled history.
Get Paid for Every Booking, Not Most of Them
Commission tracking tells you what you're owed. Reconciliation tells you what you actually got — and that's the number that pays your bills, your advisors, and your taxes.
If you're a solo agent under 50 bookings a year, a spreadsheet still works as long as you're disciplined. Past that, the manual workflow breaks down and money starts going missing. If you're running an agency, reconciliation isn't optional — it's the gate that protects every advisor payout from being wrong in your favor or theirs.
Try Pixie Dust CRM free for 30 days and see what reconciliation looks like when it's built into the same place you track your bookings, run your payouts, and pay your advisors.