Importing Your Transactions via CSV: A Quick Guide

Published on

Managing your investment transactions shouldn't be a hassle, especially when switching to a new platform. To make your transition as smooth as possible, our investment tracking platform supports importing transactions directly via CSV files. Whether your brokerage offers a compatible CSV format or you need to use our custom template, we’ve got you covered.

Supported Broker CSV Imports

For convenience, we support several CSV file formats from popular brokerages. If your brokerage is one of those supported, importing your transactions is as easy as uploading the CSV file they provide. We’ll automatically recognize the format and import your transactions accordingly. No manual adjustments are necessary, saving you time and effort.

To see if your brokerage is supported, check the list of compatible brokers in our Help Center. If your broker is listed, simply download the CSV file from your brokerage account, navigate to the Import page on our platform, and upload your file. We handle the rest.

Custom CSV Format for Incompatible Exports

If your brokerage's CSV format isn't currently supported, don't worry—we have a custom CSV format that allows you to quickly convert your data for easy import. By transforming your incompatible CSV exports into our standardized format, you can ensure that all of your transactions are correctly imported into our system.

Getting Started with the Custom CSV Format

To begin, download our custom CSV template from the Import page on our platform. This template outlines the specific headers and data fields that our system requires to successfully import your transactions. Here’s a quick overview of the format:

  • Date: The date of the transaction, formatted as YYYY-MM-DD.
  • Unique Transaction ID: A unique identifier for each transaction. This allows overriding existing data and prevents duplicate transactions. If your brokerage provides a transaction ID, please use it.
  • Unique Account ID: A unique identifier for the account. This allows transactions to be automatically mapped to the correct account. If your brokerage provides an account ID, please use it.
  • Transaction Type: Type of transaction, such as buy or sell.
  • Ticker: The ticker symbol for the stock, ETF, or cryptocurrency involved.
  • ISIN: The International Securities Identification Number, if applicable.
  • Quantity: Number of shares or units bought or sold.
  • Rate: The price per unit for the transaction. For cryptocurrencies, this must be in USD.
  • Total Fees: Any fees associated with the transaction.
  • Fees Currency: The currency used for the fees.
  • Account Amount: The amount paid or received in the account.
  • Account Currency: The currency of the account, e.g., USD, EUR.
  • Settlement Amount: The amount paid on the exchange.
  • Settlement Currency: The currency used for settlement on the exchange. This is also the currency in which the price is denominated. For cryptocurrencies, this must be in USD.
  • Settlement Currency Rate: If applicable, the exchange rate between the account currency and the settlement currency at the time of the transaction.

Each column must be formatted exactly as specified, with no extra columns or data. If you have an existing CSV file that you want to convert, you can copy and paste the relevant data into our template. Many users find it helpful to use a spreadsheet editor like Excel or Google Sheets to organize the data and ensure it matches our requirements.

Sample CSV File

Here is an example of a CSV file with a buy and a sell transaction:

Date,Unique Transaction ID,Unique Account ID,Transaction Type,Ticker,ISIN,Quantity,Rate,Total Fees,Fees Currency,Account Amount,Account Currency,Settlement Amount,Settlement Currency,Settlement Currency Rate
2024-01-15,TX12345,ACC789,buy,AAPL,US0378331005,10,150,5,USD,1505,USD,1500,USD,
2024-02-20,TX12346,ACC789,sell,AAPL,US0378331005,5,160,4,USD,796,USD,800,USD,

In this example:

  • The first row represents a buy of 10 shares of AAPL at a rate of $150 per share, with $5 in fees.
  • The second row represents a sell of 5 shares of AAPL at a rate of $160 per share, with $4 in fees.

Uploading Your Custom CSV File

Once your data is organized in the custom CSV format, head back to the Import page. Upload the file, and our platform will validate the format and the data. If everything checks out, your transactions will be imported and displayed in your portfolio.

If there are any issues, such as missing fields or incorrect formatting, our system will alert you and provide instructions on how to correct the file. Common errors include typos in the header names or incorrect date formatting, so double-checking these details can save you time.

Tips for a Smooth Import

  • Use Our Template: Start with our custom template to avoid format issues.
  • Check Headers: Ensure all column headers match our requirements exactly.
  • Validate Your Data: Double-check that all necessary fields are filled in and that dates and numbers are formatted properly.
  • Partial Imports: You can import transactions in parts if you find it more manageable.

Need Help?

We’re here to make this process as smooth as possible. If you’re having trouble with CSV imports or if your brokerage isn’t supported, reach out to our support team, and we’ll be happy to assist.

By using our CSV import feature, you can quickly bring all of your historical transactions into one place, making it easier than ever to keep track of your investments and make informed decisions. Happy tracking!