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. FedEx also delivers PDFs and credit notes alongside the invoice CSVs. Files delivered lists every kind.

​
Files delivered

Each FedEx sync can deliver the files below through the Files endpoint. Trackstar names each file, so the names differ from what you’d download in the FedEx billing portal. A file’s file_name is the name shown here; PDFs also carry a pdf/ folder and credit note files a credit_notes/ folder in their file id. A / in a credit note number becomes _ in these file names.

​
Preliminary invoices

FedEx publishes an invoice’s CSV before the invoice is final. Trackstar delivers that early copy as -PRELIM.csv, then delivers the final -CSV.csv once FedEx marks the invoice final.
  • The two files carry the same per-shipment charges. Use one or the other; adding both double counts the invoice.
  • In the preliminary copy, Settlement Type, Total Standard Charges, Total Surcharges, Total Taxes, and Ship Date are blank.
  • Some invoices delivered before mid-October 2026 were preliminary but named -CSV.csv, so they have the same blanks.

​
Credit notes

Credits FedEx issues against an invoice arrive as three kinds of file:
  • Credit note PDF, one per credit note.
  • Credit note CSV, one per credit note and airway bill. It uses FedEx’s credit note column layout (29 columns in the files we’ve seen), not the invoice layout: there are no charge label/amount pairs, and the tracking column is spelled Airway Bill Number rather than Air Waybill Number. FedEx lists every credit on an airway bill under each credit note that airway bill appears on, and dates credits a day earlier than the PDF does, so these CSVs repeat credits. Trackstar doesn’t build line items from them. Older files named {account}-{credit note}-{stamp}-CN.csv cover only the first airway bill on the note.
  • Credit note history JSON, one per invoice. Trackstar delivers a new one each time the invoice gains a credit note, so the file with the highest {n} is the most complete. This is the source of credit note line items (see Mapping to invoice line items). Older files named {account}-{invoice}-creditnote-{credit note}.json (one per note) may also appear; Trackstar doesn’t build line items from them.
Each history file is a JSON object with accountNumber, invoice (invoiceNumber and FedEx’s internal invoiceId), and transactionHistory: the invoice’s credit note entries as FedEx returns them. Trackstar reads creditNoteNumber, creditNoteDate, transactionId, transactionDate, transactionAmount.amount, and originalReason from each entry; the other fields are passed through.

​
Invoice CSV 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.
  • Base freight can sit outside the pairs. Transportation Charge Amount (US) holds the base freight charge. It is usually repeated in a pair labelled Transportation Charge. When no pair has that label, Trackstar makes a Transportation Charge line item from the column instead.
  • A row with no charges still becomes a line item. If a row has no populated pairs and no transportation charge, Trackstar creates one line item for the row total, described by the row’s Invoice Type (or Shipment when that’s blank).
  • 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. Trackstar checks this before delivering an invoice CSV and doesn’t deliver one that fails. Invoices whose Original Amount Due is 0 or blank aren’t checked.
  • 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. The samples use DD-MMM-YYYY (e.g., 31-Mar-2026). Some FedEx reports write it as YYYYMMDD (20260331) or Mon DD, YYYY (Mar 31, 2026) instead; Trackstar reads all three.
  • Column sets vary slightly by account. Most US accounts use the 210-column layout documented here; a small number use a close variant with a few different columns (around 203). The identifier, tracking, and charge-pair columns shown below are present across all of them.

​
Sample rows

Curated subset showing the tracking-ID charge-pair structure. The downloadable CSV has all 210 columns.

​
Download

Download FedEx US sample CSV (1 header + 22 data rows, 210 columns)

​
Fields (US-specific)

​
Mapping to invoice line items

​
From invoice CSVs

Each populated charge pair on a row becomes one line item. Preliminary and final CSVs for the same invoice produce the same line items.

​
From credit note history JSON

Each credit in transactionHistory becomes one line item. FedEx lists a credit under every credit note on the same airway bill; Trackstar assigns it to the first of those notes dated after the credit and drops the repeats, so each credit appears once. Because credits keep the airway bill as tracking_number, they net against that shipment’s charges.
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.