What should you download from SelfWealth?
A trade report exported as a CSV, covering the period since your first trade. Third-party guides describe it under your trading account's Report section in Settings, with options to include trades, set a custom period and export rows as CSV. ASX and US trades may come as separate exports. Menu names change; check SelfWealth's help centre for the current steps.
One tip from those guides: if you open the CSV in Excel before importing, Excel may rewrite the dates. Give your AI the file as downloaded.
What does Worthbase use from the file?
A SelfWealth trade report typically has one row per trade, with the date, the code, buy or sell, quantity, price and brokerage. Your AI maps those to buys and sells, with brokerage added to the cost base of a buy and taken off the proceeds of a sale. US trades are kept in US dollars, with the exchange rate for each trade's date, so your Australian dollar cost base and gains are right.
What should you ask your AI?
Here's my SelfWealth trade report (CSV) since my first trade. Add the trades to my SelfWealth account in Worthbase, with brokerage on each trade. Check the closing holdings against my SelfWealth portfolio and show me the preview before saving.
What does the preview show?
Your AI first looks up your existing SelfWealth account and holdings, searches for any new codes, and sends one batch. The preview then reads something like this (figures illustrative):
You resolve the mismatch (often a missing earlier file or a corporate action) or accept it, then confirm. If you reject the preview, nothing was written.
How do you check the import?
Give your AI your current holdings from SelfWealth (a screenshot works) and ask it to reconcile. Worthbase compares the calculated units for each code with your figures and flags any difference, as in the CSL example above.
Questions
Does Worthbase connect to SelfWealth?
No. Worthbase never asks for broker logins. You export the file and your AI reads it.
Does Worthbase work out my tax?
No. Worthbase gives the cost base and the realised gain or loss on each sale, parcel by parcel, using FIFO or the parcels you choose. It doesn't calculate tax; check that with your accountant.
What about dividends?
Add them from your dividend statements or bank statement. Your AI records them as income, so total return and annualised return include them.
SelfWealth is a trademark of its owner; Worthbase isn't affiliated with it.
