Smartpos Budgeteer: Design and Implementation of a Python-Based Sales, Inventory, and Expense Management System Using Oop Principles
Authors
Barcena, Jules.
Department of Computer Engineering Eulogio “Amang” Rodriguez Institute of Science and Technology (EARIST) Nagtahan, Manila, Philippines (PH)
Braw, Lhemuel Jr M.
Department of Computer Engineering Eulogio “Amang” Rodriguez Institute of Science and Technology (EARIST) Nagtahan, Manila, Philippines (PH)
Casta, Pamela Ann.
Department of Computer Engineering Eulogio “Amang” Rodriguez Institute of Science and Technology (EARIST) Nagtahan, Manila, Philippines (PH)
Garin, Ma. Soccoro B.
Department of Computer Engineering Eulogio “Amang” Rodriguez Institute of Science and Technology (EARIST) Nagtahan, Manila, Philippines (PH)
Amerie R.
Department of Computer Engineering Eulogio “Amang” Rodriguez Institute of Science and Technology (EARIST) Nagtahan, Manila, Philippines (PH)
Rosento, Hannah L.
Department of Computer Engineering Eulogio “Amang” Rodriguez Institute of Science and Technology (EARIST) Nagtahan, Manila, Philippines (PH)
Valentin, Patrick Jake D.
Department of Computer Engineering Eulogio “Amang” Rodriguez Institute of Science and Technology (EARIST) Nagtahan, Manila, Philippines (PH)
San Andres, Lorraine, Reyes, Bizzy
Department of Computer Engineering Eulogio “Amang” Rodriguez Institute of Science and Technology (EARIST) Nagtahan, Manila, Philippines (PH)
Article Information
DOI: 10.51583/IJLTEMAS.2026.150600086
Subject Category: Smartpos Budgeteer
Volume/Issue: 15/6 | Page No: 1184-1207
Publication Timeline
Submitted: 2026-07-07
Published: 2026-07-07
Abstract
Manual management of sales, inventory, and expenses in small retail establishments often results in inaccurate calculations, delayed transactions, inconsistent stock tracking, missing records, and challenges in report generation. These issues can negatively affect business operations, financial monitoring, and decision-making processes. To address these challenges, this study developed SmartPOS Budgeteer, a Python-based, Graphical User Interface (GUI)-driven system that integrates Point-of-Sale (POS), inventory management, and expense tracking functionalities into a single platform. The system was designed and implemented using Object-Oriented Programming (OOP) principles to ensure modularity, maintainability, scalability, and efficient code organization.
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.
Keywords
SmartPOS Budgeteer, Point-of-Sale, Inventory Management, Expense Tracking, Python, Tkinter, ObjectOriented Programming, SQLite, MySQL, Retail Management System.
Downloads
References
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. https://saylordotorg.github.io/text_information-systems-for-business-and-beyond/ [Google Scholar] [Crossref]
4. 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. [Google Scholar] [Crossref]
5. Garados, M., Smith, J., & Wang, S. (2026). POS impact on operational performance and financial success. [Google Scholar] [Crossref]
6. 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. [Google Scholar] [Crossref]
7. 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. [Google Scholar] [Crossref]
8. Python Software Foundation. (n.d.). Python documentation. https://docs.python.org/3/ [Google Scholar] [Crossref]
9. Python Software Foundation. (n.d.). Tkinter — Python interface to Tcl/Tk. https://docs.python.org/3/library/tk.html [Google Scholar] [Crossref]
10. Pressman, R. S., & Maxim, B. R. (2020). Software engineering: A practitioner's approach (9th ed.). McGraw-Hill Education. [Google Scholar] [Crossref]
11. Silberschatz, A., Korth, H. F., & Sudarshan, S. (2019). Database system concepts (7th ed.). McGraw-Hill Education. [Google Scholar] [Crossref]
12. 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. [Google Scholar] [Crossref]
13. Suya, F., Li, J., Zhao, G., Li, J., Chen, X., & Wong, D. S. (2026). Smart inventory management for mini grocery stores. [Google Scholar] [Crossref]
14. Sommerville, I. (2016). Software engineering (10th ed.). Pearson Education. [Google Scholar] [Crossref]
15. 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 [Google Scholar] [Crossref]
Metrics
Views & Downloads
Similar Articles
- Enhancing Formation Control of Multi Agent Systems Using Ann Based Technique
- Improving Sliding Mode Control with Chattering Reduction using Fuzzy Based Technique
- Cooking Quality, Fasting Blood Glucose, Glycemic Index and Load of High–Fiber Noodles Made from Wheat, Tiger Nut Residue and Cassava Flour Blends
- Matrix Rhythm Therapy Versus Interferential Therapy Combined with Lumbar Stabilization Exercises in Chronic Non-Specific Low Back Pain: A Randomized Comparative Trial
- Formulation and Sensory Evaluation of Functional Cake Prepared from Sweet Potato Powder