Importing Custom Investments from a Spreadsheet (property, bonds, art & more)

Use this guide to import unsupported or unlisted assets into Navexa using a spreadsheet, then update prices and income manually after the investment has been added.

Custom investments are used for assets Navexa does not support with a live price feed, such as property, bonds, art, private company shares, unlisted equity, and other manually priced assets.

Custom investments are tracked using Navexa’s buy, sell, income, and manual price update workflow. For a full explanation of how custom investments work, see What is a Custom Investment in Navexa?

Before uploading a spreadsheet, make sure the file only includes the investment transactions you want to import.

For best results, remove:

Income such as rent, coupons, interest, or private company dividends should usually be added manually after the custom investment has been created.

For the most reliable format, click Start from a template inside the importer and download the Unlisted template.

Templates are downloaded from inside Navexa rather than attached to this article. This keeps the latest templates in one place and helps ensure you are always using the current version.

Use the Unlisted template when you want to import custom investments such as property, bonds, art, private shares, or other unsupported assets.

If you use the Unlisted template, keep the column names unchanged.

The key fields are:

Use the date format YYYY-MM-DD where possible, such as 2026-07-03.

The Symbol field should be a clear name or code for the custom investment.

Examples:

Use something you will recognise later in your portfolio, reports, and transactions.

The Price and Quantity fields depend on the type of custom investment.

For property, art, and similar one-off assets:

For private company shares:

For bonds:

Example:

If you buy a bond with a face value of 50,000 and a clean capital value of 53,158.50, the price is:

53,158.50 ÷ 50,000 = 1.06317

The template values would be:

Use Fee for costs directly connected to the trade.

Examples include:

For bonds using the clean price method, you can also use the Fee field on the buy trade to record accrued interest paid at purchase.

For non-AUD custom investments, include the currency and exchange rate.

Use:

For example, if 1 USD equals AUD $1.50, enter 1.50 as the exchange rate.

Use the exchange rate that applies to the transaction date where possible.

To import your custom investment spreadsheet:

Navexa supports .csv, .xlsx, and .xls files.

After you upload your file, Navexa will analyse it and show a review screen with the extracted transactions.

Before importing, check:

Use Only show errors to find rows that need attention.

Once the review screen looks correct, click Import Trades.

When the import is complete, click View transactions to review the imported transactions on the Transactions page.

Custom investment income is usually added manually after the holding has been created.

Use this for income such as rental income, bond coupons, interest payments, private company dividends, royalties, or other recurring income from the asset.

To add income, open the custom investment holding, go to the Income tab, and add the income payment from there.

For detailed steps, see Add a Dividend Or Income Payment To A Custom Investment.

For property rent, the income is usually entered as unfranked income. For private company dividends, use the franked or unfranked fields based on the dividend statement. For bonds, record coupon or interest payments as income.

Custom investments do not have a live price feed, so their market value does not update automatically.

Your imported buy and sell transactions are managed in the holding’s Trades tab. Manual valuations are managed separately in the Prices tab.

This means editing or importing a trade will not automatically update the holding’s manual price history. To update the investment’s current value, open the custom investment holding and add or edit a price from the Prices tab.

For detailed steps, see Add a Custom Investment.

Use these examples to structure common custom investment types in the Unlisted template.

For an investment property purchase:

For a sale:

For bonds, choose a clean price method or dirty price method.

Using the clean price method:

Using the dirty price method:

The clean price method keeps capital and interest more clearly separated. The dirty price method is simpler, but it combines accrued interest and capital movement.

For an artwork or collectible purchase:

For a sale, use the sale price and include seller commission or sale costs in Fee.

For private company shares:

For a partial sale:

The value may be wrong if the file uses a total price where Navexa expects a per-unit price.

Check that:

Custom investments do not have live price feeds in Navexa.

Use Update Price when you want the portfolio value to reflect a new valuation, appraisal, or market price.

Custom investment income is usually added manually after the holding has been created.

Use the holding’s Income tab to add rent, interest, coupons, royalties, or private dividends.

Import errors usually mean Navexa needs more information before the row can be imported.

Check for:

Use Only show errors to find and fix the affected rows.

For the best custom investment import result:

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