{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["EA2022","System"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"EA2022","index":0,"n_rows":73,"n_cols":42,"rows_kept":73,"cut":false,"hidden":false,"merged":[[15,10,15,17],[15,34,15,41],[16,34,16,41],[9,16,9,41],[0,0,0,5],[0,14,0,28],[0,29,0,39],[1,13,1,28],[2,4,2,9],[2,13,2,28],[2,30,2,41],[3,4,3,9],[3,13,3,24],[3,25,3,26],[3,36,3,41],[5,0,6,41],[11,5,11,23],[11,34,11,41],[12,7,12,17],[12,34,12,41],[13,7,13,17],[13,34,13,41],[18,0,19,0],[19,36,19,41],[22,25,22,27],[22,28,22,30],[22,31,22,33],[22,36,22,41],[21,36,21,41],[23,28,23,34],[23,36,23,41],[34,11,34,34],[34,36,34,41],[24,36,24,41],[25,36,25,41],[26,11,26,18],[26,19,26,20],[26,21,26,28],[26,36,26,41],[29,10,29,28],[30,10,30,28],[30,36,30,41],[32,14,32,34],[32,36,32,41],[51,25,51,32],[35,36,35,41],[36,36,36,41],[37,36,37,41],[38,36,38,41],[41,36,41,41],[42,36,42,41],[59,35,59,41],[43,36,43,41],[46,36,46,41],[47,36,47,41],[48,36,48,41],[49,36,49,41],[52,25,52,32],[54,36,54,41],[57,9,57,41],[58,33,58,34],[58,35,58,41],[69,23,69,40],[70,23,70,40],[72,2,72,7],[72,23,72,40],[61,33,61,34],[61,35,61,41],[64,23,64,40],[65,23,65,40],[66,23,66,40],[68,23,68,40]]}
["(C.P. 8A - Pin. 2022) ",null,null,null,null,null,null,null,null,null,null,null,null,null,"MALAYSIA",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Penyata Gaji Pekerja SWASTA",null,null,null,null,null,null,null,null,null,null,null,"EA"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"CUKAI PENDAPATAN   ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"No. Cukai Pendapatan Pekerja"]
["No. Siri ",null,null,null,null,null,null,null,null,null,null,null,null,"PENYATA SARAAN DARIPADA PENGGAJIAN",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(AI12,tEmployeeDatas[],5,0)","v":"S1234"}]
["No. Majikan E",null,null,null,null,null,null,null,null,null,null,null,null,"BAGI TAHUN BERAKHIR 31 DISEMBER  ",null,null,null,null,null,null,null,null,null,null,null,2022,null,null,null,null,"Cawangan LHDNM"]
[]
["BORANG EA INI PERLU DISEDIAKAN UNTUK DISERAHKAN KEPADA PEKERJA BAGI TUJUAN CUKAI PENDAPATAN "]
[]
[]
["A","BUTIRAN PEKERJA"]
[null,"1.","Nama Penuh Pekerja/Pesara (En./Cik/Puan)",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(AI12,tEmployeeDatas[],2,FALSE)","v":"Kent Lau"}]
[]
[null,"2.","Jawatan",null,null,{"$f":"VLOOKUP(AI12,tEmployeeDatas[],3,0)","v":"Director"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3.","No. Kakitangan/No. Gaji",null,null,null,null,null,null,null,"CW001"]
[null,"4.","No. K.P. Baru ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"5.","No. Pasport"]
[null,"6.","No. KWSP",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"7.","No. PERKESO"]
[null,"8.","Bilangan Anak Yang Layak",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"9.","Jika bekerja tidak genap setahun, nyatakan:"]
[null,null,"Untuk Pelepasan Cukai",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(a)","Tarikh mula bekerja",null,null,null,null,null,null,{"$f":"VLOOKUP(AI12,tEmployeeDatas[],4,0)","v":"2013-01-01"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(b)","Tarikh berhenti kerja"]
[]
["B","PENDAPATAN PENGGAJIAN, MANFAAT DAN TEMPAT KEDIAMAN "]
[null,"(Tidak Termasuk Elaun/Perkuisit/Pemberian/Manfaat Yang Dikecualikan Cukai)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RM"]
[]
[null,"1.","(a)","Gaji kasar, upah atau gaji cuti (termasuk gaji lebih masa)"]
[null,null,"(b)","Fi (termasuk fi pengarah), komisen atau bonus "]
[null,null,"(c)","Tip kasar, perkuisit, penerimaan sagu hati atau elaun-elaun lain (Perihal pembayaran:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,")"]
[null,null,"(d)","Cukai Pendapatan yang dibayar oleh Majikan bagi pihak Pekerja"]
[null,null,"(e)","Manfaat Skim Opsyen Saham Pekerja (ESOS)"]
[null,null,"(f)","Ganjaran bagi tempoh dari",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"hingga"]
[]
[null,"2.","Butiran bayaran tunggakan dan lain-lain bagi tahun-tahun terdahulu dalam tahun semasa"]
[null,null,"Jenis pendapatan ",null,null,null,null,null,"(a)"]
[null,null,null,null,null,null,null,null,"(b)"]
[]
[null,"3.","Manfaat berupa barangan (Nyatakan:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,")"]
[]
[null,"4.","Nilai tempat kediaman (Alamat:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,")"]
[]
[null,"5.","Bayaran balik daripada Kumpulan Wang Simpanan/Pencen yang tidak diluluskan"]
[]
[null,"6.","Pampasan kerana kehilangan pekerjaan"]
[]
["C","PENCEN DAN LAIN-LAIN"]
[null,"1.","Pencen"]
[null,"2.","Anuiti atau Bayaran Berkala yang lain"]
[null,"JUMLAH"]
[]
["D","JUMLAH POTONGAN"]
[null,"1.","Potongan Cukai Bulanan (PCB) yang dibayar kepada LHDNM"]
[null,"2.","Arahan Potongan CP 38"]
[null,"3.","Zakat yang dibayar melalui potongan gaji"]
[null,"4.","Derma / Hadiah / sumbangan diluluskan yang dibayar melalui potongan gaji"]
[null,"5.","Jumlah tuntutan potongan oleh pekerja melalui Borang TP1 berkaitan:"]
[null,null,"(a)",null,"Pelepasan",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RM"]
[null,null,"(b)",null,"Zakat selain yang dibayar melalui potongan gaji bulanan",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RM"]
[]
[null,"6.","Jumlah pelepasan bagi anak yang layak"]
[]
["E","CARUMAN YANG DIBAYAR OLEH PEKERJA KEPADA KUMPULAN WANG SIMPANAN/PENCEN YANG DILULUSKAN DAN PERKESO"]
[null,"1.","Nama Kumpulan Wang"]
[null,null,"Amaun caruman yang wajib dibayar (nyatakan bahagian pekerja sahaja)   ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RM"]
[null,"2.","PERKESO : Amaun caruman yang wajib dibayar (nyatakan bahagian pekerja sahaja)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RM"]
[]
["F","JUMLAH ELAUN / PERKUISIT / PEMBERIAN / MANFAAT YANG DIKECUALIKAN CUKAI",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RM"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Nama Pegawai"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Jawatan"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Nama dan Alamat Majikan"]
[]
[]
[]
["Tarikh",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"No. Telefon Majikan"]

{"sheet":"System","index":1,"n_rows":10,"n_cols":6,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,"Emp ID","Emp Name","Position","Hired Date","HASIL No"]
[null,"CW001","Kent Lau","Director","2013-01-01","S1234"]
[null,"CW002","Michelle","HR Manager","2023-02-01","S2334"]
[]
[]
[]
[null,"CW001",{"$f":"VLOOKUP(B10,tEmployeeDatas[],2,FALSE)","v":"Kent Lau"}]