Skip to main content

Download CSV template

Loss history template with column headers and descriptions.

Download Excel template

Combined template with both Merchant List and Loss History sheets.
  • Merchant-related losses over the last 5 years
  • One row per loss event
  • Improves pricing accuracy and coverage limits

​
Merchant identity

These fields must match the corresponding values in your merchant list.
​
merchant_registration_id
string
required
The legal registration ID of the merchant, matching your merchant list.Example: "201912345H" (SG) or "5457657" (US)
​
merchant_registration_id_type
string
required
The type of registration ID based on the country where the merchant is registered.Example: "UEN" (SG) or "SOS" (US)
​
merchant_registered_country
string
required
The country where the merchant is legally registered, as a two-letter code per ISO 3166 alpha-2.Example: "SG"
​
merchant_registered_state
string
The state where the merchant headquarters are legally registered, per ISO 3166-2:US. Mandatory for US merchants, can be left blank for non-US merchants.Example: "US-NY"
​
merchant_legal_name
string
required
The merchant’s legal name as registered with the relevant government authority.Example: "ABC Trading Ltd."
​
mccs
string
required
A comma-separated list of Merchant Category Codes (MCC).Example: "5251, 5714"
​
currency
string
required
The currency in which figures are reported, as a three-letter code per ISO 4217.Example: "SGD"

​
Loss details

​
loss_start_date
date
required
The date when losses started to occur from this merchant, formatted as ISO 8601.Example: "2024-01-30"
​
total_loss_amount
integer
required
The total value of losses suffered from this merchant. Whole number, no decimals.Example: 8000000
​
prior_12_months_tpv
integer
The last 12 months of TPV processed by this merchant prior to the loss occurring. Whole number, no decimals.Example: 8000000
​
collateral_held_at_time_of_loss
integer
The total value of collateral held for risk prevention purposes at the time of the loss. Whole number, no decimals.Example: 8000000
​
loss_description
string
required
A description of the loss and any details relevant to the insurance coverage.Example: "Merchant ceased trading without fulfilling customer orders. No assets recovered."
Still compiling your loss data? Send the merchant list first and we’ll get started on indicative pricing. Note that loss history is required to finalise coverage — indicative pricing provided without it is subject to change once the full loss picture is available.