Skip to main content

​
Overview

DHL Express delivers invoices as CSVs with a two-level structure: I (invoice) rows carry billing account metadata, and S (shipment) rows are the actual line items. Charges live in numbered XC1–XC9 column groups — each group holds one charge code, label, amount, tax, discount, and total. DHL Express CSVs have 153 columns and up to 9 concurrent charges per shipment.

​
Shape notes

  • Line Type markers. The first column is Line Type: I for invoice-level rows, S for shipment rows. Only S rows become line items in the Trackstar API; billing account is carried forward from the preceding I row when an S row leaves Billing Account blank.
  • Dates are YYYYMMDD. Invoice and shipment dates use 8-digit format with no separators — e.g., 20260331 for 31 March 2026.
  • Charges come from XC columns. Each of XC1–XC9 has 7 associated columns (Code, Name, Charge, Tax Code, Tax, Discount, Total). Any XC slot with a populated Name and non-zero Charge becomes a Trackstar line item.
  • European number format is tolerated. DHL Express in some regions delivers amounts like 5.476,48 (period as thousands separator, comma as decimal). Trackstar handles both formats automatically.
  • Customs CSVs use XC10 and XC11. Express (shipment) CSVs only use XC1–XC9; customs CSVs extend to XC11.

​
Sample rows

Curated subset showing the Line Type/XC structure. The downloadable CSV has all 153 columns. 
Line Type,Invoice Number,Invoice Date,Billing Account,Shipment Number,Product Name,Weight (kg),Total amount (excl. VAT),XC1 Name,XC1 Charge,XC2 Name,XC2 Charge
I,MUC2684030563,20260331,196946120,,,,,,,,
S,MUC2684030563,20260331,196946120,8693906809,EXPRESS WORLDWIDE doc,10.1,138.56,Duties & Taxes Advanced,8.95,Address Correction,6.66
S,MUC2684030563,20260331,196946120,3391005566,EXPRESS 12:00 doc,3.7,84.30,Oversize Piece,15.76,Premium 10:30,15.63
S,MUC2684030563,20260331,196946120,4339666456,EXPRESS 9:00 doc,9.7,102.08,Premium 10:30,3.41,Duties & Taxes Advanced,2.32
S,MUC2684030563,20260331,196946120,6935433564,EXPRESS WORLDWIDE nondoc,16.8,133.35,Premium 10:30,16.41,Duties & Taxes Advanced,4.51

​
Download

Download full sample CSV (1 I row + 15 S rows, 153 columns)
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.

​
Fields

​
Invoice identification

ColumnDescriptionExample
Line TypeI or S — determines how the row is processedS
Billing SourceSource system (BBP = billing portal)BBP
Original Invoice NumberOriginal if this is a correction
Invoice NumberUnique invoice IDMUC2684030563
Station CodeDHL billing stationMUC
Invoice IdentifierStation + invoice + type suffixMUC2684030563I
Invoice TypeInvoice kindInvoice / Credit Note
Invoice DateYYYYMMDD20260331
Payment TermsFree-text termsNet 14 Days
Due DatePayment due (YYYYMMDD)20260414
Parent AccountBilling hierarchy parent
Billing AccountCustomer account196946120

​
Billing address

ColumnDescription
Billing Account Name / Billing Account Name (Additional)Billed entity names
Billing Address 1 / 2 / 3Street lines
Billing PostcodePostal code
Billing CityCity
Billing State/ProvinceState / province
Billing Country CodeISO country
Billing ContactContact name
VAT NumberVAT registration (for EU accounts)

​
Shipment

ColumnDescriptionExample
Shipment NumberDHL tracking number8693906809
Shipment DateYYYYMMDD20260314
Country Specific Label / Country Specific ValueCountry-specific reference
Shipment Reference 1 / 2 / 3Customer-supplied refs
ProductProduct codeP
Product NameHuman-readable serviceEXPRESS WORLDWIDE doc
PiecesPiece count1

​
Origin and destination

ColumnDescription
Origin / Orig Name / Orig Country Code / Orig Country NameOrigin station
Senders Name / Senders Address 1–3 / Senders Postcode / Senders City / Senders State/Province / Senders Country / Senders ContactShipper address
Destination / Dest Name / Dest Country Code / Dest Country NameDestination station
Receivers Name / Receivers Address 1–3 / Receivers Postcode / Receivers City / Receivers State/Province / Receivers Country / Receivers ContactRecipient address
Proof of Delivery/NamePOD signer

​
Contents and dimensions

ColumnDescription
Description of ContentsShipment description
Event DescriptionStatus / event
DimensionsLxWxH string
Cust Scale Weight (A)Customer-reported scale weight
DHL Scale Weight (B)DHL-measured scale weight
Cust Vol Weight (V) / DHL Vol Weight (W)Volumetric weights
Weight FlagWhich weight was used for billing
Weight (kg)Final billed weight

​
Invoice totals

ColumnDescriptionExample
CurrencyISO 4217EUR
Total amount (excl. VAT)Pre-tax total138.56
Total amount (incl. VAT)Tax-inclusive total164.89
Tax CodeTax codeN
Total TaxTotal VAT amount26.33
Tax AdjustmentPost-calc adjustment
Invoice FeeFlat invoice fee

​
Core charges

ColumnDescription
Weight ChargeCharge based on weight
Weight Tax (VAT)VAT on weight charge
Other Charges 1 / Other Charges 1 AmountNamed other charge #1
Other Charges 2 / Other Charges 2 AmountNamed other charge #2
Discount 1–3 / Discount 1–3 AmountUp to three named discounts
Total Extra Charges (XC)Sum of all XC charges on this row
Total Extra Charges TaxVAT on extra charges

​
Extra charges (XC1–XC9)

Each XC slot has 7 columns: Code, Name, Charge, Tax Code, Tax, Discount, Total. Any slot with a populated Name and non-zero Charge becomes a Trackstar line item. XC slots are dense, not sparse — if only 2 charges apply, they occupy XC1 and XC2, leaving XC3–XC9 empty.
SlotColumns
XC1XC1 Code, XC1 Name, XC1 Charge, XC1 Tax Code, XC1 Tax, XC1 Discount, XC1 Total
XC2(same structure)
XC3
XC4
XC5
XC6
XC7
XC8
XC9
Common XC charge names include:
  • Fuel Surcharge
  • Oversize Piece
  • Remote Area Delivery
  • Address Correction
  • Duties & Taxes Advanced
  • Premium 10:30 / Premium 9:00
  • Saturday Delivery