nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Creating a share report

acs2

Is it possible to create a Share activity report for Investments? I'd like to be able to choose a security and create an activity report where I can view the share details of each action transaction and show an associated balance when sorted by date.

Find more posts tagged with

Investment Reports

Accepted answers

All comments

Jim_Harman

The closest report to that would be the Investment Transaction report with just one account and security selected. That has all the transactions for a given time period and a column for the number of shares and the cash amount of each transaction, but not running balances.

If you export the report to Excel and add the starting balances, I think you could produce the report you want.

q_lurker

"Share details of each action transaction". If that means for a sale transaction you want to know from what lot the sold shares were taken, that data only shows through a Capital Gains report.

acs2

I'm not in need of knowing the lot. I would like an easy way to track share activity. An example report would show shares traded in one column and balance in the next with filters available. If it's an account with multiple securities one could subtotal by security. Or one could customize to show one or more securities in an account. If the same security is in more than one account the sort would be by account and date sequence for that security within an account.

An important feature is a running balance column

mshiggins

@acs2

Are you wanting the share balance, the share $ balance, or both?

Jim_Harman

If the dollar value will do, you could use the Investing>Portfolio Value and Cost Basis report customized to include date range, the account(s) and security(s) you want.

If you need the share counts, you could use the Investment Transaction report as described above, or for just one security you could start on the Security Detail page and click on the Security button to get a transaction report for just that security. You can select the columns you want to see and subtotal the report by account if you want.

If you set the starting date before the first purchase, you don't need the opening share balance.

Export the report to Excel and compute the running balance based on the Shares column.

mshiggins

@acs2

From the recently released version 70.20 release notes:

IMPROVED Added the ability to filter and search investment register transactions by action type, date range, security, amount, and memo.

Perhaps this improvement will give you the info you are looking for.

Jim_Harman

With R70.20, there is a new search box at the top of the Transaction List where you can enter an amount, security name, or text from the Memo field. This is combined with filter boxes for the date range and Action Type to display the matching transactions.

This will be very useful, but unfortunately I don't think it would help for this report.

acs2

I'll try some of what is mentioned. I'd like to have a report whereby I can select one or more securities, see the action, the number of shares associated with that action, and the balance of shares. In its simpliest form:

Security Name date action Shares Share balance

Stock a 11/6 buy 15 15

12/5 sell 5 10 etc.

mshiggins

@acs2

The quickest way to see the date, action, shares, and running share balance is to sort the investment transaction register by security.

Jim_Harman

Taking another look at this:

Based on the suggestion of @mshiggins to use the new investing account register filters in R70.20, you can filter the account register to include one security. This will include the running share balance. The format is not pretty, but you can then print or export the result.