Home → Investments →

Bank Register Balance $0 in MD 2023?

• Edit

Jens

13 May, 2023 09:25 PM

Hi,

it seems that with MD 2023, the Bank Register balance in Investment Accounts does not show the resulting
balance of the shown bank transactions anymore; it used to before. It's always $0 now.
Is that a bug or a feature?

I actually look at that once in a while for a couple of my REITs to judge my ROI;
those tend to have regular distributions some of which are reinvested, some paid back
directly, plus share and price adjustment, which makes accounting a bit tricky (to me at least).
But, if I simply looked at the Bank Register, and it went into the negative, I knew I
was getting more money out of the REIT than I put in! :-)

I know I can get those numbers by running an "Investment Performance" report,
but the Bank Register is/was just a single click away.

Jens

1. Support Staff 1 Posted by Maddy on 17 May, 2023 12:08 PM

   

   Hi Jens,
   We are sorry to hear about the problem you have encountered.

   Upgrading to the latest preview version should hopefully fix the problem for you.

   Moneydance 2023.2 build 5007 is now available to download from this page.

   I hope this information is helpful. Please let us know if you have further questions or need more assistance.

   --
   Maddy, Infinite Kind Support

   • Edit

2. 2 Posted by Jens on 20 May, 2023 12:43 AM

   

   Hi Maddy,

   unfortunately build 5007 still has that same issue.

   Jens

   • Edit

3. 3 Posted by dwg on 20 May, 2023 02:21 AM

   

   There does appear to be a behaviour change in MD 2023. I'm not sure exactly what the software is doing, that would take some more analysis, or the reasons behind it.

   • Edit

4. 4 Posted by Stuart Beesley ... on 20 May, 2023 04:59 AM

   

   Watching…

   • Edit

5. 5 Posted by Stuart Beesley ... on 20 May, 2023 06:37 AM

   

   OK, I just checked and mine does show the (cash) balance fine.. Are you sure you don't have any filters applied?

   However, I have noticed that the balance only shows upto / on the last showing txn in that Bank register... Thus if you had a Xfr dated 1/April/23 and then a Buy dated 2/April/23 then only the balance upto 1/April/23 would show.

   I personally think this register is (and always has been) useless anyway... Just use the main Investment register as that will show you your cash balance anyway..

   ??

   • Edit

6. 6 Posted by dwg on 20 May, 2023 08:15 AM

   

   I've pulled the same data set into both MD2022 and MD2023 and then pulled up the same bank register.

   There is more going on here.

   • MD2022.png 39.4 KB
   • MD2023.png 47.4 KB
   • Edit

7. 7 Posted by dwg on 20 May, 2023 08:47 AM

   

   and FWIW the balance in the Bank register has never reflected reality.

   • Edit

8. 8 Posted by dwg on 20 May, 2023 09:14 AM

   

   The two versions are including different items in the Bank register balance some items are in the bank register and I can see them being excluded from the running balance some items I can see are only in the Investment register and are being included.

   Personally I'd like to see the balance column removed from the Bank register in Investment accounts as the register can never include all transactions.

   • Edit

9. 9 Posted by Stuart Beesley ... on 20 May, 2023 09:46 AM

   

   Which one includes more txns?

   • Edit

10. 10 Posted by dwg on 20 May, 2023 09:57 AM

    

    The bank registers of both show the same transactions.

    • Edit

11. 11 Posted by dwg on 20 May, 2023 10:07 AM

    

    It looks like the bank register balance of the two versions are including/excluding different items.

    • Edit

12. 12 Posted by Jens on 20 May, 2023 01:10 PM

    

    Here's my use case, made up example. First screenshot shows the complete register as entered in MD 2022. Second the Bank Register; if you think of it as "Realized Gains of the account" it does make sense (to me anyway, multiply with -1). Once the balance crosses the $0 threshold, I got my investment back. The final balance after the final distribution and shares cancelled is my ROI.
    Last screenshot is the same "file" with MD 2023, showing the Bank Register.

    It's just a curious and unexpected change I don't see a reason for. But then, the bank register may not have any use for many others.

    • MD22_1.png 148 KB
    • MD22_2.png 153 KB
    • MD23_2.png 140 KB
    • Edit

13. System closed this discussion on 19 Aug, 2023 01:20 PM.