Contoh Laporan Keuangan Proyek Renovasi Rumah [PDF]

  • 0 0 0
  • Suka dengan makalah ini dan mengunduhnya? Anda bisa menerbitkan file PDF Anda sendiri secara online secara gratis dalam beberapa menit saja! Sign Up
File loading please wait...
Citation preview

LAPORAN KEUANGAN NO.



TANGGAL



BELANJA/KEGIATAN



1



18-Nov-18



Transfer dari owner



2 3 4 5 6 7 8 9 10 11 12 13



19-Nov-18



Semen 5 Zak Triplex 3 Lembar Paku Bentor (Angkutan) Truck (Angkut Bongkaran) Balok 4 x 6 Cuka (H2SO4) Pasir Bensin (Akomodasi) Saringan Pasir Konsumsi Tali



14



23-Nov



Transfer dari owner



15 16



26-Nov



17



BELANJA



TERIMA Rp



SALDO



Ket.



3,000,000.00 Rp



3,000,000.00



-



Rp Rp Rp Rp Rp Rp Rp Rp Rp Rp Rp Rp



2,760,000.00 2,588,000.00 2,538,000.00 2,488,000.00 2,288,000.00 2,092,000.00 2,008,000.00 1,508,000.00 1,458,000.00 1,438,000.00 1,405,000.00 1,400,000.00



-



4,000,000.00 Rp



5,400,000.00



-



Rp Rp



5,050,000.00 4,142,000.00



-



Rp Rp Rp Rp Rp Rp Rp Rp Rp Rp Rp Rp



240,000.00 172,000.00 50,000.00 50,000.00 200,000.00 196,000.00 84,000.00 500,000.00 50,000.00 20,000.00 33,000.00 5,000.00



Batu Kali Besi dan Kawat



Rp Rp



350,000.00 908,000.00



26-Nov-18



Upah Pemborong



Rp



4,142,000.00



Rp



18



27-Nov-18



Transfer dari owner



7,000,000.00 Rp



7,000,000.00



19 20 21



27-Nov-18



Kerikil Batu Merah @1000 bj Papan



Rp Rp Rp



300,000.00 480,000.00 162,000.00



Rp Rp Rp



6,700,000.00 6,220,000.00 6,058,000.00



22



27-Nov-18



23 24 25 26 27 28 29 30 31 32



30-Nov-18



1-Des-2018 4-Des-2018



Rp



Rp



-



Rp



2,900,000.00



Rp



3,158,000.00 Dp 30% borongan Lunas



Besi 2 btg + Kawat Semen 3 Zak Bensin (Angkutan) Semen 6 Zak Semen 10 Zak -6.Besi 12, -4 Besi 8 Garu Pot 2 Glass Block 3 Batu Merah 1000 bj Papan Cor 4



Rp Rp Rp Rp Rp Rp Rp Rp Rp Rp



240,000.00 141,000.00 50,000.00 288,000.00 470,000.00 810,000.00 10,000.00 75,000.00 500,000.00 120,000.00



Rp Rp Rp Rp Rp Rp Rp Rp Rp Rp



2,918,000.00 2,777,000.00 2,727,000.00 2,439,000.00 1,969,000.00 1,159,000.00 1,149,000.00 1,074,000.00 574,000.00 454,000.00



Rp



168,000.00



Rp



33



5-DES-2018



Pipa & Kelengkapan



34



7-Dec-18



Transfer dari owner



35



8-Des-2018



Rp



286,000.00 Sisa Dana bahan



3,000,000.00 Rp



3,286,000.00



4 Batang Besi 12



Rp



420,000.00



Rp



2,866,000.00



2 Batang Besi 8 1 Kg Kawat Pasir 1 Truck Semen 5 Zak Glass Block 3 Bambu 10 Batang Balok 4 x 6 @20 btg Balok 5 x 10 @3 btg Bensin 5 btg besi 12



Rp Rp Rp Rp Rp Rp Rp Rp Rp Rp



90,000.00 20,000.00 600,000.00 240,000.00 75,000.00 250,000.00 360,000.00 135,000.00 50,000.00 525,000.00



Rp Rp Rp Rp Rp Rp Rp Rp Rp Rp



2,776,000.00 2,756,000.00 2,156,000.00 1,916,000.00 1,841,000.00 1,591,000.00 1,231,000.00 1,096,000.00 1,046,000.00 521,000.00



46



4 btg besi 8



Rp



180,000.00



Rp



341,000.00



47



Kawat 2 Kg



Rp



40,000.00



Rp



301,000.00



48



Semen 5 Zak



Rp



235,000.00



Rp



66,000.00



4,500,000.00 Rp



4,566,000.00



Rp Rp Rp Rp



219,000.00 240,000.00 550,000.00 270,000.00



Rp Rp Rp Rp



4,347,000.00 4,107,000.00 3,557,000.00 3,287,000.00



36 37 38 39 40 41 42 43 44 45



9-Des-2018



13-Des-2018



14-Des-2018



49



14-Dec-18



50 51 52 53



15-Des-2018



Penerimaan Tukang seharusnya 6.9 Jt, sisa 2,9 jt



Transfer dari owner Papan Cor 7 lmbr 10 btg bambu Triplex 9mm 5 Lembar Balok 4 x 6 @15 btg



Rp



Perubahan setelah dicocokkan dgn nota Sisa Dana bahan Sampai hari ini Jum'at 14/12



Papa Cor 7 lmbr 4 btg besi 12 5 btg besi 8 10 btg besi 10 Balok 5 x 10 @2 btg Balok 4 x 6 @7 btg 5 btg bambu Triplex 9mm 4 Lembar Paku 3 1/2kg Paku 5 1/2kg Paku 7 1/2kg 7 btg besi 10



Rp Rp Rp Rp Rp Rp Rp Rp Rp Rp Rp Rp



181,000.00 420,000.00 225,000.00 680,000.00 90,000.00 126,000.00 125,000.00 420,000.00 10,000.00 10,000.00 10,000.00 680,000.00



Rp Rp Rp Rp Rp Rp Rp Rp Rp Rp Rp Rp



3,106,000.00 2,686,000.00 2,461,000.00 1,781,000.00 1,691,000.00 1,565,000.00 1,440,000.00 1,020,000.00 1,010,000.00 1,000,000.00 990,000.00 310,000.00



66



Paku 2 Kg



Rp



36,000.00



Rp



274,000.00



67



Kawat 2 Kg



Rp



40,000.00



Rp



234,000.00



68



Paku 1/2kg



Rp



10,000.00



Rp



224,000.00



5,000,000.00 Rp



5,224,000.00



54 55 56 57 58 59 60 61 62 63 64 65



69



17-Des-2018



19-Des-2018



20-Des-2018



22-Des-2018



24-Dec-18



Transfer dari owner



Rp



Glass Block 2 Kerikil Pasir 1/2 Semen 5 Zak Paku 1 Kg Kawat 1 Kg Besi 10 @1 btg Glass Block 1 Semen 5 Zak Kelengkapan Listrik Semen 2 Zak Aplus 1 Lem Kape Paku 1 Kg Ember 5



Rp Rp Rp Rp Rp Rp Rp Rp Rp Rp Rp Rp Rp Rp Rp Rp



50,000.00 500,000.00 300,000.00 240,000.00 18,000.00 20,000.00 68,000.00 25,000.00 240,000.00 200,000.00 96,000.00 57,000.00 18,000.00 5,000.00 15,000.00 50,000.00



Rp Rp Rp Rp Rp Rp Rp Rp Rp Rp Rp Rp Rp Rp Rp Rp



5,174,000.00 4,674,000.00 4,374,000.00 4,134,000.00 4,116,000.00 4,096,000.00 4,028,000.00 4,003,000.00 3,763,000.00 3,563,000.00 3,467,000.00 3,410,000.00 3,392,000.00 3,387,000.00 3,372,000.00 3,322,000.00



86



Semen 4 Zak



Rp



192,000.00



Rp



3,130,000.00



87



Tali



Rp



5,000.00



Rp



3,125,000.00



88



Solar



Rp



50,000.00



Rp



3,075,000.00



89 90 91



Aplus 4 Zak Semen 2 Zak Pasir 1/2



Rp Rp Rp



228,000.00 96,000.00 300,000.00



Rp Rp Rp



2,847,000.00 2,751,000.00 2,451,000.00



92



Lem Fox 3 Bks



Rp



45,000.00



Rp



2,406,000.00



93



Ongkos Antar



Rp



30,000.00



Rp



2,376,000.00



94



Tagihan PDAM Bulan 12



Rp



396,500.00



Rp



1,979,500.00



Semen 4 Zak Ongkos Bensin 5 btg Besi 10 3 btg Besi 8 Kawat 1 Kg Glass Blok 8 Biji Semen 2 Zak Kerikil



Rp Rp Rp Rp Rp Rp Rp Rp



192,000.00 50,000.00 340,000.00 90,000.00 20,000.00 150,000.00 94,000.00 250,000.00



Rp Rp Rp Rp Rp Rp Rp Rp



1,787,500.00 1,737,500.00 1,397,500.00 1,307,500.00 1,287,500.00 1,137,500.00 1,043,500.00 793,500.00



5,000,000.00 Rp



5,793,500.00



70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85



95 96 97 98 99 100 101 102



25-Des-2018 26-Des-2018



10-Jan-19 11-Jan-19



12-Jan-19



103



Transfer dari owner



104



Bayar Upah Pemborong



Rp



5,000,000.00



Rp



793,500.00



Paku 2 Kg Lem Fox 2 Bks



Rp Rp



36,000.00 30,000.00



Rp Rp



757,500.00 727,500.00



105 106



14-Jan-19



Rp



Pemasukan pada tgl 13Des, Nota baru ditemukan



Sisa Dana bahan Sampai hari ini Sabtu 22/12



Pemasukan pada tgl 13Des, Nota baru ditemukan



Sisa Dana bahan Sampai hari ini Sabtu 22/12



Pemasukan pada tgl 13Des, Nota baru ditemukan



Upah Borongan terbayarkan 12 Jt



107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136



Amplas A-Plus



Rp Rp



30,000.00 57,000.00



Rp Rp



697,500.00 640,500.00 340,500.00 Sisa Dana 14 Jan 2019



Biaya Reparasi Pintu



Rp



300,000.00



Rp



15-Jan-19



Pasir



Rp



300,000.00



Rp



15-Jan-19 15-Jan-19 20-Jan-19



Transfer dari owner



21-Jan-19



1/2/2019



2/2/2019



Batu Bata @1000 bj Konsumsi (Minuman Tamu) Angkutan Bongkaran 2 x Race 5 btg Pipa 3/4 2 btg pipa 3 inch 15 Sambungan pipa 3/4 2 btl lem pipa 3 Zak Aplus 5 btg besi 10 2 btg besi 8 10 Zak Semen Tonasa 2 x 5 kg No Drop 2 Kuas 2 Lem Fox 1 Kg Kawat 3 kelengkapan pipa Pasir 1 Truck Batu 500 bj Semen 3 Zak Keran 1/2'' Sambungan knee 3/4 && 1/2 Dop 3/4'' 1 m rang pasir Lem pipa klg fox



Rp Rp Rp Rp Rp Rp Rp Rp Rp Rp Rp Rp Rp Rp Rp Rp Rp Rp Rp Rp Rp Rp Rp Rp



Rp



5,000,000.00 Rp Rp Rp Rp Rp Rp Rp Rp Rp Rp Rp Rp Rp Rp Rp Rp Rp Rp Rp Rp Rp Rp Rp Rp Rp



Rp



5,000,000.00



500,000.00 60,000.00 500,000.00 175,000.00 150,000.00 37,500.00 20,000.00 171,000.00 325,000.00 90,000.00 480,000.00 350,000.00 30,000.00 40,000.00 20,000.00 27,000.00 500,000.00 250,000.00 192,000.00 25,000.00 10,000.00 5,000.00 20,000.00 18,000.00



Transfer dari owner



40,500.00 5,040,500.00 4,540,500.00 4,480,500.00 Kunjungan Owner 3,980,500.00 3,805,500.00 3,655,500.00 3,618,000.00 3,598,000.00 3,427,000.00 3,102,000.00 3,012,000.00 2,532,000.00 2,182,000.00 2,152,000.00 2,112,000.00 2,092,000.00 2,065,000.00 1,565,000.00 1,315,000.00 1,123,000.00 1,098,000.00 1,088,000.00 1,083,000.00 1,063,000.00 1,045,000.00



Rp



6,045,000.00



Bayar Upah Pemborong



Rp



3,500,000.00



Rp



2,545,000.00



3 btg Besi 10 3 btg Besi 6 3 Zak Semen Tonasa Kelengkapan perpiaan Pasir 1 Ret 3 Zak Semen Tonasa Besi 10 @7 btg Semen 3 Zak 2 x 5 kg No Drop Putih



Rp Rp Rp Rp Rp Rp Rp Rp Rp



210,000.00 84,000.00 144,000.00 106,500.00 500,000.00 144,000.00 476,000.00 144,000.00 350,000.00



Rp Rp Rp Rp Rp Rp Rp Rp Rp



2,335,000.00 2,251,000.00 2,107,000.00 2,000,500.00 1,500,500.00 1,356,500.00 880,500.00 736,500.00 386,500.00



147



Semen 3 Zak



Rp



144,000.00



Rp



148



Transfer dari owner



Rp



5,242,500.00



149



Bayar Upah Pemborong



Rp



3,500,000.00



Rp



1,742,500.00



150 151 152 153 154 155 156 157 158 159



7 btg besi 10 2 btg besi 6 5 Zak Semen Tonasa 1 Kg Kawat Mata Gurinda Pipa 2'' Kabel+ Pipa Kabel untuk wt Roster A-Plus, Kelengkapan pipa Kerikil



Rp Rp Rp Rp Rp Rp Rp Rp Rp Rp



455,000.00 60,000.00 240,000.00 20,000.00 10,000.00 45,000.00 38,000.00 120,000.00 141,000.00 50,000.00



Rp Rp Rp Rp Rp Rp Rp Rp Rp Rp



1,287,500.00 1,227,500.00 987,500.00 967,500.00 957,500.00 912,500.00 874,500.00 754,500.00 613,500.00 563,500.00



10,000,000.00 Rp



10,563,500.00



137 138 139 140 141 142 143 144 145 146



160



3/2/2019



4/2/2019 7/2/2019



11/2/2019



13/2/2019



Rp



Transfer dari owner



Rp



5,000,000.00



242,500.00 Sisa Dana 7/2/2019



161



Transport



Rp



50,000.00



Rp



10,513,500.00



162 163 164 165



No Drop 1 5 Kg 15 Dos Tegel Lantai Kamar 1 Dos Tambahan Tegel LK 5 Dos Tegel Lantai WC



Rp Rp Rp Rp



175,000.00 6,000,000.00 400,000.00 1,250,000.00



Rp Rp Rp Rp



10,338,500.00 4,338,500.00 3,938,500.00 2,688,500.00



14/2/2019



Sisa Dana sampai 2/2/2019



166



32 Dos Dinding wc



Rp



2,272,000.00



416,500.00



5,000,000.00 Rp



5,416,500.00



167



16/2/2019



Transfer dari owner



168



17/2/2019 19/2/2019



Bayar Upah Pemborong



Rp



3,500,000.00



Rp



1,916,500.00 Sisa Dana Sampai 17/2



Tali Spidol 8 Semen Tonasa 5 btg pipa 5/8 listrik Kabel Antena 30 Mtr 3 Saklar Seri MAE PNS 4 Saklar Engkel MAE PNS 5 Stop Kontak MAE 2 Stop Antena TV 1 Set Stop AC PNS 2 Dos Sadel No. 9 20 imbodox 9 Pitting Broco



Rp Rp Rp Rp Rp Rp Rp Rp Rp Rp Rp Rp Rp



10,000.00 7,500.00 384,000.00 40,000.00 150,000.00 144,000.00 116,000.00 157,500.00 163,000.00 63,000.00 30,000.00 50,000.00 81,000.00



Rp Rp Rp Rp Rp Rp Rp Rp Rp Rp Rp Rp Rp



1,906,500.00 1,899,000.00 1,515,000.00 1,475,000.00 1,325,000.00 1,181,000.00 1,065,000.00 907,500.00 744,500.00 681,500.00 651,500.00 601,500.00 520,500.00



Rp



310,000.00



169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201



21/2/19



21/2/19 21/2/19



22/2/19



1 Roll Kabel NYA 2.5 Transfer dari owner Pipa 5/8 10 batang Sambungan T dan ab 15 bh Selang Flexibel 5 m Isolasi Wat 3 bh Sadel 17 mm 30 bj kertas gosok 2m mata pot. Tegel NAT C Pem 2 Paku beton Hitam 5 cm No Drop 5 Kg 2 Roll Kabel 2.5 (50 m) 10 bh Sambungan T dan ab Selang Flexibel 5 m 3 knee 2' 2 bungkus sadel 17 mm Mobil angkut tegel Galon Angkut sampah + Simon



202



Cash dari owner U/ PLAFOND



203 204 205



Bahan Plafon Portex yuri biru Bensin n minum firman



23/2/19



206



Cash dari owner



207 208 209



Bayar Upah Pemborong Bayar Tukang Listrik Portex



210 211 212 213 214 215 216 217 218 219 220 221 222 223 224



25/2/19



Rp



Rp



Rp Rp Rp Rp Rp Rp Rp Rp Rp Rp Rp Rp Rp Rp Rp Rp Rp Rp



60,000.00 22,500.00 20,000.00 15,000.00 10,000.00 20,000.00 45,000.00 30,000.00 25,000.00 175,000.00 310,000.00 15,000.00 20,000.00 21,000.00 40,000.00 120,000.00 10,000.00 150,000.00



Rp Rp Rp



1,300,000.00 21,500.00 20,000.00



Rp Rp Rp



1,210,500.00 1,150,500.00 1,128,000.00 1,108,000.00 1,093,000.00 1,083,000.00 1,063,000.00 1,018,000.00 988,000.00 963,000.00 788,000.00 478,000.00 463,000.00 443,000.00 422,000.00 382,000.00 262,000.00 252,000.00 102,000.00



Rp



1,300,000.00 Rp



1,402,000.00 Diterima oleh Firman



2,500,000.00 500,000.00 20,400.00 Rp



Rp Rp Rp Rp Rp Rp Rp Rp Rp Rp Rp Rp Rp Rp



15,000.00 50,000.00 20,000.00 12,000.00 120,000.00 5,000.00 20,000.00 192,000.00 27,000.00 5,000.00 80,000.00 15,000.00 18,000.00 155,500.00



210,500.00 Sisa Dana Sampai 19/2



1,000,000.00 Rp Rp Rp Rp Rp Rp Rp Rp Rp Rp Rp Rp Rp Rp Rp Rp Rp Rp Rp



Rp



Transfer dari owner Sambungan Pipa Sekrup Gypsum Sekrup Closset Paku Beton 2 cm Bayar Tukang Pintu 2 soket 3/4 2 Drat lengan 4 Tonasa 3 Angel 2 SambunganT 1 btg Pipa 4" 1 knee pipa 4" 1 Lem Fox Ex Haust WC



Rp Rp



Rp Rp Rp



102,000.00 80,500.00 60,500.00



3,000,000.00 Rp



3,060,500.00



Rp Rp Rp



560,500.00 60,500.00 40,100.00



1,500,000.00 Rp



1,540,100.00



Rp Rp Rp Rp Rp Rp Rp Rp Rp Rp Rp Rp Rp Rp



1,525,100.00 1,475,100.00 1,455,100.00 1,443,100.00 1,323,100.00 1,318,100.00 1,298,100.00 1,106,100.00 1,079,100.00 1,074,100.00 994,100.00 979,100.00 961,100.00 805,600.00



TUKANG BATU LISTRIK



225



Ex Haust Kamar



Rp



430,000.00



Rp



375,600.00



226



5 Bh Down Light



Rp



255,000.00



Rp



120,600.00 Sisa Dana sampai 26/2



227



Bensin



Rp



50,000.00



228



Transfer dari owner



26/2/19



229 230 231 232 233 234 235 236 237 238 239



Rp Beli Tegel Lantai & Teras Atas Rp 1 buah bungkus saklar 3s Rp 5 buah bungkus saklar seri gandeng 2 buah bungkus saklar gandeng Rp Rp Kabel NYA 30 Meter Rp Aplus 1 Rp 5 Kg Cornis Plafond Rp 1 Lem Fox Rp 5 Tonasa Rp 1 knee pipa 4" 27/2/19



240 241 242 243 244 245 246 247 248 249 250



Rp



3/3/2019



251



Bayar Upah Pemborong 4/3/2019



Transfer dari owner



253



4/3/2019



Bayar sisa borongan listrik



254



6/3/2019



Transfer dari owner



Rp



770,600.00 DITERIMA OLEH JAYA 755,600.00 548,100.00 529,100.00 424,100.00 367,100.00 342,100.00 327,100.00 87,100.00 72,100.00



2,000,000.00 Rp



2,072,100.00



Rp Rp Rp Rp Rp Rp Rp Rp Rp Rp



1,859,100.00 1,788,100.00 1,688,100.00 1,547,100.00 1,337,100.00 1,107,100.00 557,100.00 252,100.00 145,100.00 1,100.00



213,000.00 71,000.00 100,000.00 141,000.00 210,000.00 230,000.00 550,000.00 305,000.00 107,000.00 144,000.00



Transfer dari owner



252



Rp Rp Rp Rp Rp Rp Rp Rp Rp Rp Rp



Rp Rp Rp Rp Rp Rp Rp Rp Rp Rp



70,600.00 3,070,600.00



2,300,000.00 15,000.00 207,500.00 19,000.00 105,000.00 57,000.00 25,000.00 15,000.00 240,000.00 15,000.00



Transfer dari owner Tambahan Tegel Dinding WC Sewa gojek & bensin Kuku Tegel Tangga Cat dan Kuas Mata Saklar + Bensin T. Listrik Sewa Scafolding & Mobilisasi Pasir 1 Ret Bayar Tagihan Listrik Bayar Tagihan Air Semen 3 Zak



Rp 3,000,000.00 Rp



Rp



2,000,000.00



Rp



2,000,000.00 Rp



2,001,100.00



Rp



1,100.00



2,000,000.00



Rp



1,100.00 Sampai 3/3/19



Rp



2,000,000.00



3,000,000.00 Rp



3,001,100.00



275,000.00



Rp



2,726,100.00



Rp



255



Rek Listrik



Rp



256



Bensin dll



Rp



30,100.00



Rp



2,696,000.00



257



Profil Gypsum



Rp



693,000.00



Rp



2,003,000.00



258



Rek. PDAM



Rp



850,000.00



Rp



1,153,000.00



259



Sewa Scafolding & Mobilisasi



Rp



870,000.00



Rp



283,000.00



260



Cat dan Kuas



Rp



124,000.00



Rp



159,000.00



261



Minuman Teh botol



Rp



31,000.00



Rp



128,000.00



262



Aplus, Lem & Kuas



Rp



88,000.00



Rp



40,000.00



40,000.00



Rp



263 264



Mata Gurinda (Tembok) & Spidol Rp



3Dos



Uang Jaminan 540 Rb



-



Tegel 10 Dus



Rp



2,340,000.00



Melalui Pak Jaya



265



Kaca Cermin Pintu Wc



Rp



415,000.00



Melalui Pak Jaya



266



Transfer dari owner



267



Bayar Upah Pemborong



Rp



4,000,000.00



9/3/2019



18/3/2019



Rp



4,000,000.00 Langsung ke rek. Firman



REKAPITULASI LAP. KEUANGAN



TOTAL TRANSFER & CASH DARI OWNER



Rp



Dana Langsung A.n Ke Pak Jaya



Rp



2,755,000.00



PENGELUARAN BAHAN



Rp



53,513,000.00



PEMBAYARAN UPAH BORONGAN



Rp



31,042,000.00



UPAH TUKANG LISTRIK



Rp



2,500,000.00



TOTAL BAHAN + UPAH BORONGAN + LISTRIK



Rp



87,055,000.00



SISA DANA



Rp



84,300,000.00



-