Digital Transaction System for Ice Cream Retail

This paper presents the design, implementation, and evaluation of an Automated Billing System specifically engineered for small-scale retail environments, exemplified by an ice cream shop model. Developed using the robust combination of Python 3.x, the Tkinter graphical user interface (GUI) framework, and MySQL for persistent data management, the system is a desktop-based application designed to digitally transform and optimize the point-of-sale (POS) operations. The system’s core functional objectives— improving efficiency, maximizing calculation accuracy, and ensuring secure data persistence— are achieved through automated total calculation, item categorization (e.g., Exotic, Naturals), and support for multiple digital payment modes (e.g., GPay, Cash). A novel feature is the implementation of a Hold and Restore Bill mechanism, utilizing in-memory transaction queuing to enhance customer service flexibility during high-traffic periods. All completed transactions are securely stored in the MySQL database, providing digital records for immediate retrieval, analysis, and auditing.Testing demonstrates a measurable reduction in billing time and the elimination of manual arithmetic errors. This system offers a cost-effective, scalable, and readily deployable solution for small businesses transitioning toward digital operational management.