Importing from a CSV file
You can import transactions from a CSV file. Each row in the CSV file describes a transaction.
Download a template file to get started. As column delimiter, both comma
and semicolon are supported. Decimal numbers are parsed as per your system language and region settings.
Examples
Importing a buy or sell transaction
| Date | Account | Type | Amount | Currency | Instrument Name | Instrument Type | Quantity |
|---|
| 2024-03-05 12:30 | My Account | BUY | 1000.00 | EUR | Apple | SECURITY | 10 |
For sell transactions, use SELL as type. Both transactions can optionally have fees and taxes.
Importing a dividend transaction
| Date | Account | Type | Amount | Currency | Instrument Name | Instrument Type |
|---|
| 2024-03-05 12:30 | My Account | DIVIDEND | 100.00 | EUR | Apple | SECURITY |
Dividend transactions can optionally specify taxes.
Importing an interest transaction
| Date | Account | Type | Amount | Currency |
|---|
| 2024-03-05 12:30 | My Account | INTEREST | 10.00 | EUR |
Interest transactions can optionally specify taxes.
Importing a tax transaction
| Date | Account | Type | Amount | Currency |
|---|
| 2024-03-05 12:30 | My Account | TAX | 100.00 | EUR |
Importing a fee transaction
| Date | Account | Type | Amount | Currency |
|---|
| 2024-03-05 12:30 | My Account | FEE | 10.00 | EUR |
Fee transactions can optionally specify taxes.
Importing a conversion transaction
| Date | Account | Type | Amount | Currency | Converted | Converted Currency |
|---|
| 2024-03-05 12:30 | My Account | CONVERSION | 100.00 | EUR | 111.03 | USD |
Conversion transactions can optionally specify taxes.
Importing an incoming transfer transaction
| Date | Account | Type | Quantity | Amount | Currency | Instrument Name | Instrument Type |
|---|
| 2024-03-05 12:30 | My Account | TRANSFER IN | 10 | 100.00 | EUR | Apple | SECURITY |
Importing an outgoing transfer transaction
| Date | Account | Type | Quantity | Currency | Instrument Name | Instrument Type |
|---|
| 2024-03-05 12:30 | My Account | TRANSFER OUT | 10 | EUR | Apple | SECURITY |
Importing an internal transfer transaction
| Date | Account | Destination Account | Type | Quantity | Currency | Instrument Name | Instrument Type |
|---|
| 2024-03-05 12:30 | My Account | My Other Account | TRANSFER | 10 | EUR | Apple | SECURITY |
Importing a deposit or withdrawal transaction
| Date | Account | Type | Amount | Currency |
|---|
| 2024-03-05 12:30 | My Account | DEPOSIT | 1000.00 | EUR |
For a withdrawal, use type WITHDRAWAL.
Specifying transaction fees
Specifying transaction taxes
| Taxes | Taxes Currency |
|---|
| 12.67 | USD |
Specifying a security
| Instrument Name | Instrument Type | Ticker Symbol | ISIN |
|---|
| Apple | SECURITY | AAPL | US0378331005 |
Ticker symbol and ISIN are optional, but it’s encouraged to provide at least one of them.
Specifying an option
| Instrument Name | Instrument Type | Ticker Symbol |
|---|
| AAPL Dec 19 '25 100 Call | OPTION | AAPL251219C00100000 |
Specifying a cryptocurrency
| Instrument Name | Instrument Type | Ticker Symbol |
|---|
| Bitcoin | CRYPTOCURRENCY | BTC |
Reference
Columns
| Name | Description |
|---|
Date | Date and optional time of the transaction (YYYY-MM-DD or YYYY-MM-DD HH:MM) |
Account | Name of the account the transaction belongs to |
Destination Account | Name of the destination account for an incoming transfer transaction |
Type | Type of the transaction (see list of transaction types below) |
Instrument Name | Name of the instrument |
Instrument Type | Type of the instrument (see list of instrument types below) |
ISIN | ISIN of the instrument |
Ticker Symbol | Ticker symbol for the instrument |
Quantity | Amount of shares (supports decimal numbers) |
Amount | Transaction amount |
Currency | Currency code for the transactio amount |
Fees | Fees amount (decimal number) |
Fees Currency | Currency code for fees |
Taxes | Taxes amount (decimal number) |
Taxes Currency | Currency code for taxes |
Converted | Converted amount for conversion transactions (decimal number) |
Converted Currency | Currency code for the converted amount |
Reference | Optional transaction reference |
Note | Optional transaction note |
Instrument types
| Type | Description |
|---|
SECURITY | Security |
OPTION | Option |
CRYPTOCURRENCY | Cryptocurrency |
Transaction types
| Type | Description |
|---|
BUY | Buy transaction |
SELL | Sell transaction |
DIVIDEND | Dividend transaction |
CONVERSION | Conversion transaction |
INTEREST | Interest transaction |
TRANSFER | Transfer transaction |
TRANSFER IN | Transfer In transaction |
TRANSFER OUT | Transfer out transaction |
TAX | Tax transaction |
FEE | Fee transaction |
DEPOSIT | Deposit transaction |
WITHDRAWAL | Withdrawal transaction |
Currency codes
Profit uses ISO 4217 currency codes.
| Code | Currency |
|---|
EUR | Euro |
USD | US Dollar |
JPY | Japanese Yen |
BGN | Bulgarian Lev |
CZK | Czech Koruna |
DKK | Danish Krone |
GBP | British Pound Sterling |
GBX | Penny Sterling (GBX) |
HUF | Hungarian Forint |
PLN | Polish Złoty |
RON | Romanian Leu |
SEK | Swedish Krona |
CHF | Swiss Franc |
ISK | Icelandic Króna |
NOK | Norwegian Krone |
HRK | Croatian Kuna |
TRY | Turkish Lira |
AUD | Australian Dollar |
BRL | Brazilian Real |
CAD | Canadian Dollar |
CNY | Chinese Yuan (Renminbi) |
HKD | Hong Kong Dollar |
IDR | Indonesian Rupiah |
ILS | Israeli New Shekel |
INR | Indian Rupee |
KRW | South Korean Won |
MXN | Mexican Peso |
MYR | Malaysian Ringgit |
NZD | New Zealand Dollar |
PHP | Philippine Peso |
SGD | Singapore Dollar |
THB | Thai Baht |
ZAR | South African Rand |
TWD | New Taiwan Dollar |
VND | Vietnamese Đồng |
SAR | Saudi Riyal |
AED | UAE Dirham |
QAR | Qatari Riyal |
If you need further assistance, have any questions, need to report an issue, or would like to request a feature, don’t hesitate to contact us—by email or on X at @codefreeze.
