Create a Historical Cost Report

Use the Historical Cost report to review how the cost base and value of your holdings changed over a selected period.

The Historical Cost report shows holding-level cost information for the selected portfolio and period.

Use this report to review:

This can help you check how each holding moved over time and compare your recorded cost base against market value.

Use the Historical Cost report when you want to review cost and balance information across your portfolio.

It can be useful when you want to:

The Historical Cost report is different from the Capital Gains Tax report. Use the Capital Gains Tax report when you want to review realised capital gains and losses for a financial year.

To open the Historical Cost report:

The report opens for the selected portfolio.

Use the date range selector at the top of the report to choose the period you want to review.

For example, you may use All Time if you want to review historical cost information across the full portfolio history.

The report figures update based on the selected period.

Use the filters at the top of the report to narrow down the holdings shown.

You can use:

Filtering can make it easier to review a specific asset, exchange or group of holdings without exporting the full report.

The Historical Cost report shows each holding in a table.

The Holding column shows the ticker or name of the asset.

Holdings may be grouped by market, exchange or asset type, depending on the portfolio data.

The Allocation Method column shows the sale allocation method used for that holding.

This matters where a holding has multiple purchase parcels and sales. The allocation method can affect how Navexa calculates cost of sales and remaining cost balance.

The Opening Balance column shows the cost balance at the start of the selected period.

If the report period starts before the holding existed, this may show as zero.

The Purchases column shows the cost of purchases recorded during the selected period.

This is based on the trade data recorded in the portfolio.

The Cost Of Sales column shows the cost allocated to units sold during the selected period.

This helps explain how sales affected the remaining cost balance.

The Closing Balance column shows the remaining cost balance at the end of the selected period.

This is useful when reviewing the cost base that remains for holdings still owned at period end.

The Closing Market Value column shows the market value of the holding at the end of the selected period.

This lets you compare the holding’s remaining cost balance against its estimated market value.

The Closing Quantity column shows how many units remain at the end of the selected period.

Use this to check whether the remaining quantity matches your records.

The Historical Cost report includes totals for each group and for the full report.

Use the totals to check the portfolio-level movement across:

If totals look unexpected, review the individual holdings underneath. A missing trade, incorrect sale, transfer or unmatched quantity can affect the report.

Use Export to download the Historical Cost report.

The Historical Cost report exports to an Excel file only.

Exporting to Excel is useful when you want to:

Historical Cost report figures depend on the data recorded in your portfolio.

Figures may look wrong if:

Check the holding’s trades and income records if a figure does not look right.

A holding may show a closing quantity of zero if Navexa records that the holding was fully sold or no longer held at the end of the selected period.

If you still own the holding, check that all buy and sell trades have been entered correctly.

The Closing Market Value is based on available market pricing for the holding at the end of the selected period.

This may differ from your cost balance because market value reflects price movement, while cost balance reflects the recorded cost of your holding.

Remember, this is general information, not personal financial advice.