Exporting CSV data from new Cash Ledger (Stock V2)

Let's Get Started from the Securities (Equity + ETF) and Tangible Assets

Moderator: Renato

adamlylegallagher
New User
Posts: 14
Joined: Wed Nov 08, 2017 1:31 am
Are you a spam bot?: No

Exporting CSV data from new Cash Ledger (Stock V2)

Post by adamlylegallagher »

I think this may be a small bug, I spent the entire day moving all my share transactions, transfers, stock purchases, dividend income into the new Stock V2 account so now all of my transactions are in the Cash Ledger.

First, I went to export them to a CSV by picking File -> Export As -> MMEX CSV format but when I do that, I don't see the accounts as an option to select. The 3 accounts listed under the Stock Portfolios that contain my "Cash Ledger" data are not listed as options to export.

However I found a work around, if I right click on the "Cash Ledger" and pick Export As "CSV" then I can export the Cash Ledger transactions which is what I really need for my accounting macros in excel. I then have to stitch the 3 CSV files together but that isn't a big deal.

But I just noticed that the Status Column is blank in the exported CSV and I do need to see which transactions are R (Reconciled) or blank (Unreconciled) please see the screenshot below when you can see transactions from back in 2022 which are definitely marked R in MMEx are showing blank in the Export CSV data.
Untitled.jpg
Untitled.jpg (72.46 KiB) Viewed 17 times
adamlylegallagher
New User
Posts: 14
Joined: Wed Nov 08, 2017 1:31 am
Are you a spam bot?: No

Re: Exporting CSV data from new Cash Ledger (Stock V2)

Post by adamlylegallagher »

Also, my life would be way easier if I could just Export the Cash Ledger transactions the same way I export all my other accounts.

When I pick "File" -> "Export As" -> "MMEx CSV File..." I can't pick the 3 accounts that I have under Stock Portfolios which have Cash Ledgers. Is this something that will get fixed in newer versions of MMEx? Or is there a reason it is too complicated or isn't possible because of the way Stocks V2 works?

I'm using MMEx 1.9.2-Beta.1

Thanks.
adamlylegallagher
New User
Posts: 14
Joined: Wed Nov 08, 2017 1:31 am
Are you a spam bot?: No

Re: Exporting CSV data from new Cash Ledger (Stock V2)

Post by adamlylegallagher »

I've spent the last 4 days moving all my transactions into the cash ledger so that stocks V2 will work properly. I think I understand stocks V2 now and I was able to delete all my old "share accounts"

Stocks V2 makes way more sense to me, I transfer the funds to my stock portfolio, then I buy and sell inside the stock portfolio and insert those transactions in the cash ledger. The cash ledger shows me a cash balance which is exactly what I have in cash in my broker accounts. All is good.

I hope the bugs can get worked out and you don't change stocks V2 again. I like it as is.now that I've migrated all my old data into it.

Thanks!

Who is online

Users browsing this forum: Claude [Bot] and 0 guests