Docs · File formats
Parcel & Freight Recovery CSV format
Header names are matched automatically, in any order and any case. Extra columns are ignored.
| Column | Required | Also accepted as | Example |
|---|---|---|---|
| Tracking / PRO number | Yes | tracking number, express or ground tracking id, tracking id, tracking, tracking #, tracking no | 1Z999AA10123456784 |
| Charge amount (net) | Yes | net amount, net charge amount, net charge, billed charge, billed amount, charge amount | 14.85 |
| Carrier | carrier, carrier name, shipping carrier, courier, scac, provider | UPS | |
| Account number | account number, bill to account number, shipper number, account, account no, account # | 4X81R2 | |
| Invoice number | invoice number, invoice, invoice no, invoice #, freight bill number, bill number | 0000004X81R2416 | |
| Invoice date | invoice date, bill date, billing date, statement date, freight bill date | 2026-10-10 | |
| Ship date | ship date, shipment date, pickup date, date shipped, shipped date, mailing date | 2026-10-05 | |
| Service | service, service type, service level, service description, service name, ground service | Next Day Air | |
| Charge description | charge description, tracking id charge description, charge type, charge, charge code description, accessorial description | Residential Surcharge | |
| Entered / declared weight | entered weight, actual weight, actual weight amount, declared weight, shipper weight, customer weight | 4 | |
| Billed weight | billed weight, rated weight, rated weight amount, billable weight, chargeable weight, billed wt | 9 | |
| Weight unit | weight unit, weight units, actual weight units, unit of weight, weight uom | LB | |
| Length | length, package length, dim length, entered length, dimension length | 12 | |
| Width | width, package width, dim width, entered width, dimension width | 10 | |
| Height | height, package height, dim height, entered height, dimension height | 8 | |
| Dimensions (LxWxH) | package dimensions, dimensions, dims, dimensions lxwxh | 12x10x8 | |
| Dimension unit | dim unit, dimension unit, dimensions unit, unit of dimension, dim uom | IN | |
| DIM divisor | dim divisor, dimensional divisor, dim factor | 139 | |
| Address type | address type, residential commercial flag, residential indicator, residential flag, residential, receiver address type | Commercial | |
| Receiver company | receiver company name, recipient company, receiver company, ship to company, consignee company, consignee | Brightline Dental LLC | |
| Receiver address | receiver address line 1, recipient address line 1, receiver address, recipient address, ship to address 1, ship to address | 200 Market St | |
| Receiver postal code | receiver postal, receiver postal code, recipient zip code, recipient postal code, ship to zip, ship to postal code | 94105 | |
| Scheduled delivery date | scheduled delivery date, scheduled delivery, commit date, commitment date, guaranteed delivery date, expected delivery date | 2026-10-06 | |
| Commit time | commit time, scheduled delivery time, commitment time, guaranteed time | 10:30 | |
| Delivery date | pod delivery date, delivery date, actual delivery date, shipment delivery date, delivered date, date delivered | 2026-10-07 | |
| Delivery time | pod delivery time, delivery time, actual delivery time, delivered time | 14:12 | |
| Published fuel % for the week | published fuel rate, published fuel %, published fuel surcharge, fuel surcharge rate, fuel rate, fuel % | 19.25 | |
| Label / shipment status | status, shipment status, label status, package status, void indicator, void status | Voided | |
| Declared freight class (LTL) | declared class, bol class, shipper class, original class, class declared, quoted class | 70 | |
| Billed freight class (LTL) | billed class, rated class, corrected class, inspected class, reclass class, freight class | 85 | |
| Original amount before correction | original amount, original charge, original net charge, pre correction amount, amount before correction, quoted amount | 412.00 | |
| Delivery exception | delivery exception, exception description, exception reason, pod exception, exception, late reason |