Turn DPEX bills into Shipment (Excel) and Duty & Tax (PDF debit note) files — all in HKD.
The files you'll get
Freight & surcharges per parcel
Duty, tax & DDP admin fee
The DPEX Excel invoice (the Details sheet). Invoice number and date are read from the file.
| Converted column | From the bill | Rule / formula |
|---|---|---|
| Carrier / Currency | — | dpex / HKD |
| Invoice No. / Date | the bill header | — |
| Tracking No. | Airway Bill Number | — |
| Ship Date | Date | — |
| Service Code | Serv | — |
| Sender / Receiver | Origin / Country | — |
| Billed Weight | Wgt (kg) | round up to 2 dp |
| Freight Cost | Standard Charge | — |
| Fuel Surcharge | Fuel Surcharge | — |
| Peak Season Surcharge | Extra Charges | — |
| Invoice Total | Total | — |
The DPEX PDF debit note. Each parcel gets a Duty & Tax row plus a flat HK$125 DDP admin fee.
| Converted column | From the bill | Rule / formula |
|---|---|---|
| Duty & Tax rows | the debit-note PDF | one per Con Note (tracking) |
| Amount / Cost | the debit-note Amount | — |
| DDP Admin Fee rows | — | flat HK$125 per shipment (tax_and_duty) |
| Invoice No. / Date | Document No. / Date | — |
| Carrier / Currency | — | dpex / HKD |
Files stay on your computer — nothing is uploaded to a server.