Portfolio Valuation Report

Path:
Client Portal > Report > Portfolio Valuation

Objective:
The Portfolio Valuation report shows the valuation and returns of an investor’s currently held investments only. If a family head is selected, it covers all family members. For each holding it shows units, purchase and current NAV, purchase and current value, unrealised gain, average holding days, absolute return and the annualised return. Holdings are grouped with sub-totals and a grand total. Several PDF sections, such as allocation breakdowns, SIP summary and insurance list, add a consolidated view of the current portfolio.

Return Type (CAGR / XIRR):
The annualised return column in the Portfolio Valuation report depends on a distributor-level setting:
Portal Settings > IFA Preferences > Portfolio Valuation Return Type
Options:

• Standard CAGR
• Weighted CAGR
• XIRR

Report Configuration:

View Type:
On Screen, PDF, Excel, Excel (Unformatted) or Email. PDF view also has Save Settings, which keeps the current configuration, and Send on WhatsApp.

Group By (non on-screen views):

1. Investor, Category, Folio
2. Investor, Category, Folio, Transaction
3. Investor, Category
4. Investor, Sub Category, Folio
5. Investor, Sub Category, Folio, Transaction
6. Investor, Sub Category
7. Investor, Transaction
8. Investor
9. Category
10. Sub Category

Choose Product:
Mutual Fund, Share & Bond, Fixed Income, Other Assets, Foreign Assets. On Screen allows one product at a time. PDF allows several together.

Filters:

Investor:
Selects an individual investor or all family members.

Source:
Selects which holdings are included in the Portfolio Valuation report, based on who manages them:

• All: both managed and outside holdings.
• Managed Data: only holdings managed through the distributor.
• Outside Data: only holdings outside the distributor. In the report, folio numbers of outside holdings end with an asterisk (*).

How a holding is classified as Managed or Outside depends on the product:

• Mutual Funds: based on the ARN. Holdings under the distributor’s ARN are Managed. Holdings under another ARN or in direct plans are Outside.
• Share & Bond, Fixed Income, Other Assets, Foreign Assets: based on the External Asset Manager. Holdings with an External Asset Manager assigned are Outside. Holdings without one are Managed.

Report as on date:
Sets the date for which holdings are valued.

Holding Period:
Filters holdings by how long they have been held: All, Upto 1 year, More than 1 year, More than 2 years, etc.

Transaction Type:
Filters holdings by the transaction they came from: All, Purchase, SIP, STP, Switch In, etc.

Advanced Filters:
Category, Sub Category, Fund, Folio, External Asset Manager, Currency (for Foreign Assets).

Data Options (PDF):
Merge SIP, STP, Div Reinvest; Investment snapshot since inception; SIP Summary; Insurance List; Folio Comment; Category; Investor Summary; Folio Details; Goal Details.

MF Allocation Sections (PDF):
Fund, Scheme, Sub Category, Investor, Holding, Sector, Equity Market Cap.

Columns Include:
Purchase NAV, Purchase Value, Current NAV, Balance Units, Dividend, Gain (unrealised), Avg Holding Days, Absolute Return, and the return column (CAGR or XIRR, as per the return type setting).

FAQs:

Q1. What does the Portfolio Valuation report show?
It shows the current value, unrealised gain and returns of an investor’s or family’s currently held investments, scheme-wise and folio-wise.

Q2. Does the Portfolio Valuation report include redeemed investments?
No. It covers currently held investments only. Use the Portfolio Summary report for realised plus unrealised returns.

Q3. Where can I find the Portfolio Valuation report?
Client Portal > Report > Portfolio Valuation.

Q4. Does the Portfolio Valuation report show CAGR or XIRR?
It shows whichever return type the distributor has set in Portal Settings > IFA Preferences > Portfolio Valuation Return Type: Standard CAGR, Weighted CAGR or XIRR.

Q5. How do I change the return type from CAGR to XIRR in the Portfolio Valuation report?
Go to Portal Settings > IFA Preferences > Portfolio Valuation Return Type and select XIRR.

Q6. Does the Portfolio Valuation report show unrealised gain?
Yes. The Gain column is the unrealised gain on currently held units: Current Value minus Purchase Value.

Q7. How is Gain calculated in the Portfolio Valuation report?
Gain = Current Value − Purchase Value, for the balance units still held.

Q8. Does the Portfolio Valuation report show realised gain?
No. It covers currently held investments only. For realised gains, use the Capital Gain Realized report. For unrealised capital gains, use the Capital Gain Unrealized report.

Q9. Can I see foreign assets in the Portfolio Valuation report?
Yes. Select Foreign Assets under Choose Product. A Currency filter is available to view holdings by currency.

Q10. Can I view multiple products together in the Portfolio Valuation report?
Yes, in PDF view, where products are multi-select. On Screen shows one product at a time.

Q11. How is the on-screen Portfolio Valuation report organised?
By investor, then by category (e.g. Equity, Hybrid, Liquid and Ultra Short). Each category has a sub-total, and there is an investor sub-total and a grand total.

Q12. What is the difference between Managed Data and Outside Data in the Source filter?
Managed Data is held through the distributor. Outside Data is held outside the distributor, and its folio numbers end with *. All includes both. For mutual funds this is decided by the ARN. For other products it is decided by whether an External Asset Manager is assigned.

Q13. What does the * after a folio number mean in the Portfolio Valuation report?
It marks an outside holding, meaning an investment held outside the distributor rather than managed through them. Use the Source filter to show only Managed Data or only Outside Data.

Q14. How does the Portfolio Valuation report decide if a mutual fund holding is Managed or Outside?
By ARN. Mutual fund holdings under the distributor’s ARN are Managed. Holdings under another distributor’s ARN, or in direct plans, are Outside.

Q15. How does the Portfolio Valuation report decide if a share, bond, fixed income, other asset or foreign asset holding is Managed or Outside?
By the External Asset Manager. If an External Asset Manager is assigned to the asset, it is Outside. If none is assigned, it is Managed.

Q16. Why is my mutual fund holding showing as Outside Data in the Portfolio Valuation report?
The holding is not under the distributor’s ARN. It may be under another distributor’s ARN or in a direct plan.

Q17. Can I see holdings older than one year only?
Yes. Use the Holding Period filter, e.g. More than 1 year.

Q18. Can I filter the Portfolio Valuation report by a specific fund or folio?
Yes. Use Advanced Filters > Fund or Folio.

Q19. Can I view the Portfolio Valuation report as of a past date?
Yes. Change the Report as on date.

Q20. Can I see sector or market-cap allocation in the Portfolio Valuation report?
Yes. In PDF view, select Sector or Equity Market Cap under MF Allocation Sections.

Q21. Can I save my Portfolio Valuation report configuration?
Yes. Use Save Settings, available in the downloadable views.

Q22. Can I share the Portfolio Valuation report on WhatsApp?
Yes. In PDF view, use Send on WhatsApp.

Q23. Why is no data shown in the Portfolio Valuation report?
The investor may have no current holdings in the selected product, source, holding period or other filters. Try widening the filters.