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
Navigate to the Holdings Tank.
Select the Trades tab and click the Import button to open the import pop-up.
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
Drag and drop your CSV file into the upload area or select it manually.
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.
Troubleshooting Common Errors
Error 1: Invalid CSV Format
Confirm the file is saved in CSV format.
Ensure all required fields are included, labeled correctly, and in the correct format.
Error 2: Incorrect Ticker
If TaxTank doesn’t recognise a ticker, the error message will identify the issue.
Correct the ticker name in your CSV file and re-import.