Thank you for hanging with me on this.
First, I do not understand why a security is considered a sub-account of the investment account. It is simply a security being held in the investment account. Fortunately, I read in the manual a way to “use” securities that have already been defined in other accounts. A very cumbersome cluge to be sure and not user friendly or an obvious operation. You have to know the secret from reading the user manual. But, it probably saved me hours on entry work.
Securities should be a Global item. If there are different classes of the security, then each would have to be defined, but each is a specific asset (not a sub-account) that could be referenced by any Investment Account in KMyMoney. This is a key concept of relational databases that has been around since at least 1990. Dbase was not considered a relational database, but you could make it one by how you initialized it and used it.
Now my example of a problem:
After creating the Investment account for the Estate, I did an “Add shares” transaction of 500 Shares for General Motors. Then 4 “Remove Shares” transactions were done to divide the 500 shares into Inheritor’s Investment accounts. A remove for 250 shares, a remove of 83.334 shares, a remove of 83.333 shares, a remove of 83.333 shares.
I ran a report for “Investment Holdings by Account”. I turned off all the checkboxes by going to configure>Account and pressing the None button. Then I selected just the parent Estate Account checkbox. I verified that the date range covered the 5 transactions (1 Add, 4 Remove). Also, the other filters were set to All Amounts, All Categories, All Tags, All Payees, and in Details: All Types, All States, and Any transaction. I click Apply and I get a report with 4 headings (Account, Shares 3-decimal places, Price, Amount). There are only 4 line entries, not 5, for General Motors. Under Shares (-83.334, -83.333, +250, -83.333). The price and amount in USD are given to 2 decimal places. There is no “Share Balance” column. Also, the Add shares of 500 is not reported at all. That Add transaction was within the date range of the report. It was in the previous month statement and had been manually reconciled. The 4 Remove transaction are within a single month and that month has been manually reconciled.
Again, the running “Share Balance” is what is important in a report. Every other software I have used shows the resulting Share Balance that is current after the transaction is applied. The Price and Amount columns are of no use to me because they do not even show a running Amount Balance.
You could quickly and easily setup an investment account and enter 1 Add and 4 Remove transactions and see this in action.
The ledger is just as bad as the report because there is NO running Share Balance column after each transaction. The numbers I see in the Balance column are positive and negative values of the transaction Quantity and not a Running Share Balance. It is not clear why some are positive and some are negative when all the transactions in this month’s statement are “Remove transactions”. The negative numbers in the balance column make it look like the share balance in the Estate Account for a specific security is in the negative!
These problems make it basically impossible to use KMyMoney for Investment Accounts. It only seems to handle Bank Accounts (Checking, and Savings).