Dashboards / Freight cost & audit

Describe your dashboard. SluiceData builds it.

Tell the AI analyst what you need to understand. It connects your sources, defines the metrics, builds the dashboard — and proves every number back to source. One conversation, not a project.

You

I need one view of our freight: total spend, overcharges we've recovered, on-time delivery, and cost per shipment by carrier — all traced back to the carrier invoices and our rate contracts.

SluiceData

Here's your freight cost & audit dashboard, built on your TMS and carrier invoices — in your own cloud. Overcharges are flagged against each lane's own benchmark; add your rate card for exact contract amounts. Here's what's in it, and how each number is proven ↓

freight_ops · your cloud Illustrative data

Freight spend (YTD)

$8.4M ▲ 6.1%

carrier_invoices

Recoverable overcharge

$312K ▲ 3.7% of spend

flagged vs lane median

On-time (OTIF)

94.2% ▲ 1.4%

shipments

Cost per shipment

$312 ▼ 4.2%

invoices / shipments

Freight spend vs. recovered overcharge

monthly · Jan–Dec

Overcharge by carrier

recovered, top 3

Carrier A

Carrier B

Carrier C

Carrier scorecard

Carrier	Shipments	Cost / shipment	OTIF	Overcharge	Status
Carrier A	12,480	$298	95.1%	$142K	healthy
Carrier B	8,210	$324	92.4%	$98K	watch
Carrier C	5,940	$341	90.8%	$72K	watch

Here's what's in it — and how it's proven

Every number traces back to its source.

Other tools give you a reconciliation map. SluiceData goes further: click any KPI and see its formula → the exact compiled SQL → the source tables, and proof it reconciles. The AI planned it; deterministic code computed it.

metricRecoverable overcharge (flagged) = $312K

formulaΣ (freight − lane_median) for shipments billed > 1.5× their lane's median

compiled SQLSELECT SUM(freight − lane_med) FROM carrier_invoices JOIN (SELECT lane, median(freight) lane_med … GROUP BY lane) USING(lane) WHERE freight > 1.5*lane_med

sourcescarrier_invoices · freight amount + origin→destination lane · no rate card required

reconciled✓ aggregates only (residency-safe) · rate-card benchmark for exact contract overcharge = on the roadmap

Anatomy

What belongs on a freight dashboard.

Who uses it

Logistics ops and finance — the team chasing overcharges and holding carriers to their contracts.

Refresh

Daily, as carrier invoices land. Anomalies — a lane spiking, a carrier slipping — surface automatically.

How it's built

Describe it → the AI plans the metrics & joins → deterministic SQL compiles → it runs in your cloud → every number provable.

Describe the dashboard you need. Get it this week.

Connect a source and SluiceData builds your first governed, provable dashboard — in your own cloud.

Book a demo