Understanding Relay payment categories

A Relay invoice is not a list of loads. It is a list of paid items, and the distinction is where most reconciliation confusion starts.

TOUR rows versus LOAD rows

Every line on the invoice has an Item Type: TOUR - COMPLETED carries the base rate for a whole tour and has an empty Load ID, while LOAD - COMPLETED rows under it usually show a Base Rate of zero and carry only accessorials. LOAD - CANCELLED is a cancelled load that was paid anyway.

The pay for one tour is therefore the TOUR row plus every LOAD row sharing its Trip ID. LoadRecon subtotals by trip rather than splitting tour pay across loads, because nothing in the file apportions it and any split would be invented.

→ Why a Relay load shows a $0 base rate works through an example and shows what a per-load spreadsheet misses.

Cancellation pay and TONU

A cancelled load can still carry pay. On the invoice it appears as a LOAD - CANCELLED row with money in either the TONU column or Base Rate, and LoadRecon labels it Paid — Cancellation/TONU so it does not read as unpaid in your own records.

The export files do not record who cancelled a load, so an uncompensated cancellation may be one you rejected — nothing owed — or an Amazon-initiated one that should have paid a fee. LoadRecon leaves that judgement to you.

→ What is TONU on an Amazon Relay invoice? covers how cancellation pay appears in both files and how to work through the unpaid ones.

The five categories

Paid. Matched to an invoice row with a completed item type and pay against it. The ordinary case.

Paid — Cancellation/TONU. Matched to a cancelled item type that still paid. This is money you might otherwise miss, since the load reads as cancelled in your own records.

Completed, not paid. You ran it; the invoice does not show it. LoadRecon splits these by timing:

• likely rollover — the load finished within 48 hours of the Saturday cutoff or after it. Delivery confirmation lag routinely pushes these onto the next invoice. Check next week before doing anything.
• review — payment missing — the load finished well inside the work period, so a rollover does not explain it. These are the ones worth attention while the 30-day dispute window is open.

Cancelled/Rejected — not paid. No compensation received. Expected for loads you rejected; worth a look if Amazon cancelled on you.

Paid, not in trips file. An invoice line with no matching load in your export. Almost always a load from the previous week arriving on this invoice — exactly the other side of the rollover coin. If the end date falls before the work period started, LoadRecon says so explicitly.

Rate variance

LoadRecon compares each paid load's Gross Pay against the Estimated Cost on the trips export and flags gaps over 10%. Read the flag as "look at this", not "you are owed money" — on tours it compares accessorials rather than base rates, and the percentage test is noisy on small amounts.

→ Why Estimated Cost doesn't match your Relay pay covers what that column records and which gaps are worth investigating.

On invoice at $0

Occasionally a load appears on the invoice with a Gross Pay of zero. LoadRecon treats these as unpaid rather than paid — the row exists, but no money arrived — and tags them on invoice at $0 so the distinction from a genuinely absent load is visible. It is an unusual state and generally worth querying.