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

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.

Install python module:

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

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

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

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.

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.

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.

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.

Parse stocks purchase/vest/sell documents.

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.

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.

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.