Customs Document Engineering · CEISA 4.0 · 2026

BC 2.5 Generator

Turns U9 ERP exports into Indonesian customs BC 2.5 declarations.

BC 2.5 Generator U9 ERP → CEISA 4.0 95% HS coverage BUILD

Parse U9Match HSGenerate XLSXSubmit CEISA

XLS

Commercial Invoice / PLU9 export · 142 lines · Template_Invoice_CIPL_BC25

✓

HTM

Product Structure (BOM).xls = HTML · parsed via read_html · 142 parts

✓

auto-detected U9 schema · freight mode by word-boundary regex · Nomor Aju pre-allocated

MatchingEngine · BOM → HS138 / 142

MaterialTierHS Code

Steel bracket Import 7326.90.99

PE resin Import 3901.10.92

Local foam pad Local 3921.13.00

Wiring harness Import resolving…

Adhesive X-22 Local missing HS

Tier 1 · OSS importTier 2 · local sheetalias-drift resilient

BC
2.5

BC25_…0159.xlsxNomor Aju · 26 digit

↓

000025 BOL7 2320 2604 0700 0159

✓Header · kantor pabean · jenis pemasukan ✓Barang · 142 rows · pos tarif HS ✓Pungutan · entitas · pengangkut ✓openpyxl fill from SCHEMA_REF template

✓ Manual portal uploadverified end-to-end · closed loop

◷ OAuth H2H submissionpending KPPBC api-key scope

POST /nle-oauth/v1/user/login · token
POST /openapi/document?isFinal=true
awaiting application authorization (dev: item null)

until H2H lands · manual upload is the supported path · missing-HS CSV → re-import → hot-reload

✓ CEISA manual-upload compatible Pydantic CeisaBC25Payload ready · 118 tests · 95% cov

Illustrative product mockup · representative data, no sensitive content

118 Tests passing

95% Coverage

26-digit Nomor Aju keyed output

2-tier HS matching engine

The problem

Inter-zone BC 2.5 declarations require re-keying ERP data into the CEISA schema and mapping every material to an HS code — slow, fragile, and easy to get rejected on a single missing tariff code.

The approach

◆ Pipeline: parse CIPL + BOM → MatchingEngine (HS enrichment) → generate BC 2.5 .xlsx keyed by 26-digit Nomor Aju.
◆ Two-tier matching: imported materials from CEISA OSS export, local materials from a maintained sheet — with column-alias drift handling.
◆ Closed manual-upload loop: auto-export missing-HS CSV, re-import filled HS, hot-reload the engine.
◆ Optional CEISA 4.0 OAuth submission; Excel is always the source of truth when the API is gated.

What it proves

✓ Verified compatible with CEISA manual portal upload end-to-end
✓ OSS column-drift resilience via alias resolution
✓ Pydantic CEISA schema models ready for full API submission

Next project

INSW Automation Studio Pro

→