Thinking this through, if a business has bought shares in company A on five occasions and company B on 10 occasions, entering this in Manager requires
- Creating 5 Manager investments for investment A and 10 for investment B
- Each time the unrealised gains in Manager for the investments are updated, 15 entries are required not 2.
- When shares are sold, the user manually select what combination of lots are actually sold
- Displaying the total shares value and quantity for investment A and investment B probably requires a separate control accounts for At cost, unrealised capital change, unrealised profit, realised profit. Custom searches may help also.
Maybe I’m wrong but that approach looks less efficient than using a spreadsheet with all prior share parcel purchases & what has been sold. Then when selling shares re-enter the sold shares purchase price in the receipt with the remainder allocated to a profit realised gain account.
Manager’s current Investment function would be dramatically improved it it just allowed the user to set custom accounts for
- at cost (Balance sheet)
- Accumulated revaluation (unrealised Balance sheet account)
- Unrealised investment Gain/loss (unrealised profit / loss account)
- (in the future a custom “Realised investment Gain/loss” profit / loss account would also be required if Manager directly supported calculation of realised gains)
Of course in an ideal world Manager would treat sale of investment shares in an equivalent manner to a receipt for a sales invoice. The old share purchase lot acts similar to a sales invoice when selling the share. Allowing default automatic allocation or manual lot selection as per a business requirements.