Issue
For a Custom Holding Account which has not been setup for investment purpose, the cost always equals to the Market Value. Why does this Custom Holding Account show different values for Cost and Market Value on Investments > Browse Holding Accounts?
Cause
There a three scenarios which can cause this issue:
Scenario 1: A Market Value different from Cost has been added in previous financial year
Scenario 2: Custom Holding Account is broken - first year fund
Scenario 3: Custom Holding Account is broken - not a first year fund
Resolution
A Market Value different from Cost has been added in previous financial year
Add a new valuation at every year end.
Instructions for manually updating the security price can be found in our knowledge article, How to update the security price in Class to match Yahoo Finance or ASX?.
Custom Holding Account is broken - first year fund
- Establish a new Custom Holding Account and use the same account setting as the previous Custom Holding Account
- Move all current year's transactions (e.g. any cash in or cash out) from the old Custom Holding Account to the new Custom Holding Account
- If it is a first year fund:
Navigate to Fund Level > Fund > Load Opening Balances
- Remove the Book Cost & Market Value recorded in the broken Custom Holding Account
- Enter the Market Value and Cost in the new Custom Holding Account
- Click on Submit
Custom Holding Account is broken - not a first year fund
- Establish a new Custom Holding Account and use the same account setting as the previous Custom Holding Account
- Move all current year's transactions (e.g. any cash in or cash out) from the old Custom Holding Account to the new Custom Holding Account
- Process a cash out on the 1st of July for the full balance in the broken Custom Holding Account
- Process a corresponding cash in transaction on the 1st of July in the new created Custom Holding Account.
Navigate to Fund Level > Transactions > Match Transactions
- Match the cash out from the broken Custom Holding Account with the cash in to the new Custom Holding Account
Navigate to Fund Level > Investments > Browse Holding Accounts
- Click on the ellipsis after the broken Custom Holding Account
- Click on "+Add" and update the security issue price to "0" (zero)
- Choose any Price Type or terminating/ continuing price ensuring the price is updated to "0". The effective date can be 30 June of the current financial year or the date you would like to suspend the broken Custom Holding Account in the current financial year
Navigate to Fund Level > Investments > Browse Holding Accounts
- Tick the box "show zero balance"
- Click on the broken Custom Holding Account
- Edit
- Suspend