How to correct a small discrepancy in initial share balance in investment account.

andy's Avatar


27 May, 2023 12:47 PM

My MD records start at 12/31/2020 and for one of my investment accounts the 'Initial Balance' for one security is off by ~2 shares. I can trace the error to a transaction that occurred (in my brokerage records) on 12/20/2020 which did not get included in my 'Initial Balance'.

I've ignored this error for over 2 years so its not urgent - but it would tidy up my cross-checks with the brokerage account if fixed.

I cannot adjust the 'Initial Balance' in the Account Register for this security (or I haven't figured out how).

I cannot introduce a transaction because that causes my cash balance to then be off.

My intention is to simply adjust the share balance (with zero cost) as if it were an initial share balance.

Thanks for your time.

  1. 1 Posted by andy on 27 May, 2023 12:54 PM

    andy's Avatar

    My workaround is to introduce a zero-cost buy transaction (on 1/1/2021 in this case) to adjust the share balance.

    Again, ideally I want to adjust the 'Initial Balance' but am unable to do so.

  2. 2 Posted by Stuart Beesley ... on 27 May, 2023 07:34 PM

    Stuart Beesley (Mr Toolbox)'s Avatar

    The only way is to perform a dummy buy txn of some sort - the way you did this is one such way.

  3. 3 Posted by Dan Hanger on 28 May, 2023 02:53 PM

    Dan Hanger's Avatar

    I've had to perform this correction on occasion as well, my solution has been to correct the number of shares, leave the total cost correct to agree with the brokerage statement, and let the per share cost adjust to compensate. Of course this will cause a slight discrepancy in the overall performance of the security but if the number of shares is substantial enough this error can be insignificant.

  4. andy closed this discussion on 03 Jul, 2023 11:56 AM.

Comments are currently closed for this discussion. You can start a new one.

Keyboard shortcuts


? Show this help
ESC Blurs the current field

Comment Form

r Focus the comment reply box
^ + ↩ Submit the comment

You can use Command ⌘ instead of Control ^ on Mac