This report is used to troubleshoot or audit return numbers for your Client and Account performance reports. If the TWR period return number appears to be inaccurate for a given time frame, running this report will help to narrow the cause of the return discrepancy down to a single day.
What levels within the software can I run this report?
This report can be run at the following levels within the software:
What information is presented in this report?
This report displays the following information.
Column Header | Description |
Date | This column provides a single day during the reporting date range |
BMV | This column provides the Beginning Market Value for each day in the reporting date range. This number should match the Ending Market Value for the previous day. |
EMV | This column provides the Ending Market Value for each day in the reporting date range. |
Net Cash Flow | This column nets the cash flow additions into the account minus withdrawals out of the account. (Excluding management fees) . The sum of this column should match the net investment field for the account on the Client Return Summary. |
TWR % | This column provides the Time Weighted Return percentage for each day in the reporting period. |
How can I manually confirm that the information displayed is correct?
If you want to manually confirm your Period Rate of Return, please follow the steps below:
Paste the following formula into cell F12 without quotation marks.
=100*((1+F11/100)*(1+E12/100)-1)
Copy the formula into the cell for each day of the reporting date range.
The final cell of your reporting date range will display your result.
Note: this formula will still yield a small discrepancy due to rounding. Please see the example below.
How can I use this report to confirm my daily average balance for Billing?
To use this report to confirm your average daily balance for billing please follow the steps below:
In the EMV column, select cells for each day of the reporting date range.
Use the =AVERAGE formula to find the average for each day in the reporting period.
The cell under the final day in your EMV column will display your average daily balance.