Pengolahan dan Visualisasi Data Kinerja Keuangan Badan Usaha Milik Daerah (BUMD) Provinsi Sumatera Selatan Menggunakan Microsoft Excel Processing and Visualization of Financial Performance Data of Regional Government-Owned Enterprises (BUMD) in South Sumatra Province Using Microsoft Excel
Article Sidebar
Page Numbers:
2758-2774
Digital Object Identifier:
10.58578/masaliq.v6i5.11928
Viewed: 0 times
Downloaded: 0 times
LYAS Publisher cordially invites qualified professionals to serve as Editors or Reviewers. Your expertise will make an important contribution to maintaining and strengthening the academic quality of our publications. Interested applicants are kindly requested to complete the application form at the following link: Editors & Reviewers
Please feel free to contact us if you need any further information about the submission process or if you have any additional questions.
Authors:Agung Setia Budi1*, Rezania Agramanisti Azdy2
Copyright :Authors retain copyright and grant the journal right of first publication.
Main Article Content
Abstract
The financial performance of regional-owned enterprises (BUMDs) in South Sumatra Province needs to be systematically monitored and evaluated to support development, oversight, and data-driven policymaking. This study aimed to process and analyze the financial performance data of BUMDs in South Sumatra Province based on the return on assets (ROA) indicator and to present the results through data visualizations and a monitoring dashboard. The study employed a quantitative approach to analyze the financial data of nine BUMDs during the 2020–2025 period. Data comprising total assets, net income, operating income, equity, and dividends contributed to Regional Own-Source Revenue (PAD) were collected, validated, processed, and analyzed using Microsoft Excel. ROA values were calculated and presented in summary tables, charts, conditional formatting, and a dashboard prototype. The results showed that ROA performance varied substantially across BUMDs and years. Based on average ROA, five BUMDs were classified as very good, one as good, one as fairly good, and one as poor, while one BUMD could not be comprehensively evaluated because of limited data. Bank Sumsel Babel demonstrated the most stable performance and accounted for more than 95% of the total contribution of BUMD dividends to PAD, while JAMKRIDA and PT Tirta Sriwijaya Maju demonstrated the highest levels of profitability. This study concludes that Microsoft Excel is effective for processing and visualizing BUMD financial performance data. These findings imply the need for data-driven BUMD development, greater selectivity in capital participation, and strengthened transparency and accountability in BUMD management by regional governments.
Citation Metrics:
Downloads
Citation Metrics & Similar Scopus Articles
-
Gong X. (2027)Wearable Electronics for Precision Diagnosis Through Advanced Manufacturing and IntegrationNano Micro Letters, 19(1)
-
Mostafavi P. (2027)Copular Verbs Typology in KhalajLanguage Related Research, 17(4), 293-329
-
Davoodi A. (2027)A Reflection on The Moral Virtues And Vices Described in Nahj al-Balāghah in The Light of Image SchemasLanguage Related Research, 17(4), 103-137
Article Details
Authors retain copyright and grant the journal right of first publication with the work simultaneously licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International License that allows others to share the work with an acknowledgement of the work's authorship and initial publication in this journal.
References
Abdullah, M. I., Sudirman, Masdar, R., Din, M., & Firman, M. F. (2022). Antecedents of the accountability in Indonesian local government financial reporting. International Journal of Professional Business Review, 7(5), Article e0709. https://doi.org/10.26668/businessreview/2022.v7i5.e709
Almaqfira, A., Alimuddin, I. I., & Amir, A. M. (2023). Financial performance analysis and review of profitability ratios at the BUMDes Cahaya Makmur. KEUDA: Jurnal Kajian Ekonomi dan Keuangan Daerah, 8(2), 134–163. https://doi.org/10.52062/keuda.v8i2.2781
Asyifa, N. L., Radiyanti, R., & Rahmat, A. (2026). Analisis kinerja keuangan PDAM Tirta Rangga Subang (BUMD) Jawa Barat periode 2020–2024 dengan pendekatan deskriptif kuantitatif. Land Journal, 7(1), 102–115. https://doi.org/10.47491/landjournal.v7i1.4564
Badewin, Elizabeth, R., Rusmardiana, A., Rely, G., & Judijanto, L. (2025). Accountability and transparency in local government financial reporting: An empirical study in Indonesia. Jurnal Ilmiah Akuntansi Kesatuan, 13(4), 831–842. https://doi.org/10.37641/jiakes.v13i4.3642
Diah, A. M., Hasiara, L. O., Lesmana, D., Raharjo, S., Aprianti, Y., & Yudaruddin, R. (2026). Information technology capability and financial reporting quality in local governments: The mediating role of accounting information system quality. Cogent Business & Management, 13(1), Article 2654816. https://doi.org/10.1080/23311975.2026.2654816
Ermiani, E., Arifia, S., & Halim, M. A. (2026). Financial performance of regional-owned enterprises (BUMD) in Bogor Regency, 2020–2024: A longitudinal study of assets, equity, and contributions to regional original revenue. Strata Business Review, 4(1), 71–81. https://doi.org/10.59631/sbr.v4i1.504
Fana, W. S., Sovia, R., Permana, R., & Islam, M. A. (2021). Data warehouse design with ETL method (extract, transform, and load) for company information centre. International Journal of Artificial Intelligence Research, 5(2), 132–137. https://doi.org/10.29099/ijair.v5i2.215
Ferza, R., & Lee, D. S. (2026). Online accessibility of local public enterprise financial statements in Indonesia: Can it be predicted by institutional traits of parent local governments? Public Administration and Development, 46(1), 7–20. https://doi.org/10.1002/pad.70025
Homan, H. S., & Susanto, S. (2025). Asset structure and business orientation of regional government-owned enterprises (BUMD) in Indonesia: Evidence from correspondence analysis. Review of Accounting and Business, 5(2), 72–86. https://doi.org/10.52250/reas.v5i2.1078
Iskandar, A. R., Junaidi, A., & Herman, A. (2019). Extract, transform, load sebagai upaya pembangunan data warehouse. Journal of Informatics and Communication Technology (JICT), 1(1), 25–35. https://doi.org/10.52661/j_ict.v1i1.21
Maharani, P. A., Lailia, W. N., Salbiyah, M., & Alfiana, A. (2026). Analisis pengaruh net profit margin (NPM) dan total assets turnover (TATO) terhadap return on assets (ROA) pada perusahaan industri logam dan mineral yang terdaftar di BEI. Indonesia Economic Journal, 2(1), 539–547. https://doi.org/10.63822/0p7mg445
Nurullah, A., Gozali, E. O. D., Hamzah, R. S., Bakti, H., Khasman, R., & Maharani, M. A. (2024). An assessment of banking sector performance in Indonesia. International Journal of Financial, Accounting, and Management, 5(4), 421–431. https://doi.org/10.35912/ijfam.v5i4.1452
Nuswantoro, M. A., & Rahmawati, E. (2025). Exploring financial reporting quality: Evidence from Indonesian local governments. Journal of Accounting and Investment, 26(3), 987–1009. https://doi.org/10.18196/jai.v26i3.27667
Prasetia, I. P. W., & Kurniawan, I. N. H. (2021). Data warehouse implementasi ETL (extract, transform, load) pada data warehouse penjualan menggunakan tools Pentaho. TIERS Information Technology Journal, 2(1), 39–47. https://doi.org/10.38043/tiers.v2i1.2844
Putri, A. R., & Sadad, A. (2025). Akuntabilitas pengelolaan aset oleh Pemerintah Provinsi Riau (studi kasus PT Pengembangan Investasi Riau). Nusantara: Jurnal Ilmu Pengetahuan Sosial, 12(3), 854–861. https://doi.org/10.31604/jips.v12i3.2025.854-861
Saleh, N. A. R., & Masyhuri, M. (2026). Analisis penggunaan Microsoft Excel dalam penyusunan laporan keuangan pada sistem akuntansi digital. Ascendia: Journal of Economic and Business Advancement, 1(4), 155–163. https://doi.org/10.65310/d6x5rg24
Sazly, S., Kusumaningrum, A., Herlan, H., Prana, I., Dewi, I. K., & Yulianto, A. R. (2023). State and regional owned enterprises: Head-to-head financial performance comparison at the years of 2017–2021. Dynamic Management Journal, 7(4), 744–753. https://doi.org/10.31000/dmj.v7i4.9949
Septiyani, Mutmainah, I., & Yulia, I. A. (2022). Analisis rasio keuangan untuk menilai kinerja keuangan pada bank BUMD yang terdaftar di BEI: Financial ratio analysis to assess financial performance in BUMD banks listed in BEI. Prospek: Jurnal Manajemen dan Bisnis, 3(2), 39–46. https://doi.org/10.31938/jp.v3i2.711
Sugini, S., & Yudhanegara, F. (2026). Analisis pengelolaan data keuangan klien menggunakan Microsoft Excel pada Kantor Konsultan Keuangan Artcounting. Jejak Digital: Jurnal Ilmiah Multidisiplin, 2(4), 6690–6699. https://doi.org/10.63822/fpmjbd62
Trityagita, A., Teturan, Y. E., & Maturbongs, E. E. (2025). Analisis pengelolaan aset daerah pada Badan Pengelola Keuangan dan Aset Daerah Kabupaten Merauke. Musamus Journal of Public Administration, 8(1), 1–7. https://doi.org/10.35724/mjpa.v8i1.7063