Integration of Store Layout Redesign and MySQL-Based Digital Accounting System to Improve Operational Efficiency of Retail SMEs

This study aims to improve operational efficiency and financial management at Toko Pink 31 Surabaya by integrating two key components: store layout redesign and the development of a MySQL-based accounting system. The research uses a combination of qualitative and quantitative approaches through observations, interviews, system design, and simulations. The redesigned layout was developed using the Systematic Layout Planning (SLP) method and simulated via AnyLogic software to evaluate customer flow and service bottlenecks. The results showed significant improvements in space utilization, reduced customer congestion, and enhanced overall shopping experience. In parallel, the accounting system was developed using MySQL to automate and structure financial transactions. The system includes modules for product input, sales, purchasing, cost of goods manufactured (COGM) reporting, and daily financial summaries. The implementation of this digital accounting system reduced manual errors, streamlined transaction processing, and provided real-time access to financial data. The integration of both layout optimization and digital accounting demonstrates a comprehensive transformation model for SMEs, particularly in the retail sector. The findings emphasize that combining spatial efficiency and financial digitalization can significantly improve business performance, supporting broader efforts to digitalize micro and small enterprises in Indonesia.