AU Taxes 24-25 (Prep)

Written By Nomad FI

AU Taxes 24-25 (Prep)

For EFI, will use WBC 24-25 Transaction statement. Using the CSV format, we can parse the data by Date, Fund, Qty, Comm, TMV, and Contract Notes for all Buy/Sell transactions.

We’ve tested using 23-24 CSV format using parse data as test, and we’ve identified the following:

  • extracted all details from the attached file

  • using one fund for test validation, extracted all details and created structured table

  • details look good on extraction

  • validating totals failed due to hallucinations

  • testing includes Buy by date, total entries, Qty, TMV, contract note

  • test validation failed on Buy qty and tmv. needs verification against the details

  • testing includes Sell by date, total entries, Qty, TMV, contract note

  • test validation failed on Sell qty and tmv. needs verification against the details

  • once all validation is complete for one fund, AI fails to remember the details for the other funds

Notes:

  • for Prep, confirm CSV and identify funds > 10 transactions

  • filter only for that fund when uploading to AI

  • extracte all details and created structured table

  • test validation on details extracted for that fund

  • test validation on Buy totals for entries, Qty, TMV

  • Save snippet as JPG for Buy

  • test validation on Sell totals for entries, Qty, TMV

  • Save snippet as JPG for Sell

  • sort validation by date in descending order

  • Copy and paste Contract notes to Excel for that fund

Nomad FI
Previous

EK Super (AI)(Prelim Format)
Next

ETF Exposure Summary