✅ Required Column
Company NameMust not be empty — rows without this are skipped
📌 Core Columns
KeteranganCity/region label (e.g. MEDAN, SBY)
HallHall name (e.g. Foyer, Hall 5) — auto-creates the hall & booth slot(s) if new
Booth Number(s)Booth number(s), comma-separated for multi-booth (e.g. F-001, F-002)
Booth Type(s)e.g. Standard, Space Only — comma-separated for more than one
Country / NegaraDefaults to INDONESIA if blank
NPWPTax ID (digits only, max 16)
No. VAVirtual account number. Put just the prefix's digits in a separate "VA Prefix" column, or combine as "prefix-number" in this one cell (e.g. 04209-2606090854)
VA PrefixOptional separate column for the VA prefix (e.g. 04209)
Statuspending / confirmed / booked / cancelled (defaults to pending)
📦 Booth Quantity & Type
STD / Qty STDStandard booth quantity
EXH / Qty EXHExhibition booth quantity
Confirm STDConfirmed standard qty
Confirm EXHConfirmed exhibition qty
Size / Qty SizeBooth size in m² (e.g. 3x3)
💰 Contract / Payment
Contract ValueTotal contract amount (number)
CurrencyIDR or USD (defaults to IDR)
Termin CountPayment terms 1–6 (defaults to 1)
👤 Contact Info
Name / Contact NamePIC name
Phone / M. PhoneContact phone number
EmailContact email
📝 Other Fields
NPWPTax ID / NPWP number (digits only, max 16)
NPWP AddressAddress per NPWP
Shipping AddressDelivery address
ExhibitionExhibition category/type
FoyerFoyer area (if applicable)
NotesAdditional notes / remarks
SPK Date / SPK NumberContract date & reference
💡 Tips: Column headers are case-insensitive and flexible — "Company Name", "company name", or "Nama Perusahaan" all work. Extra/unknown columns are ignored. First row must be the header row.
⚠️ A booking code is auto-generated for each imported row. Duplicate companies with the same NPWP + VA in the same event will be rejected.