Project Expense Tracker

Between projects, I was tasked with building a system to show reports of the financial aspects of a project. This system was entirely coded by me, but I cooperated heavily with our operations manager for the architecture. The first tool needed was an estimation tool. With this tool, project managers would input any projected costs for a project. The next tool was the expense tracker; here is where project managers input all expenses incurred for a project. Once I had our estimated costs and our actual costs data, I could start showing reports. The reports tab not only pulled data from the two tools I created, but from 3 more sources of data: warehouse inventory, USPS shipping api, and an internal shipping system. The result is a detailed view of the projects financial status, broken down by category. If a category is ever within a certain amount of the estimated cost or is over the estimated cost, an alert is sent out to the project manager. If costs hit an account for which there is no estimation, an alert goes out for that as well.