Week-over-Week Settlement Trends: What to Actually Watch

A single settlement tells you what a week paid. A series of them, tracked properly, tells you where the business is going — whether density is improving, whether a deduction is drifting, whether "it feels slower lately" is real or recency bias. The operative phrase is tracked properly: most home-grown settlement trackers produce charts whose swings are artifacts of bookkeeping, not the business. This guide covers what to track, how to key it, and how to read it.

First, make the series trustworthy

• Key every week by the FedEx week. Weeks run Saturday–Friday; label each statement by its week-ending Friday, taken from the statement itself, never the download date. Sloppy keying collides two statements into one week or leaves phantom gaps — and the resulting chart lies confidently.
• One series per CSA. Entities have different rates and different economics. Blend them and every mix shift between entities masquerades as a trend.
• Leave gaps as gaps. A week you didn't ingest shows as missing, not interpolated. Gaps you can see are honest; smoothed-over gaps quietly poison every average that touches them.

The five series worth watching

• Revenue, but normalized. Track the weekly total, but judge revenue per stop — total ÷ stops. Raw revenue moves with volume; revenue per stop moves when the economics change, which is the thing worth noticing.
• Volume: stops and packages separately. Their ratio — packages per stop — is your density, and density drives both your stop-based revenue and your cost structure. A rising package count with flat stops is a different business trajectory than rising stops with flat packages, even at identical revenue.
• Revenue mix. The share of revenue by charge family — stop charges, activity/package charges, e-commerce lines, surcharges. Mix drift is the great masquerader: it moves revenue per package with every rate exactly right, and it's the first thing to check before suspecting a rate problem.
• The deduction set. Less the total than the composition: which lines exist, which appeared, which changed. A deductions column compared eyeball-to-eyeball across recent weeks catches drift that a summed total hides.
• Effective rates on your top lines. Dollars ÷ units for your few largest charge types, plotted weekly. These should be flat between contract changes — which is precisely why they're worth plotting. A flat line that stops being flat is your audit trigger. (Skip fuel; it floats by design.)

Reading the chart: signal vs. noise

• Single weeks are noise. Weather, holidays, a truck down, a big shipper's promotion — all produce one-week spikes that mean nothing. React to nothing that hasn't persisted 3–4 weeks unless it's structural (a missing line, a new deduction).
• Compare like seasons. Peak weeks against peak weeks, summer against summer. Year-over-year for the same FedEx week is often more informative than week-over-week during seasonal transitions.
• Direction beats level. Whether your revenue per stop is "good" depends on geography and contract; whether it's been sliding for six weeks does not. Trend against yourself is the actionable comparison.
• When a trend breaks, check in order: mix first, then volume, then effective rates, then deductions. That order rules out the common benign causes before you spend energy on the rare contractual ones.

The cadence that makes it work

Trends only exist if the ingestion is weekly and the review is regular. A workable rhythm: statements in and keyed the same day they're available; a five-minute glance weekly (structural checks + anything that moved); a longer look monthly (mix, density, margin against payroll). The monthly look is where decisions happen; the weekly glance is what keeps the monthly look honest.

Where the platform fits

This entire apparatus — FedEx-week keying, per-CSA series, gaps-not-guesses, mix and density and effective-rate tracking — is what Route Impact's Earnings module builds automatically from your uploaded statements, with the weekly audit checks layered on top and a Monday digest that brings the week's numbers to your inbox so the cadence survives your busiest stretch. And accumulating the series has a compounding property: every additional week makes the baselines sharper, whichever tool maintains it. Start the series before you need it; the trend you want to see in January is built from the weeks you record now.