Yun ExpressConverter
Turn a Yun (YunExpress) statement into Shipment and Duty & Tax files — all in HKD, invoice details read from the file.
The files you'll get
Freight & surcharges per parcel — 支出记录(HKD)
VAT + tariff — VAT增值税记录(HKD)
Upload the Yun Express statement
The Yun (YunExpress) electronic bill Excel file. The invoice number & date are read from the statement. It creates a Shipment and a Duty & Tax file from the HKD sheets (支出记录(HKD) / VAT增值税记录(HKD)) — and, if the bill also carries RMB sheets, a matching pair converted to HKD at the rate below.
Only used for the RMB sheets — ask finance for the month's rate (around 1.08).
Shipment — what maps to what
| Converted column | From the bill | Rule / formula |
|---|---|---|
| Carrier | — | always spaceship-air |
| Invoice No. / Date | In the statement | 账单编号 (bill number) |
| Tracking No. | 客户单号 (SS number) | — |
| Ship Date | 到货时间 | — |
| Service Code | 销售产品 | mapped (Premium / Cosmetics / Express / Economy) |
| Sender / Receiver Country | HK / 目的国家 | destination → ISO code |
| Billed Weight | 计费重量 / 材积重 | round up max(billed, dim) |
| Dim / Actual Weight | 材积重 / 实重 | — |
| Freight Cost | 速递运费 + 挂号费 | — |
| Fuel Surcharge | 燃油费 | — |
| Remote Area Surcharge | 偏远附加费 | — |
| D&T Handling Fee | 欧盟海关处理费 | — |
| Other Surcharges | 其他费用 | — |
| Currency / amounts | — | RMB sheet × RMB→HKD rate; HKD sheet as-is |
| Invoice Total | 总运费 | — |
Duty & Tax — what maps to what
| Converted column | From the bill | Rule / formula |
|---|---|---|
| Tracking No. | 客户单号 | — |
| Carrier | — | always spaceship-air |
| Currency | — | always HKD |
| Tariff | 总金额 + 手续费 | HKD: VAT(HKD)+支出记录 fee · RMB: VAT(RMB)+VAT(RMB) fee × rate |
| Description | — | "Duty & Taxes" per component |
| Invoice No. / Date | In the statement | — |
Note: refund / return parcels (negative VAT) are left out of Duty & Tax. RMB-billed parcels & tariffs are converted to HKD using the rate above and written to their own Shipment / Duty & Tax files.
Files stay on your computer — nothing is uploaded to a server.