Is there a report or way to export to excel or csv the register for an investment account that will show a daily cash balance?
Nope, just the "transaction by transaction" balance that's shown by printing the account register.
But I suppose that you could export that report to a CSV file and import into Excel.
If all you want to see is the cash balance by day, go to Reports > Net Worth & Balances > Net worth
Select the date range you want and set the interval to Daily
Click on the gear to customize
Select the account you want
On the Securities tab, select No Security (includes cash) and money market funds if you want to include them
Click on OK to display the report
To export, click on the icon to the right of the printer.
Hello @jtgostars,
We haven't heard back from you in a while. Do you still need assistance? Were you able to give the suggestions from our SuperUsers above a try?
Check back and let us know! Thank you.
Hello again,
Checking in once more before this thread is closed. Let us know if you still need assistance.
Thank you!
Due to the lack of response, I went ahead and closed this post.
If you still require assistance, please feel free to start a new post.