Hi Steve,
There are a couple of ways you can do this, depending on how you want it formatted.
1) Set up your client's sub-portfolios with their name and account number. When you report on this sub-portfolio, this information will be in the report header. You can then do any type of report, like the Portfolio Value report, which lists shares of each item. You can optionally sub-total by any lower level sub-portfolios, like if they have accounts beneath.
Example sub-portfolio hierarchy:
- Code: Select all
My RIA Firm
Client XYZ
Acct 12345
Acct 6789
Client ABC
....
When you create a report, report on "Client XYZ", and turn on sub-totals by sub-portfolio. List by investment.
2) If you wanted to see the account number on each line, you can do this by creating a custom report, and adding this field to the report.