Instead of manually running the plethora of SQL scripts each month I created an automated way to run them using Python. This version of the program now includes a GUI which allows you to select more than one billing system to run at a time. The GUI was created using PySimpleGUI and was made with the intent to distribute among other members of my organization who aren't as comfortable with the command prompt.
The GUI utilizes threads to run the SQL scripts which means the interface is non-blocking. During testing I used SQLAlchemy along with an excel file to simulate a database, the following article was very helpful: Creating a Mock Database
Overall this program should be a useful tool for my team members and expedite the script running process for month end close.
