Export carton mark worksheet

What the worksheet produces

The tool returns two summary rows and a plain text block. The rows are Carton sequence, shown as the entered case number followed by of and the total, and Packaging tare in kilograms. The text block lists CONSIGNEE, DESTINATION, PO, CASE, GROSS, NET, DIMENSIONS, ORIGIN and HANDLING in that order. It is a worksheet for assembling buyer-entered identifiers, not a finished label file. It does not add barcodes, logos, borders, pictograms or printer layout. The output is useful when you need a consistent mark draft that a buyer, broker or carrier can review before production.

Identifier fields and operational meaning

Consignee, destination, purchase order, dimensions, origin and handling are free text fields. Enter the wording exactly as it should appear on the carton mark. The purchase order field is not checked against an order system, and the consignee and destination fields are not matched to an address database. The dimensions field accepts a string such as 40 x 30 x 25 cm; it does not parse length, width or height and does not calculate volume. The origin field starts with Confirm origin, which is a placeholder, not a verified origin statement. The handling field starts with Keep dry, which is text, not a symbol. Confirm origin wording and handling symbols with the buyer, broker and carrier before use.

Case sequence and total cases

Case number and total cases are integer entries. The worksheet compares them and stops with Case number cannot exceed total cases when the case number is larger. A case number equal to the total is accepted, so the final carton can be marked. The sequence row and the CASE line both use the entered values, for example 2 of 10 and CASE: 2 OF 10. Changing only the case number changes the sequence mark but does not change weights or tare. The tool does not check that every case in the range is unique or that the total matches a packing list.

Gross, net and packaging tare

Gross weight and net weight are entered in kilograms. The worksheet rejects net greater than gross with Net weight cannot exceed gross weight. When net is less than or equal to gross, packaging tare is gross minus net and is shown in kilograms. A 10 kg gross carton with 8 kg net gives 2 kg tare. A 12 kg gross carton with 8 kg net gives 4 kg tare. The tare row is arithmetic from the two entered weights; it is not a measured packaging weight. If net equals gross, the tare row shows 0 kg, which may mean packaging weight was omitted or included in net. Review the entered weights before printing.

Dimensions, origin and handling text

The dimensions field is copied into the DIMENSIONS line as entered, including the unit text. The tool does not sort axes, convert units or validate that the string contains three measurements. Origin and handling are also copied as entered. The default origin text is a prompt to confirm, and the default handling text is a plain instruction. The worksheet does not render handling pictograms or certify that the wording meets a carrier or customs rule. Treat these lines as draft content for approval, not as a compliance determination.

Worked examples with entered values

Starting scenario: consignee Example buyer, destination Receiving warehouse, PO-EXAMPLE, case 1, total 10, gross 10 kg, net 8 kg, dimensions 40 x 30 x 25 cm, origin Confirm origin and handling Keep dry. The summary rows are Carton sequence 1 of 10 and Packaging tare 2 kg. The text block includes CASE: 1 OF 10, GROSS: 10 kg and NET: 8 kg. The origin and handling lines remain the entered placeholder text, so they still need review.

Changed scenario: the same identifiers and dimensions, with case 2, total 10, gross 12 kg and net 8 kg. The summary rows become Carton sequence 2 of 10 and Packaging tare 4 kg. The case change alters the sequence mark only. The gross change from 10 kg to 12 kg, with net held at 8 kg, raises the reported tare by 2 kg. The text block shows CASE: 2 OF 10, GROSS: 12 kg and NET: 8 kg. No other line changes because the other fields are unchanged.

Validation, edge cases and limits

The worksheet rejects a case number above total cases and net weight above gross weight. Text must be nonblank and at most 4,000 characters after trimming. The tool does not check address format, purchase order format, dimension syntax, origin wording or handling instructions. An edge case is case equal to total, which is accepted and useful for the last carton. Another edge case is net equal to gross, which is accepted and produces 0 kg tare; check whether packaging weight is missing. The output is a document worksheet, not a customs or dangerous-goods label. Country-of-origin wording and handling symbols need buyer, broker and carrier approval. The transparent arithmetic reference supports the equation, units and assumptions shown here.

Questions about export carton mark worksheet