TreasuryTrack
Digitizing Outdated Expense Tracking
-
For my senior capstone project, I decided to work with my local USPS union. After examining their processes, the treasury’s method of expense tracking was a clear problem. Previously, the union would simply keep all physical receipts, give them to the treasury to store in a folder, and manually add up and categorize the receipts at year end.
This method is not only outdated and inconvenient, but poses a serious risk of inaccurate or missing data, and is not feasible for long term data retention.
-
To solve this, I decided to create TreasuryTrack. TreasuryTrack is a digital expense tracking system that allows the user to upload photos of receipts then categorize and store them in a database.
TreasuryTrack is easier to use and much less error prone than manual tracking. In addition, it preserves data indefinitely for future reference if needed, like for an audit, for example.
-
Microsoft Access
The primary software used in this project is Microsoft Access
Check out a walkthrough of TreasuryTrack below
Coming Soon! TreasuryTrack is currently in development. Check back later for the finished project.