Optimalisasi Pencatatan E-commerce pada Perusahaan: Input Data Google Sheets

Authors

  • Syarifah Nadia Universitas Nahdlatul Ulama Sidoarjo
  • Chairil Anwar Universitas Nahdlatul Ulama Sidoarjo

DOI:

https://doi.org/10.54066/jkb.v2i4.2649

Keywords:

Google Sheets, Finansial, E-commerce

Abstract

This service aims to optimize e-commerce sales recording on the Shopee platform using Google Sheets. The problem faced by companies is the difficulty in managing transaction recording manually which is often time consuming and prone to errors. Service is carried out through field work practice at PT Aliyan Jaya Perkasa. The service results show that integrating Shopee sales data into Google Sheets can increase efficiency and accuracy in managing sales data in real-time. The contribution of this service lies in developing a more structured digital recording process for small and medium businesses.

References

Akbar, M. N., & Ariesta, A. (2021). E-commerce based digital marketing using business model canvas. Inform: Jurnal Ilmiah Bidang Teknologi Informasi Dan Komunikasi, 6(2), 127–132. https://doi.org/10.25139/inform.v6i2.3985

Anjarwati, S., Zaena, R. R., Fitrianingsih, D., & Sulistiana, I. (2023). Pengaruh digitalisasi akuntansi terhadap efisiensi dan pengurangan biaya pada perusahaan wirausaha UMKM di Kota Bandung. Jurnal Aktiva: Riset Akuntansi Dan Keuangan, 5(1), 43–58. https://doi.org/10.52005/aktiva.v5i1.181

Darmayasa, I. N., & Kumontoy, M. (2022). Optimizing income tax and value added tax on e-commerce transaction. Proceedings of the First Lekantara Annual Conference on Public Administration, Literature, Social Sciences, Humanities, and Education, LePALISSHE 2021, August 3, 2021, Malang, Indonesia. https://doi.org/10.4108/eai.3-8-2021.2315147

Dharmawan, W. (2023). Penerapan sistem informasi akuntansi pengelolaan keuangan berbasis website. Jurnal Sistem Informasi Akuntansi, 4(1), 74–83. https://doi.org/10.31294/justian.v4i1.1952

Erstiawan, M. S., Candraningrat, & Wibowo, J. (2021). Efektivitas strategi pemasaran dan manajemen keuangan pada UMKM roti. DIKEMAS (Jurnal Pengabdian Kepada Masyarakat), 5(1), 105–110.

Faris, M., & Ratnawat, S. (2023). Analisis pengalaman pengguna pada aplikasi Tokopedia dengan menggunakan metode user experience questionnaire (UEQ). Jurnal Perangkat Lunak, 5(2), 210–216. https://doi.org/10.32520/jupel.v5i2.2629

Fauzi, Rahmayana, L., Wulandari, I., & Sugiharto, B. H. (2023). Mengapa digitalisasi akuntasi harus dilakukan pada perusahaan UMKM: Sebuah tinjauan pustaka. Jurnal Aktiva: Riset Akuntansi Dan Keuangan, 5(1), 43–56. https://doi.org/10.52005/aktiva.v5i1.179

Gao, J., Siddik, A. B., Khawar Abbas, S., Hamayun, M., Masukujjaman, M., & Alam, S. S. (2023). Impact of e-commerce and digital marketing adoption on the financial and sustainability performance of MSMEs during the COVID-19 pandemic: An empirical study. Sustainability (Switzerland), 15(2). https://doi.org/10.3390/su15021594

Hidayatuloh, S., Kusumaningtyas, R. H., & Aziati, Y. (2021). Analisis pengaruh user experience terhadap kepuasan pengguna mobile application e-commerce Shopee menggunakan model Delone & McLean. Applied Information System and Management (AISM), 2(2). https://doi.org/10.15408/aism.v2i2.20159

Kartikasari, N., Ambarwati, R., & Pebrianggara, A. (2023). Marketing content analysis of Korean drama streaming platforms: Social network analysis on Twitter. Budapest International Research and Critics Institute (BIRCI-Journal). https://doi.org/10.33258/birci.v6i2.7561

Kusuma, C. S. D., Faradilla, C., Augustinah, F., Haryati, T., Seseli, E. M. I., Panggabean, E. P. A., Ubjaan, J., Sarwani, S., Bagenda, C., Witi, F. L., Khudori, A. N., Grace, E., Fauziah, F., Albab, U., Lesnussa, J. U., Girsang, R. M., & Rosharita, R. (2024). E-commerce: Suatu pengantar bisnis digital (A. Setyawati & A. Sudirman, Eds.). Eureka Media Aksara.

Mashuri, A. A. S., & Ermaya, H. N. L. (2021). Peningkatan kualitas penyusunan laporan keuangan manual menjadi digitalisasi akuntansi sederhana pada pelaku UMKM di Kabupaten Serang. Jurnal Bakti Masyarakat Indonesia, 4(1). https://doi.org/10.24912/jbmi.v4i1.9501

Nuryahya, E., Ichsana, Y., & Andini, K. M. (2019). Perilaku pengguna sistem informasi akuntansi e-commerce. Jurnal Akuntansi Multiparadigma, 10(3). https://doi.org/10.21776/ub.jamal.2019.10.3.29

Saputra, M., Rahmadani, A., Elvina, A., & Fahlefi, R. (2023). Dampak e-commerce terhadap pendapatan pedagang sandang di Pasar Batusangkar. TAMWIL, 9(2), 101. https://doi.org/10.31958/jtm.v9i2.11017

Ummah, M. S. (2019). Resume: Instrumen pengumpulan data. Sustainability (Switzerland), 11(1), 1–14. http://scioteca.caf.com/bitstream/handle/123456789/1091/RED2017-Eng-8ene.pdf?sequence=12&isAllowed=y%0Ahttp://dx.doi.org/10.1016/j.regsciurbeco.2008.06.005%0Ahttps://www.researchgate.net/publication/305320484_SISTEM_PEMBETUNGAN_TERPUSAT_STRATEGI_MELESTARI

Widyastuti, L. Y., Maulana, H., Erik, E., Izzah, K. A., & Azzahra, Y. C. (2023). Perluasan potensi pasar produk lokal dengan e-commerce pada pelaku usaha mikro, kecil, dan menengah (UMKM). Jurnal Pembelajaran Pemberdayaan Masyarakat (JP2M), 4(2), 376–389. https://doi.org/10.33474/jp2m.v4i2.20279

Zubaidah, T. R., Wadhah, A. N., & Muzakki, K. (2024). Optimalisasi pembudayaan pengelolaan keuangan UMKM melalui pendekatan akuntansi. Nusantara Entrepreneurship and Management Review, 2(1), 41–47. https://doi.org/10.55732/nemr.v2i1.1259

Downloads

Published

2024-11-12

How to Cite

Syarifah Nadia, & Chairil Anwar. (2024). Optimalisasi Pencatatan E-commerce pada Perusahaan: Input Data Google Sheets. Jurnal Kabar Masyarakat, 2(4), 189–197. https://doi.org/10.54066/jkb.v2i4.2649