Reporting security dealing

Ben's Avatar

Ben

07 Jul, 2020 10:55 AM

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?

  1. 1 Posted by Ben on 07 Jul, 2020 12:24 PM

    Ben's Avatar

    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. 2 Posted by dwg on 07 Jul, 2020 09:52 PM

    dwg's Avatar

    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. 3 Posted by Ben on 08 Jul, 2020 09:28 PM

    Ben's Avatar

    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. 4 Posted by dwg on 08 Jul, 2020 09:52 PM

    dwg's Avatar

    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.

  5. Ben closed this discussion on 10 Jul, 2020 06:48 PM.

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