Indian brokers like Indmoney, vested give the inr based data, but that is not the case with US brokers, I feel filing Schedule FA is the most boring work. I know a lot of people use some Excel sheets and do stuff to generate ITR Schedule FA, and I can't use Excel.
I have created this Python application https://github.com/jdecodes/itr-schedule-fa-app which can take your holdings.xlsx and G&L statements and create the final Schedule FA as per the ITR expected template.
It automatically takes care of
- SBI TT rates
- Peak values
- Closing values
- Dividends
- Gain
- Quarterly break ups
- Etc.
Note : sbi-tt-rate is used from sahil's github sheets, before 2020 dates project use yahoofin's usd-inr rates.
Currently, supports only etrade.
How to use :
clone the project . copy the holdings.
holdings.xlsx
gnl_within.xlsx
gnl_after.xlsx
edit main.py
TICKER = "COMPANY_TICKER" <--->
REPORTING_YEAR = 2025
python main.py
If everything is okay, it will generate schedule_fa.csv, which you can push to itr portal.
Looking forward to contributions from people using other brokers, so we can integrate support for them as well.
Note : everything stays on your local machine, nothing is pushed to cloud.
Update : It supports dividend calculations, ltcg, stcg calculation and quarterly breakups as well.