This script automates the conversion of an Interactive Brokers (IBKR) financial statement CSV file into a format suitable for Israel's 1325 tax form.
The script processes the statement produced by IBKR's custom report, as described in this fintranslator.com article. Each Trade row is merged with its corresponding ClosedLot and the currency rates for the buy and sale days (currently only supports USD), as well as other calculations necessary for the 1325 form, as detailed here.
- Clone the repository.
- Copy your IBKR statement into the root directory of the project.
- Install requirements:
$ pip install -r ./requirements.txt- Run the script using the following commands:
$ python srcThe output, an Excel spreadsheet, will be generated in the same directory.
This software is provided "as is" without any warranty of any kind. The author(s) disclaim all warranties, including implied warranties of merchantability, fitness for a particular purpose, and non-infringement. The software is intended for educational and informational purposes only.
This software is NOT a substitute for professional tax advice or services, nor does it provide legal, financial, or tax advice of any kind. Please consult a professional tax advisor or accountant to ensure the accuracy of tax information.
In no event shall the author(s) or copyright holder(s) be liable for any claim, damages or other liability, arising from, out of, or in connection with the software or its use.
By using this software, you acknowledge and accept these terms.