transaction listing - ideas for improvement

[mkappa74]

When looking to transaction of a portfolio report, or of an investment, always happens that the date order is not very user friendly
I mean (sorry for my english!) that I'd like to see, for example, this order: new cash on cash investment (IN), then hew bought of XXX investment (OUT), and so on.
Instead, If in the same day I've several transaction, they appears as they're inserted or modified, so that when listing I've some IN, some OUT.
In other words, I'd like to "link" or "constrain" in cash account specific IN and OUT transaction, so that when I print it or print report, it's much more readable.

I'm not sure to have explained well ...

[Mark]

Hi mkappa74,

I think you are asking to consolidate all buys/sells of a particular security onto a single line in a report? If so, you may consider using a "Custom" report instead of the "Investment Transaction" report. In this report, you can add columns like "Purchases" and "Redemptions", and list by investment, so each line item consolidates all purchases for a single investment into a single number per line. Does this meet your needs?

[mkappa74]

Hi mkappa74,

I think you are asking to consolidate all buys/sells of a particular security onto a single line in a report? If so, you may consider using a "Custom" report instead of the "Investment Transaction" report. In this report, you can add columns like "Purchases" and "Redemptions", and list by investment, so each line item consolidates all purchases for a single investment into a single number per line. Does this meet your needs?

Not exactly ...
I'm just looking for a transaction list of cash account (end of transaction report) where I can see transaction related to same security in consequential order.
For example: on 11.02.2012 I add 10.000€ to cash account (new cash).
Then I buy 6000€ of stock X and 4000€ of Y. Regardless how I insert data, I'd like to see this report list:

11.02.12 buy CASH 10.000
11.02.12 sell CASH 6.000
11.02.12 buy X 6.000
11.02.12 sell CASH 4.000
11.02.12 buy Y 4.000

Instead, I normally have a casual situation (even if date order is correct) like this:
11.02.12 buy CASH 10.000
11.02.12 sell CASH 6.000
11.02.12 sell CASH 4.000
11.02.12 buy Y 4.000
11.02.12 buy X 6.000

or
11.02.12 sell CASH 4.000
11.02.12 buy Y 4.000
11.02.12 buy CASH 10.000
11.02.12 sell CASH 6.000
11.02.12 buy X 6.000

This is not an error, but while you are checking all trasnaction, it's a bit confusing.

[mkappa74]

It's like I need a field where manual set the order of transaction for that specific day ... 1,2,3 ...

[Mark]

Hi mkappa74,

Okay, thanks for the nice example, that makes it easy for me to understand. I do see your point, and that makes sense.

[mkappa74]

Please, work on this idea if you can in next version!