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.

  • Buy 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: You can use the bulk delete function. Simply navigate to the Trades tab, select all those you wish to delte and then click on the delete selected button.

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.

Did this answer your question?