Commercial Invoice & Packing List Generator: Stop Getting Held at Customs

The problem this kills

A shipment is sitting on a dock because the commercial invoice has the wrong HS code, a value that doesn't match the order, an Incoterm nobody confirmed, or a packing list whose carton count doesn't tie to the invoice lines. Customs flags it, the broker calls, the freight forwarder waits, and a someone in your shipping office rebuilds the paperwork by hand — copy-pasting line items into a Word template, hunting down each product's tariff code and country of origin in a spreadsheet, and re-typing values that were already sitting in the order.

It's slow, it's error-prone, and the mistakes are expensive: held shipments, demurrage, re-classification penalties, and an annoyed buyer. Every export coordinator has their own fragile template and their own private knowledge of "which HS code goes with which product." You don't need to live like that, and you don't need to be a developer to fix it.

What you'll build

A simple internal web tool. You import two things: your order lines (what's shipping, quantities, prices) and a product master (each item's description, HS code, country of origin, and declared value). You pick an order, and the tool pulls its lines, enriches each one from the product master, and drafts a matching commercial invoice and packing list — totals in the right currency, the agreed Incoterm, the shipper / consignee / buyer parties filled in, and the packing list carton and weight figures tied to the invoice lines. It flags anything risky: a missing HS code, a value that doesn't match the order, a country of origin that's blank. Your export coordinator reviews the draft, fixes flags, and clicks Approve. Only then does the tool render the PDFs, save a stamped export record, and email the documents to the broker, forwarder, or buyer via Resend.

What's inside the Implementation Plan

The downloadable plan is a step-by-step file you paste into an AI coding agent. It opens by interviewing you about your business — what you export and to where, what your order export and product master columns are actually named, your HS-code and country-of-origin conventions, which Incoterms and currencies you use, your invoice-numbering scheme, and your messy edge cases — and then it tailors the data model, the validations, and every later step to your answers. This is not a generic template; the agent reflects a short spec back to you and waits for your thumbs-up before it builds anything. From there it walks the agent through the imports, the order-to-document drafting, the customs-data validation, the coordinator review-and-approve screen, the PDF and export-record generation, and the document email — each step with a ready-to-copy prompt. There's also a fallback so you can build the whole thing today even with no API to your ERP.

The governance it includes (this is the point)

This is real customs paperwork, so it ships with the controls a shipping team needs: login so only your team can use it, row-level security so you only ever see your own organization's orders and documents, a complete audit trail of who drafted, edited, and approved which documents and when, a hard human-approval gate so no invoice or packing list is issued until your coordinator signs off on the values, HS codes, and Incoterms, and duplicate guards keyed on invoice number so the same invoice can't be issued twice. Risky data — a blank HS code, a value mismatch, a missing country of origin — is flagged and blocks approval instead of sailing out the door.

Who it's for

Export coordinators and shipping admins who own outbound customs paperwork and are tired of rebuilding invoices in Word under time pressure. If you can describe how your shipments get classified and valued today, you can build this.

You've got this — start with the plan, paste the first prompt, answer the interview, and you'll see your first clean invoice and packing list draft take shape the same afternoon.