Back to all couriers
AramexConverter
Turn Aramex bills into Shipment (Excel + invoice PDF) and Duty & Tax files — all in HKD.
The 2 files you'll get
Shipment
Freight, fuel & peak per parcel
Waiting for Step 1
Duty & Tax
Customs charge per parcel
Waiting for Step 2
1
Upload the Aramex bill + invoice PDF
Two files: the bill Excel (the tabular charges) and the invoice PDF. The fuel amount lives only in the PDF, so both are needed — Peak is whatever's left after Base and fuel. Invoice date is read from the PDF.
Creates:Shipment1 file
Shipment — what maps to what
| Converted column | From the bill | Rule / formula |
|---|---|---|
| Carrier | — | always aramex |
| Invoice No. | Bill. Doc. | — |
| Invoice Date | Document Date on the invoice | |
| Tracking No. | Airway Bill No. | — |
| Ship Date | Pick up Date | — |
| Service Code | Material Group | — |
| Sender / Receiver Country | Origin / Destination Location | — |
| Billed Weight | Chargeable Weight | — |
| Freight Cost | Base Charge (Excel) | — |
| Fuel Surcharge | "Other Charges" column, matched by air waybill | |
| Peak Season Surcharge | — | Net Value − Base − Fuel |
| Invoice Total | Net Value | — |
2
Upload the customs-charge file
The Aramex customs charge Excel. Each tracking number is read from the charge text (HAWB#…). Set the statement date — it's not inside the file.
Creates:Duty & Tax1 file
Duty & Tax — what maps to what
| Converted column | From the bill | Rule / formula |
|---|---|---|
| Tracking No. | Airway Bill No. | the HAWB# in the charge text |
| Carrier | — | always spaceship-air |
| Invoice No. | Bill. Doc. | — |
| Currency | — | always HKD |
| Tariff | Net Value | — |
| Description | — | always "Duty and Tax" |
| Invoice Date | You set it | the statement date (Step 2) |
Files stay on your computer — nothing is uploaded to a server.