Title: Freight audit: Rate card (sample) | Livo Assistant
Source: https://livoassistant.com/demos/logistics/checks/rate-card

The approved rate card itself. 7 items found on sample transporter invoices.

---

[Logistics tour](https://livoassistant.com/demos/logistics/)/ [Checks](https://livoassistant.com/demos/logistics/checks/)/ Rate card

# Freight audit: Rate card

A freight audit category from Livo's logistics sample tour (invented data).

Sample project: invented data (a manufacturer's six months of transporter invoices). Figures in ₹.

7 items · not priced

The approved rate card itself: rates should rise with vehicle size and distance, each lane listed once, and every vehicle the Register uses covered.

## Bigger vehicle priced lower

1 item

On a lane, a bigger vehicle tier should never cost less than a smaller one. An inversion means one of the two rates is wrong, and trips at either tier are priced against it.

Item Result Why Amount Hinjewadi · 9 Ton ₹5,450, below 5.5 ton at ₹5,850 On the Hinjewadi lane the 9 Ton vehicle costs less than the 5.5 ton one.
Lane: Hinjewadi · Local
5.5 ton rate: ₹5,850
9 Ton rate: ₹5,450
9 Ton ₹5,450 < 5.5 ton ₹5,850: the bigger vehicle is ₹400 cheaper

## Rate out of line for the distance

2 items

For one vehicle tier, the rate per km should be close to that of destinations at a similar distance (within 30%). A lane the client ships on that is priced well above its peers is worth renegotiating or correcting.

Item Result Why Amount Ahmednagar · 15 ton ₹192/km vs ₹120/km for similar distances The 15 ton rate to Ahmednagar works out to ₹192 per km; similar-distance lanes are ₹120.
Lane: Ahmednagar · Outstation · 15 ton
Rate: ₹23,040
Distance: 120 km
₹23,040 ÷ 120 km = ₹192/km vs ₹120/km typical (1.6×) Kolhapur · 15 ton ₹192/km vs ₹120/km for similar distances The 15 ton rate to Kolhapur works out to ₹192 per km; similar-distance lanes are ₹120.
Lane: Kolhapur · Outstation · 15 ton
Rate: ₹44,160
Distance: 230 km
₹44,160 ÷ 230 km = ₹192/km vs ₹120/km typical (1.6×)

## Lane listed twice

1 item

Each destination and vehicle tier should appear once in the rate card. Listed twice at different rates, the audit has to pick one, and so does whoever checks the invoice.

Item Result Why Amount Wakad · 2.5 Ton listed 2 times · ₹2,970 vs ₹3,270 The Wakad 2.5 Ton rate is listed 2 times, at ₹2,970 and ₹3,270.
Lane: Wakad · Local · 2.5 Ton
Times listed: 2
Rates listed: ₹2,970, ₹3,270

## Lead time shorter than a nearer place

2 items

Allowed transit time should grow with distance. A destination allowed less time than a nearer one makes on-time delivery look worse or better than it is.

Item Result Why Amount Panaji 8 h for 450 km · Belagavi gets 10 h for 340 km Panaji (450 km) is allowed 8 h, less than Belagavi (340 km, 10 h).
Destination: Panaji · 450 km
Lead time allowed: 8 h
Nearer destination: Belagavi · 340 km
Its lead time: 10 h Solapur 5 h for 250 km · Aurangabad gets 7 h for 235 km Solapur (250 km) is allowed 5 h, less than Aurangabad (235 km, 7 h).
Destination: Solapur · 250 km
Lead time allowed: 5 h
Nearer destination: Aurangabad · 235 km
Its lead time: 7 h

## No rate-card column for this row

1 item

Every row should map to a rate-card column: its Local/Outstation tag picks the sheet, its vehicle type the tier. A row with no tag, or a vehicle type the sheet doesn't list, can't be checked.

Item Result Why Amount ODN DN8100001366 T 709 · no Local/Outstation tag The row has no Local/Outstation tag, so no rate-card column applies.
Vehicle type: T 709
Local/Outstation: blank
Freight: —

Livo runs these checks on every freight invoice. More on [auditing freight bills](https://livoassistant.com/logistics).

Other categories: [Billing integrity](https://livoassistant.com/demos/logistics/checks/billing-integrity)· [Longest-leg freight](https://livoassistant.com/demos/logistics/checks/longest-leg-freight)· [Load utilization](https://livoassistant.com/demos/logistics/checks/load-utilization)· [Rate-card compliance](https://livoassistant.com/demos/logistics/checks/rate-card-compliance)· [Vehicle identity](https://livoassistant.com/demos/logistics/checks/vehicle-identity)· [Data & controls](https://livoassistant.com/demos/logistics/checks/data-controls)· [Cost insights](https://livoassistant.com/demos/logistics/checks/cost-insights)· [Customer destination](https://livoassistant.com/demos/logistics/checks/customer-destination)

Open the freight audit desk to see each item with the Register rows behind it.

[Open the interactive tour](https://livoassistant.com/demos/logistics/)[Book a call](https://livoassistant.com/demos/logistics/checks/rate-card#book)

To run these checks on your own records, see [how a pilot works](https://livoassistant.com/pilot).

Book a call: [pick a 30-minute slot with a founder on Calendly](https://calendly.com/kangana-livoassistant/30min?utm_source=livoassistant.com&utm_medium=website&utm_campaign=no-js-booking).
