Wash Sales Report

Owned by Copy Page Tree (Unlicensed)
Last updated: Oct 03, 2023 by Nancy Cohn (Deactivated)
2 min read

The Wash Sales report displays the wash sale deferral and reversal activity for a specified date range, including the cost of the block sold, the sell that created the loss, the open lot replacement shares that received the cost adjustment including any wash sale cost adjustment reversals.

Grid report views available for this report include:

  • Wash Sale Deferrals. This view displays base and local deferral details.

  • Wash Sale Reversals. This view displays base and local reversal details.

  • Wash Sales Summary. This view displays wash sales with deferrals and reversals summarized.

  • Wash Sales Report (Legal Size Paper). This view displays the deferrals and reversals for tracking wash sales.

Advanced report views available for this report include:

  • Wash Sales Details. This view displays wash sales deferral and reversal details.

  • Wash Sales Summary. This view displays wash sales deferrals and reversals summarized.

To create the Wash Sales report:

  1. In Accounting Center, in the left navigation pane, click Reports > Investment Accounting Reports > Trade > Wash Sales Report. 
    You see the Wash Sales Report panel.

  2. Complete the options on the Wash Sales Report panel.

  3. Under Result Options, click Grid or Advanced Report for the report view you want.

  4. Click Submit.
    The report results appear on your desktop for the view selected.

Wash Sales Report Panel Options

A definition of the options on the Wash Sales Report panel follows.

Option

Description

Option

Description

Entity Information

 

Entity ID

Specifies a portfolio, sector portfolio, composite portfolio, or Master Fund by the entity ID of the entity.

Entity Name

Specifies a portfolio, sector portfolio, composite portfolio, or Master Fund by name of the entity.

Accounting Basis

Specifies the entity accounting basis. For example, USTAX, GAAP, or IFRS.

Date Type and Range

 

Beginning Date

Specifies the start date for your report results. The default is the first day of the current month.

Ending Date

Specifies the ending date for your report results. The default is today's date.

Beginning Balance Option

Allows you to filter the transactions with/without transaction details. Options include:

  • All Beginning Balances (Default)

  • Beginning Balances with Activity

Selection Criteria

 

Report Filters

Allows you to show/hide additional security filters. The default is No.

Advanced Report Options

Allows you to show/hide advanced report detail tabs and format options. The default is No.

Filter Security By

Allows you to show/hide additional report filters. Options include:

  • Security Cross Reference (Default). If you select this option the panel unhides the Xref Type and Xref Security ID fields for data entry.

  • Issue Name. If you select this option, the panel unhides the Issue Name field for data entry.

  • Primary Asset ID. If you select this option, the panel unhides the Primary Asset ID field for data entry.

Detail Tab Selection

Allows you to select additional views for your advanced report results. Options include:

  • Summary (Default Yes)

  • Detail (Default Yes)

Â