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.

Cooperative governance, good corporate governance, digitalisation, stakeholders, transparency, accountability.

1. Bhavani, V. T., Chinthana, S., Aishwarya, K., Shweta, B., & Nirmala, S. (2025). Implementation of an expense tracker using Python. International Journal for Multidisciplinary Research. [Google Scholar] [Crossref]

2. Birajdar, R. S. (2025). Personal expense tracker: Advancing financial management through software solutions. IIP International Multidisciplinary Research Journal. [Google Scholar] [Crossref]

3. Bourgeois, D. T., Smith, J. L., Wang, S., & Mortati, J. (2019). Information systems for business and beyond. Saylor Foundation. [Google Scholar] [Crossref]

4. Laudon, K. C., & Laudon, J. P. (2012). Management information systems: Managing the digital firm (12th ed.). Pearson. [Google Scholar] [Crossref]

5. MySQL. (n.d.). MySQL documentation. Oracle. [Google Scholar] [Crossref]

6. O’Brien, J. A., & Marakas, G. M. (2011). Management information systems (10th ed.). McGraw-Hill. [Google Scholar] [Crossref]

7. Python Software Foundation. (n.d.). Python documentation. [Google Scholar] [Crossref]

8. Python Software Foundation. (n.d.). Tkinter — Python interface to Tcl/Tk. [Google Scholar] [Crossref]

9. Shneiderman, B., Plaisant, C., Cohen, M., Jacobs, S., Elmqvist, N., & Diakopoulos, N. (2016). Designing the user interface: Strategies for effective human-computer interaction (6th ed.). Pearson. [Google Scholar] [Crossref]

10. Silberschatz, A., Korth, H. F., & Sudarshan, S. (2019). Database system concepts (7th ed.). McGraw-Hill Education. [Google Scholar] [Crossref]

• Block-Based Programming for Education: A Comprehensive Analysis of Visual Programming Environments in K-12 Learning
• Management of Academic Libraries and Client Satisfaction Towards Digital Utilization: Basis for Monitoring Library Operations in SOCCSKSARGEN Region.
• Revenue Leakages in TPA Insurance Claims and Corporate Claims: An Institutional Overview of Aster Prime Hospital, Hyderabad
• Technology and Innovation in Hospitality and Tourism: A Management Perspective
• Geospatial Distribution of Tarok Sacred Grove of Langtang North and Langtang South Local Government Areas