Book Wash Sale Adjustments
In the Book Wash Sale Adjustment panel, you can adjust a wash sale.
To book a wash sale adjustment:
In Accounting Center, in the left navigation pane, click Transactions > Adjustments > Cost Adjustments > Book Wash Sale Adjustment.
You see the Book Wash Sale Adjustment panel.Complete the options on the Book Wash Sale Adjustment panel.
Click Submit.
Book Wash Sale Adjustment Panel Options
The following are the options on the Book Wash Sale Adjustment panel. Note options may vary according to your selections.Â
Option | Tag | Description |
---|---|---|
Entity Information | Â | Â |
Entity ID | 1163 | Specifies the unique identifier of the entity. |
Entity Name | 1164 | Specifies the name of the entity. |
Accounting Basis | 21 | Specifies the primary accounting basis for the entity. |
Base Currency | 86 | Displays the base currency of the entity/accounting basis. |
Wash Sale Inhibit Ind | 775 | Displays whether the system can apply the wash sale rule to trades for the entity/accounting basis. Options include:
|
Begin Trade Date | 220 | Defines the begin date, which identifies the first trade date used to display open lots in the Choose Lot to Change field (tag 7014) lookup. |
End Trade Date | 221 | Defines the end date, which identifies the last trade date used to display open lots in the Choose Lot to Change field (tag 7014) lookup. |
Event Information | Â | Â |
Manual Wash Sale Type | 157 | Specifies the type of manual wash sale adjustment you are adding. After you select a value, additional fields become available in the panel. Options include
|
Trade Ticket Number | 761 | Contains the trade ticket identification number. The system uses it during processing. For example, IDLOT close or cancel events use this number to locate an open lot. |
CLOSE Issue Details | Â | Â |
Cross Reference Type | 1234 | Specifies the cross reference type associated with the security associated with the close lot. This field appears only when you set the Manual Wash Sale Type field to Substantially Identical Wash Sale or Single Security Wash Sale. |
Issue Name | 961 | Specifies the name of the security. This field appears only when you set the Manual Wash Sale Type field to Substantially Identical Wash Sale or Single Security Wash Sale. |
Ticker | 13 | Specifies the trade ticker of the security. This field appears only when you set the Manual Wash Sale Type field to Substantially Identical Wash Sale or Single Security Wash Sale. |
Cross Reference ID | 1233 | Specifies the cross reference identifier associated with the security. This field appears only when you set the Manual Wash Sale Type field to Substantially Identical Wash Sale or Single Security Wash Sale. |
Primary Asset ID | 14 | Displays the primary asset identifier for the security. |
Asset ID | 10 | Displays the asset identifier, the internal number assigned to each asset. This field appears only when you set the Manual Wash Sale Type field to Substantially Identical Wash Sale or Single Security Wash Sale. |
Instrument Type | 11 | Displays the instrument type, such as cash, equity, or fixed income. This field appears only when you set the Manual Wash Sale Type field to Substantially Identical Wash Sale or Single Security Wash Sale. |
Security Type | 82 | Displays the security type of the asset. This field appears only when you set the Manual Wash Sale Type field to Substantially Identical Wash Sale or Single Security Wash Sale. |
Issue Currency | 85 | Displays the local currency of the security. This field appears only when you set the Manual Wash Sale Type field to Substantially Identical Wash Sale or Single Security Wash Sale. |
Quantity Scale | 19 | Displays the quantity multiplier. This field appears only when you set the Manual Wash Sale Type field to Substantially Identical Wash Sale or Single Security Wash Sale. |
Price Multiplier | 18 | Displays the price factor. This field appears only when you set the Manual Wash Sale Type field to Substantially Identical Wash Sale or Single Security Wash Sale. |
CLOSE Lot Information | Â | Â |
Choose Lot to Change | 334 | Allows you to select the close lot for the manual wash sale adjustment. The lookup displays close lots that met your criteria, ordered by the Close Event ID and describing the Receive Date, Close Qty, and Loss Amt. You must select a position/lot value that is eligible for disallowance. The lot's Qty Wash Elig field (tag 405) must identify wash eligible quantity available and the Loss Sec Curr B field (tag 402) must reflect a base loss to be disallowed. This field appears only when you set the Manual Wash Sale Type field to Substantially Identical Wash Sale or Single Security Wash Sale. |
OPEN Issue Details | Â | Â |
Cross Reference Type | 7001 | Displays the cross reference type associated with the security. This field appears only when you set the Manual Wash Sale Type field to Open Lot Adjustment or Substantially Identical Wash Sale. |
Issue Name | 7002 | Specifies the name of the security. This field appears only when you set the Manual Wash Sale Type field to Open Lot Adjustment or Substantially Identical Wash Sale. |
Ticker | 7003 | Specifies the trade ticker of the security. This field appears only when you set the Manual Wash Sale Type field to Open Lot Adjustment or Substantially Identical Wash Sale. |
Cross Reference ID | 7004 | Specifies the cross reference identifier associated with the security. This field appears only when you set the Manual Wash Sale Type field to Open Lot Adjustment or Substantially Identical Wash Sale. |
Primary Asset ID | 7005 | Displays the primary asset identifier for the security. This field appears only when you set the Manual Wash Sale Type field to Open Lot Adjustment or Substantially Identical Wash Sale. |
Asset ID | 7006 | Displays the asset identifier, the internal number assigned to each asset. This field appears only when you set the Manual Wash Sale Type field to Open Lot Adjustment or Substantially Identical Wash Sale. |
Quantity Type | 7009 | Specifies the quantity generally accepted as a standard for exchanges, such as shares and par. This field appears only when you set the Manual Wash Sale Type field to Substantially Identical Wash Sale. |
Instrument Type | 7010 | Displays the instrument type, such as cash, equity, or fixed income. This field appears only when you set the Manual Wash Sale Type field to Open Lot Adjustment. |
Security Type | 7011 | Displays the security type of the asset. This field appears only when you set the Manual Wash Sale Type field to Open Lot Adjustment. |
Issue Currency | 7013 | Displays the local currency of the security. This field appears only when you set the Manual Wash Sale Type field to Open Lot Adjustment or Substantially Identical Wash Sale. |
Quantity Scale | 7660 | Displays the quantity multiplier. This field appears only when you set the Manual Wash Sale Type field to Substantially Identical Wash Sale. |
Price Multiplier | 7661 | Displays the price factor. This field appears only when you set the Manual Wash Sale Type field to Substantially Identical Wash Sale. |
OPEN Lot Information | Â | Â |
Washsale Open Lot Flag | 4916 | Specifies whether the target open lot is identified on the transaction or if the system generates the target open lot. This field appears only when you set the Manual Wash Sale Type field to Substantially Identical Wash Sale or Single Security Wash Sale. Options include:
|
Choose Lot to Change | 7014 | Allows you to select the open lot for the manual wash sale adjustment. |
Open Trade Ticket Number | 7007 | Displays the trade ticket identification number for the selected open lot. This field appears when you set the Manual Wash Sale Type field to Open Lot Adjustment. It also appears when you set the Manual Wash Sale Type field to Substantially Identical Wash Sale or Single Security Wash Sale and also set the Washsale Open Lot Flag field to User Defined Open. |
Trade Date | 7560 | Displays the effective date of the trade. This field appears when you set the Manual Wash Sale Type field to Open Lot Adjustment. It also appears when you set the Manual Wash Sale Type field to Substantially Identical Wash Sale or Single Security Wash Sale and also set the Washsale Open Lot Flag field to User Defined Open. |
Accounting Date | 7561 | Displays the date the trade is reported and has an effect on the entity's holdings and cash balances. This field appears when you set the Manual Wash Sale Type field to Open Lot Adjustment. It also appears when you set the Manual Wash Sale Type field to Substantially Identical Wash Sale or Single Security Wash Sale and also set the Washsale Open Lot Flag field to User Defined Open. |
Monthly Accounting Date | 7562 | Displays the month end accounting date. This field appears when you set the Manual Wash Sale Type field to Open Lot Adjustment. It also appears when you set the Manual Wash Sale Type field to Substantially Identical Wash Sale or Single Security Wash Sale and also set the Washsale Open Lot Flag field to User Defined Open. |
Settlement Date | 7563 | Displays the date the trade is settled. This field appears when you set the Manual Wash Sale Type field to Open Lot Adjustment. It also appears when you set the Manual Wash Sale Type field to Substantially Identical Wash Sale or Single Security Wash Sale and also set the Washsale Open Lot Flag field to User Defined Open. |
Quantity Orig | 159 | Displays the original quantity for the open lot. This field appears when you set the Manual Wash Sale Type field to Open Lot Adjustment. It also appears when you set the Manual Wash Sale Type field to Substantially Identical Wash Sale or Single Security Wash Sale and also set the Washsale Open Lot Flag field to User Defined Open. |
Current Quantity | 163 | Displays the current quantity for the open lot. This field appears when you set the Manual Wash Sale Type field to Open Lot Adjustment. It also appears when you set the Manual Wash Sale Type field to Substantially Identical Wash Sale or Single Security Wash Sale and also set the Washsale Open Lot Flag field to User Defined Open. |
Open Hld Per Date | 164 | Displays the open holding period date for the open lot. This field appears when you set the Manual Wash Sale Type field to Open Lot Adjustment. It also appears when you set the Manual Wash Sale Type field to Substantially Identical Wash Sale or Single Security Wash Sale and also set the Washsale Open Lot Flag field to User Defined Open. |
Adjusted Open Hld Per Date | 7572 | Specifies the adjusted open holding period date for the open lot. This field initially displays the lot date. You can change the value if you are modifying the holding period date from the wash sale transaction. This field appears only when you set the Manual Wash Sale Type field to Open Lot Adjustment. |
Cash Event Type | 7015 | Displays the cash event type. This field appears when you set the Manual Wash Sale Type field to Open Lot Adjustment. It also appears when you set the Manual Wash Sale Type field to Substantially Identical Wash Sale or Single Security Wash Sale and also set the Washsale Open Lot Flag field to User Defined Open. |
Local Net Amount | 7350 | Displays the net amount of the transaction in local currency. This field appears when you set the Manual Wash Sale Type field to Open Lot Adjustment. It also appears when you set the Manual Wash Sale Type field to Substantially Identical Wash Sale or Single Security Wash Sale and also set the Washsale Open Lot Flag field to User Defined Open. |
Settlement Currency | 7017 | Displays the currency in which the trade is settled. This field appears when you set the Manual Wash Sale Type field to Open Lot Adjustment. It also appears when you set the Manual Wash Sale Type field to Substantially Identical Wash Sale or Single Security Wash Sale and also set the Washsale Open Lot Flag field to User Defined Open. |
Local to Base FX Rate | 7662 | Displays the foreign exchange rate used to calculate the net base amount. The value must be greater than zero. This field appears when you set the Manual Wash Sale Type field to Open Lot Adjustment. It also appears when you set the Manual Wash Sale Type field to Substantially Identical Wash Sale or Single Security Wash Sale and also set the Washsale Open Lot Flag field to User Defined Open. |
Base Net Amount | 7430 | Displays the base amount of the trade. This amount is calculated based on the following formula: Local Net Amount / Local to Base FX Rate. The value must be greater than zero. This field appears when you set the Manual Wash Sale Type field to Open Lot Adjustment. It also appears when you set the Manual Wash Sale Type field to Substantially Identical Wash Sale or Single Security Wash Sale and also set the Washsale Open Lot Flag field to User Defined Open. |
Target Event ID | 7018 | Displays the target event ID. This field appears when you set the Manual Wash Sale Type field to Open Lot Adjustment. It also appears when you set the Manual Wash Sale Type field to Substantially Identical Wash Sale or Single Security Wash Sale and also set the Washsale Open Lot Flag field to User Defined Open. |
Qty Wash Eligible | 7022 | Displays the wash eligible quantity for the open lot. This field appears when you set the Manual Wash Sale Type field to Open Lot Adjustment. It also appears when you set the Manual Wash Sale Type field to Substantially Identical Wash Sale or Single Security Wash Sale and also set the Washsale Open Lot Flag field to User Defined Open. |
Existing Local Disallowance | 7020 | Displays the existing local disallowance for the open lot. This field appears when you set the Manual Wash Sale Type field to Open Lot Adjustment. It also appears when you set the Manual Wash Sale Type field to Substantially Identical Wash Sale or Single Security Wash Sale and also set the Washsale Open Lot Flag field to User Defined Open. |
Wash Sales Fields | Â | Â |
Washsale Close Trade Date | 3863 | Specifies the trade date of the sell generating the disallowed loss. This field appears only when you set the Manual Wash Sale Type field to Open Lot Adjustment. |
Current Washsale Disallowance B | 3850 | Specifies the disallowed loss of a wash sale transaction, base currency. This field appears only when you set the Manual Wash Sale Type field to Open Lot Adjustment. |
Current Washsale Disallowance L | 3849 | Specifies the disallowed loss of a wash sale transaction, local currency. This field appears only when you set the Manual Wash Sale Type field to Open Lot Adjustment. |
Washsale Adj Fx Rate | 7663 | Displays the Fx rate used for the wash sale adjustment. By default, this field displays the Fx rate of the open lot. This field appears only when you set the Manual Wash Sale Type field to Open Lot Adjustment. |
Washsale Adj Trade Date | 7568 | Displays the trade date for the wash sale adjustment. By default, this field displays the latter value of either the open lot trade date or the wash sale close trade date. This field appears only when you set the Manual Wash Sale Type field to Open Lot Adjustment. |
Washsale Adj Accounting Date | 7567 | Displays the accounting date for the wash sale adjustment. This field appears only when you set the Manual Wash Sale Type field to Open Lot Adjustment. |
Washsale Adj Settlement Date | 7570 | Displays the settlement date for the wash sale adjustment. This field appears only when you set the Manual Wash Sale Type field to Open Lot Adjustment. |
Wash Sale - Open Lot with Disallowance Information | Â | Â |
Washsale Disallowance Term | 3851 | Specifies whether a short term (ST) or long term (LT) close is washed. This field appears only when you set the Manual Wash Sale Type field to Open Lot Adjustment. Options include:
|
Washsale Trade Ticket Number | 5018 | Specifies the trade ticket number of the transaction that caused the wash sale. This field appears only when you set the Manual Wash Sale Type field to Open Lot Adjustment. |
Wash Sale - Close Trade Information | Â | Â |
Washsale Close Event ID | 4917 | Specifies the Event ID of the close that generated the loss prior to a disallowance. This field appears only when you set the Manual Wash Sale Type field to Open Lot Adjustment. |
Washsale Close Trade Ticket Number | 3861 | Specifies the trade ticket ID of the sell generating the disallowed loss. This field appears only when you set the Manual Wash Sale Type field to Open Lot Adjustment. |
Washsale Close Event Type | 4919 | Specifies the event type of the close event creating the loss being disallowed. This field appears only when you set the Manual Wash Sale Type field to Open Lot Adjustment. |
Washsale Close Security Alias | 4911 | Specifies the security alias of the close security in a wash sale transaction. The system uses this value if the loss is from a close lot of a different security. This field appears only when you set the Manual Wash Sale Type field to Open Lot Adjustment. |
Washsale Close Post Date | 4920 | Specifies the post date of the close event creating the loss being disallowed. This field appears only when you set the Manual Wash Sale Type field to Open Lot Adjustment. |
Washsale Close Acct Date | 4921 | Specifies the accounting date of the close event creating the loss being disallowed. This field appears only when you set the Manual Wash Sale Type field to Open Lot Adjustment. |
Washsale Close monthly Accounting Date | 4922 | Specifies the monthly accounting date of the close event creating the loss being disallowed. This field appears only when you set the Manual Wash Sale Type field to Open Lot Adjustment. |
Total Close Quantity | 4924 | Specifies the total trade quantity of a close trade, that is, the sum of all disposal lots created by a close. This field appears only when you set the Manual Wash Sale Type field to Open Lot Adjustment. |
Washsale Close Quantity | 3865 | Specifies the total units of the original close lot for the wash sale. This field appears only when you set the Manual Wash Sale Type field to Open Lot Adjustment. |
Washsale Total Cls Loss B | 4998 | Specifies the value stored on the open lot to represent the total lot level base loss of the close being relieved. This field appears only when you set the Manual Wash Sale Type field to Open Lot Adjustment. |
Washsale Total Cls Loss L | 4999 | Specifies the value stored on the open lot to represent the total lot level local loss of the close being relieved. This field appears only when you set the Manual Wash Sale Type field to Open Lot Adjustment. |
Wash Sale - Original Open Lot that was Closed Information | Â | Â |
Washsale Open Holding Date | 3988 | Specifies the adjusted holding period of the sold lot creating the original disallowance. This field appears only when you set the Manual Wash Sale Type field to Open Lot Adjustment. |
Washsale Original Open Event ID | 3862 | Specifies the event ID of the lot sold prior to a wash sale. This field appears only when you set the Manual Wash Sale Type field to Open Lot Adjustment. |
Washsale Original Open Trade Ticket Number | 4925 | Specifies the trade ticket number of the lot sold prior to a wash sale transaction. This field appears only when you set the Manual Wash Sale Type field to Open Lot Adjustment. |
Washsale Original Acquisition Date | 3864 | Specifies the acquisition date of the sold lot creating the loss prior to a wash sale. This field appears only when you set the Manual Wash Sale Type field to Open Lot Adjustment. |
Â