Smartpos Budgeteer: Design and Implementation of a Python-Based Sales, Inventory, and Expense Management System Using Oop Principles
Article Sidebar
Main Article Content
The graphical user interface was developed using Tkinter, providing an intuitive and user-friendly environment for business owners and staff. Data management and storage were implemented through SQLite and MySQL databases to ensure secure, accurate, and permanent record keeping. The system includes modules for sales processing, inventory monitoring, expense recording, refund management, activity logging, and report generation. Automated calculations and real-time database updates help minimize human errors while improving operational efficiency.
A system development approach based on the Software Development Life Cycle (SDLC) was utilized throughout the planning, design, implementation, testing, and deployment phases. Functional testing was conducted to evaluate the performance, reliability, and accuracy of each module. Results showed that the system successfully processed sales transactions, updated inventory records, recorded expenses, handled refund transactions, validated user inputs, and generated accurate reports. All test cases passed, demonstrating the reliability and effectiveness of the system in supporting retail business operations.
The findings indicate that SmartPOS Budgeteer provides a unified, efficient, and user-friendly solution for small retail establishments. By integrating POS, inventory, and expense management functionalities, the system improves accuracy, accountability, record organization, and business decision-making. Furthermore, the implementation of OOP principles and database integration contributes to system maintainability, data integrity, and long-term usability. The study demonstrates the potential of Python-based business management systems in enhancing operational productivity and supporting the digital transformation of small retail enterprises.
Downloads
References
Bhavani, V. T., Chinthana, S., Aishwarya, K., Shweta, B., & Nirmala, S. (2025). Implementation of an expense tracker using Python. International Journal for Multidisciplinary Research.
Birajdar, R. S. (2025). Personal expense tracker: Advancing financial management through software solutions. IIP International Multidisciplinary Research Journal.
Bourgeois, D. T., Smith, J. L., Wang, S., & Mortati, J. (2019). Information systems for business and beyond. Saylor Foundation. https://saylordotorg.github.io/text_information-systems-for-business-and-beyond/
Dimentieva, A., Li, J., Zhao, G., Li, J., Chen, X., & Wong, D. S. (2026). Designing cloud-based electronic systems with secure data management and application integration.
Garados, M., Smith, J., & Wang, S. (2026). POS impact on operational performance and financial success.
Ismail, M. F., Nasir, N., Rahaman, W. E. W. A., Rashid, A. A., & Rusli, M. H. M. (2024). InventsimQD: GUI-based teaching application for quantity discounts inventory models. Malaysian Journal of Intelligent Engineering and Advanced Systems (MYJIEAS), 4(1), 332–339.
Madamidola, A., Daramola, O. A., Akintola, K. G., & Adeboje, O. T. (2024). A review of existing inventory management systems. International Journal of Research in Engineering and Science (IJRES), 12(9), 40–50.
Python Software Foundation. (n.d.). Python documentation. https://docs.python.org/3/
Python Software Foundation. (n.d.). Tkinter — Python interface to Tcl/Tk. https://docs.python.org/3/library/tk.html
Pressman, R. S., & Maxim, B. R. (2020). Software engineering: A practitioner's approach (9th ed.). McGraw-Hill Education.
Silberschatz, A., Korth, H. F., & Sudarshan, S. (2019). Database system concepts (7th ed.). McGraw-Hill Education.
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 Education.
Suya, F., Li, J., Zhao, G., Li, J., Chen, X., & Wong, D. S. (2026). Smart inventory management for mini grocery stores.
Sommerville, I. (2016). Software engineering (10th ed.). Pearson Education.
Trappey, C. V., Trappey, A. J. C., & Hwang, S.-J. (1996). A computerized quality function deployment approach for retail services. Computers & Industrial Engineering, 30(4), 611–622. https://doi.org/10.1016/0360-8352(96)00014-8
This work is licensed under a Creative Commons Attribution 4.0 International License.
All articles published in our journal are licensed under CC-BY 4.0, which permits authors to retain copyright of their work. This license allows for unrestricted use, sharing, and reproduction of the articles, provided that proper credit is given to the original authors and the source.