Home & Business 2018

  • 1
  • Problem
  • Updated 1 year ago
When looking at the report “Portfolio Value and Cost Basis”.
I find I have a share with a $0.00 value cost base but a current balance of $77.76
This share has been sold and therefore does not appear in my portfolio. My portfolio balance differs by this amount from the above report.
I have run Validate without any errors.
How can I correct the report and why is it incorrect?
Photo of MarkR


  • 514 Points 500 badge 2x thumb

Posted 1 year ago

  • 1
Photo of Jiney


  • 110 Points 100 badge 2x thumb
Can't say why it is incorrect. However, to fix it, why not go to Transaction List, Enter Transactions, scroll down to Cash transferred into account and complete. Hopefully, it will fix it.
Photo of MarkR


  • 514 Points 500 badge 2x thumb
Thanks for the reply Jiney. The problem is that I have a current value in the report for a share I no longer have. It is not in my portfolio view and this is correct. Taking money in or out of the account changes the balance of the account but not the value of the share holding in the report. What I need to trace is where the value in the report came from.
Photo of Diver Dave

Diver Dave

  • 5,884 Points 5k badge 2x thumb
Mark, I suspect there's an error in one of the entries relating to that stock.

Go back to the day before it was sold and check that the Portfolio View correctly reflects the holding at that time.  If that looks correct, delete the Sales Transaction, run Validate etc. then re-enter - check the Lots Sold to make sure it's correct.

If there's still an issue, I'd suggest running an Investment Transaction Report for that stock from the date of initial purchase.  Only include BUYS, SELLS and Capital Returns.

Finally, if you have a Linked Cash account, make sure the Investment Account balance always returns to zero after each transaction.

Hope one of those helps you identify the issue.  If not come back with a bit more detail.
Photo of Robyn Kelly (Partner)

Robyn Kelly (Partner), Accredited Partner

  • 5,062 Points 5k badge 2x thumb
Mark were you participating in DRP?  If so could be the cash balance of DRP?  Click on "Customise" to customise the "Portfolio & Cash Basis" report and click on the "Securities" tab.  Now make sure there is a tick on the "No Security (includes Cash)" box.

Hope that works?
Regards, Robyn Kelly