Commission Forecast — 12-Month Cash Flow

Most travel-agency CRMs show you a list of expected commissions. JourneyFuse rolls them into a 12-month cash-flow chart with confidence weighting so you can plan capital, hiring, and IATA/CLIA qualification windows without exporting to a spreadsheet.

Find it on Reports → Commissions → Commission Forecast.

What the Chart Shows

Thirteen bars (three months back, current month, nine months forward). Each bar is stacked, color-coded:

• Emerald — Received. Commission already in your bank account.
• Blue — Pending. Expected to receive on the dates supplier listed, lifecycle still pending or submitted.
• Rose — At risk. Expected date is in the past and we haven't received yet. These are the ones you need to chase.

A summary row above the chart totals each color across the whole window.

Hover any month bar for a breakdown: amounts per status + the top 5 suppliers contributing to that month.

How the Confidence Math Works

For each commission_entry:

1. If date_received is populated and lifecycle is received / agent_payable / agent_paid → Received, bucketed by the received month.
2. Otherwise, if date_expected is in the past and lifecycle isn't written_off → At risk, bucketed by the expected month.
3. Otherwise → Pending, bucketed by the expected month.

A separate "Reconciled, payable" subtotal counts entries that are matched to a supplier payment but not yet paid out to the advisor — useful for predicting the next payout batch.

Why This Beats the Competition

Every other CRM we evaluated (TESS, Trams, Tern, Travel Joy, Travefy) gives you a list of expected commission rows. No competitor rolls them into a 12-month chart with confidence weighting. The list version forces you to do the calendar math in your head; the chart version makes the next nine months legible at a glance.

Specifically:

• TESS has Projected Income but it's a flat sortable table — no chart, no rolling forward view past current quarter.
• Trams Crystal Reports can generate a "Projected Income by Month" but the chart isn't built in — you export to Excel and build a pivot.
• Tern has YoY compare but doesn't separate "received vs at-risk" — everything's lumped as "expected."

Top Suppliers Drill-Down

Hover a month → see the supplier breakdown. This answers "which supplier owes me the most in August?" without leaving the page.

For the owner-level supplier QBR view, see Top Suppliers per Advisor.

How to Use It

Monday morning:

1. Glance at the "At risk" total. If it's growing month-over-month, your chase workflow is failing — investigate. Look at the Past Due by Tour Operator report next.
2. Look 60-90 days out. Is there a thin spot? Time to push proposals.

Before quarterly planning:

• Look at the next three months' "Received + Pending" total. That's your high-confidence forecast.
• Subtract the next three months' fixed costs. The result is your discretionary spend.

When raising commission rates with a supplier:

• Look at the supplier's contribution to the next 12 months. Negotiation power = volume × confidence.

Caveats

• Travel-date vs commission-date. The forecast buckets by commission expected/received date, not trip travel date. If your supplier pays on commission after the cruise sails, your June trips show as July commissions.
• Currency. Everything is shown in USD using the value stored on the entry. We don't yet translate non-USD commissions.
• No goal line. This chart doesn't overlay a revenue goal target — that's on the Scorecards tab. We may add a target line on a future iteration if owners ask.

FAQ

My "Pending" is huge but I'm not worried — should I be? Look at the dates. If pending dates are in the next 30 days, that's normal — those commissions are en route. If they're sitting 60+ days out without movement, the entries may have stale expected dates. Re-check supplier statements.

Can agents see this report? Yes — but RLS scopes commission_entries by trip ownership, so agents see only their own forecasted commissions.

Can support staff see this report? No. Support staff never see commission financial data.