Help
Boxes screen

Excel templates

Downloading and uploading templates for goods, IMEI, containers, transport, documents and CVD.

Actions → Excel templates. Download gives you a template with the declaration's data, Upload applies a filled-in file (.xlsx).

Excel templates

Templates

GroupTemplates
Goodsbox 31 details, IMEI of all items, IMEI of the current item, containers
Transport and carnetsbox 18, box 21, box 53 (KKDG / TIR)
Documentsbox 40, box 44
CVDCVD-2 — source of information, CVD-1 — by item
Download onlysanitary, hygiene, conformity, certification
Reportsdeclaration report, goods statement, calculations, CCD correction calculations, remainders

Uploading

  1. The file is checked first: the window shows how many rows the workbook has and that the existing data will be replaced.
  2. Errors are listed as "Row N, column X". While there are errors, Apply is disabled — fix the workbook and upload it again.
  3. Sometimes LexPort asks: merge identical items with the same code and country, create a new declaration if there are more than 100 items.
  4. After applying — "Rows loaded: N".

Box windows open only their own templates: box 31 — goods, IMEI and containers, box 44 — its own, boxes 40 and 53 — their own, the CVD sheet — CVD. Only blank templates are available from the journal. Upload isn't available for a declaration locked for editing.

On this page