How to Bulk Add Transactions to Create Your Stock Portfolio

To reduce the complexity of formatting from your end, we use A.I for our system to automatically recognise the transactions from your file and format it.

Once you're in the Transactions Data Entry page,

1. Find the "Import file" button located in the upper portion of the page.
2. In the data import modal, drag and drop a CSV file or click the browse button to directly select from your files.
3. Our system will automatically import the data from your CSV file and format the data using A.I. then it will show you the Total Imported Transactions. Click "Continue to review" button to proceed.
4. Review your imported transactions then click the Save

Reminder: Some broker CSV/ Excel files may include extra titles or info rows above the actual data. Always check and remove any non-header rows before importing, your file should start with the header row followed by data only.

If you encountered an error with the CSV import, please refer to the CSV Import Troubleshooting Guide.

This is ideal for those with minimal transaction counts.

What you need to do:

1. Prepare your data and format it in a spreadsheet.
2. Copy-and-paste the data into Simply Wall St

1. Identifying Required Data Columns

After obtaining your transaction history, identify and prepare the following five columns of data:

1. Ticker/Stock Name
2. Transaction Type: Either BUY or SELL (Dividends and other transactions will be automatically generated by Simply Wall St.)
3. Transaction Date: Ensure the transaction dates match one of the accepted formats. You can change the date format in our table by clicking on the header to match the one in your transaction history.
   • Accepted date formats:

     • DD/MM/YYYY

     • MM/DD/YYYY

     • YYYY/MM/DD

4. Number of Shares: The quantity of shares purchased or sold in each transaction.
5. Price Per Share: The price at which the shares were purchased or sold.

Note: A 'Fees' column is coming soon where you can input other charges or fees associated with your buying or selling transactions.

 

---

2. Copy and Paste the Data into Simply Wall St

1. Copy Data:Select the data from your spreadsheet or source. It's efficient to select multiple values (e.g., the entire column) at once.
2. Paste Data: In Simply Wall St, paste your data into the corresponding fields.
3. Verify Tickers and Exchanges:
   • Check Tickers: Ensure that each ticker symbol matches the correct company.
   • Confirm Exchanges: Some companies are listed on multiple exchanges. Verify that you've selected the correct one for each transaction.

1. Log in to your Avanza account.
2. Navigate to My Economy from the main menu and click on Analysis to access portfolio data.
   
3. Click on My Compiled Holdings to download the report in CSV format.
   

Note: If you need additional assistance downloading your transaction report, please visit the Avanza Help Center or contact their customer support for further guidance.

 

1. Log in to your Interactive Brokers account and navigate to the Statements tab under Performance & Reports on the main page of your personal account.
2. Click on the Activity arrow sign
   
3. In the menu that appears, select a reporting period from the suggested options or choose a customized period of up to 365 days. Select the CSV format and the language for the report.
4. Click the Run button to generate the report file, which will then be available for download.
5. Ensure you upload reports from your first transaction date. If you have invested for more than a year, upload all reports chronologically from oldest to newest to maintain data accuracy.

Note: If you need additional assistance downloading your transaction report, please visit the Interactive Brokers (IBKR) Help Center or contact their customer support for further guidance.

 

1. Log into your Webull account using the Webull app or website.
2. Navigate to the History section to access your past transactions.
3. Click on the Filter option to customize your search parameters.
4. Select Custom and choose a date range that includes all your transactions. Make sure to cover the entire period you need for the report. Once the date range is selected, click Done. 
5. Hit the Download button to save the report to your device. 

Tips: 

• • To ensure full coverage, double-check that the selected date range includes all relevant transactions, especially if you've been trading for an extended period.
  • If you need more than 365 days of data, download multiple reports with consecutive date ranges to avoid missing any transactions.

Note: If you need additional assistance downloading your transaction report, please contact their customer support at customerservices@webull.us for further guidance.

 

On the Web Platform

1. Log in to your Trading212 account on the web app.
2. Click on your email address displayed at the top right corner of the screen to open the account menu.
3. Navigate to the History section, where you can view your past transactions.
4. After selecting the desired options, confirm your request. The report might take some time to process, and you will receive a notification once the file is ready to download.

5. The report will be exported as a CSV file, which is best viewed in spreadsheet applications such as Google Sheets, Microsoft Excel, or Apple Numbers

On the Mobile App

1. Open the Trading212 mobile app and navigate to the History section of your ISA or Invest Account.
2. The Export option is located at the top right corner of the screen. This feature is not available for CFD accounts.
3. Select the time frame for the report. Trading212 allows exporting up to 1 calendar year per report.
4. If you need data covering more than one year, download the reports in separate files, each representing one calendar year. For example, for a 2-year transaction history, export two files, each covering a single year.
5. Similar to the web app, you can control the type of data included in the export by adjusting the settings under Included data.
6. Click on the Export CSV button. Once your request is submitted, you might need to wait until the export is processed. You will receive a notification when the CSV file is ready for download.

Note: If you need additional assistance downloading your transaction report, please visit the Trading212 Help Center or contact their customer support for further guidance.

 

1. Log in to your eToro account and navigate to the Settings section, which is located in the left menu.
2. Click on Account to access your account settings and documents.
3. Scroll down to the Documents section and locate the Account Statement area. Click the View button to proceed.
4. Select the time frame for the report you want to export. Once the date range is set, click the Create button to generate the report.
5. Once the report is ready, you can export it in XLS format by clicking the XLS button in the top right corner of the screen.

Note: If you need additional assistance downloading your transaction report, please visit the eToro Help Center or contact their customer support for further guidance.

 

1. Log in to your Fidelity account using the website or mobile app.
2. Navigate to the Activity & Orders section to access your transaction history.
3. The default view shows the Past 30 days. Click on this dropdown and select Custom to set a specific date range.
4. Specify the From Date and To Date, with a maximum range of 366 days. Ensure the selected period includes all transactions you need for the report.
5. Make sure to download statements starting from your first transaction date. If you have invested for more than one year, download separate reports for each year and organize them chronologically from oldest to newest.
6. Click the download icon in the upper right corner of the screen. Select the option to Download as CSV.
7. Specify a file name and save the report to your computer or device.

Note: If you need additional assistance downloading your transaction report, please contact Fidelity's customer support for further guidance.

 

1. Log in to your Interactive Investor account using the brokerage website.
2. Click on the Main Portfolio menu to access your portfolio overview.
3. Select Transaction History from the menu to view all your past transactions.
4. Choose the Time Period for the report. If you are creating a new portfolio, select the maximum time range to ensure all relevant transactions are included.
5. Click on the Download icon to export the report. 

Note: If you need additional assistance downloading your transaction report, please visit the Interactive Investor Help Center or contact their customer support for further guidance.

 

All clients of TD Ameritrade, Inc. are now Schwab clients. You may refer to Schwab's Common Questions regarding this. 

1. Sign in to your Charles Schwab account using the website or mobile app.
2. Navigate to your trading account to access detailed account information.
3. Open the Account dropdown menu at the top of the screen.
4. Select History from the dropdown menu to view your past transactions. For former TD Ameritrade accounts, you can access up to four years of transaction history
5.  If you have multiple accounts, select your specific Brokerage Account and apply a Date Range filter to narrow down the transactions you want to download.
6. Click on the Export button located at the top-right corner of the page. 

Note: If you need additional assistance downloading your transaction report, please visit the Charles Schwab Help Center or contact their customer support for further guidance.

 

1. Log in to your Degiro account using the web or mobile platform.
2. Navigate to the Inbox located on the left sidebar menu.
3. Select Transactions to view your complete trading history.
4. Set the Start Date to your first transaction date and the End Date to the present day. This ensures you capture all relevant transactions in your report.
5. Click on Export, then select the CSV format to download the report. 

Note: If you need additional assistance downloading your transaction report, please visit the Degiro Help Center or contact their customer support for further guidance.

 

1. Log in to your Questrade account using the web or mobile platform.
2. Go to the Accounts menu item. 
3. Select Account Activity from the menu to view all your transactions.
4. Choose the appropriate Date Range to ensure all relevant transactions are included. 
5. Click on the Download button and select the Excel format to export your transactions report. 

Note: If you need additional assistance downloading your transaction report, please visit the Questrade Help Center or contact their customer support at support@questrade.com for further guidance.

 

On the Web Platform

1. Log in to your Sharesies account. Sign in with the same email address and password you use for the mobile app.
2. Open the ☰ at the top left corner of the screen.
3. Click on Account to access your account settings.
4. Under the Portfolio and Investments heading, click Generate Reports.
5. Set the report time period by selecting the From and To month and year.
6. Choose the Transaction Report CSV as the report type.
7. Click the Export Report button. The report generation may take a moment depending on the selected date range and the volume of transactions.
8. The file download preview will load in a new tab window, allowing you to download the report directly to your computer.

 

On the Mobile App (iOS Mobile Devices)

1. Log in to the Sharesies app using your credentials.
2. Tap the Account icon to access your account settings.
3. Under the Portfolio and Investments heading, tap Generate Reports.
4. Select the time period you want the report to cover by setting the From and To month and year.
5. Choose the report type as Transaction Report CSV.
6. Tap the Export Report button. Depending on the amount of data, it might take a moment to generate the file and load the preview.
7. Once the report is ready, tap the share icon in the top right corner.
8. Select Save to Files to save a copy of the report to your device.

Note: If you need additional assistance downloading your transaction report, please visit the Sharesies Help Center or contact their customer support for further guidance.

 

1. Log in to your Sharesight account.
2. Click on the Reports tab
3. Scroll and find the All Trades report tile.
4. Click Run Report button to continue.
5. Using the dropdown calendar, set the date range you would like to run the report for.
6. You have 3 file options to export the report but to import to Simply Wall St you can either use the Open in Google Drive or Download as XLSX .
7. Convert to CSV file format.
   1. 1. If you have chosen to Open in Google Drive, from your google spreadsheet, Click on File > Download > select Comma Separated Values (.csv)
      2. If you downloaded as XLSX file, from your spreadsheet app, Click on File > Save As > on the File Type click on it and select CSV > click Save button. 

 

1. Log in to your Commsec account. 
2. Go to the Confirmation page under the Trading tab.
3. Select the account you wish to import using the dropdown menu.
4. Set your desired date range and click Search.
5. Click the Download CSV link to export the data.

Note: If you need additional assistance downloading your transaction report, please visit the Commsec Help Center or contact their customer support for further guidance.

 

1. Log in to your Stake account. 
2. Go to the Profile page and choose Tax and documents.
3. Choose the date range and download the report. These reports are available for viewing and downloading in PDF or Excel (CSV) format and cover all of your transactions, orders, and more. Please ensure you download the report in CSV format, as this is the required file type for upload. 

Note: If you need additional assistance downloading your transaction report, please visit the Stake Help Center or contact their customer support for further guidance.

 

1. Open the Revolut app and go to the Stocks section.
2. Tap the three dots located next to the Invest and + Add money tabs.
3. From the dropdown menu, select Statements.
4. Choose Account Statement to access your transaction history.
5. Select the Excel tab, choose the desired time period, and then click the Get statement button to download your report.

Note: If you need additional assistance downloading your transaction report, please visit the Revolut Help Center or contact their customer support for further guidance.

 

1. Open the Freetrade app on your device.
2. Navigate to the Activity tab to access your Activity Feed.
3. Locate the download button (an upward-pointing arrow) in the top-right corner of the screen.
4. Confirm by selecting All Activity to export the full report.
5. Once the file is ready, export it to your device for further analysis.

Note: The exported CSV file includes all activity from your Activity Feed, which may contain non-transactional events as well. If you need additional assistance downloading your transaction report, please visit the Freetrade Help Center or contact their customer support for further guidance.

 

1. Download and install the Tastytrade Desktop Platform.
2. Open the platform and sign in to your account.
3. Click the History symbol on the left column to access your account history.
4. In the History tab, navigate to the top right corner of the screen. If needed, filter the report by date range to include specific transactions.
5. Click on the CSV button to download your statement.

Note: If you need additional assistance downloading your transaction report, please visit the Tastytrade Help Center or contact their customer support for further guidance.

 

1. Log in to the XTB using your account credentials.
2. Navigate to the Account History section and click on the Closed Positions tab to view your past transactions.
3. Press the Export button to open the download options.
4. Select the required Date range, ensuring that you include all transactions from your first trade date if you are creating a new portfolio.
5. Select the Excel file format for easy data analysis.
6. Click the Export Report button to download your transaction history.

Note: If you need additional assistance downloading your transaction report, please visit the XTB Help Center or contact their customer support for further guidance.

 

1. Log in to the Nordnet website.
2. Navigate to the Transactions tab to access your trading history.
3. Select the Required Date Range, ensuring that you include all transactions from your first trade date if you are setting up a new portfolio.
4. Click on the Export CSV button to download the transaction report.

Note: Note: If you need additional assistance downloading your transaction report, please visit the XTB Help Center or contact their customer support for further guidance.

 

1. Log in to your SaxoTraderGO account.
2. Navigate to the Transactions tab to access your trade history.
3. Select the ALL tab to ensure all transaction types are included in the report.
4. Click on the Export button to download the transaction data.

Note: If you need additional assistance downloading your transaction report, please visit the SaxoTraderGO Help Center or contact their customer support for further guidance.

 

1. Sign in to your Exante account.
2. Navigate to Account and then Reports on your dashboard.
3. Click on Create a Custom Report to generate a new report.
4. Set the date range for the Transactions and Financial Transactions sections to ensure all relevant data is included.
5. At the top of the report settings, select CSV as the file format.
6. Click Save and Send to generate the report.
7. The report will appear in the list of reports at the bottom of the Account → Reports page. It is usually available within a minute, but in some cases, it may take longer.
8. Once the report is ready, download it directly from the list.

Note: If you need additional assistance downloading your transaction report, please visit the Exante Help Center or contact their customer support for further guidance.

 

1. Go to E*TRADE and log in to your account.
2. Once logged in, go to the main menu and click on the “Transactions” tab. This section provides a detailed history of your trading and account activity.
3. In the Transactions tab, look toward the top right corner of the page. Click on the Download icon to open the download options.

4. From the dropdown options, Select “Microsoft Excel” (CSV) as your preferred file format and choose your desired date range for the transaction history you want to export.

5. After selecting the format and date range, click the “Download” button.

Note: If you need additional assistance downloading your transaction report, please visit the E*TRADE Help Center or contact their customer support for further guidance.

 

1. Go to Disnat and log in to your account.
2. Once logged in, you will be redirected to the main page listing all your accounts.
3. Open the account from which you want to download the statement history by clicking on the “+” next to the account name.
4. Click on the third box labeled History to access your past transactions.
5. Choose the desired period for your report (e.g., 3 months, 6 months, or a custom period).

Note: If you need additional assistance downloading your transaction report, please visit the Disnat Help Center or contact their customer support for further guidance.

 

1. Log in to your Firstrade account.
2. Once logged in, navigate to the main menu and click on “Accounts”. From the dropdown, select “Tax Center”.
3. On the Tax Center page, scroll down until you see the “Download Account Information” section.
4. Choose “Excel CSV Files” as your preferred format and select the specific account (if you have multiple) and the date range you wish to download.
5. Once all selections are made, click on the “Download” button. Your file will be generated and saved to your device in CSV format.

Note: If you need additional assistance downloading your transaction report, please visit the Firstrade Help Center or contact their customer support for further guidance.

 

1. Log in to your Nabtrade account.
2. Once you’re logged in, go to the top navigation menu and select “Trading”. From the dropdown list, click on “Confirmations”.
3. Use the filters to set a custom date range that covers the full period of transactions you want to review. Make sure the range includes all relevant trades. 
4.  Display and review your transactions.
5. Click on the “Download” button to export the transaction list.

Note: If you need additional assistance downloading your transaction report, please visit the Nabtrade Help Center or contact their customer support for further guidance.

 

1. Log in to your Robinhood account.
2. From the main menu, select “Account” and go to “Reports and Statements”. 
3. Under the “Customize Your Report” section, select your account and choose your desired date range. Make sure it includes all the activity you want to capture.
4. Once your selections are made, click the “Generate Report” button. The system will begin creating your custom CSV file.
5. Once the report is ready, you’ll see an option to “Download CSV”. Click it to save the file to your device.

Note: If you need additional assistance downloading your transaction report, please visit the Robinhood Help Center or contact their customer support for further guidance.

 

1. Log in to your Vanguard account.
2. Navigate to My Accounts > Transaction History.
3. Click the Download button located at the top right.
4. Choose a Spreadsheet-compatible CSV file, select your desired date range, and pick the portfolios you want to include.
5. Once the report is ready, you’ll see an option to “Download CSV”. Click it to save the file to your device.

Note: If you need additional assistance downloading your transaction report, please visit the Vanguard Help Center or contact their customer support for further guidance.

 

1. Log in to your Wealthsimple account.
2. Click your Profile icon in the top-right corner.
3. Select Settings from the dropdown menu and choose Accounts from the sidebar options.
4. Select the specific account you want to access. 
5. Click on Account Documents and use the Date Range filter to set the period you want to download transactions for.
6. Click the Download CSV button to export the statement in CSV format.

Note: If you need additional assistance downloading your transaction report, please visit the Wealthsimple Help Center or contact their customer support for further guidance.

 

1. Log in to your Zerodha account.
2. Go to the top menu and click on Reports > Tradebook.
3. Choose the Segment from the dropdown menu and select the desired Date Range for your report.
4. Click the "→" (arrow) button to generate the trade report.
5. Once the report loads, click Download XLSX to export the file.

Note: If you need additional assistance downloading your transaction report, please visit the Zerodha Help Center or contact their customer support for further guidance.

These 5 common formatting errors can cause the import tool to fail or misinterpret your data:

• Extra non-data rows (e.g., report titles, footnotes, or blank rows above your actual data).
• Missing or mislabeled headers- your file must start with a valid header row like:
  Date, Symbol, Quantity, Price, Transaction Type. 
• Special characters in number fields, such as quotation marks (") or dollar signs ($) in price or amount columns.
• Merged cells, inconsistent spacing, hidden columns, or non-standard date formats.
• Empty or misaligned columns that shift the structure of your data.

How to fix it? 

• Remove all non-data rows above the header (your data should start at Row 1 with column titles)
• Make sure headers are clearly labeled and consistently formatted
• Delete any special characters from numeric fields - numbers should be plain (e.g., 2500.00, not "$2,500")
• Ensure all columns are consistently filled, aligned, and unmerged.
• Standardize date formats to something simple like YYYY-MM-DD or MM/DD/YYYY.

If the file doesn’t clearly indicate Buy or Sell actions, the import tool can’t tell what kind of trades were made.

How to fix it? 
Ensure your file has a dedicated Transaction Type column with clear entries like "Buy" or "Sell". This helps the system understand each transaction correctly.

Issue: Some users notice duplicate transactions (e.g., dividends)

How to fix it? 
Only add Buy & Sell transactions. Dividends, stock splits, and other corporate events will be automatically recognised and accounted for. 

Sometimes the system fails to match certain companies or assets. This usually happens due to:

• Unclear or missing identifiers (e.g., no ticker symbol, vague names).
• Mismatch between file data and internal database.

How to fix it? 

Include specific identifiers like ticker symbols. Please see the sample below: