Dates

Information about each asset appears in a row defined by the ticker. The dates bought and sold are in columns adjacent to the ticker. Enter them when entering the ticker or later if preferred.  Leave date sold blank if the asset is currently held in the account. The example illustrates various possibilities, including the number of shares held or sold.

Dates
 
  • DJP       This asset was sold (less than one year after purchase) and will have incurred a short term tax liability or credit for a taxable account.
  • MUB      This asset is currently held in the account.
  • VEA       This asset is currently held in the account. When the date bought is blank it is assumed that the date was more than one year ago and therefore long term gains will apply.
  • VIG        This asset was sold and would have incurred a long term liability or credit because the date bought is blank.

Holding periods, as determined by the difference between date bought and the current date, are obviously important for taxable accounts to distinguish between short and long-term gains. Holding period is also important for tax advantaged accounts, because of wash sale rules. A blank date bought in a tax advantaged account is interpreted to mean that the holding period is greater than 30 days eliminating any wash sale penalty.

You must enter the date sold once an asset is sold. This is required so that the system can ignore it during rebalancing calculations. Also, remember that sold assets do not contribute to the total account value. If the sale generated a taxable loss then this date is also required for honoring wash sale rules.

Most sales are partial; only part of the holding is sold.  See Tax Lots on how to deal with this situation.


Tips & Tricks

It can be quicker to enter all tickers for one account and then come back and enter dates. This is especially true when there are many assets to enter. Fortunately, that usually happens only once during initial setup. Remember that you can leave date bought blank if the asset was acquired more than one year ago.