Wash Sales Report

Owned by Former user (Deleted)
Oct 27, 2016
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. From the Accounting Center window, click Reporting in the left navigation.
  2. Double click Investment Accounting, Trade Reports, and Wash Sales Report.
    You see the Wash Sales Report panel.
  3. Complete the fields on the Wash Sales Report panel.
  4. Click Submit.
    You see the Submit Query dialog box.
  5. Click Grid Report or Advanced Report for the report view you want.
    The report results appear on your desktop for the view selected.

Wash Sales Panel Options

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

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)