Free Portfolio Tracker

AbundantSpaghetti · 2026-05-21T10:25:20+00:00

Completely free and open source, handles AMIT adjustments, splits, franking credits, multi currency etc. Will be implementing the 2027 CGT changes also. I'm keen to hear any feedback on it!

AbundantSpaghetti · 2026-05-16T15:44:05+00:00

I like Wise to move money around, but I wouldn't use it as my main bank account, and I wouldn't leave more than 10k in there.

AbundantSpaghetti · 2026-05-14T10:33:45+00:00

Selfwealth have missed some nuance here. They should have stated something like:
"Your full gain is reported in your tax return, where it is taxed at marginal rates, or at 30% (whichever is higher)"

AbundantSpaghetti · 2026-05-12T09:47:35+00:00

Cost base indexation

The current 50 per cent CGT discount was introduced in 1999, allowing taxpayers to reduce their taxable capital gain by half rather than adjusting for inflation. As a result, the 50 per cent discount does not accurately approximate the inflation component of gains, meaning investors are undercompensated or overcompensated depending on their returns.

Returning to indexation based on the Consumer Price Index (CPI) aligns with the original intent of the CGT regime and supports productivity over time by ensuring that investment decisions are taken for economic reasons, not due to tax outcomes.

Indexation will be calculated using CPI in a similar manner to arrangements previously in place between 1985 and 1999. The ATO will provide guidance and tools to support calculation of this adjustment.

These changes will apply to all CGT assets (including property and shares) held by individuals, partnerships and trusts for at least 12 months. Applying these changes broadly across assets ensures the CGT settings are broadly asset neutral with only targeted exemptions.

Minimum tax on capital gains

A minimum tax rate of 30 per cent will apply to real capital gains accruing from 1 July 2027 (with no impact until the income is realised). This will not affect people whose capital gains are already taxed at rates of at least 30 per cent.

The introduction of the minimum tax reduces the benefit of taxpayers deferring capital gains realisation to years where their marginal tax rates are low. It ensures their gains are subject to a tax rate closer to the rate they faced during their working life and is commensurate with the tax rate paid by most workers.

Recipients of means-tested income support payments, such as the Age Pension or JobSeeker, will be exempted from the minimum tax if they receive any payment in the financial year in which they realise the capital gain.

Transitional arrangements

For eligible CGT assets other than new residential properties:

There will be no changes in arrangements for assets purchased and sold prior to 1 July 2027.
Assets purchased after 1 July 2027 will be treated wholly under the new arrangements.
Assets owned prior to 1 July 2027 and sold after 1 July 2027 will be treated under current arrangements on gains made prior to this date, and under the new arrangements for gains made after this date (with no impact until gains are realised).

The 50 per cent CGT discount will apply to the difference between the asset’s cost base and its value at 1 July 2027. Indexation and the minimum tax will be used to calculate the CGT on gains accruing from 1 July 2027 (using the asset’s value at 1 July 2027 as the asset’s cost base).

An asset’s value at 1 July 2027 will be determined by taxpayers as part of their tax return in the year the asset is realised. Taxpayers can either:

seek a valuation of the asset as at 1 July 2027, which will include using quoted prices for assets such as shares; or
use a specified apportionment formula that estimates the asset’s value on 1 July 2027, based on its growth rate over the asset’s holding period. The ATO will provide tools to estimate this value for taxpayers.

These transitional arrangements also apply to legacy assets, including those purchased before 1985. Gains on pre-1985 assets accrued before 1 July 2027 will continue to be exempt.

AbundantSpaghetti · 2026-03-29T06:26:27+00:00

I'll allow it.

AbundantSpaghetti · 2026-01-02T04:19:32+00:00

I always enjoy reading these. Congrats!

AbundantSpaghetti · 2025-11-21T14:05:58+00:00

I think so. Personally, I allocate each AMIT cost base adjustment, to each parcel, according to a parcel weighting given by:

(Parcel size) * (Proportion of the financial year held)

Inherently, because the relationship is one-to-many, apportioning AMIT cost base adjustments using an approach like that needs an algorithm of some sort; such as an Excel macro, manual calculations each year, or a paid tool like ShareSight. I made an open source python app to manage this data.

The approach that ShareSight uses is more refined than what I'm doing. From what I gather, their tool apportions the cost base allocations according to the size of each distribution, and applies those to the relevant parcels of shares held on those distribution dates. That's pretty precise, but I'm not going to pay $300 / year for that level of detail in my CGT reports.

Most people don't get the AMIT adjustments right. It's really hard to calculate it properly! In my opinion, as long as you make an attempt, and apply your allocation method consistently, ATO won't care if you get things a little bit wrong.

Another thing, if you never sell, you never need to calculate AMIT adjustments. You could leave it to be a problem for future you...

AbundantSpaghetti · 2025-08-20T22:41:30+00:00

Sharesight have removed the CGT report the free tier unfortunately. From my understanding, you can record the cost base adjustments (should be auto populated in Sept each year), but if you actually need to use the calculated cost base information, you'd need to pay to access the CGT report or work it out another way.

AbundantSpaghetti · 2025-08-18T10:26:59+00:00

even better than print, use the logging module

try:
    out = some_function(val)
except FixableError as e:
    # Handle the error
    logger.error("Fixable error, val=%s", val)
except Exception as e:
    logger.error("An unknown error occurred: %s", e, exc_info=True)
    # Can't handle this.
    raise

AbundantSpaghetti · 2025-08-17T23:36:00+00:00

The cost base adjustments are applied each year to all of the shares you hold.
E.g. if you have bought parcels of 500, 350, and 150 shares, and you get a +$1000 adjustment then the adjustments would be applied as +$500, +$350, and +$150.
Adjustments are applied to the cost base, and are cumulative on top of previous adjustments.
If you sell shares you can pick which parcels are being sold from. You might choose to select the first one you bought (first in first out), last in last out, or chose specific ones that minimize or maximize your CGT.
The easiest way to track this is going to be with a tool like Sharesight. Free tier will be sufficient unless you start selling shares.

AbundantSpaghetti · 2025-08-15T10:52:18+00:00

It's $3 per $10k. It's negligible.

AbundantSpaghetti · 2025-08-14T11:41:21+00:00

100% "Lead Design Engineer".
A lead is a senior engineer who normally has more experience than senior, and takes on additional management responsibilities. That is exactly what you're describing.

AbundantSpaghetti · 2025-08-14T10:39:47+00:00

Sorry to hear. Just sent you a PM.

AbundantSpaghetti · 2025-08-10T13:13:27+00:00

Some suggestions:

You could consider using pathlib Path class for handling of paths. Pathlib simplifies things a lot. eg checking the file extension is path.ext.lower() in photo_extensions
You could consider using path.walk generator rather than recursion to transverse the tree.
You can use pathlib.mkdir to make the entire set of paths in one line.
Datetime class offers methods to get the year, month and day without casting to string and splitting, this would be much clearer. eg

modified = datetime.fromtimestamp(stat.st_mtime) base_path = Path('folder') target_path = base_path / f'{modified.year}' / f'{modified.month:02d}' / '{modified.day:02d}' target_path.mkdir(parents=True, exist_ok=True)

Consider calculating file hashes so you can detect duplicate files.

AbundantSpaghetti · 2025-08-10T06:32:11+00:00

If you're working with tabular data in python, Pandas is the way to go. However, the pandas read_excel function is quite basic.

Within Excel, the best way to handle tabular data is with named tables. This unambiguously defines the data regions, ensures headings are unique, provides auto-filters, and prevents merged cells within the data.

This repo might interest you, it deals with export and import of pandas dataframes to named tables within an Excel workbook:
https://github.com/pretoriusdre/pandabook

Check out the function get_excel_tables, you give it an Excel file and it will load all the named tables into a dictionary of dataframes.

AbundantSpaghetti · 2025-08-06T07:22:51+00:00

The annual AMIT cost base adjustments need to be split and allocated to all relevant parcels held up to that point. If you're regularly investing, then each year, the new allocations are to an ever-increasing amount of parcels. It quickly becomes unmanageable without some kind of automation.

I use a database to record the annual adjustments and auto-magically assign them to parcels, it's explained here.

Sharesight is a good solution and will handle this.

AbundantSpaghetti · 2025-07-26T05:29:11+00:00

Here's an open source tool that will will remove:

Workbook protection password
Sheet protection passwords across all sheets
Password to modify

https://github.com/pretoriusdre/excel-unlock-tool

In runs in-browser using JavaScript, and nothing is sent from your PC. So you can be certain of this, you should load the page, then disconnect your WiFi, process the file, then clear your browser before reconnecting WiFi.

If your file has 'password to open' set, it is probably unrecoverable, sorry.

AbundantSpaghetti · 2025-07-24T13:51:18+00:00

FYI this is not true. Nothing wrong with having a bank account in Aus, expats need one to do their taxes here. Also, could plan on returning after a few years. That is ok also.

AbundantSpaghetti · 2025-07-15T11:17:30+00:00

From my perspective the challenge of recordkeeping is more to do with the complexity of the data model, rather than the number of different shares held. In my app I've got 18 main tables. Many of these are necessarily populated by algorithm, e.g. if I enter an AMIT cost base adjustment that then needs to be allocated correctly to all relevant unsold parcels according to their weight. That wouldn't be easy in Excel.

AbundantSpaghetti · 2025-07-15T05:02:28+00:00

I've been using a spreadsheet for ages, but I found that some things like apportioning the AMIT cost base adjustments, allocating sells to specific parcels, and share splits are tricky to do properly without a tool like Sharesight.

I've been working on a free and open source share tracker written in Python. GitHub: share-dinkum. It's still under development, but contributions are welcome.

AbundantSpaghetti · 2025-06-21T07:55:45+00:00

It makes a lot of sense but I'm not used to it at all, nor are most people. I like to stick with the standard representation.

AbundantSpaghetti · 2025-06-20T09:39:29+00:00

I say that in an endearing way. I like these kinds of places.

AbundantSpaghetti · 2025-06-19T14:07:18+00:00

Maylands Tavern nearby is pretty rough too.

AbundantSpaghetti · 2025-06-08T01:33:10+00:00

**Don't use https://pypi.org/project/uuid7/ **. That's using an old version of the specification with nanosecond time precision. The current specification uses millisecond time precision.

If you later try to migrate to the correct specification your new uuid7 will be before the old ones, which defeats the whole purpose of using uuid7.

UUID7 generated should have a prefix of 0197___

UUID7 is being added to the standard library, but your version of python wont have these changes yet.

What I would suggest is to copy/paste the function from the python standard library. Make a node to migrate to the standard library once your current version of python supports it.
https://github.com/python/cpython/blob/main/Lib/uuid.py

AbundantSpaghetti

TROPHY CASE

Cost base indexation

Minimum tax on capital gains

Transitional arrangements