ABSTRAK Pada saat ini setiap perusahaan membutuhkan akuntansi untuk mencatat keuangan pada setiap transaksi. Transaksi yang telah dilakukan di bukukan yang kemudian diproses untuk dijadikan laporan keuangan perusahaan. Urutan dalam pembuatan laporan keuangan,pertama-tama proses pencatatan transaksi sesuai dengan akuntansi. Kemudian proses pengecekan kembali catatan akutansi, Jika terjadi kesalahan maka dapat dilakukan jurnal pembalik atau jurnal penyesuaian untuk memperbaiki kesalahan pencatatan yang sudah dilakukan. Setelah pengecekan maka dibuat buku besar dan neraca lajur. Berikutnya pembuatan laporan per bulan berdasarkan neraca lajur yang ada, contoh laporan yang dibuat adalah laporan labarugi, laporan neraca, laporan pajak internal perusahan, dan sebagainya. Setelah dibuat laporan maka jurnal tersebut harus ditutup agar tidak terjadi pencatatan ulang kembali. Proses pembuatan laporan keuangan ini hanya salah satu contoh dari banyak contoh Proses pembuatan laporan keuangan. Kata kunci : Akuntansi
vii
ABSTRACT At this time every company needs accounting for financial records on each transaction. Transactions that have been performed are recorded are then processed to be used as the company's financial statements. Step in financial reporting, First, process of recording transactions in accordance with accounting. Then process of re-checking accounting records, if something goes wrong it can be done reversing entries or adjusting entries to correct errors that have been done recording. Next, upon checking ledger and then created a work sheet. Next preparation of reports per month based on an existing work sheet, examples of statements made are labarugi statements, balance sheets, statements of internal corporate taxes, and so on. After having made the report to the journal must be closed in order to avoid recording over again. This financial reporting process is just one example of many examples of financial reporting process. Password: accounting
viii
DAFTAR ISI
PERNYATAAN ORISINALITAS LAPORAN PENELITIAN ............................... ii PERNYATAAN PUBLIKASI LAPORAN PENELITIAN ................................... iii PRAKATA ....................................................................................................... v ABSTRAK ...................................................................................................... vii ABSTRACT ................................................................................................... viii DAFTAR ISI .................................................................................................... ix DAFTAR GAMBAR ....................................................................................... xiv DAFTAR TABEL ......................................................................................... xviii DAFTAR NOTASI/ LAMBANG ....................................................................... xx DAFTAR SINGKATAN ................................................................................. xxii DAFTAR ISTILAH ....................................................................................... xxiii BAB 1.
PENDAHULUAN ............................................................................ 1 Latar Belakang Masalah .................................................................... 1 Rumusan Masalah ............................................................................. 1 Tujuan Pembahasan .......................................................................... 2 Ruang Lingkup Kajian ........................................................................ 2
1.4.1
Ruang Lingkup Software............................................................. 2
1.4.2
Ruang Lingkup Hardware ........................................................... 2
1.4.3
Ruang Lingkup Permasalahan .................................................... 3
Sumber Data ...................................................................................... 3 Sistematika Penyajian........................................................................ 3 BAB 2.
KAJIAN TEORI ............................................................................... 5 Akuntansi ........................................................................................... 5 Flowchart ......................................................................................... 10 Entitiy Relation Diagram (ERD) ....................................................... 11 Data Flow Diagram (DFD) ............................................................... 12
2.4.1
Kamus Data .............................................................................. 12 ix
2.4.2
PSPEC...................................................................................... 13
Delphi............................................................................................... 14 Firebird............................................................................................. 14 Black Box Testing ............................................................................ 14 BAB 3.
ANALISIS DAN RANCANGAN SISTEM ....................................... 16 Proses Bisnis ................................................................................... 16
3.1.1
Flowchart .................................................................................. 17
Entitas Relasi Diagram (ERD) ......................................................... 18 3.3
DFD ................................................................................................. 19
3.3.1
DFD Level 0 .............................................................................. 19
3.3.2
DFD Level 1 .............................................................................. 19
3.3.3
DFD Level 2 .............................................................................. 21
3.3.4
DFD Level 3 .............................................................................. 24
3.4
Kamus Data ..................................................................................... 24
3.4.1
Data jenis Akuntansi ................................................................. 24
3.4.2
Data Kodeakun ......................................................................... 25
3.4.3
Data transaksi ........................................................................... 26
3.4.4
Data penyesuaian ..................................................................... 26
3.4.5
Data Bukubesar ........................................................................ 27
3.4.6
Data Penutup ............................................................................ 28
3.4.7
Data Pengaturan ....................................................................... 29
3.5
PSPEC............................................................................................. 29
3.5.1
Tambah Jenis Akuntansi........................................................... 29
3.5.2
Ubah Jenis Akuntansi ............................................................... 30
3.5.3
Hapus Jenis Akuntansi ............................................................. 31
3.5.4
Tambah Kode Akuntansi........................................................... 32
3.5.5
Ubah Kode Akuntansi ............................................................... 33
3.5.6
Hapus Kode Akuntansi ............................................................. 34
3.5.7
Tambah Transaksi .................................................................... 35
3.5.8
Hapus Transaksi ....................................................................... 35 x
3.5.9
Simpan Transaksi ..................................................................... 36
3.5.10 Print Jurnal Umum .................................................................... 37 3.5.11 Tambah Penyesuaian ............................................................... 38 3.5.12 Hapus Penyesuaian .................................................................. 39 3.5.13 Simpan Penyesuaian ................................................................ 40 3.5.14 Print Bukubesar ........................................................................ 41 3.5.15 Print Labarugi ........................................................................... 41 3.5.16 Print Neraca .............................................................................. 42 3.5.17 Print Perubahan Modal ............................................................. 43 3.5.18 Print Pajak ................................................................................ 43 3.5.19 Tambah Jurnal Penutup............................................................ 44 3.5.20 Hapus Jurnal Penutup .............................................................. 45 3.5.21 Simpan Jurnal Penutup............................................................. 46 3.5.22 Ubah Pengaturan ...................................................................... 47 Rancangan Sistem .......................................................................... 48 3.6.1
Rancangan Tampilan Menu Utama .......................................... 48
3.6.2
Rancangan Tampilan Jenis Akuntansi ...................................... 48
3.6.3
Rancangan Tampilan Kode Akuntansi ...................................... 49
3.6.4
Rancangan Tampilan Transaksi ............................................... 50
3.6.5
Rancangan Tampilan Penyesuaian .......................................... 51
3.6.6
Rancangan Tampilan Neraca Lajur .......................................... 52
3.6.7
Rancangan Tampilan Penutup ................................................. 53
3.6.8
Rancangan Tampilan Pengaturan ............................................ 53
BAB 4.
HASIL PENELITIAN ..................................................................... 55 User Interface Menu Utama ............................................................. 55
4.1.1
File ............................................................................................ 55
4.1.2
Jurnal ........................................................................................ 56
4.1.3
Laporan..................................................................................... 56
User Interface Jenis Akuntansi ........................................................ 57 4.2.1
User Interface Tambah Jenis Akuntansi ................................... 57 xi
4.2.2
User Interface Ubah Jenis Akuntansi ........................................ 60
4.2.3
User Interface Hapus Jenis Akuntansi ...................................... 62
4.2.4
User Interface Cari Jenis Akuntansi .......................................... 64
User Interface Kode Akuntansi ........................................................ 65 4.3.1
User Interface Tambah Kode Akuntansi ................................... 66
4.3.2
User Interface Ubah Kode Akuntansi ........................................ 69
4.3.3
User Interface Hapus Kode Akuntansi ...................................... 72
4.3.4
User Interface Cari Kode Akuntansi .......................................... 74
User Interface Transaksi .................................................................. 75 4.4.1
User Interface Tambah Transaksi ............................................. 76
4.4.2
User Interface Hapus Transaksi ............................................... 77
4.4.3
User Interface Simpan Transaksi .............................................. 80
User Interface Penyesuaian............................................................. 82 4.5.1
User Interface Tambah Penyesuaian ....................................... 82
4.5.2
User Interface Hapus Penyesuaian .......................................... 84
4.5.3
User Interface Simpan Penyesuaian ........................................ 86
User Interface Jurnal Umum ............................................................ 87 User Interface Neraca Saldo............................................................ 89 User Interface Neraca Lajur ............................................................. 91 User Interface Penutup .................................................................... 92 4.9.1
User Interface Tambah Penutup ............................................... 92
4.9.2
User Interface Hapus Transaksi ............................................... 93
4.9.3
User Interface Simpan Transaksi .............................................. 93 User Interface Pengaturan............................................................ 94
BAB 5.
PEMBAHASAN DAN UJI COBA HASIL PENELITIAN ................. 96 Blackbox Testing ............................................................................. 96
5.1.1.
Pengujian Halaman Menu Utama ............................................. 96
5.1.2.
Pengujian Halaman Jenis Akuntansi ........................................ 96
5.1.3.
Pengujian Halaman Kode Akuntansi ........................................ 97
5.1.4.
Pengujian Halaman Transaksi .................................................. 97 xii
5.1.5.
Pengujian Halaman Jurnal Umum ............................................ 98
5.1.6.
Pengujian Halaman Neraca Saldo ............................................ 98
5.1.7.
Pengujian Halaman Penyesuaian ............................................. 99
5.1.8.
Pengujian Halaman Neraca Lajur ........................................... 100
5.1.9.
Pengujian Halaman Penutup .................................................. 100
5.1.10. Pengujian Halaman Pengaturan ............................................. 101 BAB 6.
SIMPULAN DAN SARAN ........................................................... 102 Simpulan ........................................................................................ 102 Saran ............................................................................................. 102
DAFTAR PUSTAKA .................................................................................... 103
xiii
DAFTAR GAMBAR
Gambar 2.1 Jurnal Umum Akuntansi (Buku Ekonomi 2 Kelas XI SMA dan MA 2009 hal.278) .................................................................................................. 6 Gambar 2.2 Contoh Buku besar (Buku Ekonomi 2 Kelas XI SMA dan MA 2009 hal.283) ........................................................................................................... 7 Gambar 2.3 contoh Neraca lajur (Buku Ekonomi 2 Kelas XI SMA dan MA 2009 hal.294) ........................................................................................................... 8 Gambar 2.4 Contoh Laporan Laba/ Rugi (Buku Ekonomi 2 Kelas XI SMA dan MA 2009 hal.314)............................................................................................ 9 Gambar 2.5 Contoh Laporan Perubahan Modal (Buku Ekonomi 2 Kelas XI SMA dan MA 2009 hal.315) ............................................................................ 9 Gambar 2.6 Contoh Laporan Neraca (Buku Ekonomi 2 Kelas XI SMA dan MA 2009 hal.316-317) ......................................................................................... 10 Gambar 3.1 Flowchart akuntansi hotel ......................................................... 17 Gambar 3.2 ERD akuntansi hotel ................................................................. 18 Gambar 3.3 DFD level 0 ............................................................................... 19 Gambar 3.4 DFD level 1 ............................................................................... 20 Gambar 3.6 DFD level 2 Jenis akuntansi ...................................................... 21 Gambar 3.7 DFD level 2 Kode akuntansi ...................................................... 21 Gambar 3.8 DFD level 2 Transaksi ............................................................... 22 Gambar 3.9 DFD level 2 Penyesuaian .......................................................... 22 Gambar 3.10 DFD level 2 Buku besar .......................................................... 23 Gambar 3.11 DFD level 2 Penutup ............................................................... 23 Gambar 3.12 DFD level 2 Pengaturan .......................................................... 23 Gambar 3.13 DFD level 3 Laporan Buku besar ............................................ 24 Gambar 3.14 Tampilan Menu Utama ............................................................ 48 Gambar 3.15 tampilan Jenis Akuntansi ........................................................ 49 Gambar 3.16 Tampilan Kode Akuntansi ....................................................... 50 xiv
Gambar 3.17 Tampilan transaksi .................................................................. 51 Gambar 3.18 tampilan penyesuaian ............................................................. 52 Gambar 3.19 tampilan Buku besar ............................................................... 52 Gambar 3.20 Tampilan Jurnal Penutup ........................................................ 53 Gambar 3.21 tampilan pengaturan ............................................................... 54 Gambar 4.1 Tampilan Menu Utama .............................................................. 55 Gambar 4.2 Tampilan sub-menu File............................................................ 56 Gambar 4.3 Tampilan sub-menu Jurnal........................................................ 56 Gambar 4.4 Tampilan sub-menu Laporan .................................................... 57 Gambar 4.5 Tampilan Jenis Akuntansi ......................................................... 57 Gambar 4.6 Tampilan Tambah Jenis Akuntansi ........................................... 58 Gambar 4.7 Tampilan Pesan Kesalahan null Tambah Jenis Akuntansi ........ 59 Gambar 4.8 Tampilan Pesan Kesalahan ID Jenis Akuntansi ........................ 59 Gambar 4.9 Tampilan Pesan Kesalahan Nama Jenis Akuntansi .................. 60 Gambar 4.10 Tampilan Pesan Berhasil Tambah Jenis Akuntansi ............... 60 Gambar 4.11 Tampilan Ubah Jenis Akuntansi .............................................. 61 Gambar 4.12 Tampilan Pesan kesalahan Nama Jenis Akuntansi ................ 62 Gambar 4.13 Tampilan Pesan Berhasil Ubah Jenis Akuntansi ..................... 62 Gambar 4.14 Tampilan Pesan Konfirmasi Hapus Jenis Akuntansi ............... 63 Gambar 4.15 Tampilan Pesan Gagal Hapus Jenis Akuntansi ...................... 64 Gambar 4.16 Tampilan Pesan Berhasil Hapus Jenis Akuntansi ................... 64 Gambar 4.17 Tampilan Cari Jenis Akuntansi ................................................ 65 Gambar 4.18 Tampilan Kode Akuntansi ....................................................... 66 Gambar 4.19 Tampilan Tambah Kode Akuntansi ......................................... 67 Gambar 4.20 Tampilan Pesan Kesalahan null Kode Akuntansi .................... 67 Gambar 4.21 Tampilan Cari Jenis Akuntansi ................................................ 68 Gambar 4.22 Tampilan Pesan Kesalahan ID Kode Akuntansi ...................... 68 Gambar 4.23 Tampilan Pesan Kesalahan Nama Kode Akuntansi ................ 69 Gambar 4.24 Tampilan Pesan Berhasil Tambah Kode Akuntansi ................ 69 Gambar 4.25 Tampilan Ubah Kode Akuntansi .............................................. 70 xv
Gambar 4.26 Tampilan Pesan Kesalahan ID Kode Akuntansi ...................... 71 Gambar 4.27 Tampilan Pesan Kesalahan Nama Kode Akuntansi ................ 71 Gambar 4.28 Tampilan Pesan Berhasil Ubah Kode Akuntansi ..................... 72 Gambar 4.29 Tampilan Konfirmasi Hapus Kode Akuntansi .......................... 73 Gambar 4.30 Tampilan Pesan Kesalahan Hapus Kode Akuntansi ............... 73 Gambar 4.31 Tampilan Pesan Berhasil Hapus Kode Akuntansi ................... 74 Gambar 4.32 Tampilan Cari Kode Akuntansi ................................................ 75 Gambar 4.33 Tampilan Transaksi ................................................................. 75 Gambar 4.34 Tampilan Pesan Kesalahan null Tambah Transaksi ............... 76 Gambar 4.35. Tampilan Cari Kode Transaksi ............................................... 77 Gambar 4.36 Tampilan Pesan Berhasil Tambah Transaksi .......................... 77 Gambar 4.37 Tampilan Pesan Konfirmasi Hapus Transaksi ........................ 78 Gambar 4.38 Tampilan Pesan Gagal Hapus Transaksi ................................ 79 Gambar 4.39 Tampilan Pesan Berhasil Hapus Transaksi ............................ 79 Gambar 4.40 Tampilan Pesan Kesalahan null SimpanTransaksi ................. 80 Gambar 4.41 Tampilan Pesan Kesalahan tidak seimbang Simpan Transaksi ...................................................................................................................... 81 Gambar 4.42 Tampilan Pesan Berhasil Simpan Transaksi........................... 81 Gambar 4.43 Tampilan Form Penyesuaian .................................................. 82 Gambar 4.44 Tampilan form cari kode .......................................................... 82 Gambar 4.45 tampilan pesan kesalahan null tambah penyesuaian ............. 83 Gambar 4.46 tampilan pesan berhasil disimpan ........................................... 84 Gambar 4.47 Tampilan konfirmasi hapus penyesuaian ................................ 85 Gambar 4.48 tampilan pesan kesalahan hapus penyesuaian ...................... 85 Gambar 4.49 Tampilan pesan berhasil disimpan .......................................... 86 Gambar 4.50 Tampilan pesan kesalahan simpan penyesuaian ................... 87 Gambar 4.51 tampilan pesan berhasil simpan penyesuaian ........................ 87 Gambar 4.52 Tampilan Jurnal Umum ........................................................... 88 Gambar 4.53 tampilan cari jurnal umum ....................................................... 89 Gambar 4.54 tampilan laporan jurnal umum ................................................. 89 xvi
Gambar 4.55 tampilan form neraca saldo ..................................................... 90 Gambar 4.56 tampilan cari neraca saldo ...................................................... 90 Gambar 4.57 tampilan laporan neraca saldo ................................................ 91 Gambar 4.58 tampilan form buku besar ........................................................ 92 Gambar 4.59 tampilan pesan kesalahan cari bukubesar .............................. 92 Gambar 4.60 tampilan form pengaturan ....................................................... 94 Gambar 4.61 tampilan ubah pengaturan ...................................................... 94 Gambar 4.62 tampilan pesan kesalahan ubah penguturan .......................... 95 Gambar 4.63 tampilan pesan berhasil ubah pengaturan .............................. 95
xvii
DAFTAR TABEL Tabel 2.1 analsis Bukti Pencatatan ................................................................. 5 Tabel 2.2 Contoh Kamus data ...................................................................... 13 Tabel 2.3 Contoh proses spesifikasi ............................................................. 13 Tabel 3.1 Data jenis akuntansi ...................................................................... 25 Tabel 3.2 Data kode akuntansi ..................................................................... 25 Tabel 3.3 Data transaksi ............................................................................... 26 Tabel 3.4 Data penyesuaian ......................................................................... 26 Tabel 3.5 Data bukubesar ............................................................................. 27 Tabel 3.6 Data penutup ................................................................................ 28 Tabel 3.7 Data pengaturan ........................................................................... 29 Tabel 3.8 Tambah jenis akuntansi ............................................................... 29 Tabel 3.9 Ubah jenis akuntansi ..................................................................... 30 Tabel 3.10 Hapus jenis akuntansi ................................................................. 31 Tabel 3.11 Tambah Kode akuntansi ............................................................. 32 Tabel 3.12 Ubah kode akuntansi .................................................................. 33 Tabel 3.13 Hapus kode akuntansi................................................................. 34 Tabel 3.14 Tambah transaksi........................................................................ 35 Tabel 3.15 Hapus transaksi .......................................................................... 36 Tabel 3.16 Simpan transaksi......................................................................... 36 Tabel 3.17 Print jurnal umum ........................................................................ 37 Tabel 3.18 Tambah penyesuaian.................................................................. 38 Tabel 3.19 Hapus penyesuaian .................................................................... 39 Tabel 3.20 Simpan penyesuaian................................................................... 40 Tabel 3.21 Print Bukubesar .......................................................................... 41 Tabel 3.22 Print Labarugi .............................................................................. 41 Tabel 3.23 Print neraca ................................................................................. 42 Tabel 3.24 Print Perubahan Modal ............................................................... 43 xviii
Tabel 3.25 Print pajak ................................................................................... 44 Tabel 3.26 Tambah jurnal penutup ............................................................... 44 Tabel 3.27 Hapus jurnal penutup .................................................................. 45 Tabel 3.28 Simpan jurnal penutup ................................................................ 46 Tabel 3.29 Simpan Pengaturan .................................................................... 47 Tabel 5.1 Tabel Pengujian Halaman Menu Utama ....................................... 96 Tabel 5.2 Tabel Pengujian Halaman Jenis Akuntansi ................................... 96 Tabel 5.3 Tabel Pengujian Halaman Kode Akuntansi ................................... 97 Tabel 5.4 Tabel Pengujian Halaman Transaksi Akuntansi............................ 97 Tabel 5.5 Tabel Pengujian Halaman Jurnal Umum Akuntansi ...................... 98 Tabel 5.6 Tabel Pengujian Halaman Neraca Saldo Akuntansi ..................... 98 Tabel 5.7 Tabel Pengujian Halaman Penyesuaian Akuntansi ...................... 99 Tabel 5.8 Tabel Pengujian Halaman Neraca lajur Akuntansi ...................... 100 Tabel 5.9 Tabel Pengujian Halaman Penutup Akuntansi ............................ 100 Tabel 5.10 Tabel Pengujian Halaman Penyesuaian Akuntansi .................. 101
xix
DAFTAR NOTASI/ LAMBANG
Jenis
Notasi/ Lambang
Nama
Flowchart
Terminator
Flowchart
Dokumen
Flowchart
Flowchart
Arti Menunjukan permulaan atau pengakhir suatu proses Menunjukan berkas input atau output
Kegiatan
Menunjukan pekerjaan secara
manual
manual
Arsip
Merupakan kumpulan dokumen yang di simpan Proses perbandingan,
Flowchart
Keputusan
penyeleksian untuk menentukan langkah selanjutnya
Flowchart
Alur proses
Menyatakan alur atau langka
bisnis
berikutnya dari proses bisnis
ERD
entitas
ERD
relasi
Menyatakan sebuah entitas dalam ERD Menyatakn sebuah relasi antara 2 atau lebih entitas
ERD
atribut
Menyatakan atribut yang dimiliki oleh entitas
xx
DFD
proses
Merupakan sebuah proses dalam DFD
DFD
aktor
Menyatakan sebuah entitas dalam DFD
DFD
Data store
Menyatakan sebuah data store/ database dalam DFD
DFD
Alur data
Menyatakan alur atau jalannya data dari suatu entitas menuju proses dan menuju data store, atau sebaliknya
xxi
DAFTAR SINGKATAN ERD : Entity Relationship Diagram DFD : Data Flow Diagram RAM : Random Access Memory
xxii
DAFTAR ISTILAH Software
: Perangkat lunak.
Password
: Kata rahasia yang dienkripsi untuk mengakses ke sumber
tertentu. Login
: Fungsi dimana user harus memasukkan email dan password
sebelum mengakses aplikasi. Logout
: Fungsi untuk mengakhiri akses current user.
Hak akses : Hak yang mengelola data user untuk dapat mengakses file – file atau direktori tertentu.
xxiii