Etrade docs parsing for dividends and stocks vest/sell

Use at your own risk! Do not treat it as a tax consultancy.

General

Those scripts were initally designed to calculate taxes from E*TRADE dividends for Intel employees. Stock sales/vesting and liquidity funds were added later. It was not tested with any other entities.

Installation

Install python module:

python3 -m pip install --upgrade git+https://github.com/akantak/[email protected]

Preparation

Prepare a directory with all PDF files to be considered for the parsing process. Review sections Dividends and Stocks.

Usage

Run the installed python module directly in the directory with PDFs:

python3 -m etrade_tax_poland

or pass the directory as an argument (if the statements are in ex. /tmp/statements):

python3 -m etrade_tax_poland /tmp/statements

Output

In the previously indicated directory, there will be created a spreadsheet file etrade.xslx, with multiple sheets, one for each data type.

After the spreadsheet is prepared, review if all entries are valid for the selected fiscal year, and review if any stock purchase data were not already included in previous PITs.

Dividends

There is a script prepared that calculates paid tax vs due tax for stock dividends based on multiple E*Trade statements.

Also, there is a second dividend type for dividends paid from the Liquidity Fund. For those, there is no tax paid in the US.

Dividends calculation methodology

The dividends withholding tax (podatek u źródła) is 15% (for stocks dividends), while in Poland, the capital gains tax is 19%, so it is required to pay an additional 4% in Poland.

While, for the Liquidity Fund dividends, one has to pay the whole 19% tax in Poland.

The amounts in USD have to be converted with the NBP ratio from the day before granting/vesting.

Dividends documents

Prepare a directory with all the statements from E*TRADE to be considered during tax calculation. Those statements are named like: Brokerage Statement (...).pdf or MS_ClientStatements_(...).pdf. Multiple files allowed.

Those statements can be found on https://edoc.etrade.com/e/t/onlinedocs/docsearch?doc_type=stmt.

Stocks

Parse stocks purchase/vest/sell documents.

Stocks calculation methodology

For selling Restricted Stocks RS, there are 0 tax-deductible costs.

When selling the Employee Stock Purchase Plan (ESPP), the purchase price is the tax-deductible cost.

Stocks gain (bought or vest) documents

Go to https://us.etrade.com/etx/sp/stockplan#/myAccount/stockPlanConfirmations and download all files that should be taken into consideration. Those files will be named getEsppConfirmation.pdf or getReleaseConfirmation.pdf.

Trades confirmation

To get trade confirmations, go to https://edoc.etrade.com/e/t/onlinedocs/docsearch?doc_type=cnf and download the required confirmations. Those files will be named ETRADE Brokerage Trade Confirmation (...).pdf.