Skip to main content

How to bulk import shares trades from any platform

Learn how to import shares and crypto trades in bulk in Holdings Tank to calculate your current holding balances and any Capital Gains Tax.

Updated this week

Managing your share trades in TaxTank is quick and efficient with the bulk import feature. Here's how you can easily import your buy and sell share trades from any platform into the Holdings Tank using a CSV file.

Step 1: Access the Import Function

  1. Navigate to the Holdings Tank.

  2. Select the Trades tab and click the Import button to open the import pop-up.

  3. From the top menu, select Shares as the asset type.

Step 2: Select Ownership Type

  • Held in my name: Use this option if the assets are owned by you personally (default).

  • Held in other: Use this option for assets held in a trust, company, or SMSF to ensure these trades are excluded from your Tax Summary.

Step 3: Prepare Your CSV File

TaxTank calculates your current holdings balances and any CGT from the imported trades. To ensure accuracy:

  • Import your complete trade history or start from a zero balance at the beginning of a financial year.

  • Use the required fields format to prepare your CSV file, or download TaxTank’s template for guidance.

Required Fields for CSV

Ensure your CSV includes the following fields in the top row:

  • Type: buy or sell.

  • Ticker: The stock symbol for the asset.

  • Price: The price paid per unit of the asset (in AUD).

  • Quantity: The number of units bought or sold.

  • Fee: Transaction fees paid (in AUD).

  • Date of Trade: The date of the trade (format: DD/MM/YYYY).

Step 4: Import the CSV File

  1. Drag and drop your CSV file into the upload area or select it manually.

  2. Click Import Bulk to finalize the process.

Note: Ensure all values, including Buy Price and Fees, are in Australian dollars (AUD). After importing, you can also attach supporting documents to individual trades for added documentation.

FAQs

Q: Can I import CSV files from any platform?
A: No, all imports must use the TaxTank CSV template. This ensures your data is correctly formatted and avoids errors during import.

Q: How can I delete a bulk import?

A: Yes, you have 2 options. You can use the bulk delete function. Simply navigate to the Trades tab, select all those you wish to delete and then click on the delete selected button. Or alternatively, select the Import History icon on the Trades tab to remove csv files.

Q: What should I do if I get an "Invalid CSV Format" error?
A: Make sure your file is saved as a CSV. Check that all required fields are included, correctly labeled, and in the correct format.

Q: What if TaxTank doesn’t recognise a ticker?
A: The error message will tell you which ticker is unrecognised. Update the ticker name in your CSV file and re-import.

Q: Why won’t my shares CSV import?

A: The most common reason a bulk trade import fails is that the file is not using the TaxTank CSV template format. Unlike bank transaction imports, holdings imports must follow the exact template structure.

Before uploading, please check the following:

CSV import checklist

  1. Use the TaxTank template only

    All bulk imports must use the TaxTank CSV template.

    Even if your broker exports a CSV, it usually contains extra columns or different header names that won’t import correctly.

    The easiest option is to copy your data into the TaxTank template before uploading.

  2. The first row must match these exact headers

    Your top row should include:

    • type

    • ticker

    • price

    • quantity

    • fee

    • date of trade

    These fields must be correctly labelled.

  3. Remove extra columns

    Delete any columns not included in the template, such as:

    • exchange

    • order ID

    • settlement date

    • currency

    • market

    • notes

    • account number

    • wallet address

    • broker reference

    Extra columns can cause the import to fail.

  4. Remove blank rows and summary rows

    Delete any blank lines, subtotal rows, or summary sections before uploading.

  5. Check date formatting

    Dates must be consistent and in the required format:

    DD/MM/YYYY

    For example:

    07/04/2026

  6. Check trade type values

    The type column must only contain:

    • buy

    • sell

    No other values such as:

    • purchase

    • sold

    • deposit

    • withdrawal

    • transfer

  7. All values must be in AUD

    Price and fee amounts must be in Australian dollars (AUD).

    If your broker exports in USD or another currency, convert the values before importing.

Did this answer your question?