Dashboard Data Analysis and Financial Reporting Based on Google Spreadsheet (Case Study of Bam’s Barbershop MSME)
Year: 2025
Type: article
Abstract: MSMEs play an important role in the Indonesian economy, but many still face obstacles in recording transactions and preparing financial reports according to standards. MSME Bams Barbershop, for example, still uses manual recording through notebooks and mobile phones, which makes it difficult to report accurately and on time. This study aims to develop dashboard for data analysis and financial reporting based on Google Spreadsheet in accordance with SAK EMKM. The method used is descriptive qualitative with interview, observation, and documentation techniques, as well as the System Development Life Cycle (SDLC) approach. The system feasibility evaluation uses the TELOS method. The system developed includes a worksheet of account lists, general journals, ledgers, trial balances, profit and loss statements, financial position statements, and Notes to the Financial Statements, as well as additional features such as customer recaps, service packages, and automatic bonus calculations. The dashboard result can help for data transaction analysis to help the owner. The system also produce financial reports automatically, accurately, and according to standards. The feasibility evaluation shows that this system is feasible to be implemented from technical, economic, legal, operational, and time aspects, and can be implemented effectively in MSME operations.
Authors: Ikhsan Fallah Rizki, Rahmanita Vidyasari
Institution: Jakarta State Polytechnic
Language: English
Subfield: Management Information Systems
Domain: Social Sciences
Open Access status: diamond
OpenAlex ID: W7220143200