Docs · File formats
Freight Loss & Damage Claims CSV format
Header names are matched automatically, in any order and any case. Extra columns are ignored.
| Column | Required | Also accepted as | Example |
|---|---|---|---|
| PRO / shipment number | Yes | pro number, pro #, pro no, pro, carrier pro, freight bill number | 0812204417 |
| Motor carrier | Yes | carrier, carrier name, motor carrier, carrier scac, scac, vendor | Old Dominion Freight Line |
| Bill of lading | bol number, bol #, bol, bill of lading, bill of lading number, b/l | BOL-55120 | |
| Ship date | ship date, pickup date, pick up date, shipped date, shipped, tender date | 2026-09-04 | |
| Delivery date | delivery date, delivered date, date delivered, delivered, pod date, actual delivery date | 2026-09-10 | |
| Origin | origin, origin city, shipper, shipper name, ship from, from city | Columbus, OH | |
| Destination | destination, destination city, consignee, consignee name, ship to, to city | Atlanta, GA | |
| Exception type | exception type, exception, os&d type, osd type, os&d, osd | Damage | |
| Delivery receipt notation | dr notation, delivery receipt notation, delivery receipt, pod notation, pod exceptions, receipt notation | 2 cartons crushed | |
| Concealed damage reported date | concealed damage reported, concealed damage reported date, concealed damage date, concealed report date, damage reported date, date reported | 2026-09-12 | |
| Invoice value of goods | invoice value, goods value, commodity value, merchandise value, cargo value, product value | 4,800.00 | |
| Quantity shipped | quantity, qty, pieces, pcs, handling units, cartons | 10 | |
| Quantity lost or damaged | damaged quantity, damaged qty, short quantity, short qty, qty damaged, qty short | 2 | |
| Weight | weight, weight lbs, weight (lbs), gross weight, lbs, billed weight | 1,250 lb | |
| Released / declared value or liability limit | released value, declared value, liability limit, limit of liability, carrier liability limit, max liability | $10.00/lb | |
| Freight charges | freight charges, freight charge, freight bill amount, freight cost, freight amount, freight | 680.00 | |
| Freight refunded | freight refunded, freight refund, freight credit, freight credited, freight refund amount | ||
| Carrier claim number | claim number, claim #, claim no, carrier claim number, carrier claim #, claim id | OD-C-778120 | |
| Claim filed date | claim filed date, claim filed, claim date, date filed, filed date, claim submitted | 2026-09-15 | |
| Claim amount | claim amount, amount claimed, claimed amount, claim value, claim total | 960.00 | |
| Carrier acknowledgment date | acknowledgment date, acknowledgement date, ack date, acknowledged, acknowledged date, carrier acknowledgment | 2026-09-25 | |
| Carrier response / settlement date | response date, carrier response date, settlement date, resolution date, resolved date, declination date | 2026-10-20 | |
| Settlement amount | settlement amount, settlement, settled amount, amount paid, paid amount, carrier paid | 1,200.00 | |
| Claim status | claim status, status, carrier response, response, outcome, resolution | Open |