Clarification of requirements for CSV imports

Questions

There are a few details about the CSV format that are still unclear to me after reading the reference documentation:

  1. Should “Sent quantity” always include fees, if applicable, or is this only true for “Withdrawal” transactions?
  2. Should the “Fee quantity” always include fees, even when these are included in the “Sent quantity” (e.g. for “Withdrawal” transactions)?

Documentation improvements

The reference documentation could really be improved by providing a list of requirements for each column. I’ve drafted an example below based on my understanding of the requirements.

Date

  • Must be formatted “MM/DD/YYYY HH:MM:SS” (e.g. 09/30/2019 07:19:01) in UTC time.

Received fields

  • Must be reported for Receive / Deposit and Trade transactions.
  • Must be empty for Send / Withdrawal transactions.

Received Quantity

  • Must be a positive number up to 8 decimals.
  • Should exclude transaction fees (if applicable).

Received Currency

  • Must match the currency symbols available when adding manual transactions.

Sent fields

  • Must be reported for Send / Withdrawal and Trade transactions.
  • Must be blank for Receive / Deposit transactions.

Sent Quantity

  • Must be a positive number up to 8 decimals.
  • Should include transaction fees (if applicable).

Alternatively, based on the answer to the question above:

  • Must include transaction fees for Send / Withdrawal transactions (if applicable).
  • Must not include transactions fees for Trade transactions.

Sent Currency

  • Must match the currency symbols available when adding manual transactions.

Fee fields

  • May be reported for any transaction type.
  • Should be blank if no fee was charged.

Fee Quantity

  • Must be a positive number up to 8 decimals.

Fee Currency

  • Must match the currency symbols available when adding manual transactions.
1 Like