DAFTAR ISI Hal. HALAMAN JUDUL .............................................................................................. i HALAMAN PENGESAHAN ............................................................................... ii HALAMAN PERNYATAAN .............................................................................. iii MOTTO ................................................................................................................ iv HALAMAN PERSEMBAHAN ............................................................................v ABSTRAK ............................................................................................................ vi ABSTARCT ......................................................................................................... vii KATA PENGANTAR ........................................................................................ viii DAFTAR ISI ...........................................................................................................x DAFTAR GAMBAR .......................................................................................... xiv DAFTAR TABEL .............................................................................................. xvi BAB I PENDAHULUAN .......................................................................................1 1.1 Latar Belakang Masalah .....................................................................................1 1.2 Rumusan Masalah ..............................................................................................2 1.3 Ruang Lingkup ...................................................................................................2 1.4 Tujuan Penelitian ...............................................................................................2 1.5 Manfaat Penelitian .............................................................................................3 1.6 Sistematika Penulisan ........................................................................................3 BAB II TINJAUAN PUSTAKA DAN DASAR TEORI .....................................5 2.1 Tinjauan Pustaka ................................................................................................5 2.2 Dasar Teori .........................................................................................................7 2.2.1 Sekilas Tentang Jogja Web Center ..........................................................7 2.2.2 Sistem Informasi ......................................................................................8 2.2.3 Akuntansi .................................................................................................8 2.2.4 Sistem Informasi Akuntansi ....................................................................8 2.2.5 Neraca ......................................................................................................9 2.2.6 Laporan Rugi Laba ..................................................................................9 2.2.7 Buku Besar...............................................................................................9 2.2.8 XAMPP ...................................................................................................9
x
2.2.9 Bahasa Pemrograman ..............................................................................9 2.2.10 MySQL ................................................................................................10 2.2.11 HTML 5 ...............................................................................................10 2.3 Metode Penelitian.............................................................................................10 2.3.1 Observasi ...............................................................................................10 2.3.2 Studi Pustaka .........................................................................................11 2.3.3 Peralatan ................................................................................................11 BAB III ANALISIS DAN PERANCANGAN SISTEM ....................................13 3.1. Analisis Sistem ................................................................................................13 3.1.1. Analisis Kebutuhan ...............................................................................13 1. Kebutuhan Input ....................................................................................13 2. Kebutuhan Output .................................................................................13 3. Kebutuhan Software ..............................................................................13 4. Kebutuhan Hardware ............................................................................14 3.2. Arsitektur Sistem.............................................................................................14 3.3. Perancangan Sistem ........................................................................................15 3.3.1. Diagaram Alir Data...............................................................................15 1. DFD Level 0 (Diagram Konteks) .........................................................16 2. DFD Level 1 ........................................................................................18 3.3.2. Rancangan Entitas Relationship Diagram ....................................................20 3.3.3. Rancangan Tabel ..........................................................................................21 1. Data Bag.Akuntansi .............................................................................21 2. Data Manager .......................................................................................21 3. Data Aktiva Lancar .............................................................................22 4. Data Aktiva Tetap ................................................................................22 5. Data Kewajiban ....................................................................................22 6. Data Ekuitas .........................................................................................23 7. Data Jasa...............................................................................................23 8. Data Biaya ............................................................................................23 9. Data Pendapatan Jasa ...........................................................................23 10. Data Pengeluaran ...............................................................................24 11. Data Pengambilan Prive .....................................................................24
xi
12. Data Transaksi Peralatan ....................................................................24 13. Data Utang .........................................................................................25 14. Data Bayar Utang ...............................................................................25 15. Data Jurnal .........................................................................................26 16. Data Neraca Saldo ..............................................................................26 17. Data Rugi Laba ..................................................................................26 18. Data Perubahan Modal .......................................................................27 3.3.4. Relasi Antar Tabel ................................................................................27 3.4. Rancangan Web ..............................................................................................28 3.4.1. Login .....................................................................................................29 3.4.2. Halaman Utama ....................................................................................29 3.4.3. Rancangan Masukan Aktiva Lancar .....................................................29 3.4.4. Rancangan Masukan Aktiva Tetap .......................................................30 3.4.5. Rancangan Masukan Kewajiban ..........................................................30 3.4.6. Rancangan Masukan Jasa .....................................................................31 3.4.7. Rancangan Masukan Biaya ..................................................................31 3.4.8. Rancangan Transaksi Pendapatan Jasa .................................................31 3.4.9. Rancangan Transaksi Pengeluaran .......................................................32 3.4.10. Rancangan Transaksi Peralatan ..........................................................32 3.4.11. Rancangan Transaksi Utang ...............................................................33 3.4.12. Rancangan Transaksi Bayar Utang .....................................................33 3.4.13. Rancangan Pengambilan Prive ...........................................................34 3.4.14. Rancangan Keluaran Aktiva Lancar ...................................................34 3.4.15. Rancangan Keluaran Aktiva Tetap .....................................................35 3.4.16. Rancangan Keluaran Kewajiban.........................................................35 3.4.17. Rancangan Keluaran Ekuitas ..............................................................35 3.4.18. Rancangan Keluaran Jasa ...................................................................35 3.4.19. Rancangan Keluaran Biaya.................................................................36 3.4.20. Rancangan Keluaran Jurnal ................................................................36 3.4.21. Rancangan Keluaran Buku Besar .......................................................36 3.4.22. Rancangan Keluaran Neraca Saldo ....................................................37 3.4.23. Rancangan Keluaran Rugi Laba .........................................................37
xii
3.4.24. Rancangan Keluaran Perubahan Modal..............................................38 3.4.25. Rancangan Keluaran Neraca...............................................................38 BAB IV IMPLEMENTASI SISTEM DAN PEMBAHASAN SISTEM ..........39 4.1. Implementasi Dan Uji Coba Sistem ................................................................39 4.1.1. Program Koneksi ke Database ..............................................................39 4.1.2. Program Login Bag.Akuntansi .............................................................40 4.1.3. Program Halaman Utama .....................................................................41 4.1.4. Program Simpan Aktiva Lancar ...........................................................41 4.1.5. Program Pendapatan Jasa .....................................................................42 4.1.6. Program Laporan Jurnal Umum ...........................................................42 4.2. Pembahasan Sistem .........................................................................................43 4.2.1. Proses Input Akun Aktiva Lancar ........................................................43 4.2.2. Proses Transaksi Pendapatan Jasa ........................................................43 4.2.3. Proses Transaksi Pengeluaran ..............................................................44 4.2.4. Laporan Jurnal Umum ..........................................................................44 4.2.5. Buku Besar............................................................................................45 4.2.6. Neraca Saldo ........................................................................................45 4.2.7. Laporan Rugi Laba ...............................................................................45 4.2.8. Laporan Perubahan Modal ....................................................................46 4.2.9. Neraca ...................................................................................................46
BAB V KESIMPULAN DAN SARAN ...............................................................47 5.1. Kesimpulan ....................................................................................................47 5.2. Saran ...............................................................................................................47 DAFTAR PUSTAKA ...........................................................................................48
xiii
DAFTAR GAMBAR Hal. Gambar 3.1. Arsitektur Sistem ...........................................................................15 Gambar 3.2. DFD Level 0 (Diagram Konteks) ...................................................16 Gambar 3.3. DFD Level 1 ...................................................................................18 Gambar 3.4. Rancangan ERD (Entity Relationship Diagram) ...........................20 Gambar 3.5. Relasi Antar Tabel ..........................................................................27 Gambar 3.6. Form Halaman Login .....................................................................29 Gambar 3.7. Halaman Utama ..............................................................................29 Gambar 3.8. Rancangan Form Masukan Aktiva Lancar .....................................30 Gambar 3.9. Rancangan Form Masukan Aktiva Tetap .......................................30 Gambar 3.10. Rancangan Form Masukan Kewajiban ...........................................30 Gambar 3.11. Rancangan Form Masukan Jasa ....................................................31 Gambar 3.12. Rancangan Masukan Biaya ............................................................31 Gambar 3.13. Rancangan Form Transaksi Pendapatan Jasa .................................32 Gambar 3.14. Rancangan Form Transaksi Pengeluaran .......................................32 Gambar 3.15. Rancangan Transaksi Peralatan ......................................................33 Gambar 3.16. Rancangan Transaksi Utang ...........................................................33 Gambar 3.17. Rancangan Form Transaksi Bayar Utang .......................................34 Gambar 3.18. Rancangan Form Pengambilan Prive .............................................34 Gambar 3.19. Rancangan Form Keluaran Aktiva Lancar ....................................34 Gambar 3.20. Rancangan Form Keluaran Aktiva Tetap .......................................35 Gambar 3.21. Rancangan Form Keluaran Kewajiban .........................................35 Gambar 3.22. Rancangan Form Keluaran Ekuitas ................................................35 Gambar 3.23. Rancangan Form Keluaran Jasa .....................................................35 Gambar 3.24. Rancangan Form Keluaran Biaya ..................................................36 Gambar 3.25. Rancangan Form Keluaran Jurnal .................................................36 Gambar 3.26. Rancangan Form Keluaran Buku Besar .........................................36 Gambar 3.27. Rancangan Form Keluaran Neraca Saldo ......................................37 Gambar 3.28. Rancangan Form Keluaran Rugi Laba ...........................................37 Gambar 3.29. Rancangan Form Keluaran Perubahan Modal ................................38
xiv
Gambar 3.30. Rancangan Form Keluaran Neraca .................................................38 Gambar 4.1. Implementasi Koneksi Database ..................................................38 Gambar 4.2. Program Login Bag.Akuntansi .....................................................40 Gambar 4.3. Program Halaman Utama ...............................................................41 Gambar 4.4. Potongan Script Program Simpan Aktiva Lancar ..........................41 Gambar 4.5. Potongan Script Program Pendapatan Jasa ...................................42 Gambar 4.6. Program Laporan Jurnal Umum .....................................................42 Gambar 4.7. Proses Input Akun Kas ...................................................................43 Gambar 4.8. Proses Transaksi Pendapatan Jasa ..................................................43 Gambar 4.9. Proses Transaksi Pengeluaran ........................................................44 Gambar 4.10. Laporan Jurnal Umum ....................................................................44 Gambar 4.11. Buku Besar .....................................................................................45 Gambar 4.12. Neraca Saldo ..................................................................................45 Gambar 4.13. Laporan Rugi Laba .........................................................................46 Gambar 4.14. Laporan Perubahan Modal .............................................................46 Gambar 4.15. Neraca .............................................................................................46
xv
DAFTAR TABEL Hal. Tabel 2.1.
Arsitektur Sistem ...............................................................................6
Tabel 3.1.
Struktur Tabel Bag.Akuntansi ..........................................................21
Tabel 3.2.
Struktur Tabel Manager .................................................................21
Tabel 3.3.
Struktur Tabel Aktiva Lancar ..........................................................22
Tabel 3.4.
Struktur Tabel Aktiva Tetap .............................................................22
Tabel 3.5.
Struktur Tabel Kewajiban ................................................................22
Tabel 3.6.
Struktur Tabel Ekuitas .....................................................................23
Tabel 3.7.
Struktur Tabel Jasa .........................................................................23
Tabel 3.8.
Struktur Tabel Biaya .........................................................................23
Tabel 3.9.
Struktur Tabel Pendapatan Jasa ........................................................23
Tabel 3.10. Struktur Tabel Pengeluaran ..............................................................24 Tabel 3.11. Struktur Tabel Prive ..........................................................................24 Tabel 3.12. Struktur Tabel Peralatan ................................................................25 Tabel 3.13. Struktur Tabel Utang ......................................................................25 Tabel 3.14. Struktur Tabel Bayar ......................................................................25 Tabel 3.15. Struktur Tabel Jurnal .....................................................................26 Tabel 3.16. Struktur Tabel Neraca Saldo ...........................................................26 Tabel 3.17. Struktur Tabel Rugi Laba .................................................................26 Tabel 3.18. Struktur Tabel Perubahan Modal ......................................................27 Tabel 3.19. Struktur Tabel Manager .................................................................21
xvi