Home → Problems →

Cash flow report with incorrect/wrong amounts when including accounts with security investments

• Edit

tguny

17 Jun, 2024 04:28 PM

I have included several brokerage accounts in my cash flow report since they have a meaningful cash balance that is readily accessible. This is not the case for other investment accounts such as HSA, 529k, 401K for example so I don't include those in my CF report.
For those brokerage accounts, the CF report shows any dividend payment as income correctly. When these dividends are reinvested in full, here's what happens with the CF report.
First, the investments are displayed with the number of shares purchased and not the dollar amount, which is odd. Since the cash balance was incorrect as I ran the report for 2023, I investigated and discovered by isolating one investment in one account that the valuation for the purchases is made based on the latest value per share available in the history table of that investment. In other words, if a dividend of $1000 was paid in March 2023, and reinvested in full, but the latest price per share in the history table is $23 as of June 6, 2024, that's the number used by the report to value the expense. Depending on whether the actual purchase price in March 2023 was below or above $23 this automatically creates a difference in cash flow that should not be there. See example in file attached. This happens for all investments in all accounts included in the cash flow reports. Regardless of whther the investment comes from a dividend or an incoming cash contribution. Once again, it appears the valuation of the purchase does NOT track to the price at the time of the purchase but to the latest price available is the table. A major issue.

• Screenshot_2024-06-13_at_3.26.38 PM.png 1.11 MB

1. 1 Posted by tguny on 19 Jun, 2024 01:48 PM

   

   I forgot to mention the report behavior is the same for investment sales: the valuation is done based on the latest value stored regardless of the timing of the sale. In short, the CF report can't be trusted whenever accounts with sales and purchases of securities are included.

   • Edit

2. 2 Posted by tguny on 05 Sep, 2024 09:26 AM

   

   Closing in on 3 months...still not msg, not even acknowledging the pb

   • Edit

3. 3 Posted by Stuart Beesley ... on 05 Sep, 2024 10:12 AM

   

   following

   • Edit

4. Support Staff 4 Posted by Sean Reilly on 05 Sep, 2024 10:30 AM

   

   Hello,

   Yes, I see what you're saying. The cash flow report is using the security's price on the date of the time interval, not the date of the transaction. Ideally it would also use the actual base-currency value of the purchase amount in the report. I agree this is a bug and will try to have a fix available soon.

   Thanks,
   Sean

   --
   Sean Reilly
   Developer, The Infinite Kind
   https://infinitekind.com

   • Edit