Use the spreadsheet importer to add transaction history from a bank account, brokerage cash account, savings account, term deposit or another account used to hold investment cash.
Before You Begin
You must create a Cash Account in your portfolio before you can import transactions into it.
The Cash Account’s currency applies to every transaction imported into that account. If you hold cash in multiple currencies, create a separate Cash Account for each currency.
If you haven’t created the account yet, see Adding a Cash Account.
Open the Cash Account
To open an existing Cash Account:
Open Portfolio.
Select the Cash Account from your holdings list.
You can also find and open the account using the search bar at the top of Navexa.
Start the Import
The import option appears differently depending on whether the Cash Account already contains transactions.
Account With Transactions
If the Cash Account already contains transactions:
Select + Add Transaction.
In the Add transactions window, select Import Transactions.
Upload Your Spreadsheet
After starting the import:
Upload your CSV or Excel spreadsheet.
Wait while Navexa analyses the file.
Review the transactions Navexa identifies.
For the best results, use a spreadsheet containing only transactions for that Cash Account.
If the file also contains investment trades, Navexa may process it as a trade import instead of importing the cash transactions.
Review the Transactions
Review every detected transaction before completing the import.
Navexa will attempt to recognise each transaction’s:
Date
Description
Amount
Transaction type
Select any field to change it or correct an error.
For example, if Navexa identifies an interest payment as a Deposit, change the transaction type to Interest Payment before completing the import.
Resolve any errors shown on the review screen before continuing.
Supported Transaction Types
Navexa can import the following Cash Account transaction types:
Deposit: Money added to the Cash Account.
Withdrawal: Money removed from the Cash Account.
Interest Payment: Interest received.
Interest Charged: Interest paid or charged to the account.
Fee: A non-interest account or transaction fee.
Choose the type that best represents each cash movement. The transaction type can affect how the amount is treated in your portfolio reporting.
Complete the Import
Once you’ve checked the transactions:
Complete the import.
Return to the Cash Account.
Review the imported transactions.
Check that the resulting balance is correct.
If the balance isn’t what you expected, check for:
Missing transactions
Incorrect amounts
Duplicate entries
Transactions assigned to the wrong type
A missing opening balance
For opening-balance guidance, see Adding a Cash Account.
Avoid Duplicates
Navexa can automatically create Cash Account transactions for eligible investment trades and income.
Before importing a spreadsheet, check whether automation has already recorded any of the same cash movements. Importing them again may create duplicates and distort your cash balance and portfolio performance.