Converts simple lists of lots and sales into a TXF file
...Some institutions provide limited export capabilities such as CSV or excel export but this is not easy to translate into tax preparation software.
These python scripts convert two simple to generate input files BuyLots.csv and Sales.csv into a .TXF file that can be imported into tax prep software and a second RemainingLots.csv that can be used for next year. The scripts automatically calculate the First In First Out lots for every sale and properly tag them in the TXF format ( https://turbotax.intuit.com/txf/TXF042.jsp ).
...
Creates and Maintains a MySQL Database of the IRS Business Master File
The IRS has created the Business Master File of all tax-exempt entities. There are 28 searchable fields.
This project consists of two bash scripts plus two SQL scripts to automate the process of converting and updating the files from the IRS into a MySQL (MySQL, MariaDB) database.
The first script (plus SQL) creates a database and primary table. It then downloads the files from the IRS, processes them and adds them to the database.