1-888-485-3456 Free Online Demo Login
MENU

Help Center

Manage Client’s Account: Tax Center Downloads

Spreadsheet File (.csv), Unrealized Gains/Losses

The Spreadsheet File (.csv) can be used in spreadsheet software such as Microsoft Excel. Click Download and follow the instructions that appear on your screen.

When you download this spreadsheet file, you get the following information:

  • Symbol – The security’s symbol.
  • Security – The name of the company.
  • Quantity of Shares – The number of shares bought.
  • Share price – The price at which the security was bought.
  • Total Price – The share price multiplied by the quantity of shares.
  • Date Bought* – The date on which the security was purchased.
  • Account Name – The name of the account for which security was purchased.
  • Folio Name – The name of the Folio that holds the security. Securities held outside a Folio are identified as “non-Folio holdings.”
  • Status – The current status of the open tax lot—short or long term.
  • Report Date – The date on which the report was downloaded.
  • Current Value per share – The current share price.
  • Total Current Value – The current share price multiplied by the quantity of shares.
  • Unrealized Gain/Loss – The value of the capital gain or loss if all shares of the security were sold. Since these unrealized gains and losses are based on a last transaction price that is 20 minutes old, the amount given does not reflect the actual gains or losses you would realize if you sold your shares. Keep in mind that the last transaction may have occurred more than 20 minutes ago.

*Note: Retirement accounts are tracked using the Average Cost method. Therefore individual lots are not tracked and purchase date is reported as the current date on the unrealized gain/loss reports.

Spreadsheet File (.csv), Realized Gains/Losses

The Spreadsheet File (.csv) can be used in spreadsheet software such as Microsoft Excel. Select Download and follow the instructions that appear on your screen.

When you download this spreadsheet file, you get the following information:

  • Symbol – The security’s symbol.
  • Security – The name of the company.
  • Quantity of Shares – The number of shares bought.
  • Share Price – The price at which the security was bought.
  • Total Purchase Price – The share price multiplied by the quantity of shares.
  • Date Bought – The date on which the security was purchased.
  • Account Name – The name of the account for which security was purchased.
  • Folio Name – The name of the Folio that holds the security. Securities held outside a Folio are identified as “non-Folio holdings.”
  • Status – The current status of the closed tax lot—short or long term.
  • Date Sold – The date on which the security was sold.
  • Value per share – The price at which the security was sold.
  • Total Ending Value – The value per share multiplied by the quantity of shares.
  • Realized Gain/Loss – The value of the capital gain or loss. The gain or loss is determined by subtracting the total purchase price from the total ending value.

Tax Software File (.txf)

The Tax Software File (.txf) can be imported to tax software such as Quicken TurboTax. Click Download and follow the instructions that appear on your screen.
Note: With some browsers and operating systems, this file will appear directly on your screen.

To Save the Tax Software File

  1. Close this window.
  2. Right-click on the Download button beneath Tax Software File (.txf).
  3. Select Save Target As.
  4. When prompted to do so, give the file a name that you’ll remember, with the file extension .txf.

For example, you might call your year 2000 closed tax lots, “Tax Lots_2000.txf”.

You can then import the file into your tax software.

Information in Tax Software File

When you download this tax software file, you get the following information:

  • Symbol – The security’s symbol.
  • Security – The name of the company.
  • Quantity of Shares – The number of shares bought.
  • Purchase Price – The price at which the security was bought.
  • Total Purchase Price – The share price multiplied by the quantity of shares.
  • Date Bought – The date on which the security was purchased.
  • Account Name – The name of the account for which security was purchased.
  • Status – The current status of the closed tax lot – short or long term.
  • Date Sold – The date on which the security was sold.
  • Value per share – The price at which the security was sold.
  • Total Ending Value – The value per share multiplied by the quantity of shares.
  • Realized Gain/Loss – The value of the capital gain or loss. The gain or loss is determined by subtracting the total purchase price from the total ending value.

Printable List for Tax Return (.txt)

The Printable List for Tax Return (.txt) appears directly on your screen. Simply print the list and attach it to your tax return.

To save this Printable List

  1. Close this window.
  2. Right-click on the Download button beneath Printable List for Tax Return (.txt).
  3. Select Save Target As.
  4. When prompted to do so, give the file a name that you’ll remember, with the file extension .txt.

For example, you might call your year 2000 closed tax lots, “Tax Lots_2000.txt.”

Information in Printable List

When you download this printable list, you get the following information:

  • Shares – The number of shares bought.
  • Ticker – The security’s symbol.
  • Date Acquired – The date on which the security was purchased.
  • Date Sold – The date on which the security was sold.
  • Sale Price – The price at which the security was sold.
  • Cost Basis – The purchase price adjusted for any commissions or stock splits.
  • Gain/Loss – The value of the capital gain or loss. The gain or loss is determined by subtracting the cost basis from the sale price.
  • Total Sale Price – The dollar sum of all security sales.
  • Total Cost Basis – The dollar sum of all security cost bases.
  • Total Gain/Loss – The dollar sum of all gains or losses.

Tax Center Download Legal Disclaimer

The cost basis and gain/loss information is based on trade data or information that you enter. Total realized and unrealized gains/losses do not include securities for which cost basis is unavailable. The tax tools allow you to change the cost basis of all open tax lots, however, we take no responsibility for the information you provide.

Remember the accuracy of the calculations provided depend on the accuracy of the information you have entered. For securities purchased through this account, the calculations are based on actual trade data. While an attempt is made to provide precise data, the accuracy of all trade information is not guaranteed.

This information is for general guidance. We are not authorized to give tax advice. Because of the complexity of tax regulations and the individual circumstances of our customers, this information may not be complete or accurate for tax-reporting purposes. For example, we can’t identify losses that may be disallowed because of wash sale rules.