Import from CSV

Profit supports importing transactions from CSV files; including the accounts and instruments those transactions reference. The CSV file needs to be formatted as follows:

• Delimiter must be either comma (,) or semicolon (;)
• Decimal numbers must be formatted as per your macOS language settings

Example

Date,Account,Destination Account,Type,Instrument Name,Instrument Type,Ticker Symbol,Quantity,Amount,Currency,Fees,Fees Currency,Taxes,Taxes Currency,Converted,Converted Currency
2020-09-17 10:00,My Account,,DEPOSIT,,,,,33000,USD,,,,,,
2020-09-18 08:41,My Account,,BUY,Apple,SECURITY,AAPL,100,10600,USD,1,USD,0,USD,,
2020-12-11 14:21,My Account,,BUY,NVIDIA,SECURITY,NVDA,100,13000,USD,1.20,USD,,,,
2021-01-22 11:02,My Account,,SELL,Apple,SECURITY,AAPL,10,1390,USD,1,USD,,,,
2021-02-20 15:14,My Account,,WITHDRAWAL,,,,,1000,USD,,,,,,

Columns

The CSV file supports these columns. Not all of them are required. Which are required and which are optional depends on the transaction the row describes.

Date

The date of the transaction. Always required. Supported date formats:

• YYYY-MM-DD HH:MM
• YYYY-MM-DD

Account

The name of the account the transaction belongs to. Always required.

Destination Account

The name of the destination account for transfer transactions. Required for transactions of type:

• TRANSFER
• TRANSFER IN

Type

The type of the transaction. Always required. Supported transaction types:

• BUY
• SELL
• TRANSFER
• TRANSFER IN
• TRANSFER OUT
• DEPOSIT
• WITHDRAWAL
• DIVIDEND
• CONVERSION
• TAX
• INTEREST

Instrument Type

The type of the instrument the transaction references. Supported instrument types:

• SECURITY
• OPTION
• CRYPTO CURRENCY

Required for transactions of type:

• BUY
• SELL
• TRANSFER
• TRANSFER IN
• TRANSFER OUT
• DIVIDEND

Instrument Name

The name of the instrument the transaction references. Optional and only applicable to transactions that require Instrument Type. The instrument name is considered in instrument lookup if lookup by ticker symbol does not yield any result.

Ticker Symbol

The ticker symbol of the instrument. Optional and only applicable to transactions that require Instrument Type. The ticker symbol is considered first when looking up an instrument.

Quantity

The transaction quantity as a decimal number. Required for transactions of type:

• BUY
• SELL
• TRANSFER
• TRANSFER IN
• TRANSFER OUT

Amount

The amount of the transaction as a decimal number. Required for transactions of type:

• BUY
• SELL
• DEPOSIT
• WITHDRAWAL
• DIVIDEND
• CONVERSION
• TAX
• INTEREST
• TRANSFER IN

Currency

The ISO currency code for the value in the Amount column. Required if Amount is present.

Fees

The amount of transaction fees as a decimal number. Leave empty if there are no fees. Only relevant for transactions of type:

• BUY
• SELL
• CONVERSION

Fees Currency

The ISO currency code for the value in the Fees column. Required if Fees is present.

Taxes

The amount of taxes for the transaction as a decimal number. Leave empty if there are no taxes associated with the transaction. Only relevant for transactions of type:

• BUY
• SELL
• DIVIDEND
• INTEREST

Taxes Currency

The ISO currency code for the value in the Taxes column. Required if Taxes is present.

Converted

The value of the converted amount as a decimal number. Required for transactions of type CONVERSION.

Converted Currency

The ISO currency code for the value in the Converted column. Required if Converted is present.