Back Home > Advisor View > Reports > Dynamic and PDF Reports > Available Reports > Transaction Reports > Realized Gains and Losses Report
|
Back |
Home > Advisor View > Reports > Dynamic and PDF Reports > Available Reports > Transaction Reports > Realized Gains and Losses Report
|
Realized Gains and Losses Report
|
|
| Applies to: | |||
|---|---|---|---|
| ✔ Dynamic | Mobile |
✔ Client Portal |
|
The Realized Gains and Losses report displays a table of the gains or losses for transactions in an account or group over a specified period. The report allows you to choose columns from a variety of data points and their order in the report, as well as determine up to two levels of sorting. You can also set custom column widths for this report and preview it to determine if the data fits as expected.
The Realized Gains and Losses report is helpful for estimating a client's potential tax burden and for optimizing trading decisions based on realized gains or losses.
In the Realized Gains and Losses report, you will find versatile sorting options that let you answer many questions about accounts and groups, such as:
For this period, what is the difference between cost basis and proceeds of sales? See the realized gains or losses for the account or group for whatever date period you select.
How much in gains should the client anticipate being taxed on? Evaluate the tax implications of gains and losses both at the account level and at the group level.
When Trading, Where can I optimize for Gains or Losses? Review the current gains and losses in a client's portfolio to help make trading recommendations that reduce the client's overall tax burden.
Although the custodian is the final source of record for realized gains and losses, for tax planning purposes, Cherry Street Financial likes to provide clients or their CPAs with estimates of the gains or losses within their accounts on a regular basis.
They use a Realized Gains/Losses PDF template that shows group- and account-level data set to sort by account and then by total gain/loss. It is automatically posted to the client portal.
Before making trading recommendations, Cherry Street Financial advisors like to refer to the Realized Gains/Losses report to review the current gains or losses in a client's account. This allows the firm to minimize tax burden as much as possible and to answer the question, "Should I reconsider the funds I'm invested in based on their capital gains?"
They use a dynamic Realized Gains/Losses report sorted to display descending short term gain/loss and then sorted by account. This helps them quickly identify which accounts might benefit from tax optimization.
The dynamic report helps you easily filter and sort data to drill down to meaningful results. Interactive reporting features include:
Highly customizable. Display only relevant data. You control what data are displayed and which columns are included, in what order, so you can create the exact report you need.
On-the-Fly Column Sorting. Sort columns by clicking column headers. The caret direction (^ or ˅) indicates sorting order, either ascending or descending.
View Security Details. Click the name of a security to view Google Finance information about that security.
You can to enable or disable ticker links for each security type.
Set the Data Source. You can choose the data source: Either the custodian or Advisor View. If you choose Advisor View, the data could come from your portfolio accounting system, or from the custodian if Use the account custodian as the source of record for the Realized Gains/Losses report is selected. To learn more about setting the data source, see Data Source.
You can use dashboard views to see a pared-down, at-a-glance summary of the main dynamic report on your dashboard.
To learn more about creating and managing dashboard views, see Create and Share Dashboard Views.
For more information on customizing your dashboard, visit Add/Edit/Delete Dashboard Modules.
The following settings are available for the Realized Gains and Losses report. Click the setting name for more details:
| Setting | Details | Available In... | |||
|---|---|---|---|---|---|
| Dynamic Report | PDF Report | Advisor Dashboard | PDF Dashboard |
||
| Report Name | Designate a unique name for the report view. | X | X | ||
| Mark as Publicly Accessible | Share the report view. | X | |||
| Section Title | Designate what the section will be called in the PDF report. | X | X | ||
| Theme | Designate what theme the section will use. | X | |||
| Header and Footer | Choose a unique header and footer for the section or use defaults. | X | |||
| Include Page Break After This Section |
Control where page breaks occur in PDF reports. |
X | |||
| Account Grouping | Control grouping of accounts and groups. | X | |||
| Realized Gains/Losses Source | If you bring in data from Schwab, Fidelity, TD Ameritrade, or other custodians, you can choose to display their data or the data from Advisor View. | X | |||
| Select the date period you want to use for the report. | X | X | X | X | |
| Transactions Per Page | Choose how many accounts, positions, payments, or transactions to display per page. | X | |||
| Sort First By/Then By | Determine the default order in which the data is displayed. | X | X | X | |
| Include Non-Taxable Accounts | Show or hide non-taxable accounts. | X | X | X | X |
| Show Lot Level Detail | View detailed information about the holdings at the trade lot level. | X | X | ||
| Show Capital Gain Distributions |
Include or exclude capital gain distributions. Includes the following related setting:
|
X | X | ||
| Available/Selected Columns | Choose which columns, rows, indices, or benchmarks are included and in what order. | X | X | X | X |
To learn more about general dynamic reports settings, including how to customize columns, add footers, and more, see:
You can do any of the following actions with the Realized Gains and Losses report:
| Action | Available in Dynamic Report | Available in PDF Report | |
|---|---|---|---|
| Run Report | Run dynamic report or PDF template. | X | X |
| Edit Report | Edit report view or template. | X | X |
| Copy Report | Copy report view or template. | X | X |
| Delete Report | Delete report view or template. | X | X |
| Share Report | Share report view or template with other firm users. | X | X |
| Export to Excel | Export report data to a CSV file. | X | NA |
| Print Report | Print a dynamic report. | X | X |
| Site Themes | Edit how the dynamic report looks. | X | |
| Learn More About Customizing How PDF Templates Look | Edit how the PDF report looks. | X |
