The Development Of Accounting Information System Based On Excel In Helping CV. Ladi Collection Preparing Their Financial Statement

Authors

  • Putri Wulanditya STIE Perbanas Surabaya
  • Riski Aprillianita STIE Perbanas Surabaya

DOI:

https://doi.org/10.31106/jema.v15i01.778

Keywords:

Accounting Recording, Production Cost, Microenterprises

Abstract

Microenterprises in Indonesia is showing increasing progress, especially the printing industry. This study wanted to know what is the description of printing business cycle, accounting records on financial transactions, calculation of production costs and operating income. Research method used is study case at CV. Ladi Collection through field observation, interview, and documentation. Data analysis technique used is qualitative descriptive. From study result in CV. Ladi Collection, there are 2 types of business namely screen printing and school badge production. Accounting recording has been done but only limited to Accounts Receivable Bookkeeping. Many of cash receipts transactions from cash sales are derived from screen printing orders and expenditures were not stored and recorded. Solution on production costs calculation for CV. Ladi Collection is using job order costing for screen printing service and job product costing for badge production. This research also produces Excel design For Accounting (EFA), which consists of 7 sheets of the navigation sheet, beginning balance, journal, ledger, income statement, financial position statement, and depreciation.

References

Anjarsari, Destanti Puspita. (2015). Aplikasi Penentuan Harga Pokok Produksi dengan Menggunakan Metode Process Costing (Studi kasus: ABC). Retrieved from goo.gl/HQ5o6j.

Carter, William K. (2009). Akuntansi Biaya. Jakarta: Salemba Empat.

Dewi, Adityas Widayani. (2014). Peluang Bisnis Dalam Usaha Percetakan. Retrieved from goo.g;/76Sd5h.

Harahap, Sofyan Syafri. (2011). Teori Akuntansi. Jakarta: PT. Raja Grafindo.

Hery. (2008). Pengantar Akuntansi I. Jakarta: Lembaga Penerbit Fakultas Ekonomi Universitas Indonesia.

Ikatan Akuntan Indonesia (IAI). (2009). Standar Akuntansi Keuangan Entitas Tanpa Akuntabilitas Publik. Jakarta: Ikatan Akuntan Indonesia.

Ilham & Sudarno. (2013). Penentuan Harga Pokok Produksi Percetakan Sablon “OTAKKANAN Production†di Yogyakarta. Diponegoro Journal of Accounting 2(2): 1-14.

Latifa & Utami, Tri. (2011). Analisis Perhitungan Harga Pokok Produksi pada CV. Abadi Jaya. Skripsi. Politeknik Palcom Tech Palembang.

Lasena, Sitty Rahmi. (2013). Penentuan Harga Pokok Produksi pada PT. Dimembe Nyiur Agipro. Jurnal EMBA 1(3) : 585-592.

Martani, Dwi, Siregar, Sylvia Veronika NP., Wardani, Ratna; Farahmita, Aria, Tanudjaja, Edward; Hidayat, Taufik. (2012). Akuntansi Keuangan Menengah Berbasis PSAK. Jakarta: Salemba Empat.

Mayes, Timothy R & Shank, Todd M. (2011). Financial Analysis with Microsoft Excel (6th ed). South-Western: Cengange Learning.

Nurmala Ahmar & Iwan Tri Tjahjono. (2011). Excel for Accounting: Panduan Praktis Menyusun Laporan Keuangan Perusahaan dengan Microsoft Excel. Surabaya: STIE Perbanas Press.

Putra, Hermon Adhy & Kurniawan, Elizabeth Penti. (2012). Penyusunan Laporan Keuangan untuk Usaha Kecil dan Menengah (UKM) Berbasis Standar Akuntansi Keuangan Entitas Tanpa Akuntabilitas Publik (SAK ETAP). Skripsi. Universitas Kristen Satya Wacana, Salatiga.

Rachman, Noorhayati. (2016). Analisis Perhitungan Harga Pokok Produksi Percetakan Sablon Dengan Menggunakan Metode Full Costing pada CV. ATR Borneo Mandiri di Balikpapan. eJournal Adminisrasi Bisnis, 4(3) : 826-840.

Republik Indonesia. UU No. 20 Tahun 2008 tentang Usaha Mikro Kecil Menengah.

Rodhiyah. (2013). Kajian tentang Akuntabilitas Usaha Kecil Menengah melalui Laporan Keuangan (Studi Kasus pada UKM Konveksi di Semarang). Retrieved from http://core.ac.uk/download/files/379/11737509.pdf.

Rofiq, Aunur. (2015). Strategi UKM Hadapi MEA – Sektor Riil. Retrieved from http://economy.okezone.com/read/2016/01/14/320/1288073/strategi-UMKM-hadapi-mea.

Romney, M.B. & Steinbart, P.J. (2015). Accounting Information System (13th edition). New Jersey: Pearson Education, Inc.

Setiadi, Pradana; Saerang, David P.E., & Runtu, Treesje. (2014). Perhitungan Harga Pokok Produksi dalam Penentuan Harga Jual pada CV. Minahasa Mantap Perkasa. Jurnal Berkala Ilmiah Efisiensi, 14(2).

Setyobudi, Andang. (2007). Peran Serta Bank Indonesia Dalam Pengembangan Usaha Mikro, Kecil, dan Menengah (UMKM). Buletin Hukum Perbankan dan Kebanksentralan, 5(2): 29-35.

Setyorini, Dhyah, Istiningrum, Andian Ari, Nugroho, Mahendra Adhi, & Sagoro, Endra Murti . (2012). Pelatihan Akuntansi UMKM bagi Usaha Mikro Kecil Menengah (UMKM) untuk Meningkatkan Kinerja Keuangan Perusahaan. Laporan Kegiatan Pengabdian Masyarakat. Universitas Negeri Yogyakarta, Yogyakarta.

Triandi and Stephanie, Thresia. (2010). Penerapan Proses Akuntansi Menggunakan Microsoft Excel dalam Penyusunan Laporan Keuangan pada Perusahaan Sinar Harapan. Jurnal Ilmiah Ranggading, 10(2): 113-120.

Yin, Robert K. (2008). Case Study Research: Design and Methods (Applied Social Research Methods). Illinois: Sage Publications, Inc.

Yudha, Ahmad Nur Al. (2014). Analisis Penentuan Harga Pokok Produksi Percetakan dengan Menggunakan Metode Full Costing pada CV. Global Sejahtera. Retrieved from goo.gl/zpJ5nj.

Downloads

Published

2018-01-16

How to Cite

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. https://doi.org/10.31106/jema.v15i01.778