Importing CommSec CSVs into Crowdfolio Step-by-Step

Introduction to CommSec CSV Imports in Crowdfolio

For Australian DIY investors using CommSec as their primary broker, managing capital gains tax (CGT) forecasting and portfolio rebalancing can feel disconnected from your actual trading. CommSec holds your transaction history, but that data lives in isolation—until you bring it into a dedicated portfolio tracker like Crowdfolio, which specializes in tax-aware portfolio management for ASX investors. This tutorial also explains the CommSec CSV import process in step-by-step detail so you know exactly what to export and upload.

This tutorial walks you through the complete process of importing your CommSec portfolio data into Crowdfolio using CSV files. Unlike brokers that require direct API connections, Crowdfolio’s privacy-first approach lets you export your transaction history from CommSec and upload it manually, giving you full control over your data. The CommSec CSV import approach works seamlessly whether you’re managing a small portfolio of a few ETFs or a complex mix of individual ASX-listed stocks. Whether you’re performing a one-off CommSec CSV import or planning regular updates, this guide covers the exact steps you need.

By the end of this guide, you’ll understand how to export holdings and transaction history from CommSec, prepare your CSV files for import, and configure Crowdfolio to track your portfolio with full parcel-level detail—enabling you to forecast CGT outcomes before you rebalance, rather than discovering tax surprises at tax time. A correct CommSec CSV import ensures parcel-level cost base is preserved so Crowdfolio can deliver accurate CGT forecasts.

Why Import CommSec Data into Crowdfolio?

CommSec is one of Australia’s largest and most user-friendly share brokers, offering low-cost trading for ASX stocks and ETFs. However, CommSec’s native portfolio tools focus on holdings and performance, not on tax planning. When you need to understand the tax impact of selling a parcel—whether you should use FIFO (first-in-first-out), LIFO (last-in-first-out), specific lot selection, or highest-cost-first methods—CommSec doesn’t provide that forecasting capability. A CommSec CSV import lets Crowdfolio calculate parcel-level CGT outcomes so you can see the tax impact of a proposed trade before you execute it.

This is where Crowdfolio’s unique value proposition emerges. Crowdfolio is built specifically for Australian tax-aware investing. It puts the tax cost inside your trading decision by showing you parcel-level outcomes before you trade. When you import your CommSec data, Crowdfolio can:

Forecast CGT liability for any proposed sale, showing the tax outcome under each method it compares (minimise-tax, FIFO, LIFO and highest-cost-first).
Flag wash-sale and Part IVA risks so you understand compliance implications before rebalancing.
Enable tax-loss harvesting by identifying losses across your portfolio that can offset gains.
Track portfolio drift against your target allocation and suggest rebalancing with tax impact visible upfront.
Generate accountant-ready reports that you can export and share with your tax agent without requiring your broker login credentials.

Unlike tools that require direct broker API connections, Crowdfolio’s CSV import approach prioritizes privacy and security. You control what data you share; no third-party integrations access your broker account. The CommSec CSV import preserves granular trade details (dates, quantities, fees) which are critical for accurate CGT accounting.

Prerequisites and Setup Requirements

Before you begin importing CommSec data into Crowdfolio, ensure you have the following in place:

Crowdfolio Account

You’ll need an active Crowdfolio account. If you haven’t already signed up, visit the Crowdfolio website and create an account using your email address. The account setup is free and takes just a few minutes. Crowdfolio supports Australian DIY investors managing ASX portfolios, so you can begin using the platform immediately. When preparing for a CommSec CSV import, make sure your Crowdfolio account settings (financial year and default lot selection) reflect your preferences.

CommSec Account Access

You must have active access to your CommSec account with permission to view and download your transaction history and holdings. This typically requires logging into CommSec’s website (not the mobile app, as the export features are web-based) using your CommSec username and password. For a smooth CommSec CSV import, perform exports via the web interface where CSV options are available.

Data Files You’ll Need

You’ll export two main CSV files from CommSec:

Holdings Summary: A snapshot of your current positions, showing the number of shares/units held in each security.
Transaction History: A complete record of all trades (buys, sells, dividends, corporate actions) with dates, quantities, prices, and costs.

Both files are available from CommSec’s portfolio section. As detailed in CommSec’s official help article on downloading holdings summaries, these exports are straightforward to generate. Both files are required for a complete CommSec CSV import so Crowdfolio can reconcile current holdings with historical transactions.

System Requirements

A modern web browser (Chrome, Firefox, Safari, or Edge).
A spreadsheet application (Excel, Google Sheets, or similar) to review CSV files before uploading (optional but recommended).
Approximately 10–15 minutes to complete the import process, depending on the size of your portfolio.

Completing each CommSec CSV import carefully reduces the risk of reconciliation errors later.

Step 1: Export Your CommSec Holdings Summary

The first step is to export a summary of your current holdings from CommSec. This file captures what you own right now and forms the foundation of your Crowdfolio portfolio. This holdings export is the first part of the CommSec CSV import, giving Crowdfolio the snapshot it needs to match transaction-derived positions.

Accessing CommSec’s Portfolio Section

Log in to your CommSec account at www.commsec.com.au. Once logged in, navigate to the Portfolio section. You’ll typically see this as a main menu option or under an account dashboard. CommSec displays your holdings as a list showing security name, quantity, current price, and market value.

Locating the Download Option

In the Portfolio section, look for a Download or Export button. This is usually positioned near the top right of the holdings table or within a menu icon (often represented by three horizontal lines or a gear icon). Click this button to access download options.

CommSec may offer several export formats:

CSV (Comma-Separated Values): Plain text format compatible with most spreadsheet and portfolio tracking applications.
Excel (.xlsx): Microsoft Excel format.
PDF: Printable format (not suitable for import into Crowdfolio).

Select CSV format for compatibility with Crowdfolio and for a clean CommSec CSV import.

Downloading the File

After selecting CSV, CommSec will generate the file and prompt you to save it. Choose a clear filename such as `CommSec_Holdings_[Date].csv` (for example, `CommSec_Holdings_2024-01-15.csv`). Save it to a folder on your computer where you can easily locate it later.

The CSV file will contain columns such as:

Security Code (ASX ticker symbol, e.g., VAS, CBA, A200)
Security Name
Quantity Held
Price
Market Value
Percentage of Portfolio

Once downloaded, you can open this file in a spreadsheet application to review the data. Verify that all your holdings are listed and quantities are correct. A clean holdings file makes the subsequent CommSec CSV import simpler and reduces the chance of ticker mismatches.

Step 2: Export Your CommSec Transaction History

Your transaction history is crucial for Crowdfolio to calculate cost base, track parcel details, and forecast CGT outcomes. This file includes every buy, sell, dividend, and corporate action. The transaction history completes the CommSec CSV import and supplies the detail Crowdfolio needs to reconstruct parcel-level lots.

Navigating to Transaction History

In CommSec, navigate to the Statements or History section. You may find this under Portfolio > Statements or as a separate menu item. CommSec typically labels this as Transaction History, Trade History, or Account Statements.

Selecting Your Date Range

Crowdfolio works best when you include your complete transaction history, dating back to your first purchase. However, if your account has been active for many years, you can start with the past 2–3 years and add historical data later if needed.

Select the date range:

Start Date: The earliest date you want to include (ideally your first trade or the start of the financial year).
End Date: Today’s date or the most recent trading day.

CommSec will display all transactions within this range.

Exporting the Transaction History

Look for a Download, Export, or Print button. Select CSV format. CommSec will generate a file containing your transaction history.

Save this file with a descriptive name such as `CommSec_Transactions_[Date].csv`. The file will include columns such as:

Date (transaction date)
Security Code (ASX ticker)
Security Name
Transaction Type (Buy, Sell, Dividend, Corporate Action)
Quantity
Price
Amount
Brokerage/Fees
Net Amount

As explained in the TrackMyShares help guide on importing from CommSec, this format is standard across portfolio trackers and is directly compatible with Crowdfolio’s import process. Ensuring your transaction file is complete is essential for an accurate CommSec CSV import and correct CGT forecasting.

Step 3: Review and Prepare Your CSV Files

Before uploading your CSV files to Crowdfolio, it’s wise to review them in a spreadsheet application to ensure data integrity and identify any potential issues. Spending a few extra minutes checking your files improves every CommSec CSV import outcome.

Opening Your CSV Files

Open both your Holdings and Transaction History CSV files in Excel, Google Sheets, or another spreadsheet application. This allows you to visually inspect the data and spot any anomalies.

Checking for Data Integrity

Review the following:

Holdings File:

All expected securities are listed.
Quantities are positive numbers (no negative quantities unless you hold short positions, which CommSec doesn’t typically allow for retail investors).
Ticker symbols match ASX codes (e.g., VAS, CBA, BHP).

Transaction History File:

Dates are in a consistent format (typically DD/MM/YYYY in Australia).
Transaction types are clearly labeled (Buy, Sell, Dividend, etc.).
Quantities and prices are numeric values.
Brokerage and fees are captured (important for accurate cost base calculations).

Identifying Potential Issues

Common issues to watch for:

Dividend Reinvestment Plans (DRPs): If you have DRPs enabled, CommSec may record these as separate transactions. Ensure they appear in your transaction history.
Corporate Actions: Stock splits, mergers, and capital reconstructions should appear as separate line items. Verify these are present if applicable to your portfolio.
Duplicate Entries: Occasionally, export errors can create duplicate rows. Scan for and remove any exact duplicates.
Currency Conversions: If you hold international ETFs or securities, ensure any currency conversions are correctly recorded.
Missing Fees: Some brokerages omit brokerage fees in their standard exports. If you notice fees are missing, you may need to add them manually or contact CommSec for a detailed statement.

If you find errors, contact CommSec’s support team to clarify before proceeding with the import. Addressing these issues early prevents problems during the CommSec CSV import and validation steps.

Saving Your Files

Keep both CSV files saved in their original format. Do not convert them to Excel (.xlsx) or other formats, as Crowdfolio expects standard CSV structure. Ensure filenames are descriptive and include the date so you can track which version you imported.

Step 4: Log Into Crowdfolio and Navigate to the Import Section

Now that your CSV files are ready, it’s time to upload them into Crowdfolio. Use the import wizard to start your CommSec CSV import and follow the guided prompts.

Accessing Your Crowdfolio Account

Visit Crowdfolio’s website and log in with your email and password. Once logged in, you’ll see your Crowdfolio dashboard. If this is your first time using Crowdfolio, the dashboard will be empty or show a welcome screen.

Finding the Import Feature

Look for an Import, Add Portfolio, or Upload Data button or menu option. This is typically located in a prominent position on the dashboard or within a settings menu. Crowdfolio’s interface is designed to guide new users, so the import option should be clearly visible.

Click on the import option to open the import wizard or upload dialog.

Understanding the Import Workflow

Crowdfolio’s import process typically follows these steps:

Select Import Source: choose the Generic / Other Broker template. There is no CommSec-specific template, because CommSec’s standard export is a cash ledger rather than a trade list.
Prepare the file: your export needs a row per transaction with Date, Type, Ticker, Quantity, Price and Fees. An unmodified CommSec export is rejected, so reshape it first.
Upload Transaction History File: Upload your CommSec Transaction History CSV.
Map Columns: Confirm that Crowdfolio correctly identifies each column in your CSV files.
Review and Confirm: Preview the imported data and confirm the import.

The entire process is guided, so you won’t need to manually configure complex settings. If you follow the steps exactly, the CommSec CSV import should complete without issues.

Step 5: Upload Your Holdings CSV File

The first file you’ll upload is your Holdings CSV, which gives Crowdfolio a snapshot of your current positions.

Initiating the Holdings Upload

In the import dialog, select the option to upload your Holdings file. This may be labeled as Current Holdings, Portfolio Snapshot, or Positions. Click the Choose File or Browse button and navigate to your `CommSec_Holdings_[Date].csv` file.

Select the file and click Open or Upload. Crowdfolio will begin processing the file.

Column Mapping

Once your file is uploaded, Crowdfolio will display a preview of the data and ask you to confirm column mappings. This means confirming which column represents the security ticker, which represents quantity, and so on.

Typically, Crowdfolio auto-detects these mappings based on column headers. You should see something like:

Security Code → ASX Ticker
Quantity Held → Shares/Units Held
Price → Current Price (optional)
Market Value → Total Value (optional)

Review each mapping and adjust if needed. If a column is not required for the import, you can leave it unmapped. Once you’re satisfied, click Confirm or Next.

Validation and Confirmation

Crowdfolio will validate the data to ensure all tickers are recognized and quantities are valid. If there are any errors (for example, an unrecognized ticker or invalid quantity), Crowdfolio will flag these and ask you to correct them.

Common issues and fixes:

Unrecognized Ticker: Verify the ticker symbol is correct and matches the ASX listing. For example, ensure it’s not a typo or an outdated code.
Invalid Quantity: Ensure quantities are positive numbers without text or special characters.
Missing Data: If a required field is blank, add the data or skip that row.

Once validation passes, click Confirm or Import Holdings. Crowdfolio will import your holdings into your portfolio. This holdings import is the first half of the CommSec CSV import and must reconcile with the transactions file you upload next.

Step 6: Upload Your Transaction History CSV File

With your holdings imported, the next step is to upload your complete transaction history. This is the most important file for tax forecasting, as it contains the cost base and timing of every purchase and sale. Accurate column mapping is essential for a successful CommSec CSV import and correct parcel reconstruction.

Initiating the Transaction History Upload

Return to the import section (or Crowdfolio may automatically advance to the next step). Select the option to upload your Transaction History file. Click Choose File and navigate to your `CommSec_Transactions_[Date].csv` file.

Select and upload the file. Crowdfolio will process it and display a preview.

Column Mapping for Transactions

Crowdfolio will ask you to map the columns in your transaction history file. You’ll confirm mappings such as:

Date → Transaction Date
Security Code → ASX Ticker
Transaction Type → Type (Buy, Sell, Dividend, etc.)
Quantity → Number of Shares/Units
Price → Price per Share/Unit
Amount → Total Amount or Net Amount
Brokerage/Fees → Commission and Fees

If your CommSec export includes these columns with clear headers, Crowdfolio should auto-detect them. Review and adjust as needed.

Handling Different Transaction Types

CommSec’s transaction history includes various transaction types:

Buy: Purchase of shares or units.
Sell: Sale of shares or units.
Dividend: Cash dividend payment.
Dividend Reinvestment: Dividend automatically reinvested as additional shares (DRPs).
Corporate Action: Stock splits, mergers, or capital reconstructions.
Interest: Interest earned (less common for equity portfolios).

Crowdfolio handles all these types. Ensure your mappings correctly identify each type. If CommSec uses different labels (for example, “Dividend Payment” instead of “Dividend”), adjust the mapping accordingly. Proper labeling ensures the CommSec CSV import correctly classifies each transaction.

Validation and Error Handling

Crowdfolio will validate the transaction data. Common issues include:

Mismatched Dates: Ensure dates are in a recognized format (typically DD/MM/YYYY for Australian exports).
Ticker Mismatches: If a ticker in the transaction history doesn’t match one in the holdings file, Crowdfolio will flag it. This is usually a typo; correct it.
Negative Quantities or Prices: These should only appear for short sales (rare for retail investors) or corrections. Review and confirm these are intentional.
Missing Brokerage: If brokerage fees are missing, note that this will affect cost-basis calculations. You may need to add these manually or contact CommSec for a detailed statement.

As detailed in the Navexa guide on importing CommSec trades, handling these validation steps carefully ensures accurate tax calculations downstream. Once validation passes, click Confirm or Import Transactions. Crowdfolio will import your complete transaction history and complete the CommSec CSV import process.

Step 7: Review Your Imported Portfolio in Crowdfolio

After importing both files, Crowdfolio will process and reconcile the data. You should now see your portfolio populated with all your holdings and transaction history. Reviewing the results confirms your CommSec CSV import succeeded.

Accessing Your Portfolio Dashboard

Navigate to your Crowdfolio portfolio dashboard. You should see:

Holdings List: All your ASX securities listed with current quantity, cost base, and current value.
Portfolio Summary: Total portfolio value, total cost base, and unrealized gains/losses.
Transaction History: A chronological list of all your trades, dividends, and corporate actions.

Verifying Data Accuracy

Spend a few moments verifying that your data is accurate:

Holdings Match: Compare the holdings displayed in Crowdfolio with your current CommSec portfolio. Quantities and tickers should match exactly.
Transaction Count: Verify that the number of transactions imported matches the number in your CommSec export. If counts differ, some transactions may have been filtered or rejected.
Cost Base: Review the cost base shown for a few holdings. This should match the average purchase price you’d expect based on your trades.
Unrealized Gains/Losses: Check that unrealized gains/losses are calculated correctly. Crowdfolio uses current market prices (updated daily) to calculate these.

If you notice discrepancies, review the transaction history in detail or contact Crowdfolio support for assistance. Good verification after a CommSec CSV import helps avoid tax surprises later.

Exploring Crowdfolio’s Tax Features

Now that your portfolio is imported, you can begin using Crowdfolio’s core tax-forecasting features:

CGT Forecast: Select a holding and simulate a sale to see the tax outcome under different lot-selection methods (FIFO, LIFO, specific, highest-cost-first). This shows you the tax cost before you trade.
Tax-Loss Harvesting: Identify holdings with unrealized losses and explore opportunities to harvest these losses to offset gains.
Wash-Sale and Part IVA Checks: Crowdfolio flags potential wash-sale violations and Part IVA risks based on your transaction history and proposed trades.
Portfolio Rebalancing: Use Crowdfolio’s rebalancing tool to adjust your allocation toward your target weights, with full tax impact visibility.
Accountant-Ready Reports: Generate reports that you can export and share with your tax agent, showing all transactions, gains/losses, and tax forecasts.

As explained on Crowdfolio’s main website, these features put the tax cost inside your trading decision, helping you make more tax-efficient investment choices. After each CommSec CSV import, try a few simulated sales to confirm tax calculations meet your expectations.

Step 8: Ongoing Data Updates and Maintenance

Your initial import captures your portfolio as of a specific date. To keep Crowdfolio current, you’ll need to periodically import new transactions. Regular CommSec CSV import cadence keeps your tax forecasts accurate.

Regular Update Schedule

Depending on your trading frequency, consider updating your Crowdfolio data:

Weekly: If you trade frequently or rebalance often.
Monthly: A good cadence for most DIY investors.
Quarterly: Sufficient if you trade infrequently.
Before Tax Time: Essential to ensure your tax forecasts are current before the end of the financial year.

Incremental Imports

Each time you import, export a new transaction history file from CommSec covering the period since your last import. Crowdfolio can handle incremental imports; it will add new transactions without duplicating existing ones (provided the dates and details match).

Alternatively, you can export your complete transaction history each time and re-import the entire file. Crowdfolio’s system is designed to reconcile and avoid duplicates. Choose the approach that best fits your workflow for CommSec CSV import frequency.

Updating Holdings

You can also periodically re-import your holdings file to ensure Crowdfolio has your current quantities. This is useful if you want to verify that Crowdfolio’s calculated holdings (based on transaction history) match your actual CommSec holdings.

Troubleshooting Common Import Issues

If you encounter problems during the import process, refer to this troubleshooting guide. Troubleshooting CommSec CSV import issues is covered below so you can resolve common errors quickly.

Issue: “File Format Not Recognized”

Cause: The file may be corrupted, saved in the wrong format, or have an incorrect file extension.

Solution:

Verify the file is saved as `.csv` (not `.xlsx` or `.txt`).
Re-export the file from CommSec and try again.
If the issue persists, open the CSV in a text editor to check for unusual characters or formatting.

Issue: “Ticker Not Found” or “Unrecognized Security”

Cause: The ASX ticker in your CSV may be misspelled, outdated, or not recognized by Crowdfolio’s database.

Solution:

Verify the ticker matches the current ASX listing. For example, ensure it’s not an old code for a company that has changed its ticker.
Check the ASX website (asx.com.au) to confirm the correct ticker.
If the ticker is correct, contact Crowdfolio support; the security may need to be added to their database.

Issue: “Quantity Mismatch” Between Holdings and Transactions

Cause: The imported transaction history doesn’t reconcile with the holdings file. This could indicate missing transactions, data entry errors, or corporate actions that weren’t properly recorded.

Solution:

Review your CommSec account to ensure all transactions are included in your export (check date range).
Look for corporate actions (stock splits, mergers) that may have affected quantities. Ensure these are captured in your transaction history.
If quantities still don’t match, contact CommSec support to request a detailed statement and reconciliation.
As a last resort, you can manually adjust quantities in Crowdfolio (if the platform allows) or contact Crowdfolio support for assistance.

Issue: “Import Takes Too Long” or “Times Out”

Cause: Large files or slow internet connections can cause timeouts. CommSec exports for accounts with many years of history can be large.

Solution:

Try uploading during off-peak hours when Crowdfolio’s servers may be less congested.
If your transaction history is very large (thousands of transactions), consider splitting it into multiple files by year and importing separately.
Check your internet connection speed and stability.
Clear your browser cache and try again.

Issue: “Brokerage Fees Not Imported”

Cause: CommSec’s standard CSV export may omit brokerage fees, or they may be in a separate column that wasn’t mapped.

Solution:

Review your CommSec CSV file in a spreadsheet to check if a brokerage or fees column exists.
If it exists, ensure it was correctly mapped during import.
If it’s missing, contact CommSec to request a detailed export that includes brokerage fees.
You can manually add fees to specific transactions in Crowdfolio if needed (check if the platform supports this).

Issue: “Dividend Reinvestment Not Showing Correctly”

Cause: CommSec records DRPs as separate transactions, but they may not be clearly labeled in the export.

Solution:

Review your transaction history to identify DRP entries (usually labeled as “Dividend Reinvestment” or similar).
Ensure these are being imported and mapped correctly as “Dividend Reinvestment” transactions.
Verify that the resulting share quantity increase matches the number of shares purchased via the DRP.
If DRPs are missing, check your CommSec account settings to confirm DRPs are enabled and recorded.

Issue: “Date Format Errors”

Cause: Crowdfolio may not recognize your CSV’s date format, especially if CommSec uses DD/MM/YYYY and Crowdfolio expects MM/DD/YYYY (or vice versa).

Solution:

Check the date format in your CSV file. CommSec typically uses DD/MM/YYYY for Australian accounts.
If Crowdfolio’s import dialog asks you to specify the date format, select the appropriate option.
If the issue persists, you can manually convert dates in your CSV using a spreadsheet’s text-to-date function or contact Crowdfolio support.

Advanced Tips for Optimizing Your Import

Once you’ve successfully imported your CommSec data, consider these advanced practices to maximize Crowdfolio’s tax-forecasting capabilities.

Segmenting Your Portfolio

If you manage multiple CommSec accounts (for example, a personal account and a spouse’s account, or a general trading account and a long-term investment account), consider importing each as a separate portfolio in Crowdfolio. This allows you to:

Track tax outcomes separately for each account.
Generate separate accountant-ready reports for each account.
Analyze performance and tax efficiency by account type.

After a CommSec CSV import, splitting accounts can make reporting and tax planning much clearer.

Configuring Tax Settings

Crowdfolio allows you to configure your tax settings, including:

Financial Year: Set your financial year (1 July to 30 June for Australian investors).
Default Lot-Selection Method: Pick the method on each rebalance preview: minimise-tax, FIFO, LIFO or highest-cost-first. There is no saved default, and allows you to override it for specific sales.
Tax Rate: Input your marginal tax rate so Crowdfolio can estimate your tax liability (not just the capital gain).

These settings ensure Crowdfolio’s forecasts are tailored to your situation and make each future CommSec CSV import align with your tax preferences.

Using Crowdfolio for Rebalancing Decisions

When you’re ready to rebalance, use Crowdfolio’s rebalancing tool to:

Set Target Allocation: Define your target weights for each holding or asset class.
Simulate Rebalancing: Crowdfolio will show which holdings to buy and sell to reach your target.
Forecast Tax Impact: For each proposed sale, Crowdfolio displays the CGT liability under different lot-selection methods.
Optimize Lot Selection: Choose the most tax-efficient lot-selection method for each sale, or use Crowdfolio’s recommendations.
Review Wash-Sale and Part IVA Risks: Ensure your rebalancing doesn’t trigger compliance issues.

This approach puts the tax cost front and center in your rebalancing decision, helping you avoid costly tax surprises. After each CommSec CSV import, run a rebalance simulation to see whether tax-aware trades are materially different from tax-ignorant trades.

Documenting Your Lot Selection

When you execute a sale in CommSec, ensure you select the specific lot (if CommSec allows) that matches the lot-selection method you chose in Crowdfolio. CommSec’s interface allows you to specify which parcel to sell; use this feature to implement your tax-optimized strategy.

Document your lot selection in Crowdfolio or in a separate record so your accountant can verify your CGT calculations at tax time. Keeping this documentation consistent with each CommSec CSV import makes audits and tax reviews straightforward.

Exporting Reports for Your Accountant

Before you meet with your tax agent or accountant, export Crowdfolio’s reports. These typically include:

Capital Gains Summary: Total gains, losses, and net CGT for the financial year.
Transaction Detail: A line-by-line record of all trades, including dates, quantities, prices, and cost base.
Parcel-Level Outcomes: For each sale, the specific lot sold, cost base, sale price, and gain/loss.
Tax Forecast: Estimated CGT liability based on your chosen lot-selection method.

As noted in the PortWorth guide on exporting CommSec transaction history, having detailed, organized transaction records significantly simplifies tax preparation and reduces the risk of errors. Including the results of your CommSec CSV import in these reports makes them immediately accountant-ready.

Conclusion: Moving Forward with Tax-Aware Investing

Importing your CommSec portfolio into Crowdfolio is the first step toward tax-aware investing. By bringing your transaction history and holdings into a dedicated tax-forecasting tool, you shift from reactive tax planning (discovering CGT liability at tax time) to proactive tax optimization (understanding tax impact before you trade). A successful CommSec CSV import gives you parcel-level visibility and the ability to plan trades with tax results in mind.

The process is straightforward: export your CommSec holdings and transaction history as CSV files, upload them into Crowdfolio, map the columns, and you’re ready to start forecasting CGT outcomes, identifying tax-loss harvesting opportunities, and rebalancing with full tax visibility. Regular CommSec CSV import maintenance—weekly, monthly, or quarterly depending on your activity—keeps your forecasts accurate and your records current.

As you continue using Crowdfolio, you’ll develop a clearer understanding of how your trading decisions impact your tax liability. This knowledge empowers you to make more tax-efficient choices, keep more of your investment returns, and approach your accountant with organized, detailed records.

Regular updates to your Crowdfolio portfolio—importing new transactions from CommSec on a weekly, monthly, or quarterly basis—ensure your tax forecasts remain current and accurate. Combined with Crowdfolio’s wash-sale flagging and tax-loss harvesting reports, you have a comprehensive toolkit for managing your ASX portfolio with tax efficiency at the center of your strategy. Scheduling a recurring CommSec CSV import as part of your portfolio routine is one of the best habits to build for long-term tax efficiency.

If you encounter any issues during the import process, refer back to the troubleshooting section or contact Crowdfolio support. The platform is designed to be intuitive, but personalized assistance is available if you need it.

Happy importing, and here’s to more tax-efficient investing in 2024 and beyond.