Design and Functional Evaluation of a Gui-Based Expense Tracker System Using Python, Tkinter, and MYSQL

Manual expense tracking often results in disorganized records, inaccurate calculations, and difficulty in monitoring financial activities. To address these problems, this study developed a GUI-based Expense Tracker System designed to help users record, organize, update, delete, and monitor expenses efficiently. The system was developed using Python as the main programming language, Tkinter for the graphical user interface, and MySQL as the database management system for permanent record storage. The application includes essential expense management features such as Add Expense, View Expenses, Edit or Update Record, Delete Record, Clear All Records, and Report or Analytics Window. It also provides category filtering, automatic summary computation, database connectivity, and light/dark mode interface options to improve usability. Functional testing was conducted to determine whether the system performs correctly under valid and invalid input conditions. The testing covered major operations such as adding records, validating empty fields, detecting non-numeric amounts, checking date formats, filtering categories, updating records, deleting records, generating reports, and verifying database connectivity. The results showed that the system successfully performed all tested functions and maintained accurate synchronization between the graphical interface and the MySQL database. Overall, the Expense Tracker System provides a simple, organized, and user-friendly solution for managing expense records while demonstrating the practical application of object-oriented programming, GUI development, and database integration.