Skip to main content

Overview

FedEx invoice CSV shape depends on the billing region of the account — not the shipment’s origin or destination. Trackstar supports two regional shapes today:
  • United States — FedEx’s domestic format. Has explicit Ground Tracking ID Prefix / Express or Ground Tracking ID columns and uses Tracking ID Charge Description / Tracking ID Charge Amount pair columns for line-item charges.
  • International (UK + NL) — FedEx’s air-waybill format, used by both UK and Netherlands billing accounts. Has a Billing Country/Territory column, Air Waybill Number as the tracking ID, and uses Air Waybill Charge Label / Air Waybill Charge Amount pair columns for charges.
Switch between the two shapes using the tabs below.

Shape notes

  • Charge pairs repeat. Both formats have up to 51 (Charge Label, Charge Amount) or (Charge Description, Charge Amount) column pairs on each row. Each populated pair becomes one line item in the Trackstar API. Empty pairs are skipped.
  • One row per shipment, not per charge. Unlike UPS (which has one row per charge), FedEx has one row per shipment, and that row contains all the shipment’s charges in the pair columns.
  • Totals reconciliation. For each invoice, the sum of Net Charge Amount (US) or Air Waybill Total Amount (International) across all rows equals Original Amount Due. Use this to verify invoice integrity.
  • Subtotal labels are excluded from line items. Labels like Net Transportation Charges, Subtotal, Import/Export Subtotal, Tax Subtotal, and Non-Trans Charges appear in the pair columns but represent subtotals rather than actual charges — Trackstar excludes them from the invoice_line_items output.
  • Invoice Date format. US uses DD-MMM-YYYY (e.g., 31-Mar-2026); International uses the same.

Sample rows

Curated subset showing the tracking-ID charge-pair structure. The downloadable CSV has all 210 columns.
Bill to Account Number,Invoice Number,Invoice Date,Express or Ground Tracking ID,Service Type,Zone Code,Tracking ID Charge Description,Tracking ID Charge Amount
196946120,2684030563,31-Mar-2026,936725700869,FedEx 2Day,2,Address Correction,22.00
196946120,2684030563,31-Mar-2026,126146287812,FedEx Express Saver,2,Delivery Area Surcharge,3.74
196946120,2684030563,31-Mar-2026,888433966645,FedEx Priority Overnight,3,Address Correction,21.41
196946120,2684030563,31-Mar-2026,847368723682,FedEx 2Day,5,Additional Handling,22.60
196946120,2684030563,31-Mar-2026,987472769644,FedEx Priority Overnight,2,Delivery Area Surcharge,3.67

Download

Download FedEx US sample CSV (22 rows, 210 columns)

Fields (US-specific)

ColumnDescriptionExample
Consolidated Account NumberParent billing account196946120
Bill to Account NumberBilling account — mapped to account_id196946120
Invoice DateDD-MMM-YYYY — mapped to transaction_date31-Mar-2026
Invoice NumberInvoice ID — mapped to invoice_id2684030563
Store IDRetail store reference
Original Amount DueInvoice grand total (used for reconciliation)1847.22
Current BalanceCurrent balance after payments1847.22
PayorWho pays (Shipper, Recipient, Third Party)
Ground Tracking ID PrefixFirst digits of the tracking number for Ground shipments96
Express or Ground Tracking IDTracking number — mapped to tracking_number936725700869
Transportation Charge AmountBase freight charge (standalone column)42.18
Net Charge AmountRow total (sum of charges in pair columns)72.18
Service TypeService (FedEx Ground, FedEx 2Day, etc.)FedEx Ground
Ground ServiceGround-specific sub-service
Shipment DateMM/DD/YYYY3/12/2026
POD Delivery Date / POD Delivery Time / POD Service Area Code / POD Signature DescriptionProof-of-delivery fields
Actual Weight Amount / Actual Weight UnitsWeight at tender time8.4 / LB
Rated Weight Amount / Rated Weight UnitsBilled weight (may be dimensional)
Number of PiecesPiece count1
Bundle NumberMulti-piece bundle ID
Meter NumberFedEx meter number
TDMasterTrackingIDTransborder Delivery master tracking ID
Service PackagingPackaging typeFEDEX ENVELOPE
Dim Length / Dim Width / Dim Height / Dim Divisor / Dim UnitDimensional weight fields
Recipient Name / Recipient Company / Recipient Address Line 1 / Recipient Address Line 2 / Recipient City / Recipient State / Recipient Zip Code / Recipient Country/TerritoryRecipient address
Shipper Company / Shipper Name / Shipper Address Line 1 / Shipper Address Line 2 / Shipper City / Shipper State / Shipper Zip Code / Shipper Country/TerritoryShipper address
Original Customer Reference / Original Ref#2 / Original Ref#3/PO Number / Original Department Reference DescriptionShipper-supplied references at ship time
Updated Customer Reference / Updated Ref#2 / Updated Ref#3/PO Number / Updated Department Reference DescriptionUpdated references
RMA#Return merchandise authorization number
Original Recipient Address Line 1 / Line 2 / City / State / Zip Code / Country/TerritoryOriginal recipient (before address correction)
Zone CodeShipping zone (2–8)4
Cost AllocationCost allocation tag
Alternate Address Line 1 / Line 2 / City / State Province / Zip Code / Country/Territory CodeAlternate address (forwarding)
CrossRefTrackingID Prefix / CrossRefTrackingIDCross-referenced tracking ID
Entry Date / Entry NumberCustoms entry (international ground)
Customs Value / Customs Value Currency CodeCustoms declared value
Declared Value / Declared Value Currency CodeDeclared value
Commodity Description (×4) / Commodity Country/Territory Code (×4)Up to 4 commodity entries
Currency Conversion Date / Currency Conversion RateFX fields
Multiweight Number / Multiweight Total Multiweight Units / Multiweight Total Multiweight Weight / Multiweight Total Shipment Charge Amount / Multiweight Total Shipment WeightMulti-weight consolidation
Ground Tracking ID Address Correction Discount Charge Amount / Ground Tracking ID Address Correction Gross Charge AmountStandalone address-correction charges
Rated MethodHow the shipment was rated
Sort HubOrigin sort hub
Estimated Weight / Estimated Weight UnitEstimated weight
Postal Class / Process Category / Package SizeCategory fields
Delivery ConfirmationDelivery confirmation service
Tendered DateDate tendered to FedEx
MPS Package IDMulti-piece shipment package ID
Tracking ID Charge Description × 51Charge label for each pair slotFuel Surcharge
Tracking ID Charge Amount × 51Charge amount for each pair slot6.33
Shipment NotesFree-text notes column
All sample data is synthetic. Tracking numbers, account numbers, addresses, and reference fields are fabricated and do not correspond to any real shipments or customers.