contoh rekod kewangan

Upload: hairul-faiszul-sanuri

Post on 31-Oct-2015

267 views

Category:

Documents


9 download

DESCRIPTION

rekod kewangan excel

TRANSCRIPT

Sheet1REKOD KEWANGAN 2010ITEMJUNEJULYAUGUSTSEPTEMBEROCTOBERNOVEMBERDECEMBERPENDAPATANBAKI861649.8147.37208.53336.02203.68864GAJI4573.474573.474573.474573.474573.474573.474573.47ELAUN1500150015001500150015001500ANAK500500500500500500500EDDAH100100100100100100100ROYALTI BUKU2625SPACE769raya500MTE675SPACE1350SPACE1582.5350PUL CUKAI PENDAPATAN350Jumlah pendapatan14885.977673.286720.8468827009.496877.15PERBELANJAANPOTONGAN GAJI:RUMAH905.29905.29905.29905.29905.29905.29905.29PCB96969696969696ZAKAT150150150150150150150BIRO (INSSURAN)256.02256.02256.02256.02256.02256.02256.02KOPERASI20202020202020TABUNG HAJI150150150150150150150

Jumlah1577.311577.311577.311577.311577.311577.311577.31TETAPKERETA470470470470470470TADIKA135195135135135135TASKA235110220227220220BAS959595959595

Jumlah9358709209279209200

BilsInternet505050.25050Celcom88106150.3244Electric362334.130.526Air71021412.5Jumlah181189255.62128.588.50

BELANJA BERUBAHRESTORAN MKN SEGERA10086.224.7MINYAK KERETA280170270310TOL90MAKAN N BRG DAPUR3001502803001000HADIAH KAWIN SITI NOR136.220.3BALIK KAMPUNG200500Barang elektrik290MEJA OVEN130FRAME SIJIL48YOS LADA KERING3.120DERMA1001060200MAK DAN AYAH500300BAJU 16416.926997.2KAD KREDIT3002606DERMA KUIH SITI NOR70SUSU HAIQAL3542.5RENEW KAD JUSCO12SUSU KAMBING DAN MINYAK5072100200BARANG DAPUR18041.65200SABUN EUMORA90KERETA25140UBAT JUSCO2018082.851000PEMBENTUNGAN48ALFA INDAH(IKAN)45.95ALFA INDAH53.5SPONSOR KASUT + TUDUNG13028180BELANJA GI SINGAPORE56.5MADU45BUKU BADAN & ALATULIS36.1101.15YOS24.5PARKSON124PELBAGAI (TANPA REKOD)600951.18001000PEGUAM N&I270RENANG94Pakaian150Seminar (HOTEL)217PASAR MALAM1730Jumlah 3823.853597.629262786.052180JUMLAH BELANJA6336.166225.915612.315545.984805.812497.311577.31SIMPANANPBM (PIF -HAIQAL )100PBM (PIF - ATIQAH)100PBM (PIF-ROHANA)1003001000PBM (PIEF - ATIQAH)200200100PMB (PIEF- ROHANA300PBM (PIEF -HAIQAL )200200100ASB380010005001000ASB (PENDAPATAN P. TIME4000Jumlah Simpanan79001400900100020000000000000000000RINGKASANPENDAPATAN14885.977673.286720.8468827009.496877.150JUMLAH BELANJA6336.166225.915612.315545.984805.812497.31BAKI KASAR8549.811447.371108.531336.022203.684379.84

JUMLAH SIMPANAN790014009001000200000BAKI KEBULAN DEPAN649.8147.37208.53336.02203.684379.840BERAKHIR PADA24-Jun-1023 julai

PELABURAN PUBLIC MUTUALJUAL PIF (15 /6)9275.41JUAL PIEF HAIQAL3928.72kereta 1/9beli vacumJUMLAH13204.13REINVESTSort termBELI PIEF (HAIQAL 25/6)5000BELI PIEF (ATIQAH 25/5)5000Long termBELI PIF (HAIQAL 25/6)5000beli pif rohana(28/8)10000SEVICE CHARGE4.3

Sheet2REKOD KEWANGAN 2013/14

ITEMAPRILMEIJUNJULAIOGOSSEPTOKTNOVDISJAN'14FEB'14MAC'14APRIL'2014PENDAPATANBAKI-350.00-700.00-1050.00-1400.00-2050.00TANGGUNGAN IBU BAPA400400400400400400400400400400400400PTPTN300300300300300300300300300300300300BONUS

Jumlah pendapatan700350.000.00-350.00-700.00PERBELANJAAN TETAPPOTONGAN GAJI: SEWA RUMAHPCBZAKATInsuranMotorInsuran

Jumlah0

PERBELANJAAN BERUBAH

MINYAK303030303030303030303030MAKAN / belanja dapur300300300300300300300300300300300300Bil telefon303030303030303030303030Bil air Bil elektrikLain-lain300

Jumlah360360360360660

SIMPANAN UNTUK MENCAPAI MATLAMATSIMPANAN PERIBADI 505050505050505050505050PENDAHULUAN KERETA105105105105105105105105105105105105PEMBELANJAAN LI & LM100100100.00100100100100100100100100100BERKAHWIN335335335335335335335335335335335335PINJAMAN PENDIDIKAN0PENDIDIKAN MASTER / Phd100100100100100100100100100100100100

JUMLAH690.00690.00690.00690.00690.00

PERBELANJAAN SEKALI SEKALA / KECEMASAN

Cukai pintuKlinik187Pakaian22.4Hadiah perkahwinan209.4

Jumlah0.00PENDAPATAN700350.000.00-350.00-700.000JUMLAH BELANJA 360.00360.00360.00360.00660.00BAKI KASAR340.00-10.00-360.00-710.00-1360.00SIMPANAN MATLAMAT690.00690.00690.00690.00690.00BAKI TOLAK SIMPANAN-350.00-700.00-1050.00-1400.00-2050.00SIMPANAN KECEMASAN00.000.000.000.00BAKI KEBULAN DEPAN-350.00-700.00-1050.00-1400.00-2050.00

Sheet3