{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["FORMULIR","Jurnal","HistoTbl","COA"],"not_rendered":{"charts":0,"images":4,"macros":1,"external_links":1,"defined_names":2,"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":"FORMULIR","index":0,"n_rows":12,"n_cols":11,"rows_kept":12,"cut":false,"hidden":false,"merged":[[4,3,4,7],[11,5,11,6],[9,5,9,6]]}
[null,"Formulir Input"]
[]
[null,null,null,null,null,{"$f":"IFERROR(MATCH(F7,#REF!,0)-4,\"\")","v":""}]
[]
[null,null,null,"I N P U T   J U R N A L"]
[]
[null,null,null,"Tanggal",":","21/12/2014"]
[null,null,null,"No. Bukti",":","001/pk/xii/14"]
[null,null,null,"Keterangan",":","Beli Komputer 1 unit"]
[null,null,null,"No. Rekening",":","6500",null,null,null,null,"<=== bagaimana membuat list nomor rekening dan nama rekening langsung bisa kita cari."]
[null,null,null,"D/K",":","K"]
[null,null,null,"Jumlah Rp.",":",12000000]

{"sheet":"Jurnal","index":1,"n_rows":17,"n_cols":10,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
["No.","Tanggal","Nomo Bukti","Keterangan","No.Rek","D/K","Jumlah","Debet","Kredit","Nama Rekening"]
[1,"21/12/2014","001/pk/xii/14","Beli Komputer 1 unit","6500","D",7500000,{"$f":"IF(F2=\"D\",G2,0)","v":7500000},{"$f":"IF(F2=\"K\",H2,0)","v":0}]
[2,"21/12/2014","001/pk/xii/14","Beli Komputer 1 unit","6500","D",7500000,{"$f":"IF(F3=\"D\",G3,0)","v":7500000},{"$f":"IF(F3=\"K\",H3,0)","v":0}]
[3,"21/12/2014","001/pk/xii/14","Beli Komputer 1 unit","6500","D",7500000,7500000,0]
[1,"21/12/2014","001/pk/xii/14","Beli Komputer 1 unit","6500","D",7500000,7500000,0]
[2,"21/12/2014","001/pk/xii/14","Beli Komputer 1 unit","6500","D",7500000,7500000,0]
[3,"21/12/2014","001/pk/xii/14","Beli Komputer 1 unit","6500","D",7500000,7500000,0]
[4,"21/12/2014","001/pk/xii/14","Beli Komputer 1 unit","6500","K",12000000,0,0]
[5,"21/12/2014","001/pk/xii/14","Beli Komputer 1 unit","6500","K",12000000,0,0]
[6,"21/12/2014","001/pk/xii/14","Beli Komputer 1 unit","6500","K",12000000,0,0]
[7,"21/12/2014","001/pk/xii/14","Beli Komputer 1 unit","6500","K",12000000,0,0]
[8,"21/12/2014","001/pk/xii/14","Beli Komputer 1 unit","6500","K",12000000,0,0]
[9,"21/12/2014","001/pk/xii/14","Beli Komputer 1 unit","6500","K",12000000,0,0]
[13,"21/12/2014","001/pk/xii/14","Beli Komputer 1 unit","6500","K",12000000,0,0]
[14,"21/12/2014","001/pk/xii/14","Beli Komputer 1 unit","6500","K",12000000,0,0]
[15,"21/12/2014","001/pk/xii/14","Beli Komputer 1 unit","6500","K",12000000,0,0]
[16,"21/12/2014","001/pk/xii/14","Beli Komputer 1 unit","6500","K",12000000,{"$f":"IF(F17=\"D\",G17,0)","v":0},{"$f":"IF(F17=\"K\",H17,0)","v":0}]

{"sheet":"HistoTbl","index":2,"n_rows":8,"n_cols":12,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
[null,"tabel histori adalah tabel yg meyimpan data yg pernah diubah/dihapus"]
[]
[]
["No.","Tanggal","Nomo Bukti","Keterangan","No.Rek","D/K","Jumlah","Debet","Kredit","Nama Rekening"]
[3,"003","Rk","Ad","Ckg","Jkt",31810,"S1","SE","2011-09-26T16:52:40","Edited"]
[5,"005","SK","Design","Ckg","Jkt",34824,"SMU","Design","2011-09-30T23:17:11","Deleted"]
[4,"004","Tk","Tek","Ckg","Jkt",32935,"S1","TI","2014-12-25T19:01:52","Deleted"]
[null,null,null,null,null,null,null,null,null,null,"12/25/2014  11:16:14 PM","Deleted"]

{"sheet":"COA","index":3,"n_rows":51,"n_cols":2,"rows_kept":51,"cut":false,"hidden":false,"merged":[]}
["No Rek.","Nama Rekening"]
["1111","Kas Kecil"]
["1121","Bank Mulia"]
["1122","Bank Sejahtera"]
["1123","Bank Abadi"]
["1210.01","Piutang Dagang - Tuan A"]
["1210.02","Piutang Dagang - Tuan B"]
["1210.03","Piutang Dagang - Tuan C"]
["1220","Piutang Karyawan"]
["1300","Persediaan Barang"]
["1400","Pajak dibayar dimuka"]
["1450","Biaya dibayar dimuka"]
["1510","Tanah"]
["1520","Bangunan"]
["1520.01","Akumulasi penyusutan Bangunan"]
["1530","Mesin dan Peralatan Kantor"]
["1530.01","Ak. Peny. Mesin dan Peralatan"]
["1610","Jaminan"]
["2110.01","Hutang Dagang - Tuan P"]
["2110.02","Hutang Dagang - Tuan Q"]
["2110.03","Hutang Dagang - Tuan R"]
["2120","Hutang Bunga"]
["2130","Hutang Pajak"]
["2140","Hutang Jangka pendek lainnya"]
["2200","Biaya yang masih harus dibayar"]
["2300","Hutang Bank yang telah j/t"]
["2500","Hutang Bank"]
["3100","Modal disetor"]
["3200","Laba/(Rugi) ditahan "]
["3300","Dividen"]
["4000","Penjualan"]
["5000","Beban Pokok Penjualan"]
["6110","Gaji/bonus bagian Penjualan"]
["6111","THR bagian Penjualan"]
["6120","Pengobatan bagian Penjualan"]
["6130","Beban Promosi "]
["6140","Beban distribusi"]
["6150","Beban penjualan lain-lain"]
["6210","Gaji/bonus bagian Adm & Umum"]
["6211","THR bagian Adm & Umum"]
["6220","Pengobatan bagian Adm & Umum"]
["6230","Beban alat tulis dan kantor"]
["6240","Beban listrik,telp. dan air"]
["6250","Beban pemeliharaan"]
["6260","Beban asuransi"]
["6270","Beban sewa"]
["6280","Beban penyusutan/amortisasi"]
["6290","Beban adm dan umum lainnya"]
["9110","Jasa giro"]
["9210","Beban bunga"]
["9300","Pajak penghasilan"]