Invoice Calculator 2
One of multiple in-house customer invoice calculators I wrote to cut down on time consuming data-entry and billing calculation tasks for a customer. Prior to the creation of this application, these administrative tasks were done in a spreadsheet and after a year of manually tracking the data, it became clear calculating recurrent billings would be impossible without the ability to keep track of both historical billings and changes to customer state. Upon completion of this tool, a monthly task which would typically take 4-6 hours was reduced to under a minute.
It's a Python Flask-based web-application backed by a MySQL (or SQLite) database. Some of its services include: user authentication, internal customer data storage and reporting, and most notably a data import utility that runs import data through an algorithm which calculates the current month's billing.
My Role
Front end & backend developer, Designer, QA, Deployment
Technology
Python, JavaScript, Flask, Bootstrap, JQuery, Gunicorn, MySQL, SQLite3, Nginx, Rocky Linux
Source Code
This project is not open source