RANCANG BANGUN APLIKASI PENGELOLAAN KEUANGAN DESA

STUDI KASUS : KANTOR DESA BULULAWANG KECAMATAN

BULULAWANG KABUPATEN MALANG

TUGAS AKHIR

Diajukan Untuk Memenuhi

Persyaratan Guna Meraih Gelar Sarjana Strata 1

Teknik Informatika Universitas Muhammadiyah Malang

Disusun oleh :

ROZAQ HAMIDU MALIK

201110370311126

JURUSAN TEKNIK INFORMATIKA

FAKULTAS TEKNIK

UNIVERSITAS MUHAMMADIYAH MALANG

2015

KATA PENGANTAR

Assalamu’alaikum Wr, Wb

Dengan memanjatkan puji syukur kehadiran Allah SWT. Atas limpahan

rahmat dan hidayah-NYA sehingga penelitian dapat menyelesaikan tugas akhir

yang berjudul :

“RANCANG BANGUN APLIKASI PENGELOLAAN KEUANGAN DESA

STUDI KASUS : KANTOR DESA BULULAWANG

KECAMATAN BULULAWANG KABUPATEN MALANG“

Penelitian menyadari sepenuhnya bahwa dalam penulisan tugas akhir ini

masih banyak kekurangan dan keterbatasan. Oleh karena itu penelitian

mengharapkan saran yang membangun agar tulisan ini bermanfaat bagi

perkembangan ilmu pengetahuan kedepan.

Akhir kata penulis mengucapkan terima kasih kepada semua pihak yang

telah membantu sehingga tugas akhir ini terselesaikan.

Wassalamu’alaikum Wr,Wb

Malang, Oktober 2015

Penulis

ROZAQ HAMIDU MALIK

DAFTAR ISI

ABSTRAK .........................................................................................................i

ABSTRACT ........................................................................................................ii

LEMBAR PERSEMBAHAN .............................................................................iii

KATA PENGANTAR ........................................................................................iv

DAFTAR ISI .......................................................................................................v

DAFTAR GAMBAR ..........................................................................................viii

DAFTAR TABEL ...............................................................................................xi

BAB I Pendahuluan

1.1 Latar Belakang .............................................................................. 1

1.2 Rumusan Masalah ......................................................................... 2

1.3 Tujuan ............................................................................................ 2

1.4 Batasan Masalah ............................................................................ 2

1.5 Metodologi ..................................................................................... 2

1.5.1 Studi Pustaka .......................................................................... 2

1.5.2 Analisa Kebutuhan ................................................................. 3

1.5.3 Perancangan Sistem ............................................................... 3

1.5.4 Implementasi Sistem ............................................................. 3

1.5.5 Uji Coba dan Evaluasi ............................................................ 3

1.5.6 Penyusunan Buku Tugas Akhir .............................................. 3

1.6 Sistematika Penulisan ..................................................................... 3

BAB II LANDASAN TEORI

2.1 APBD ............................................................................................ 5

2.1.1 Struktur APBD ...................................................................... 5

2.1.2 Siklus Anggaran .................................................................... 8

2.1.3 Penyusunan Rancangan APBDesa ........................................ 8

2.2 Aplikasi Komputer ........................................................................ 9

2.3 PHP ................................................................................................ 9

2.3.1 Kelebihan PHP ...................................................................... 10

2.3.2 Kekurangan PHP ................................................................... 10

2.3.3 Skirp PHP .............................................................................. 11

2.3.4 Konsep Kerja PHP ................................................................. 11

2.8.3 PHP dan Database .................................................................. 11

2.4 HTML ............................................................................................ 12

2.4.1 Kelebihan HTML .................................................................. 13

2.4.2 Kekurangan HTML ............................................................... 13

2.4 MySQL .......................................................................................... 14

2.4.1 Kelebihan MySQL ................................................................. 14

2.4.2 Kekurangan MySQL .............................................................. 15

BAB III ANALISA DAN PERANCANGAN SISTEM

3.1 Analisa Permasalahan ................................................................... 16

3.2 Perancangan Sistem ........................................................................ 16

3.2.1 Perancangan Objek ................................................................. 17

3.2.2 Perancangan Fungsional ......................................................... 17

3.2.3 Flowchart ................................................................................ 18

3.2.4 Use Case ................................................................................. 22

3.2.5 Design Database ..................................................................... 23

3.2.6 DFD Diagram ......................................................................... 25

3.2.7 Tabel Admin dan Keuangan ................................................... 45

3.2.8 User Interface ......................................................................... 48

BAB IV IMPLEMENTASI DAN PENGUJIAN

4.1 Implementasi ................................................................................. 56

4.1.1 Tampilan Halaman Admin .................................................... 56

4.1.2 Tampilan Halaman Pembukuan ............................................. 58

4.1.3 Tampilan Edit Keuangan ....................................................... 64

4.1.4 Tampilan Hasil Keuangan ..................................................... 66

4.1.5 Tampilan Menu Grafik .......................................................... 71

4.1.6 Tampilan Hasil Fitur Pencarian ............................................. 73

4.2 Pengujian Aplikasi ........................................................................ 73

4.2.1 Rencana Pengujuan ................................................................ 74

4.2.1 Pengujian Alpha .................................................................... 74

4.2.3 Pengujian Beta ....................................................................... 76

BAB V KESIMPULAN DAN SARAN

5.1 Kesimpulan .................................................................................... 84

5.2 Saran .............................................................................................. 84

DAFTAR PUSTAKA ..................................................................................... 85

LAMPIRAN .................................................................................................... 86

BIOGRAFI ...................................................................................................... 87

DAFTAR GAMBAR

Gambar 3.1 : Flowchart Login Admin ........................................................... 18

Gambar 3.2 : Flowchart Manajemen Sistem .................................................. 19

Gambar 3.3 : Flowchart View Keuangan ....................................................... 20

Gambar 3.4 : Flowchart Cetak Keuangan ...................................................... 21

Gambar 3.5 : Use Case Diagram client ........................................................... 22

Gambar 3.6 : Use Case Diagram admin ......................................................... 23

Gambar 3.7 : Design Database Aplikasi Pengelolaan Keuangan .................. 24

Gambar 3.8 : DFD Diagram Level 0 ............................................................... 25

Gambar 3.9 : DFD Diagram Level 1 Keuangan Desa .................................... 26

Gambar 3.10 : DFD Diagram Level 1 Lampiran ............................................ 27

Gambar 3.11 : DFD Diagram Level 1 Rencana Anggaran Biaya ................... 27

Gambar 3.12 : DFD Diagram Level 1 Kas Pembantu Keuangan ................... 28

Gambar 3.13 : DFD Diagram Level 1 Surat Permintaan Pembanyaran ......... 29

Gambar 3.14 : DFD Diagram Level 1 Buku Tanggungjawab Belanja ........... 30

Gambar 3.15 : DFD Diagram Level 1 Buku Kas Umum ................................ 31

Gambar 3.16 : DFD Diagram Level 1 Kas Pembantu Pajak........................... 31

Gambar 3.17 : DFD Diagram Level 1 Buku Bank Desa................................. 32

Gambar 3.18 : DFD Diagram Level 1 APBDesa ............................................ 33

Gambar 3.19 : DFD Diagram Level 1 Laporan APBDesa.............................. 34

Gambar 3.20 : DFD Diagram Level 2 Keuangan Desa .................................. 35

Gambar 3.21 : DFD Diagram Level 2 Lampiran ............................................ 35

Gambar 3.22 : DFD Diagram Level 2 Rencana Anggaran Biaya ................... 36

Gambar 3.23 : DFD Diagram Level 2 Kas Pembantu Keuangan ................... 37

Gambar 3.24 : DFD Diagram Level 2 Surat Permintaan Pembanyaran ......... 38

Gambar 3.25 : DFD Diagram Level 2 Buku Tanggungjawab Belanja ........... 39

Gambar 3.26 : DFD Diagram Level 2 Buku Kas Umum ................................ 40

Gambar 3.27 : DFD Diagram Level 2 Kas Pembantu Pajak........................... 41

Gambar 3.28 : DFD Diagram Level 2 Buku Bank Desa................................. 42

Gambar 3.29 : DFD Diagram Level 2 APBDesa ............................................ 43

Gambar 3.30 : DFD Diagram Level 2 Laporan APBDesa.............................. 44

Gambar 3.31 : Rancangan Menu Aplikasi ..................................................... 49

Gambar 3.32 : Rancangan Halaman Hasil Keuangan Desa ........................... 50

Gambar 3.33 : Rancangan Halaman Grafik .................................................... 51

Gambar 3.34 : Menu Login Admin ................................................................. 52

Gambar 3.35 : Rancangan Halaman Pembukuan Keuangan .......................... 53

Gambar 3.36 : Rancangan Halaman Edit Keuangan ....................................... 54

Gambar 3.37 : Rancangan Halaman Hasil Pencarian ..................................... 55

Gambar 4.1 : Login Admin ............................................................................ 57

Gambar 4.2 : Halaman Pembukuan Keuangan .............................................. 58

Gambar 4.3 : Halaman Pembukuan Lampiran ............................................... 58

Gambar 4.4 : Halaman Pembukuan Rencana Anggaran Biaya ...................... 59

Gambar 4.5 : Halaman Pembukuan Buku Kas Pembantu Kegiatan .............. 59

Gambar 4.6 : Halaman Pembukuan Surat Permintaan Pembayaran .............. 60

Gambar 4.7 : Halaman Pembukuan Permintaan Tanggungjawab ................. 61

Gambar 4.8 : Halaman Pembukuan Buku Kas Umum .................................. 61

Gambar 4.9 : Halaman Pembukuan Buku Kas Pembantu Pajak .................... 62

Gambar 4.10: Halaman Pembukuan Buku Bank Desa ................................... 62

Gambar 4.11: Halaman Pembukuan APBDesa ............................................... 63

Gambar 4.12: Halaman Pembukuan Laporan Realisasi APBDesa ................. 64

Gambar 4.13: Menu Edit Keuangan ................................................................ 64

Gambar 4.14: Fitur Edit Keuangan ................................................................. 65

Gambar 4.15: Halaman Hasil Keuangan ......................................................... 66

Gambar 4.16: Halaman Hasil Pembukuan Lampiran ..................................... 67

Gambar 4.17: Halaman Hasil Pembukuan Rencana Anggaran Biaya ............. 67

Gambar 4.18: Halaman Hasil Pembukuan Kas Pembantu Kegiatan ............... 68

Gambar 4.19: Halaman Hasil Pembukuan Surat Permintaan Pernyataan........ 68

Gambar 4.20: Halaman Hasil Pembukuan Peryataan Tangguggungjawab ..... 69

Gambar 4.21: Halaman Hasil Pembukuan Buku Kas Umum .......................... 69

Gambar 4.22: Halaman Hasil Pembukuan Buku Bank Desa ........................... 70

Gambar 4.23: Halaman Hasil Pembukuan APBDesa ...................................... 70

Gambar 4.24: Halaman Hasil Pembukuan Laporan APBDesa ........................ 71

Gambar 4.25: Halaman Grafik ......................................................................... 71

Gambar 4.26: Fitur Hasil Pencarian ................................................................. 73

DAFTAR TABEL

Tabel 3.1 : Deskripsi Aktor-Aktor Aplikasi ................................................... 17

Tabel 3.2 : Tabel Admin ................................................................................ 45

Tabel 3.3 : Tabel APBDesa ............................................................................ 45

Tabel 3.4 : Tabel Rencana Anggaran Biaya.................................................... 45

Tabel 3.5 : Tabel Buku Kas Pembantu Kegiatan ............................................ 46

Tabel 3.6 : Tabel Surat Permintaan Pembayaran ............................................ 46

Tabel 3.7 : Tabel Pernyataan Tanggung Jawab Belanja ................................. 47

Tabel 3.8 : Tabel Buku Kas Umum ................................................................ 47

Tabel 3.9 : Tabel Buku Kas Pembantu Pajak .................................................. 48

Tabel 3.10 : Tabel Buku Bank Desa ............................................................... 48

Tabel 4.1 : Rancangan Pengujian .................................................................... 74

Tabel 4.2 : Pengujian Aplikasi Keuangan Desa .............................................. 75

Tabel 4.3 : Interval Penilaian .......................................................................... 76

Tabel 4.4 : Skor Kuesioner ............................................................................. 77

Tabel 4.5 : Hasil Kuisioner No 1 .................................................................... 78

Tabel 4.6 : Hasil Kuisioner No 2 .................................................................... 78

Tabel 4.7 : Hasil Kuisioner No 3 .................................................................... 79

Tabel 4.8 : Hasil Kuisioner No 4 .................................................................... 79

Tabel 4.9 : Hasil Kuisioner No 5 .................................................................... 80

Tabel 4.10 : Hasil Kuisioner No 6 .................................................................. 80

Tabel 4.11 : Hasil Kuisioner No 7 .................................................................. 81

Tabel 4.12 : Hasil Kuisioner No 8 .................................................................. 81

Tabel 4.13 : Hasil Kuisioner No 9 .................................................................. 82

Tabel 4.13 : Hasil Kuisioner No 10 ................................................................ 82

Daftar Pustaka

[1] Agus, Puji. 2015. Pengelolaan Keuangan Desa: Sistem dan Prosedur

Pertanggungjawaban Keuangan Desa.

[2] Taufik, Taufeni. 2009. Pengelolaan Keuangan Desa Dalam Sistem Keuangan

Negara Republik Indonesia. Vol 17, No 3

[3] Pinto, Salvador. 2011. Anggaran Pendapatan dan Belanja Daerah (APBD).

[4] http://www.sulaidihasibuan.com/2015/03/pengertian-aplikasi-komputer.html,

waktu akses 19 juli 2015.

[5] http://hastomo.net/php/pengertian-dan-sejarah-php/, waktu akses 20 juli

2015.

[6] https://www.wattpad.com/25621-tips-mendesain-website, waktu akses 20 juli

2015.

[7] http://rplsmakzie.blogspot.co.id/2014/06/pengertian-versi-kekurangan-

kelebihan.html/, waktu akses 20 juli 2015

[8] https://ayulestari27.wordpress.com/2015/03/19/kelebihan-kelemahan-dari-

mysql/, waktu akses 10 september 2015