Import & export trading · Export documents · Hong Kong

Export invoices and packing lists for a Hong Kong trading company

One purchase order, four documents, the same figures in each — and a part carton is now caught before the goods are packed.

180 hoursestimated time saved a month
Target0invoices issued at an unagreed price
TargetMinutesfrom purchase order to draft documents

Representative example — a composite of typical Hong Kong workflows, written from the duties in current job ads. Company names, documents and figures are sample data.

A Hong Kong trading company with about 15 staff exports kitchenware and household goods, made by partner factories, to buyers in Europe and Australia. Every shipment needs a commercial invoice, a packing list, shipping marks, a booking with the forwarder and the figures for the trade declaration — and all of them must agree with each other and with the buyer's order.

At a glance

The files they already use

  • Buyer's purchase order
  • Factory packing data
  • Agreed price list
  • Buyer's shipping instructions
  • Shipping schedule
AI systembuilt around their rules
  • Cartons = quantity ÷ pieces per carton, rounded up
  • Carton volume = length × width × height
  • PO price checked against the agreed price list
  • Their own 28 m³ limit for a 20-foot container
  • Each buyer's marks and document layout

Done automatically

  • Commercial invoice
  • Packing list and shipping marks
  • Booking email to the forwarder — drafted
  • Figures for the trade declaration

Shipping staff check every document, send the booking email and lodge the declaration themselves.

How they used to do it

When a buyer's purchase order arrived as a PDF, the shipping clerk retyped each line into an Excel invoice. The factory sent its packing data — pieces per carton, carton size, gross and net weight — by email or WhatsApp, and the clerk worked out the cartons, the volume and the weights on a calculator.

The packing list was typed separately, the shipping marks were laid out in Word, and a booking email was written to the forwarder. Finally the same figures were entered once more for the trade declaration. Four documents, typed four times, and the figures did not always match.

The difficulties

  • Part cartons found too late. An order quantity that did not fill the last carton was only noticed at the factory, when the goods were already being packed.
  • Price differences missed. A buyer's PO sometimes carried an old unit price, and the invoice went out at that price.
  • Volume miscalculated. Carton sizes come in centimetres but volume is in cubic metres, and one slip changed the container booking.
  • Four documents, four versions. Invoice, packing list, booking and declaration were typed separately, and a correction in one was often missed in another.
  • Knowledge in one head. Only the senior clerk knew each buyer's marks and layout, so shipments waited whenever that clerk was on leave.

Their formula, broken down

A packing list looks like a table of numbers. Every one of them comes from the order and the factory's carton data, and the total volume decides the container. Here is order PO-4471 from a German homeware buyer, priced on the shipping term agreed with the buyer (here FOB Hong Kong) — the price covers the goods until they are loaded on board in Hong Kong.

Their formulaCartons = quantity ÷ pieces per carton, rounded up; volume = cartons × length × width × height in metres; invoice value = Σ quantity × unit price
  1. Mixing bowl sets

    2,400 sets ÷ 12 per carton = 200 cartons. Each carton is 50 × 40 × 30 cm, which is 0.5 × 0.4 × 0.3 m = 0.060 m³.

    200 cartons × 0.5 m × 0.4 m × 0.3 m12.000 m³

  2. Frying pans

    1,800 pans ÷ 10 per carton = 180 cartons. Each carton is 60 × 35 × 30 cm = 0.063 m³.

    180 cartons × 0.6 m × 0.35 m × 0.3 m11.340 m³

  3. Utensil sets — and a part carton

    3,010 sets ÷ 24 per carton = 125.4, rounded up to 126 cartons. The last carton holds only 10 sets, so it is flagged. Each carton is 40 × 30 × 25 cm = 0.030 m³.

    126 cartons × 0.4 m × 0.3 m × 0.25 m3.780 m³

Total volume — inside their own 28 m³ limit27.120 m³

What the system produces

export.alveek.ai/PO-4471/docsSample data

Buyer's order and factory packing data

PO-4471.pdfFactory packing data.xlsxAgreed price list.xlsx
ItemQtyPer cartonCarton cmPO price, US$
Stainless mixing bowl set2,4001250×40×304.85
Non-stick frying pan, 28 cm1,8001060×35×306.20
Silicone utensil set3,0102440×30×252.35
Total quantity ordered7,210

Packing list and commercial invoice

Invoice CI-4471.pdfPacking list PL-4471.pdf
ItemCartonsm³Gross kgUS$
Mixing bowl sets20012.0002,900.011,640.00
Frying pans18011.3402,160.011,160.00
Utensil sets1263.7801,008.07,073.50
Invoice value, FOB Hong Kong (US$)29,873.50

How it was calculated

Cartons 200 + 180 + 126 = 506 cartons · volume 12.000 + 11.340 + 3.780 = 27.120 m³ · gross weight 6,068.0 kg · net weight 5,451.2 kg

Invoice = 2,400 sets × US$4.85 + 1,800 pans × US$6.20 + 3,010 sets × US$2.35 = US$29,873.50

Flagged for a person to confirm

  • Utensil sets: 3,010 = 125 full cartons + 10 sets. The part carton is counted as a full carton for volume and weight until the factory weighs it, and the buyer is asked whether 3,000 or 3,024 is wanted.
  • Frying pans: the PO says US$6.20 but the agreed price list says US$6.40 — US$360.00 less on 1,800 pans. The invoice is held until the sales staff confirm the price.

In this example: cartons, volume, weights and invoice value all come from one calculation, the part carton is caught before packing, and the price difference stops the invoice instead of going out with it.

How we helped

We build one record per buyer — the agreed price list, the shipping marks, the document layout and the forwarder's details — and a system that reads the purchase order and the factory's packing data and prepares every document from the same figures. The factories change nothing about what they send; the shipping clerk stops retyping and starts checking.

  1. The order comes in. The buyer's PDF purchase order and the factory's packing data are read as they arrive; nothing is retyped.
  2. Checked against the price list. Every unit price is compared with the agreed price list, and every quantity with the carton size. A difference or a part carton is flagged.
  3. Every document from one set of figures. Invoice, packing list, shipping marks, booking email and declaration figures are prepared from one set of figures, with differences flagged for shipping staff to review.
  4. Checked, then sent. The shipping staff check the documents, send the booking email to the forwarder and lodge the trade declaration themselves.

What the system handles

Commercial invoices

In US dollars, on the shipping term agreed with the buyer (here FOB Hong Kong), in each buyer's own layout, with unit prices checked against the agreed price list.

Packing lists

Carton numbers, total cartons, volume and gross and net weight, worked out from the factory's carton data.

Shipping marks

Each buyer's marks laid out with the PO number and carton numbering, ready to send to the factory.

Forwarder booking

A booking email with cartons, volume, weight and the planned shipping date, drafted for a person to send.

Trade declaration figures

The quantities, values and weights a staff member needs to lodge the trade declaration, taken from the same invoice.

Before and after

TopicBeforeAfter
Order linesEach PO line was retyped from the PDF into Excel.The purchase order is read directly; nothing is retyped.
CartonsPart cartons were often found only at the factory.A quantity that does not fill the last carton is flagged when the order arrives.
PricesAn old unit price on the PO went straight onto the invoice.Every unit price is checked against the agreed price list before the invoice is prepared.
ContainerVolume was worked out by calculator, and centimetres were sometimes mixed up with metres.Volume is worked out from the carton size and checked against their own 28 m³ limit.
DocumentsFour documents were typed separately and did not always match.All documents come from one set of figures; any difference is flagged for shipping staff to review.

How much time it saves

  • About 72 shipments a month, each taking around 3 hours of documents: invoice, packing list, marks, booking and declaration figures.
  • 72 shipments × 3 hours = 216 hours a month.
  • With the system, the shipping staff check each set in about 30 minutes: 72 × 0.5 = 36 hours.
  • Time saved ≈ 180 hours a month — about 22.5 working days.
  • At HK$110 an hour (about HK$19,000 a month for one full-time clerk, MPF included), that is about HK$19,800 a month — before counting price differences now caught before the invoice goes out.

These are the working assumptions behind the figure, not an audited result.

How a project like this runs

  1. Free assessment. We sit with your shipping clerk through several real shipments and collect one complete set of documents for each buyer.
  2. Built on your own shipments. The layouts, marks and carton rules are rebuilt from your past shipments and tested until they reproduce the documents already sent.
  3. Side by side. For one month your clerk prepares documents by hand while the system runs on the same orders, and the two are compared line by line.
  4. Live, then maintained. Once they match, the retyping stops. New buyers are added with their price list and marks, and we fix anything that comes up.

Questions owners usually ask

  • Does the system book the shipment or lodge the declaration?
    No. It drafts the booking email and prepares the declaration figures; your shipping staff check them, send the email and lodge the declaration.
  • Where does the 28 m³ limit come from?
    It is the company's own planning limit for a 20-foot container, not an industry rule. Each company sets its own figure, and it can be changed at any time.
  • Our factories send packing data in different formats. Is that a problem?
    No. Each factory's format is set up once; missing data, such as a carton weight, is flagged instead of guessed.

The results

  • Invoice, packing list, shipping marks, booking email and declaration figures are prepared from one set of figures, with differences flagged for shipping staff to review.
  • Part cartons and price differences are flagged when the order arrives, not at the factory or after the invoice has gone out.
  • Every shipment is checked against the company's own container limit before it is booked.
PythonClaudeExcelWhatsAppEmail

Representative example — a composite of typical Hong Kong workflows, written from the duties in current job ads. Company names, documents and figures are sample data.

← Back to all case studies

Does your company have a formula like this?

Send us one real example — a quotation, an invoice or a month-end statement — and we will show you how the system would work it out. The assessment is free.

Get a free assessment →