Back to all couriers
UBIConverter
Turn UBI (SPWW) bills into Shipment, Duty & Tax and Bulk charge files — all in HKD, with a mapping table for each.
The 3 files you'll get
Shipment
Freight & surcharges per parcel
Waiting for Step 2
Duty & Tax
Customs duty / DDP per parcel
Waiting for Step 2
Bulk charge
Return & other fees
Waiting for Step 3
1
Invoice date
SetUBI bills are already in HKD, so there's nothing to convert. Just set the billing date — the invoice number is filled in automatically.
The billing / statement date
Made from the date
2
Upload the UBI billing statement
The SPWW billing Excel file. It creates two files: Shipment (from its freight sheet) and Duty & Tax (from its additional-charges sheet).
Creates:ShipmentDuty & Tax2 files
Shipment — what maps to what
| Converted column | From the bill | Rule / formula |
|---|---|---|
| Carrier | — | always spaceship-air |
| Invoice No. | Invoice date | UBIWW + date |
| Tracking No. | Tracking No | — |
| Ship Date | Account Date | — |
| Service Code | Service | — |
| Sender Country | — | always HK |
| Receiver Country | Destination | — |
| Billed Weight | Chargeable Weight | round up to 2 dp |
| Currency | — | always HKD |
| Freight Cost | Shipping Fee | — |
| Fuel Surcharge | Special Surcharge | — |
| Remote Area Surcharge | Remote Area Surcharge | — |
| Invoice Total | Total Charges | Freight + surcharges |
Duty & Tax — what maps to what (only Tariff / Customs Duty rows)
| Converted column | From the bill | Rule / formula |
|---|---|---|
| Tracking No. | TrackingNumber | — |
| Carrier | — | always spaceship-air |
| Currency | — | always HKD |
| Tariff | Amount | — |
| Description | Fee Item | Tariff→"DDP", Customs Duty→"Customs Duty" |
| Invoice No. / Date | Invoice date | UBIWW + date |
3
Upload the additional-charges file
The UBI additional charges Excel file. This makes the Bulk charge file from the non-tariff fees (like returns) — the tariff rows go to Duty & Tax above.
Creates:Bulk charge1 file
Bulk charge — what maps to what
| Converted column | From the bill | Rule / formula |
|---|---|---|
| Charge Category | Fee Item | non-tariff → shipment_or_pickup_others |
| Description | Fee Item | Return → "Return fee for return to oversea warehouse" |
| Amount / Cost | Amount | — |
| Tracking No. | TrackingNumber | — |
| Carrier | — | always spaceship-air |
Files stay on your computer — nothing is uploaded to a server.