Converts simple lists of lots and sales into a TXF file
US Tax Forms (1040 Schedule D and 8949 supplemental forms) require that every capital gains sale is listed by line, even if no cost basis or even a 1099-B has been provided to the IRS. Entering this data into tax software like TurboTax is tedious and error prone. 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...
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.
The second script is used for updates. The IRS...