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

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.

enterprises.

Keywords: SmartPOS Budgeteer, Point-of-Sale, Inventory Management, Expense Tracking, Python, Tkinter,

ObjectOriented Programming, SQLite, MySQL, Retail Management System.

The rapid advancement of information technology has significantly transformed the way businesses manage

their daily operations. In the retail industry, efficient management of sales transactions, inventory records, and

business expenses is essential to maintaining profitability, operational effectiveness, and customer

satisfaction. Small retail establishments, however, often rely on traditional methods such as handwritten

records, notebooks, and spreadsheetbased systems to manage their operations. While these methods may be

mistakes, and the absence of real-time monitoring mechanisms. These issues may result in overstocking, stock

shortages, missed sales opportunities, and increased operational costs. In addition, manual sales recording can

lead to incorrect transaction computations, inconsistencies in financial reports, and difficulties in monitoring

business performance. Likewise, inadequate expense tracking may result in poor budget management and

reduced visibility of business expenditures, making it difficult for owners to evaluate profitability and control

operational costs.

To address these challenges, many businesses have adopted Point-of-Sale (POS) systems that automate sales

transactions and inventory updates. A POS system allows businesses to process customer purchases efficiently

while maintaining accurate records of products sold and inventory levels. Similarly, expense management

systems help businesses organize and monitor operational expenses by categorizing expenditures and

enhanced reporting capabilities. By consolidating business data into a unified database, business owners can

easily monitor operations, track financial performance, and make informed decisions based on real-time

information. Furthermore, automation minimizes repetitive tasks, reduces human intervention, and improves

overall operational efficiency.

To respond to this need, the researchers developed SmartPOS Budgeteer, a Python-based Sales, Inventory,

and

Expense Management System designed specifically for small retail businesses. The system utilizes Object-

Oriented Programming (OOP) principles to create a modular, maintainable, and scalable application

architecture. Through the use of Python programming, Tkinter-based graphical user interfaces, and

SQLite/MySQL database integration, the system provides a comprehensive solution for processing sales

manual record-keeping while providing business owners with valuable insights for monitoring performance

and supporting strategic decisionmaking. As digital transformation continues to influence business operations,

systems such as SmartPOS Budgeteer demonstrate the importance of adopting technology-driven solutions

to enhance productivity, accountability, and longterm business sustainability.

Despite the availability of various digital business tools, many small retail establishments continue to

experience difficulties in managing sales transactions, inventory records, and operational expenses efficiently.

Manual methods often lead to inaccurate computations, delayed updates, inconsistent record keeping, and

challenges in generating reliable reports. These issues can affect business productivity, financial management,

and customer service. To address these concerns, this study seeks to answer the following questions:

4. How can Object-Oriented Programming principles contribute to the reliability, maintainability, and

5. How can database integration ensure secure, accurate, and permanent storage of business records?

6. How effective is the developed system in improving retail management operations based on functional

The primary objective of this study is to design, develop, and implement SmartPOS Budgeteer, a Python-

based, Object-Oriented Programming-driven Sales, Inventory, and Expense Management System that

provides an integrated solution for small retail business operations.

4. Implement a refund management feature that accurately updates inventory records and transaction

5. Integrate SQLite and MySQL databases for secure, reliable, and permanent data storage.

6. Design a user-friendly graphical user interface using Tkinter for efficient navigation and operation.

7. Generate comprehensive reports for sales, inventory, expenses, and overall business performance.

8. Apply Object-Oriented Programming principles to ensure modularity, maintainability, and scalability of

9. Conduct functional testing to evaluate the accuracy, reliability, usability, and performance of the

database technologies. For Academic Institutions, the project demonstrates the practical application of

software engineering concepts in solving real-world business problems. Finally, for Small Retail Businesses,

the study highlights the advantages of adopting computerized systems, including improved efficiency, better

record management, enhanced reporting, and increased productivity.

This study focuses on the development and implementation of a desktop-based Sales, Inventory, and Expense

Management System intended for small retail businesses. The system includes modules for sales processing,

inventory monitoring, expense recording, refund management, activity logging, database integration, and

report generation. It provides automated transaction processing, inventory updates, expense tracking, and

report creation through a graphical user interface developed using Tkinter.

Object-Oriented Programming, graphical user interface design, and previous studies relevant to integrated

retail management solutions. These concepts provide theoretical and practical support for the development

and implementation of the proposed system.

customer purchases, calculate totals, maintain inventory records, and generate business reports. Modern POS

systems have become essential tools in retail businesses because they improve transaction accuracy, reduce

processing time, and provide real-time access to sales information. According to Garados et al. (2026), POS

systems significantly enhance operational efficiency by minimizing human intervention and automating

repetitive business processes.

According to Bhavani et al. (2025), automated expense management systems improve financial transparency

by organizing expenditure data and generating accurate summaries of operational costs. These systems enable

expense summaries. These reports assist business owners in evaluating financial performance, managing

budgets, and making informed business decisions. The integration of expense tracking with sales and

inventory management creates a comprehensive business management environment that promotes financial

accountability and operational efficiency.

buttons, menus, forms, icons, and tables instead of command-line instructions. GUI design plays a significant

The literature further highlights the importance of database integration in maintaining secure, organized, and

reliable records. Likewise, Python programming and Object-Oriented Programming provide a strong

foundation for developing scalable, maintainable, and efficient software applications. Graphical User

Interfaces enhance system usability by allowing users to interact with software through intuitive visual

elements.

Based on these findings, SmartPOS Budgeteer was designed and developed as an integrated solution that

combines sales management, inventory monitoring, and expense tracking within a single Python-based OOP

application. By incorporating database technologies and a user-friendly GUI, the system addresses common

operational challenges faced by small retail businesses while improving efficiency, accuracy, accountability,

and decision-making capabilities.

designed to ensure that the developed system effectively addresses the operational challenges commonly

experienced by small retail businesses while providing a reliable, user-friendly, and efficient management

solution.

The study adopted a System Development Research Design, which focuses on the creation, testing, and

evaluation of a software application intended to solve specific operational problems. The development process

followed the Software Development Life Cycle (SDLC) framework, which consists of several

interconnected phases, namely planning, analysis, system design, development, testing, implementation, and

maintenance. This structured approach ensured that the requirements of the intended users were properly

identified, translated into system specifications, and implemented into a functional application.

process to ensure that each system component functioned correctly and met the intended objectives. This

approach enabled the researchers to identify and correct system issues during development, resulting in a

more reliable and stable application.

The planning phase involved identifying the operational challenges faced by small retail businesses and

determining the requirements necessary for the proposed system. Information was gathered through

observation of retail management practices and analysis of existing manual processes.

During this phase, the researchers identified several key requirements, including sales transaction processing,

inventory monitoring, expense tracking, refund management, report generation, activity logging, and user

authentication.

examined to identify inefficiencies and opportunities for automation.

System requirements were translated into functional specifications that defined the expected behavior of each

module.

The researchers analyzed user needs and identified critical system functionalities such as automated

calculations, realtime inventory updates, report generation, secure data storage, and intuitive navigation. This

phase provided the foundation for designing the overall system architecture.

The design phase involved creating the blueprint of the system. Several design tools and models were

developed to represent the structure, behavior, and interaction of system components.

System design activities included the creation of:

Sales Module – Handles customer purchases, calculates totals, records transactions, and updates inventory

automatically.

Inventory Module – Allows users to add, edit, delete, search, and monitor product records and stock levels.

validation mechanisms successfully prevented invalid or incomplete data entries, thereby ensuring the

accuracy and integrity of stored records. Database operations, including record insertion, updating, retrieval,

and deletion, were executed correctly without data loss or corruption.

Additional testing confirmed that inventory quantities were automatically adjusted after sales and refund

transactions, ensuring real-time stock monitoring. Expense entries were correctly categorized and included in

generated financial summaries. Report outputs were verified against database records and were found to be

accurate and consistent.

Overall, all modules passed functional testing, demonstrating that SmartPOS Budgeteer is capable of

supporting dayto-day retail operations with reliability, accuracy, and efficiency.

retail environments where accurate transaction processing and record management are essential.

integrating sales management, inventory monitoring, and expense tracking into a single desktop-based

application. The system effectively addressed common challenges associated with manual retail operations,

including inaccurate calculations, inconsistent record-keeping, delayed reporting, and inefficient inventory

monitoring.

One of the most significant findings is the effectiveness of automated sales processing and inventory

management. By automatically updating stock levels after each transaction, the system eliminates the need

operational efficiency while minimizing human errors that commonly occur in traditional record-keeping

systems.

The expense management module also proved effective in organizing and monitoring business expenditures.

Through automated expense recording and categorization, business owners can easily track operational costs

improved overall user satisfaction.

Database integration through SQLite and MySQL played a critical role in ensuring data persistence,

consistency, and reliability. All transactions, inventory records, expense entries, and activity logs were stored

accurately and remained accessible throughout testing. The use of relational database technologies enhanced

record organization and facilitated efficient report generation.

The refund management feature further strengthened the system by maintaining accurate inventory counts

and transaction histories. Returned products were successfully restored to inventory, and corresponding sales

records were updated appropriately. This functionality helps maintain accurate financial and stock records

while supporting customer service operations.

The findings also demonstrate the effectiveness of applying Object-Oriented Programming principles in

error, enhances data management, and provides valuable decision-support information through

comprehensive reporting features.

The primary objective of this study was to design, develop, implement, and evaluate SmartPOS Budgeteer,

a Pythonbased Sales, Inventory, and Expense Management System utilizing Object-Oriented Programming

(OOP) principles. Based on the development process, functional testing results, and overall system evaluation,

the following conclusions were drawn:

The study successfully developed an integrated retail management system that combines sales processing,

inventory monitoring, expense tracking, refund management, activity logging, and report generation into a

single application. By consolidating these essential business functions, SmartPOS Budgeteer provides a

centralized platform that improves operational efficiency and eliminates the need for multiple disconnected

record-keeping systems.

The implementation of automated sales computation, inventory updates, and expense recording significantly

reduced the possibility of human errors commonly associated with manual record management. The

automation of routine business processes improved transaction accuracy, increased productivity, and

business activities rather than maintaining records manually.

scalability, and modularity of the application. Through the implementation of classes, methods, and reusable

code structures, the system became easier to manage, debug, and extend for future enhancements. The

adoption of OOP principles also improved software organization and promoted efficient system development

practices.

The Tkinter-based Graphical User Interface successfully provided an interactive and user-friendly

environment for users with varying levels of technical expertise. The interface simplified navigation, reduced

operational complexity, and improved user experience through intuitive forms, dashboards, tables, and

controls. This finding demonstrates the importance of GUI design in enhancing system usability and user

acceptance.

Functional testing confirmed that all modules performed according to their intended functions. Sales

sales performance, inventory status, operational expenses, and overall business activities more efficiently.

These features provide valuable insights that can support strategic planning and operational improvements.

Overall, the findings demonstrate that SmartPOS Budgeteer successfully achieved its objectives and provides

a reliable, accurate, efficient, and user-friendly solution for managing small retail business operations. The

performance during testing and evaluation, several enhancements may be considered to further improve the

To further improve customer service and transaction documentation, future versions may incorporate a receipt

generation and printing module. This feature would allow automatic generation of printable receipts

containing transaction details, purchased items, payment information, and business branding.

tools.