Turn a Hongkong Post EC-SHIP acceptance report into the Shipment file — all in HKD, invoice details worked out from the report.
The file you'll get
Freight per item — all HKD
The HK Post EC-SHIP Acceptance report Excel. Everything is already in HKD; the invoice number & date are worked out from the report's posting dates.
| Converted column | From the bill | Rule / formula |
|---|---|---|
| Carrier | — | always hkpost |
| Invoice No. | — | EC_SHIP_<first> to <last> posting date |
| Invoice Date | — | month-end of the latest posting date |
| Tracking No. | Item No. | — |
| Ship Date | Posting Date | — |
| Service Code | Service Name | — |
| Sender / Receiver Country | HK / Destination | destination → ISO code |
| Billed Weight | Total Weight(kg) | rounded up to 2 dp |
| Freight Cost / Invoice Total | Total Post Amount(HKD) | — |
Files stay on your computer — nothing is uploaded to a server.