DEV Community

AQX Logistics Engineering
AQX Logistics Engineering

Posted on

Modeling Multi-Country Customs VAT, Duties & IATA Volumetric Weight in Python (GCC, EU & Australasia Landed Costs)

If you are building a cross-border checkout calculator, e-commerce ERP, or procurement assistant for buyers ordering from US retailers (RockAuto, Amazon US, Sweetwater, Summit Racing, B&H Photo), hardcoding a single courier flat rate will break your landed-cost estimates immediately.

In production international air cargo, three compounding variables determine the real landed cost:

  1. IATA Volumetric (Dimensional) Weight: max(actual_kg, (L_cm * W_cm * H_cm) / 5000)
  2. Consolidation & Void-Space Repacking: Removing retail outer cartons and consolidating multi-store orders over a free 30-day window regularly reduces billable volumetric weight by 45%–70% and unlocks lower commercial per-kg brackets (>= 8.0 kg).
  3. Destination VAT & Customs Duty Thresholds: Every GCC, EU, UK, and Australasian customs authority applies different VAT rates, de minimis rules, and brokerage triggers.

Below is a clean, deterministic Python landed-cost model mirroring the live commercial corridors shipped from our LAX export hub (309 E Arbor Vitae St, Inglewood, CA 90301).


1. Python Landed-Cost Engine Across 15 Customs Regimes

from dataclasses import dataclass

@dataclass(frozen=True)
class CorridorRule:
    country: str
    consolidated_usd_per_kg: float  # >= 8.0 kg billable
    express_usd_per_kg: float       # < 8.0 kg billable
    vat_rate: float                 # decimal (e.g., 0.15 = 15%)
    duty_rate: float                # standard general tariff
    duty_threshold_usd: float       # approximate CIF de minimis
    customs_system: str

RULES: dict[str, CorridorRule] = {
    "saudi-arabia": CorridorRule("Saudi Arabia", 8.50, 15.50, 0.15, 0.05, 266.0, "ZATCA FASAH"),
    "united-arab-emirates": CorridorRule("UAE", 8.50, 15.50, 0.05, 0.05, 81.0, "Dubai Trade / Mirsal 2"),
    "bahrain": CorridorRule("Bahrain", 8.50, 15.50, 0.10, 0.05, 0.0, "Bahrain NBR / OFOQ"),
    "kuwait": CorridorRule("Kuwait", 8.50, 15.50, 0.00, 0.05, 0.0, "Kuwait General Customs"),
    "oman": CorridorRule("Oman", 8.50, 15.50, 0.05, 0.05, 0.0, "Royal Oman Police Bayan"),
    "qatar": CorridorRule("Qatar", 8.50, 15.50, 0.00, 0.05, 0.0, "Qatar Al-Nadeeb"),
    "united-kingdom": CorridorRule("United Kingdom", 8.50, 15.50, 0.20, 0.025, 170.0, "HMRC CDS"),
    "germany": CorridorRule("Germany", 9.00, 15.50, 0.19, 0.03, 165.0, "ATLAS / EUSt"),
    "france": CorridorRule("France", 9.00, 15.50, 0.20, 0.03, 165.0, "DELTA / TVA"),
    "spain": CorridorRule("Spain", 9.00, 15.50, 0.21, 0.03, 165.0, "AEAT / IVA"),
    "netherlands": CorridorRule("Netherlands", 9.00, 15.50, 0.21, 0.03, 165.0, "Douane / BTW"),
    "sweden": CorridorRule("Sweden", 9.00, 15.50, 0.25, 0.03, 165.0, "Tullverket / Moms"),
    "portugal": CorridorRule("Portugal", 9.00, 15.50, 0.23, 0.03, 165.0, "AT Alfândega / IVA"),
    "australia": CorridorRule("Australia", 11.00, 15.50, 0.10, 0.05, 650.0, "ABF ICS / GST"),
    "new-zealand": CorridorRule("New Zealand", 11.00, 15.50, 0.15, 0.05, 600.0, "NZCS / GST"),
}

def estimate_landed_cost(
    corridor_slug: str,
    goods_value_usd: float,
    actual_kg: float,
    dims_cm: tuple[float, float, float],
    repack_factor: float = 0.45,
) -> dict:
    rule = RULES[corridor_slug]
    l, w, h = dims_cm
    raw_vol_kg = round((l * w * h) / 5000.0, 2)
    repacked_kg = max(0.5, actual_kg, round(raw_vol_kg * repack_factor, 2))

    rate = rule.consolidated_usd_per_kg if repacked_kg >= 8.0 else rule.express_usd_per_kg
    freight_usd = round(repacked_kg * rate, 2)
    cif_usd = goods_value_usd + freight_usd

    duty_usd = round(cif_usd * rule.duty_rate, 2) if cif_usd > rule.duty_threshold_usd else 0.0
    vat_usd = round((cif_usd + duty_usd) * rule.vat_rate, 2)

    return {
        "country": rule.country,
        "customs_system": rule.customs_system,
        "raw_volumetric_kg": raw_vol_kg,
        "repacked_billable_kg": repacked_kg,
        "rate_usd_per_kg": rate,
        "freight_usd": freight_usd,
        "est_duty_usd": duty_usd,
        "est_vat_usd": vat_usd,
        "total_landed_usd": round(cif_usd + duty_usd + vat_usd, 2),
    }
Enter fullscreen mode Exit fullscreen mode

2. Example: 11 kg Auto Parts Consolidation (USA to Bahrain & Portugal)

Suppose a workshop orders brake rotors, control arms, and gaskets across 3 US warehouses totaling 11.0 kg actual weight, packed in oversized retail cartons measuring 60 × 50 × 45 cm (27.0 kg raw volumetric weight):

  • Unconsolidated courier billing (27.0 kg): You pay for 16.0 kg of empty cardboard air!
  • Consolidated LAX repacking (12.15 kg billable): Unlocks commercial tier (>= 8.0 kg):
    • USA → Bahrain ($8.50/kg): $103.28 air freight (2–4 business days) + 10% Bahrain VAT.
    • USA → Portugal ($9.00/kg): $109.35 air freight (2–4 business days) + 23% IVA via AT Alfândega.

3. Live Regional Corridor Guides & Open Tools

Every corridor rule above maps to live air freight calculators, customs breakdowns, and MCP agent endpoints:

Feel free to reuse or extend the CorridorRule dataclass above for your own cross-border checkout or ERP quoting scripts!

Top comments (0)