OpenFolio Documentation

What is OpenFolio?

OpenFolio is an Australian investment portfolio tracker that consolidates stocks, ETFs, crypto, superannuation, dividends, and equity grants into one dashboard. It runs Australian CGT calculations (FIFO/LIFO/MIN_GAINS), tracks franking credits, and projects dividend income — all with your real data.

First steps

Data flow

How it's calculated

Categories

Cost basis

Every BUY trade creates a tax lot. The cost basis for a holding is the sum of all lot costs for units still held. Brokerage is included in cost basis (it raises your acquisition cost, reducing your eventual taxable gain).

AUD rate for foreign trades

For US stocks, set the AUD/USD rate at time of trade. The field labelled "AUD rate" is units of foreign currency per 1 AUD. Example: if 1 AUD = 0.64 USD, enter 0.64. A $100 USD price becomes $156.25 AUD at that rate.

Portfolio cost-over-time chart

The green stepped line on the Portfolio page shows cumulative cost basis over time — it steps up on each BUY and down on each SELL (by the lot cost, not sale price). The blue line (where available) shows current market value at today's date, giving a visual P&L gap.

What is a tax lot?

Every BUY trade creates one lot: a record of quantity, cost_per_unit_aud, and acquisition_date. When you SELL, lots are consumed in a strategy-defined order to calculate your realised gain.

Disposal strategies

Worked example

Suppose you bought VAS in two tranches, then sold 80 units:

Consume Lot A first (80 of 100 units)
Cost basis: 80 × $90 = $7,200
Proceeds: 80 × $105 = $8,400
Gain: $1,200 (held 878 days → 50% discount ✓)

Consume Lot B first (50 units), then 30 from Lot A
Cost basis: 50×$95 + 30×$90 = $7,450
Proceeds: $8,400
Gain: $950 (Lot B: 442 days → no discount)

Highest cost first → Lot B ($95), then Lot A
Same as LIFO here
Gain: $950 (minimised)

CGT event

A CGT event occurs when you dispose of a CGT asset — selling shares, ETFs, or crypto. The gain (or loss) is the difference between your sale proceeds and the asset's cost base.

Formulas

How losses work

Capital losses offset capital gains in the same FY. If losses exceed gains, the surplus carries forward to future years (not shown in the current estimate — enter carried-forward losses manually). The 50% discount applies only to gains, not losses — you cannot discount a loss.

Australian financial year

The ATO FY runs 1 July → 30 June. FY2025 = 1 Jul 2024 → 30 Jun 2025. The Tax page groups all realised events by the FY in which the SELL date falls.

Franking credit formula

Australian companies pay tax at 30% before distributing dividends. If a dividend is "fully franked", the ATO allows you to claim a credit for the tax already paid — the 30/70 gross-up:

Example

Partial franking

ETF distributions often carry partial franking (e.g. 30% or 60%) because the underlying portfolio is a mix of fully-franked, unfranked, and foreign income. The import page lets you set a default; you can edit individual records afterwards.

DRP (Dividend Reinvestment Plan)

Mark a dividend as DRP to flag it as reinvested. DRP dividends still count as assessable income in the year received — you should also add a matching BUY trade at the DRP issue price.

How it works

Crypto holdings are stored as snapshots: symbol, platform, quantity, and average cost in AUD. Live prices are fetched from CoinGecko on each page load. P&L is calculated against your average cost.

Supported imports

Coinstash and Bybit CSV exports are supported. Binance support is planned.

Balance tracking

Super balances are recorded as point-in-time snapshots — date and balance per fund. The chart on the Super page plots these snapshots with selectable periods (3M / 1Y / 3Y / All). Add a new snapshot each time you check your fund statement.

Contributions

Each contribution can be categorised as:

• Employer SGC — 11.5% (FY2025) of ordinary time earnings, mandatory
• Voluntary concessional — Pre-tax contributions — count toward $30k/yr cap
• Salary sacrifice — Pre-tax, reduces assessable income
• Non-concessional — After-tax personal contributions
• Government co-contribution — Low-income earners: up to $500 government match
• FHSS — First Home Super Saver Scheme withdrawals

Grant types

Vest lifecycle

Net vest value

GEMS import

Export your grant summary from GEMS as CSV. Expected columns:

Generic Trade CSV

Dividend Spreadsheet

GEMS Grant Summary

Bank — CommBank

Bank — NAB

Bank — ANZ

Bank — Westpac