Reporting security dealing
I'd like to run a report showing the dates and values of all dealing (Buy, Sell, BuyXfr and SellXfr). I'd like it to be a single report that covered several investment accounts and I'd happily settle for all, but right now I can't figure out how to do it for even a single account. The closest I can get is to run an Investment perforamnce report, giving total buys and sales for each account and security in the selected period. What am I missing?
Comments are currently closed for this discussion. You can start a new one.
Keyboard shortcuts
Generic
| ? | 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
1 Posted by Ben on Jul 07, 2020 @ 12:24 PM
I think I may have found part of the answer: avoid using BuyXfr and SellXfr. If I break them into separate transactions, values appear in the Investment Transactions report, and I can then subtotal by Action.
I'm already splitting DivXfr into Div and Xfr for similar reasons so I should have thought of this!
2 Posted by dwg on Jul 07, 2020 @ 09:52 PM
I'm a fellow user.
It seems the combination transactions (i.e. those transactions that combine two transactions into one) do not appear to work in the same way as if you do individual transaction. While the amounts work out correctly it appears there are issues on the reporting side.
In general the Investment reports need work in Moneydance.
Because of the way share sales and purchases work here I have always entered them as individual transaction so have not encountered this particular problem.
3 Posted by Ben on Jul 08, 2020 @ 09:28 PM
Yes, it does seem you're wise to use individual transactions. I've changed all mine for this year, including DivReinvest, and at last I have a clear Investment Transactions report. I don't think I'l go frther back, though - it's slow work!
4 Posted by dwg on Jul 08, 2020 @ 09:52 PM
I was fortunate in a way. With the way buys and sells work here settlement is 3 days after the transaction so I was always in the habit of separating out the transfer as its own transaction. I'd reflect the buy/sell when it happened and the transfer of funds when it happened.
With Dividend reinvestment it is usual here for a price to be set and the number of shares you can purchase depending on how many you can buy for the amount of the dividend with often any remaining balance kept until the next dividend, so again I was in the habit of recording the dividend and then recording a buy.
Ben closed this discussion on Jul 10, 2020 @ 06:48 PM.