Freight Close

Exceptions & controls

Every fallback and assumption raises a flag — no silent defaults. An accountant who automates without controls is just automating errors faster. Click any shipment-level flag to open its full calc trace, and pin a review note to record its disposition.

✓ Ready to close — 0 errors (blocking), 11 warnings to review, 12 informational. No blocking exceptions — the period can be signed off on Approval.
Errors
0
High · blocking

RATE_DIVERGENCE

3 occurrences · risk Medium · review

warn
  • EXC-0015
    Peak Logistics: calibrated rate index 0.80625 diverges from the printed card by 24.0% (printed high). Pricing uses calibrated rates; switch rateSource to printed_override to use the card.
    Peak Logistics
  • EXC-0016
    Heartland Freight: calibrated rate index 1.12148 diverges from the printed card by -10.8% (printed low). Pricing uses calibrated rates; switch rateSource to printed_override to use the card.
    Heartland Freight
  • EXC-0017
    Coastal Express: calibrated rate index 1.16962 diverges from the printed card by -14.5% (printed low). Pricing uses calibrated rates; switch rateSource to printed_override to use the card.
    Coastal Express

BACKTEST_MAPE_HIGH

3 occurrences · risk Medium · review

warn
  • EXC-0019
    Peak Logistics forecast MAPE 20.1% exceeds the 5% control threshold — driven by an unpredictable monthly rate index. The accrual carries a confidence band; the engine remains near-unbiased (bias 6.7%).
    Peak Logistics
  • EXC-0020
    Heartland Freight forecast MAPE 8.7% exceeds the 5% control threshold — driven by an unpredictable monthly rate index. The accrual carries a confidence band; the engine remains near-unbiased (bias -1.8%).
    Heartland Freight
  • EXC-0021
    Coastal Express forecast MAPE 16.2% exceeds the 5% control threshold — driven by an unpredictable monthly rate index. The accrual carries a confidence band; the engine remains near-unbiased (bias -5.5%).
    Coastal Express

IMPUTED_WEIGHT

2 occurrences · risk Medium · review

warn
  • EXC-0011
    Missing weight imputed as 772.74 lb (34 units x 22.73 lb/unit median).
    SHP-10155 · Coastal Express· view calc trace →
  • EXC-0012
    Missing weight imputed as 590.92 lb (26 units x 22.73 lb/unit median).
    SHP-10156 · Coastal Express· view calc trace →

MILEAGE_FALLBACK_GEO

1 occurrence · risk Medium · review

warn
  • EXC-0001
    No invoice or printed mileage for Reno 89501; estimated 945.62 mi from ZIP centroids x 1.2 circuity.
    SHP-10006 · Peak Logistics· view calc trace →

OUT_OF_TERRITORY

1 occurrence · risk Medium · review

warn
  • EXC-0002
    Reno, NV is outside Peak's stated territory (CO/UT/WY/MT/ID).
    SHP-10006 · Peak Logistics· view calc trace →

DUPLICATE_SHIPMENT

1 occurrence · risk Medium · review

warn
  • EXC-0014
    Duplicate shipment row SHP-10033 detected; the repeat was dropped so it is not double-counted.
    SHP-10033· view calc trace →

ORIGIN_ASSUMPTION

5 occurrences · risk Low · informational

info
  • EXC-0003
    Origin Salt Lake City priced at Denver-calibrated mileage (invoice history does not separate origin).
    SHP-10016 · Peak Logistics· view calc trace →
  • EXC-0004
    Origin Salt Lake City priced at Denver-calibrated mileage (invoice history does not separate origin).
    SHP-10019 · Peak Logistics· view calc trace →
  • EXC-0005
    Origin Salt Lake City priced at Denver-calibrated mileage (invoice history does not separate origin).
    SHP-10020 · Peak Logistics· view calc trace →
  • EXC-0006
    Origin Salt Lake City priced at Denver-calibrated mileage (invoice history does not separate origin).
    SHP-10021 · Peak Logistics· view calc trace →
  • EXC-0007
    Origin Salt Lake City priced at Denver-calibrated mileage (invoice history does not separate origin).
    SHP-10033 · Peak Logistics· view calc trace →

MISSING_WEIGHT

3 occurrences · risk Low · informational

info
  • EXC-0008
    Missing weight; no price impact (Heartland prices a flat zone rate).
    SHP-10064 · Heartland Freight· view calc trace →
  • EXC-0009
    Missing weight; no price impact (Heartland prices a flat zone rate).
    SHP-10098 · Heartland Freight· view calc trace →
  • EXC-0010
    Missing weight; no price impact (Heartland prices a flat zone rate).
    SHP-10104 · Heartland Freight· view calc trace →

INGEST_SERIALIZATION_NORMALIZED

1 occurrence · risk Low · informational

info
  • EXC-0013
    Ingest normalized 811 service-month label(s) from short form (e.g. "Oct-25") to "Month YYYY" and 972 date(s) from M/D/YYYY to ISO (so quarter-to-date ordering sequences correctly). Source data arrives in mixed serialization; normalizing on ingest lets calibration join the invoice history instead of silently defaulting the rate index to 1.0.

COST_OUTLIER

1 occurrence · risk Low · informational

info
  • EXC-0018
    SHP-10006 total $2824.71 is 3.5σ from the Peak Logistics mean ($776); review for keying/weight error.
    SHP-10006 · Peak Logistics· view calc trace →

ADJUSTMENT_RESIDUAL

1 occurrence · risk Low · informational

info
  • EXC-0022
    A credit reserve equal to the historical net-adjustment run-rate (~-0.3% of invoiced) is booked so the gross accrual is not systematically high vs eventual invoices.

SERVICE_PRICE_ASSUMPTION

1 occurrence · risk Low · informational

info
  • EXC-0023
    No rate card prices by service level and invoices carry no service field; service level is assumed not to affect price (normalized for reporting only).