Back Home > Tamarac Reporting > Data Setup & Calculations > Calculations > How Reports Display Uploaded Interval Performance Data
|
Back |
Home > Tamarac Reporting > Data Setup & Calculations > Calculations > How Reports Display Uploaded Interval Performance Data
|
How Reports Display Uploaded Interval Performance Data
There may be some times when you have outside interval data that you want to see in Tamarac reports. For example, your portfolio accounting system data may not be available, or a new client may have historical data for an account new to you want to show. In such cases, Tamarac can manually upload interval performance data for accounts and groups at the total account level or at any category level.
This data is uploaded by Tamarac, not through a bulk upload data set.
To learn more about manual interval performance uploads or to have data manually uploaded, please contact your Service Team.
When you use manually uploaded interval performance data, reports process and display that data in a variety of ways based on how you configure the account's manual performance panel settings.
The following sections provide details on how performance reports handle uploaded interval performance data.
Shows the uploaded data if Calculate analytic values using is set to Monthly returns.
Visit the Account Analytics Report.
Shows the uploaded data based on the configuration of the account's manual performance panel settings.
Visit the Account Ledger Report.
Shows uploaded account-level and category-level returns.
The PDF report does not support grouping by multiple levels of category performance.
Visit the Account Performance Report.
Uploaded interval data is only available for Managed and Total data points.
The following columns show uploaded interval data:
| Manual Upload Column | How Report Handles the Data |
|---|---|
| Start Value and End Value | For information, see Start Value and Ending Value. |
| Inflows |
If everything is uploaded to Gross/Net Inflows, positive values are placed in Inflows.
If these are split out between Inflows and Outflows in the upload, the inflows will be placed in Inflows. |
| Outflows |
If everything is uploaded to Gross/Net Inflows, negative values are placed in Outflows.
If these are split out between Inflows and Outflows in the upload, the outflows will be placed in Outflows. |
| Net Investment Gain |
Calculated as End Value - Net Flows - Beginning Value |
| Returns |
Time-weighted return (TWR): calculated by linking together the uploaded net or gross returns.
Internal Rate of Return (IRR): calculated using the values and flows that have been uploaded for either Net or Gross. |
| Interest and Dividends | Shows data uploaded to the Income column. |
| Management Fees | Shows data uploaded to the Management Fees column. |
Visit the Comparative Review Report.
Shows uploaded data and identifies it as a manual interval. By default, uploaded monthly intervals spread values and returns evenly over the period. This behavior can be configured on the account's manual performance panel settings.
Visit the Interval Performance Report.
The following columns show uploaded interval data:
| Manual Upload Column | How Report Handles the Data |
|---|---|
| Start Value and End Value | For information, see Start Value and Ending Value. |
| Inflows |
If everything is uploaded to Gross/Net Inflows, positive values are placed in Inflows. If these are split out between Inflows and Outflows in the upload, the inflows will be placed in Inflows. If Show returns as net or gross is set to Gross returns, the Inflow numbers will show gross flows. |
| Outflows |
If everything is uploaded to Gross/Net Inflows, negative values are placed in Outflows. If these are split out between Inflows and Outflows in the upload, the outflows will be placed in Outflows. If Show returns as net or gross is set to Gross returns, the Outflow numbers will show gross flows. |
| Net Investment Gain |
Calculated as End Value - Net Flows - Beginning Value |
| Returns |
Time-weighted return (TWR): calculated by linking together the uploaded net or gross returns. Internal Rate of Return (IRR): calculated using the values and flows that have been uploaded for either Net or Gross. |
Visit the Performance History Report.
Uploaded interval data is only available for Managed and Total data points. Any other data points will be left blank for the period of uploaded intervals.
The following columns show uploaded interval data:
| Manual Upload Column | How Report Handles the Data |
|---|---|
| Start Value and End Value | For information, see Start Value and Ending Value. |
| Inflows |
If everything is uploaded to Gross/Net Inflows, positive values are placed in Inflows.
If these are split out between Inflows and Outflows in the upload, the inflows will be placed in Inflows. |
| Outflows |
If everything is uploaded to Gross/Net Inflows, negative values are placed in Outflows.
If these are split out between Inflows and Outflows in the upload, the outflows will be placed in Outflows. |
| Investment Gain | For information, see Investment Gain |
| Returns |
Time-weighted return (TWR): calculated by linking together the uploaded net or gross returns.
Internal Rate of Return (IRR): calculated using the values and flows that have been uploaded for either Net or Gross. |
| Capital Appreciation |
For information, see Capital Appreciation. |
| Interest and Dividends | Because there is no differentiation between interest and dividend in uploads, both Interest and Dividend show 0. |
| Management Fees |
Shows data uploaded to the Management Fees column.
|
| Other Expenses |
Shows data uploaded to the Other Expenses column.
|
| Income | Shows data uploaded to the Income column. |
| Net Income | For information, see Net Income |
Visit the Summary Report.
The following sections provide details on how the Accounts page and transaction and holdings reports handle uploaded interval performance data.
Returns show uploaded interval data. Custom account values do not show uploaded interval data.
For more information, see Accounts Page Actions, Views, and Filters.
Shows category-level uploaded data when Show as is set to Allocation over time.
Visit the Asset Allocation Report.
Both the Account Value vs. Net Investment chart and the Summary table show uploaded interval data.
| Manual Upload Column | How Report Handles the Data |
|---|---|
| Contributions |
If everything is uploaded to Gross/Net Inflows, positive values are placed in Contributions.
If these are split out between Inflows and Outflows in the upload, the inflows will be placed in Contributions. |
| Withdrawals |
If everything is uploaded to Gross/Net Inflows, negative values are placed in Withdrawals.
If these are split out between Inflows and Outflows in the upload, the outflows will be placed in Withdrawals. |
Visit the Capital Flows Report.
Transactions can be manually uploaded for viewing only on the Transactions report. These values are not used for calculations anywhere within Tamarac.
Visit the Transactions Report.