Title: Freight audit: Data & controls (sample) | Livo Assistant
Source: https://livoassistant.com/demos/logistics/checks/data-controls

Charge columns should hold clean numbers, every charge should be posted, and codes should be typed one way. 17 items found on sample transporter invoices.

---

[Logistics tour](https://livoassistant.com/demos/logistics/)/ [Checks](https://livoassistant.com/demos/logistics/checks/)/ Data & controls

# Freight audit: Data & controls

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 ₹.

17 items · ₹3,330 at risk · ₹5,500 credit

Charge columns should hold clean numbers, every charge should be posted, and codes should be typed one way.

## Text in a charge column

2 items

Charge columns should hold numbers. Text such as "SELF" is read as blank, so the charge silently drops out of every total.

Item Result Why Amount ODN DN8100002200 Other charges: "As per bill" Other charges holds the text "As per bill" instead of an amount.
Column: Other charges
Value typed: "As per bill" ODN DN8100008247 DETENTION: "SELF" DETENTION holds the text "SELF" instead of an amount.
Column: DETENTION
Value typed: "SELF"

## Freight not posted in SAP

3 items

Every row with freight should carry the SAP posting document that books the liability. A row without one is a charge the ledger may not show.

Item Result Why Amount ODN DN8100003028 ₹1,980 with no SAP document Freight was charged on this row, but no SAP posting document is recorded.
Freight: ₹1,980
TOTAL FREIGHT: ₹1,980
Sap Posting document (first Trasporter): blank ODN DN8100004668 ₹6,270 with no SAP document Freight was charged on this row, but no SAP posting document is recorded.
Freight: ₹6,270
TOTAL FREIGHT: ₹6,270
Sap Posting document (first Trasporter): blank ODN DN8100006358 ₹5,280 with no SAP document Freight was charged on this row, but no SAP posting document is recorded.
Freight: ₹5,280
TOTAL FREIGHT: ₹5,280
Sap Posting document (first Trasporter): blank

## Negative charge

2 items

Charge columns should never be negative. A negative amount is usually a customer-paid amount netted off inside a charge, which hides whether the recovery was booked.

Item Result Why Amount ODN DN8100008884 DETENTION −₹3,700 DETENTION is negative: −₹3,700.
Column: DETENTION
Amount: −₹3,700 −₹3,700 ODN DN8100005255 DETENTION −₹1,800 DETENTION is negative: −₹1,800.
Column: DETENTION
Amount: −₹1,800 −₹1,800

## Same code typed two ways

3 items

A code should be typed one way. Variants that differ only by spacing or capitals split one code into several in any report grouped by it.

Item Result Why Amount DIV "MKX" 2 spellings DIV "MKX" is typed 2 ways: "MKX", "MKX␣".
DIV spelled "MKX": 107 rows (usual)
DIV spelled "MKX␣": 1 row DIV "PN/PS" 2 spellings DIV "PN/PS" is typed 2 ways: "PN/PS", "pn/ps".
DIV spelled "PN/PS": 105 rows (usual)
DIV spelled "pn/ps": 1 row DIV "POP" 2 spellings DIV "POP" is typed 2 ways: "POP", "POP␣␣".
DIV spelled "POP": 112 rows (usual)
DIV spelled "POP␣␣": 1 row

## Transporter never billed

1 item

This transporter moves goods but carries zero freight on every row. Either it is billed through another ledger, so this Register understates freight cost, or the liability isn't booked.

Item Result Why Amount Parcelwise Express 6 rows · ₹0 freight Parcelwise Express carries zero freight on every one of its 6 rows.
Transporter: Parcelwise Express
Rows: 6
Freight on all of them: ₹0

## Dispatched before the ODN existed

2 items

Goods can't leave before the delivery note (ODN) for them is raised. A dispatch date earlier than the ODN date means one of the two dates is wrong, or the paperwork was raised after the fact.

Item Result Why Amount ODN DN8100007567 dispatched 8 Aug 2026, ODN dated 13 Aug 2026 The goods left on 8 Aug 2026, 5 days before their ODN was raised on 13 Aug 2026.
ODN Date: 13 Aug 2026
Dispatch Date: 8 Aug 2026
dispatched 5 days before the ODN was raised ODN DN8100010181 dispatched 23 Sep 2026, ODN dated 25 Sep 2026 The goods left on 23 Sep 2026, 2 days before their O DN was raised on 25 Sep 2026.
ODN Date: 25 Sep 2026
Dispatch Date: 23 Sep 2026
dispatched 2 days before the ODN was raised

## Self-pickup still charged freight

2 items

Goods the customer collected themselves (Self Pickup Qty) shouldn't carry transporter freight. The freight on the row is shown as exposure until it's clear what it paid for.

Item Result Why Amount ODN DN8100002628 self-pickup, ₹1,980 freight The row records a self-pickup of 73 units, yet carries ₹1,980 of transporter freight.
Self Pickup Qty: 73
Total Dispatched Qty: 73
Freight: ₹1,980 ₹1,980 ODN DN8100003268 self-pickup, ₹1,350 freight The row records a self-pickup of 24 units, yet carries ₹1,350 of transporter freight.
Self Pickup Qty: 24
Total Dispatched Qty: 24
Freight: ₹1,350 ₹1,350

## Second-transporter hand-over incomplete

2 items

When a trip is handed to a second transporter, the Register should name it, state its freight, record its own LR number and say why in Remarks. Without these the extra leg can't be checked.

Item Result Why Amount Trip 4469 · 20 Jun 2026 Metro Shuttle Services · 2 items missing This trip was handed to a second transporter, but the record is incomplete: no LR number for the second leg; no remark saying why the trip was handed over.
TRANSPORTER NAME (Second): Metro Shuttle Services
Transporter (Second ) Freight Amount: ₹1,400
Transporter (Second ) LR.NO.: blank
Remarks (Under Load/Full Truck Load): blank
Missing: No LR number for the second leg; No remark saying why the trip was handed over Trip 4504 · 28 Jun 2026 Metro Shuttle Services · 2 items missing This trip was handed to a second transporter, but the record is incomplete: no freight amount for the second transporter; no LR number for the second leg.
TRANSPORTER NAME (Second): Metro Shuttle Services
Transporter (Second ) Freight Amount: blank
Transporter (Second ) LR.NO.: blank
Remarks (Under Load/Full Truck Load): Handed over after breakdown
Missing: No freight amount for the second transporter; No LR number for the second leg

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)· [Cost insights](https://livoassistant.com/demos/logistics/checks/cost-insights)· [Customer destination](https://livoassistant.com/demos/logistics/checks/customer-destination)· [Rate card](https://livoassistant.com/demos/logistics/checks/rate-card)

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/data-controls#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).
