Excel Optimization for Financial Resilience in Pre-Order SMEs: A Case Study of Digital Accounting Adaptation in Indonesia
DOI:
https://doi.org/10.59890/ijsas.v4i1.284Keywords:
Digital Accounting Tools, SME Financial Performance, Asset Utilization, Microsoft Excel, Financial Resilience, Pre-Order Business ModelAbstract
This study examines the impact of strategically customized digital accounting tools on financial management and asset utilization within small and medium-sized enterprises (SMEs), with a specific focus on accessible software like Microsoft Excel. Using an Indonesian convection SME operating on a pre-order model as a case study, a mixed-methods approach was employed. Financial data from 2023 and 2024 were analyzed through comparative horizontal analysis, common-size vertical analysis, and key financial ratios. The findings reveal a significant financial turnaround following the optimization of an Excel-based system, marked by an 83.17% revenue increase, a 1190.08% surge in gross profit, and a shift from a net loss to a 16.40% net profit margin. These improvements are primarily attributed to enhanced cost control and superior data structuring enabled by the tailored system. The research concludes that the strategic adaptation of readily available digital tools, prioritizing flexibility over sophistication, can substantially bolster financial resilience and operational efficiency for SMEs with niche business models amidst digital transformation.
References
Appelbaum, D., Kogan, A., & Vasarhelyi, M. A. (2022). Cloud-based accounting and auditing: Opportunities and challenges. Journal of Information Systems, 36(2), 1–21. https://doi.org/10.2308/isys-2020-031
Bhimani, A., & Willcocks, L. (2023). Digitisation, ‘big data’ and the transformation of accounting information. Accounting and Business Research, 53(4), 1–22. https://doi.org/10.1080/00014788.2022.2078137
Budiarto, D. S., & Siregar, S. V. (2024). Barriers to digital accounting adoption in Indonesian SMEs with non-standard business models. Asian Review of Accounting, 32(1), 89–107. https://doi.org/10.1108/ARA-05-2023-0123
Caglio, A. (2022). Enterprise resource planning systems and accountants: Towards hybridization? European Accounting Review, 31(3), 771–797. https://doi.org/10.1080/09638180.2021.2021904
Creswell, J. W., & Clark, V. L. P. (2018). Designing and conducting mixed methods research (3rd ed.). SAGE Publications.
Granlund, M., & Malmi, T. (2023). Moderate impact of ERPS on management accounting: A lag or permanent outcome? Management Accounting Research, 33(1), 1–19. https://doi.org/10.1016/j.mar.2022.100851
Hendrawan, A., & Prabowo, H. (2023). The impact of digital accounting adoption on SME profitability in Southeast Asia. Journal of Small Business Management, 61(3), 1105–1128.
Knudsen, D. R. (2022). The changing skill set of accounting professionals in the digital era. Journal of Accounting Education, 58, 100766. https://doi.org/10.1016/j.jaccedu.2022.100766
Kokina, J., & Blanchette, S. (2023). Early evidence of digital transformation in accounting: A bibliometric analysis. Accounting Horizons, 37(2), 1–25. https://doi.org/10.2308/HORIZONS-2022-078
Moll, J., & Yigitbasioglu, O. (2022). The role of internet-related technologies in shaping the work of accountants: New directions for accounting research. The British Accounting Review, 54(3), 101071.
Organisation for Economic Co-operation and Development. (2022). SME and entrepreneurship outlook 2022. OECD Publishing.
Palepu, K. G., Healy, P. M., & Peek, E. (2020). Business analysis and valuation: Using financial statements (5th ed.). Cengage Learning.
Quattrone, P. (2023). Embracing ambiguity in accounting and management. Accounting, Organizations and Society, 104, 101399.
Rikhardsson, P., & Yigitbasioglu, O. (2022). Business intelligence & analytics in management accounting research: Status and future focus. International Journal of Accounting Information Systems, 29, 100452.
Robinson, T. R., Henry, E., Pirie, W. L., & Broihahn, M. A. (2022). International financial statement analysis (4th ed.). Wiley.
Scapens, R. W. (2022). Management accounting in a digital and global economy: A review of the literature. Journal of Accounting & Organizational Change, 18(2), 181–204. https://doi.org/10.1108/JAOC-02-2021-0023
Susanto, A., & Wijaya, C. (2023). The persistence of manual bookkeeping and its implications for SME performance in Indonesia. Journal of Accounting in Emerging Economies, 13(2), 345–367. https://doi.org/10.1108/JAEE-01-2022-0012
Tayles, M., Pike, R. H., & Sofian, S. (2023). The role of management accounting in new product development: A review and synthesis. Journal of Management Accounting Research, 35(1), 1–26.
Vasarhelyi, M. A., Kogan, A., & Tuttle, B. M. (2022). Big data in accounting: An overview. Accounting Horizons, 29(2), 381–396.
Venkatesh, V., & Davis, F. D. (2000). A theoretical extension of the technology acceptance model: Four longitudinal field studies. Management Science, 46(2), 186–204. https://doi.org/10.1287/mnsc.46.2.186.11926
Warren, J. D., Moffitt, K. C., & Byrnes, P. (2022). How big data will change accounting. Accounting Horizons, 29(2), 397–407.
White, G. I., Sondhi, A. C., & Fried, D. (2020). The analysis and use of financial statements (5th ed.). Wiley.
Yin, R. K. (2018). Case study research and applications: Design and methods (6th ed.). SAGE Publications.
Downloads
Published
Issue
Section
License
Copyright (c) 2026 Lidia Andiani, Uke Prajogo
This work is licensed under a Creative Commons Attribution 4.0 International License.
