Understanding Microsoft excel phenomena in MSME financial statements: A systematic review from 2010 to 2020

Antoni Antoni

doi:10.31295/ijbem.v4n1.1575

Authors

Antoni
antoniderasap@gmail.com

Keywords:

data review, financial record, MSME businesses, MSME finance report, understanding ms. excel

Abstract

This review study discusses the understanding of trends from Microsoft Excel in financial preparation in the MSME business in the digital era through a review of various papers published from 2010 to 2020. Our first step is to search for data electronically on the Google Scholar database. Next, we understand the study question. After understanding the questions, the following study data analysis begins with the coding system. Then evaluation and sharp interpretation ensure our data findings have answered the problem with reasonable standards and trustworthiness. We rely on data from publication because we were carrying out this study in the pandemic era where there were still restrictions on movement in our place. The result is that Ms. Excel also functions for MSME businesses which require the creation and presentation of dynamic quantity data reports. Now more and more small businesses are using this tool as its effective to support the financial record. This application is known as the Excel dashboard. It can complement various reports because it is presented in the form of an effective and dynamic dashboard

Downloads

Download data is not yet available.

References

Afif, I. R., & Nawirah, N. (2020). Design of financial statement preparation based on SAK EMKM using microsoft excel. Journal of Islamic Accounting and Finance Research, 2(1), 141–152.

Agostino, A., Søilen, K. S., & Gerritsen, B. (2013). Cloud solution in Business Intelligence for SMEs–vendor and customer perspectives. Journal of Intelligence Studies in Business, 3(3).

Aletkin, P. A. (2014). International financial reporting standards implementation into the Russian accounting system. Mediterranean Journal of Social Sciences, 5(24), 33–33.

Aly, D., Simon, J., & Hussainey, K. (2010). Determinants of corporate internet reporting: Evidence from Egypt. Managerial Auditing Journal.

Anderson, D. R., Sweeney, D. J., Williams, T. A., Camm, J. D., & Cochran, J. J. (2020). Modern business statistics with Microsoft Excel. Cengage Learning.

Bakasa, R. (2016). An analysis of the effect of International financial reporting standards (IFRS) for small and medium enterprises on the quality of financial reports produced by SMEs in Zimbabwe. [PhD Thesis]. BUSE.

Beneke, J., & Carter, S. (2015). The development of a consumer value proposition of private label brands and the application thereof in a South African retail context. Journal of Retailing and Consumer Services, 25, 22–35.

Bohušová, H., & Blašková, V. (2013). In what ways are countries which have already adopted IFRS for SMEs different. Acta Universitatis Agriculturae et Silviculturae Mendelianae Brunensis, 60(2), 37–44.

Braun, M. R., Altan, H., & Beck, S. B. M. (2014). Using regression analysis to predict the future energy consumption of a supermarket in the UK. Applied Energy, 130, 305–313.

Brown-Liburd, H., Issa, H., & Lombardi, D. (2015). Behavioral implications of Big Data’s impact on audit judgment and decision making and future research directions. Accounting Horizons, 29(2), 451–468.

Bruwer, J.-P., & Yolande, S. (2015). Accounting information systems–A value-adding phenomenon or a mere trend? The situation in small and medium financial service organizations in the Cape Metropolis. Expert Journal of Business and Management, 3(1).

Chand, P., Patel, A., & White, M. (2015). Adopting international financial reporting standards for small and medium-sized enterprises. Australian Accounting Review, 25(2), 139–154.

Chavda, S., Bromley, T., Jarvis, P., Williams, S., Bishop, C., Turner, A. N., Lake, J. P., & Mundy, P. D. (2018). Force-time characteristics of the countermovement jump: Analyzing the curve in Excel. Strength & Conditioning Journal, 40(2), 67–77.

Coleman, S., Göb, R., Manco, G., Pievatolo, A., Tort-Martorell, X., & Reis, M. S. (2016). How can SMEs benefit from big data? Challenges and a path forward. Quality and Reliability Engineering International, 32(6), 2151–2164.

Collins, J. C. (2017). Using Excel and Benford’s Law to Detect Fraud: Learn the Formulas, Functions, and Techniques That Enable Efficient Benford Analysis of Data Sets. Journal of Accountancy, 223(4), 44.

Cook, V. S. (2011). Entrepreneurship Education at a FET College [PhD Thesis]. Nelson Mandela Metropolitan University.

Crane, A., Matten, D., Glozer, S., & Spence, L. (2019). Business ethics: Managing corporate citizenship and sustainability in the age of globalization. Oxford University Press, USA.

Dewi, F., & Mahendrawathi, E. R. (2019). Business Process Maturity Level of MSMEs in East Java, Indonesia. Procedia Computer Science, 161, 1098-1105. https://doi.org/10.1016/j.procs.2019.11.221

Dewi, H. U. (2019). The analysis of factors that effect business development and income of MSMEs in Denpasar city. International research journal of management, IT and social sciences, 6(4), 118-126.

Damak-Ayadi, S., Sassi, N., & Bahri, M. (2020). Cross-country determinants of IFRS for SMEs adoption. Journal of Financial Reporting and Accounting.

Di Nino, S., & Luongo, A. (2019). A simple homogenized orthotropic model for in-plane analysis of regular masonry walls. International Journal of Solids and Structures, 167, 156–169.

Esubalew, A. A., & Raghurama, A. (2020). The mediating effect of entrepreneurs’ competency on the relationship between Bank finance and performance of micro, small, and medium enterprises (MSMEs). European Research on Management and Business Economics, 26(2), 87-95. https://doi.org/10.1016/j.iedeen.2020.03.001

Einav, L., & Levin, J. (2014). The data revolution and economic analysis. Innovation Policy and the Economy, 14(1), 1–24.

Elo, S., Kääriäinen, M., Kanste, O., Pölkki, T., Utriainen, K., & Kyngäs, H. (2014). Qualitative content analysis: A focus on trustworthiness. SAGE Open, 4(1), 2158244014522633.

FEROLDI, F. (2019). Voice analysis and business applications. A state-of-the-art.

Franklin, D., & Andrews, J. (2012). Megachange: The world in 2050 (Vol. 105). John Wiley & Sons.

Gibson, C. H. (2009). Financial reporting & analysis. Eleven Edition. Nelson Education, Ltd. USA.

Gilbert, L. S., Jackson, K., & di Gregorio, S. (2014). Tools for analyzing qualitative data: The history and relevance of qualitative data analysis software. In Handbook of research on educational communications and technology (pp. 221–236). Springer.

Goodwin, K. (2012). Use of tablet technology in the classroom. NSW Department of Education and Communities.

Hamzani, U., & Achmad, D. (2016). The performance of micro, small and medium enterprises (MSMEs): indigenous ethnic versus non-indigenous ethnic. Procedia-Social and Behavioral Sciences, 219, 265-271. https://doi.org/10.1016/j.sbspro.2016.05.015

Hutahayan, B. (2021). The relationships between market orientation, learning orientation, financial literacy, on the knowledge competence, innovation, and performance of small and medium textile industries in Java and Bali. Asia Pacific Management Review, 26(1), 39-46. https://doi.org/10.1016/j.apmrv.2020.07.001

Husnunnida, M., & Alfiana, F. (2021). Improvement of msme performance through behavior analysis of financial statements using accounting information technology.

Iriyadi, I., Maulana, M. A., & Nurjanah, Y. (2018). Financial Reporting for Micro Small and Medium Enterprises Towards Industrial Revolution Era 4.0. International Conference On Accounting And Management Science 2018, 32–38.

Kania, E., & Irawan, A. (2021). Penyusunan Laporan Keuangan Berdasarkan SAK Emkm Berbantuan Microsoft Excel Pada UMKM Uncal. Co. Indonesian Accounting Literacy Journal, 1(2), 338–352.

Kijkasiwat, P., Wellalage, N. H., & Locke, S. (2021). The impact of symbiotic relations on the performance of micro, small and medium enterprises in a small-town context: The perspective of risk and return. Research in International Business and Finance, 56, 101388. https://doi.org/10.1016/j.ribaf.2021.101388

Klychova, G. S., Fakhretdinova, E. N., Klychova, A. S., & Antonova, N. V. (2015). Development of accounting and financial reporting for small and medium-sized businesses in accordance with international financial reporting standards. Asian Social Science, 11(11), 318.

Lin, M., Fiore, A. M., Cooper, O. R., Horowitz, L. W., Langford, A. O., Levy, H., Johnson, B. J., Naik, V., Oltmans, S. J., & Senff, C. J. (2012). Springtime high surface ozone events over the western United States: Quantifying the role of stratospheric intrusions. Journal of Geophysical Research: Atmospheres, 117(D21).

Lloyd, I. (2020). Information technology law. Oxford University Press.

Mun, J. (2010). ‘Modeling Risk: Applying Monte Carlo, Risk Simulation. Strategic Real Options, Stochastic Forecasting, and Portfolio Optimization.

Nikaido, Y., Pais, J., & Sarma, M. (2015). What hinders and what enhances small enterprises’ access to formal credit in India?. Review of Development Finance, 5(1), 43-52. https://doi.org/10.1016/j.rdf.2015.05.002

Nino, I. J., Manafe, J. D., & Setyorini, T. (2019). Simple bookkeeping model using Microsoft excel for culinary micro-business in East Nusa Tenggara Indonesia. International Research Journal of Engineering, IT and Scientific Research, 5(2), 29-41.

Nurmadi, R., & Novietta, L. (2020). Accounting standards for micro, small and medium enterprises: effective or not? Accounting and Business Journal, 2(2), 63–69.

Oduor, C. (2016). The Factors Influencing the Adoption of Software as a Service (Saas) by Small and Medium Size Enterprises (Smes): A Case Study of Nairobi County in Kenya [PhD Thesis]. University of Nairobi.

Ojua, M. (2016). Accountants’ perceptions of the use of excel spreadsheet in financial reporting: A survey of accounts personnel in manufacturing firms. Imperial Journal of Interdisciplinary Research (IJIR), 2(8), 781–790.

Okediran, O. O., Arulogun, O. T., Ganiyu, R. A., & Oyeleye, C. A. (2014). Mobile operating systems and application development platforms: A survey. International Journal of Advanced Networking and Applications, 6(1), 2195.

Osuga, P. O. (2016). The effects of strategic innovation on the performance of SMES in Nairobi County [PhD Thesis]. United States International University-Africa.

Polotski, V., Kenne, J.-P., & Gharbi, A. (2020). Kalman filter based production control of a failure-prone single-machine single-product manufacturing system with imprecise demand and inventory information. Journal of Manufacturing Systems, 56, 558–572.

Rao, P., Kumar, S., & Madhavan, V. (2019). A study on factors driving the capital structure decisions of small and medium enterprises (SMEs) in India. IIMB Management Review, 31(1), 37-50. https://doi.org/10.1016/j.iimb.2018.08.010

Rachmadanti, E. (2019). Penyusunan laporan keuangan menggunakan microsoft access pada umkm bengkel hade motor [PhD Thesis]. Universitas Gadjah Mada.

Rahmatullah, R., Inanna, I., Sahade, S., Nurdiana, N., Azis, F., & Bahri, B. (2020). Utilization of Digital Technology for Management Effectiveness Micro Small and Medium Enterprises. International Journal of Scientific & Technology Research, 9(04), 1357–1362.

Samaha, K., Dahawy, K., Hussainey, K., & Stapleton, P. (2012). The extent of corporate governance disclosure and its determinants in a developing market: The case of Egypt. Advances in Accounting, 28(1), 168–178.

Shmueli, G., Patel, N. R., & Bruce, P. C. (2011). Data mining for business intelligence: Concepts, techniques, and applications in Microsoft Office Excel with XLMiner. John Wiley and Sons.

Singla, A., & Mallik, G. (2021). Determinants of financial literacy: Empirical evidence from micro and small enterprises in India. Asia Pacific Management Review. https://doi.org/10.1016/j.apmrv.2021.03.001

Sovaniski, T., & Mohd Ali, B. (2021). The Financial Statements Analysis. The Financial Statements Analysis (March 1, 2021).

Suwandi, A. N., Afriyeni, E., & Neswardi, S. (2020). Pencatatan Transaksi Dan Penyusunan Laporan Keuangan Berbasis Spreadsheet Pada Bengkel Dika Motor Kabupaten Agam. Menara Ilmu, 14(1).

Thampy, A. (2010). Financing of SME firms in India: interview with Ranjana Kumar, former CMD, Indian bank; vigilance commissioner, Central vigilance commission. IIMB Management Review, 22(3), 93-101. https://doi.org/10.1016/j.iimb.2010.04.011

Vivel-Búa, M., Lado-Sestayo, R., & Otero-González, L. (2019). Influence of firm characteristics and the environment on hotel survival across MSMES segments during the 2007–2015 period. Tourism Management, 75, 477-490. https://doi.org/10.1016/j.tourman.2019.06.015

Wegner, T. (2010). Applied business statistics: Methods and Excel-based applications. Juta and Company Ltd.

Wicaksono, A., Kartikasary, M., & Salma, N. (2020). Analyze Cloud Accounting Software Implementation and Security System for Accounting in MSMEs and Cloud Accounting Software Developer. 2020 International Conference on Information Management and Technology (ICIMTech), 538–543.

Wulanditya, P., & Aprillianita, R. (2018). The Development of Accounting Information System Based on Excel in Helping CV. Ladi Collection Preparing Their Financial Statement. JEMA: Jurnal Ilmiah Bidang Akuntansi Dan Manajemen, 15(1), 71–84.