{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Inventaris Wasiat","Aset Wasiat","Liabilitas Wasiat"],"not_rendered":{"defined_names":1},"read":"whole","date_system":"1900"}

{"sheet":"Inventaris Wasiat","index":0,"n_rows":45,"n_cols":35,"rows_kept":45,"merged":[[0,1,0,30],[0,31,0,39],[1,1,5,39],[6,1,6,6],[6,7,6,39],[7,1,7,6],[7,7,7,39],[9,1,9,6],[9,7,9,39],[10,1,10,6],[10,7,10,39],[11,1,11,6],[11,7,11,20],[11,21,11,26],[11,27,11,30],[11,31,11,33],[11,34,11,39],[12,1,12,6],[12,7,12,20],[12,21,12,26],[13,1,13,6],[13,7,13,20],[13,21,13,26],[14,1,14,6],[14,7,14,20],[14,21,14,26],[15,1,15,6],[17,1,17,39],[18,1,18,6],[18,7,18,12],[18,13,18,15],[18,16,18,18],[18,19,18,26],[18,27,18,31],[18,32,18,39],[19,1,19,6],[19,7,19,12],[19,13,19,15],[19,16,19,18],[19,19,19,26],[19,27,19,31],[19,32,19,39],[20,1,20,6],[20,7,20,12],[20,13,20,15],[20,16,20,18],[20,19,20,26],[20,27,20,31],[20,32,20,39],[21,1,21,6],[21,7,21,12],[21,13,21,15],[21,16,21,18],[21,19,21,26],[21,27,21,31],[21,32,21,39],[22,1,22,6],[22,7,22,12],[22,13,22,15],[22,16,22,18],[22,19,22,26],[22,27,22,31],[22,32,22,39],[23,1,23,6],[23,7,23,12],[23,13,23,15],[23,16,23,18],[23,19,23,26],[23,27,23,31],[23,32,23,39],[25,1,25,39],[26,1,26,6],[26,7,26,12],[26,13,26,18],[26,19,26,26],[26,27,26,31],[26,32,26,39],[27,1,27,6],[27,7,27,12],[27,13,27,18],[27,19,27,26],[27,27,27,31],[27,32,27,39],[28,1,28,6],[28,7,28,12],[28,13,28,18],[28,19,28,26],[28,27,28,31],[28,32,28,39],[29,1,29,6],[29,7,29,12],[29,13,29,18],[29,19,29,26],[29,27,29,31],[29,32,29,39],[30,1,30,6],[30,7,30,12],[30,13,30,18],[30,19,30,26],[30,27,30,31],[30,32,30,39],[31,1,31,6],[31,7,31,12],[31,13,31,18],[31,19,31,26],[31,27,31,31],[31,32,31,39],[33,1,33,12],[33,14,33,39],[34,1,34,12],[34,14,34,21],[34,22,34,25],[34,26,34,33],[34,34,34,39],[35,2,35,12],[35,14,35,21],[35,22,35,25],[35,26,35,33],[35,34,35,39],[36,2,36,12],[36,14,36,21],[36,22,36,25],[36,26,36,33],[36,34,36,39],[37,2,37,12],[37,14,37,21],[37,22,37,25],[37,26,37,33],[37,34,37,39],[38,2,38,12],[38,14,38,21],[38,22,38,25],[38,26,38,33],[38,34,38,39],[39,2,39,12],[39,14,39,21],[39,22,39,25],[39,26,39,33],[39,34,39,39],[40,2,40,12],[40,14,40,21],[40,22,40,25],[40,26,40,33],[40,34,40,39],[41,2,41,12],[41,14,41,21],[41,22,41,25],[41,26,41,33],[41,34,41,39],[42,2,42,12],[42,14,42,21],[42,22,42,25],[42,26,42,33],[42,34,42,38],[43,2,43,12],[43,14,43,21],[43,22,43,25],[43,26,43,33],[43,34,43,39],[44,2,44,12],[44,14,44,21],[44,22,44,25],[44,26,44,33],[44,34,44,39]]}
[]
[null,"Inventaris Wasiat"]
[]
[]
[]
[]
[null,"Nama Eksekutor",{"$nulls":5},"Alan Mudzaki"]
[null,"Informasi Kontak",{"$nulls":5},"Jalan Mawar no. 4567, Jakarta 98052"]
[]
[null,"Nama Orang yang Meninggal",{"$nulls":5},"Agus Bramantya"]
[null,"Alamat",{"$nulls":5},"Jalan Mawar no. 6789"]
[null,"Kota",{"$nulls":5},"Jakarta",{"$nulls":13},"Provinsi",{"$nulls":5},"JKT",{"$nulls":3},"Kode Pos",null,null,98052]
[null,"KTP",{"$nulls":5},"AAA-GG-SSSS",{"$nulls":13},"Pekerjaan",{"$nulls":5},"Dokter"]
[null,"Tanggal Kelahiran",{"$nulls":5},"1965-12-08",{"$nulls":13},"Tempat Kelahiran",{"$nulls":5},"JKT"]
[null,"Tanggal Kematian",{"$nulls":5},{"$f":"TODAY()-3","v":"2022-05-15"},{"$nulls":13},"Tempat Kematian",{"$nulls":5},"JKT"]
[null,"Informasi Tambahan"]
[]
[null,"  Pasangan, Anak dan Tanggungan Lainnya"]
[null,"Nama",{"$nulls":5},"Hubungan",{"$nulls":5},"Tanggungan",null,null,"Umur",null,null,"Alamat",{"$nulls":7},"Nomor Telepon",{"$nulls":4},"Email"]
[null,"Miranda Nainggolan",{"$nulls":5},"Perwakilan Pribadi",{"$nulls":5},"Tidak",null,null,30]
[null,"Vina Lindasari",{"$nulls":5},"Pasangan",{"$nulls":5},"Ya",null,null,35]
[null,"Adipati Martadinata",{"$nulls":5},"Anak-anak",{"$nulls":5},"Ya",null,null,12]
[]
[]
[]
[null,"Konsultan Profesional"]
[null,"Tipe Konsultan",{"$nulls":5},"Narahubung",{"$nulls":5},"Perusahaan",{"$nulls":5},"Alamat",{"$nulls":7},"Nomor Telepon",{"$nulls":4},"Email"]
[null,"Akuntan"]
[null,"Pengacara/Notaris"]
[null,"Lainnya"]
[]
[]
[]
[null,"  Daftar Periksa Wasiat",{"$nulls":12},"  Inventaris Wasiat"]
[null,"    Item Daftar Periksa",{"$nulls":12},"Aset Wasiat",{"$nulls":7},"Nilai (Rp)",{"$nulls":3},"Liabilitas Wasiat",{"$nulls":7},"Nilai (Rp)"]
[null,"✔","Wasiat Terakhir, Perjanjian, atau dokumen lainnya",{"$nulls":11},{"$f":"'Aset Wasiat'!B12","v":"Rekening Bank"},{"$nulls":7},{"$f":"'Aset Wasiat'!G20","v":{"v":0,"d":"Rp0.00"}},{"$nulls":3},{"$f":"'Liabilitas Wasiat'!B11","v":"Hipotek"},{"$nulls":7},{"$f":"'Liabilitas Wasiat'!G18","v":{"v":0,"d":"Rp0.00"}}]
[null,"✔","Perjanjian sewa dan kunci brankas",{"$nulls":11},{"$f":"'Aset Wasiat'!B22","v":"Investasi Pribadi"},{"$nulls":7},{"$f":"'Aset Wasiat'!G30","v":{"v":0,"d":"Rp0.00"}},{"$nulls":3},{"$f":"'Liabilitas Wasiat'!B21","v":"Pinjaman Pribadi dan Lini Kredit"},{"$nulls":7},{"$f":"'Liabilitas Wasiat'!G28","v":{"v":0,"d":"Rp0.00"}}]
[null,"✖","Kata sandi untuk komputer dan akun online",{"$nulls":11},{"$f":"'Aset Wasiat'!B32","v":"Bunga Bisnis"},{"$nulls":7},{"$f":"'Aset Wasiat'!G40","v":{"v":0,"d":"Rp0.00"}},{"$nulls":3},{"$f":"'Liabilitas Wasiat'!B31","v":"Bunga Bisnis"},{"$nulls":7},{"$f":"'Liabilitas Wasiat'!G38","v":{"v":0,"d":"Rp0.00"}}]
[null,"✔","Perjanjian living trust",{"$nulls":11},{"$f":"'Aset Wasiat'!B42","v":"Real Estat"},{"$nulls":7},{"$f":"'Aset Wasiat'!G50","v":{"v":0,"d":"Rp0.00"}},{"$nulls":3},{"$f":"'Liabilitas Wasiat'!B41","v":"Kartu Kredit"},{"$nulls":7},{"$f":"'Liabilitas Wasiat'!G48","v":{"v":0,"d":"Rp0.00"}}]
[null,"✔","Asuransi jiwa, kesehatan/kecelakaan, dan polis asuransi",{"$nulls":11},{"$f":"'Aset Wasiat'!B52","v":"Rencana Pensiun"},{"$nulls":7},{"$f":"'Aset Wasiat'!G60","v":{"v":0,"d":"Rp0.00"}},{"$nulls":3},{"$f":"'Liabilitas Wasiat'!B51","v":"Liabilitas Lainnya"},{"$nulls":7},{"$f":"'Liabilitas Wasiat'!G58","v":{"v":0,"d":"Rp0.00"}}]
[null,"✔","Laporan keuangan",{"$nulls":11},{"$f":"'Aset Wasiat'!B62","v":"Asuransi"},{"$nulls":7},{"$f":"'Aset Wasiat'!G70","v":{"v":0,"d":"Rp0.00"}}]
[null,"✔","Pengembalian pajak penghasilan selama tiga tahun terakhir",{"$nulls":11},{"$f":"'Aset Wasiat'!B72","v":"Pinjaman Pribadi dan Hipotek"},{"$nulls":7},{"$f":"'Aset Wasiat'!G80","v":{"v":0,"d":"Rp0.00"}}]
[null,"✔","Sertifikat kelahiran dan kematian",{"$nulls":11},{"$f":"'Aset Wasiat'!B82","v":"Bunga pada Estat dan Trust lainnya"},{"$nulls":7},{"$f":"'Aset Wasiat'!G90","v":{"v":0,"d":"Rp0.00"}}]
[null,"✖","Akta, hipotek, dan pernyataan sewa",{"$nulls":11},{"$f":"'Aset Wasiat'!B92","v":"Efek Pribadi dan Aset lainnya"},{"$nulls":7},{"$f":"'Aset Wasiat'!G100","v":{"v":0,"d":"Rp0.00"}}]
[null,"☐","Tagihan dan catatan yang belum dibayar",{"$nulls":11},"Total Aset",{"$nulls":7},{"$f":"'Aset Wasiat'!G10","v":{"v":0,"d":"Rp0.00"}},{"$nulls":3},"Total Liabilitas",{"$nulls":7},{"$f":"SUM(AI36:AN44)","v":{"v":0,"d":"Rp0.00"}}]

{"sheet":"Aset Wasiat","index":1,"n_rows":100,"n_cols":8,"rows_kept":100,"merged":[[0,1,0,7],[1,1,5,7],[6,1,7,7],[11,1,11,7],[12,1,12,7],[21,1,21,7],[22,1,22,7],[31,1,31,7],[32,1,32,7],[41,1,41,7],[42,1,42,7],[51,1,51,7],[52,1,52,7],[61,1,61,7],[62,1,62,7],[71,1,71,7],[72,1,72,7],[81,1,81,7],[82,1,82,7],[91,1,91,7],[92,1,92,7]]}
[]
[null,"Aset Wasiat"]
[]
[]
[]
[]
[null,"Gunakan lembar kerja ini untuk membuat inventaris aset wasiat. Anda perlu menentukan nilai pasar setiap aset estat pada tanggal kematian. Tinjau semua catatan, termasuk laporan keuangan, kebijakan asuransi, dan pengembalian pajak untuk mendapatkan nilai pasar. Anda mungkin juga perlu mendapatkan penilaian barang-barang pribadi (misalnya, karya seni, koleksi, barang antik, dll.). Pastikan untuk menyertakan aset asing apa pun dalam inventaris, seperti real estat, surat berharga, atau bunga bisnis di luar negeri. Anda mungkin ingin mendapatkan bantuan profesional untuk mendapatkan nilai pasar yang akurat untuk aset asing."]
[]
[]
[null,"Total Aset",{"$nulls":4},{"$f":"tblRekeningBank[[#Totals],[Saldo ]]+tblInvestasiPribadi[[#Totals],[Nilai Pasar]]+tblBungaBisnis[[#Totals],[Nilai ]]+tblRealEstat[[#Totals],[Harga Pasar]]+tblRencanaPensiun[[#Totals],[Nilai ]]+tblAsuransi[[#Totals],[Nilai Kas ]]+tblHipotek[[#Totals],[Saldo Terhutang ]]+tblReksadana[[#Totals],[Jumlah Distribusi]]+tblAsetLainnya[[#Totals],[Nilai ]]","v":{"v":0,"d":"Rp0.00"}}]
[]
[null,"Rekening Bank"]
[null,"Cantumkan semua rekening bank termasuk uang tunai, cek perjalanan, wesel, dan rekening dengan bank komersial, bank tabungan, serikat kredit, dll. Sertakan semua nama yang tercantum pada rekening dan nilai tunai aktual yang mengacu pada dolar yang tepat dan jumlah perubahan pada saat kematian."]
[null,"Lembaga Keuangan ","Alamat","Telepon","Nomor Rekening","Tipe Akun","Saldo ","Catatan"]
[]
[]
[]
[]
[]
[null,"Total",{"$nulls":4},{"$f":"SUBTOTAL(109,tblRekeningBank[[Saldo ]])","v":{"v":0,"d":"Rp0.00"}}]
[]
[null,"Investasi Pribadi"]
[null,"Cantumkan rekening tunai, rekening margin, Rekening Tabungan Bebas Pajak, Rencana Tabungan Pensiun Terdaftar (RRSP), Dana Pendapatan Pensiun Terdaftar (RRIF), RRIF Terkunci, RRSP Terkunci, Dana Pendapatan Jiwa, Dana Pendapatan Pensiun yang Ditetapkan, Tabungan Pendidikan Terdaftar Rencana, anuitas, dll."]
[null,"Perusahaan","Alamat","Telepon","Nomor Rekening","Penerima","Nilai Pasar","Catatan"]
[]
[]
[]
[]
[]
[null,"Total",{"$nulls":4},{"$f":"SUBTOTAL(109,tblInvestasiPribadi[Nilai Pasar])","v":{"v":0,"d":"Rp0.00"}}]
[]
[null,"Bunga Bisnis"]
[null,"Cantumkan semua bunga bisnis termasuk kepemilikan tunggal, praktik profesional, korporasi, kemitraan, perseroan terbatas dan kemitraan, usaha patungan, dan entitas bisnis non-publik lainnya. "]
[null,"Nama Bisnis","Alamat","Telepon","Kontak","Tipe","Nilai ","Catatan"]
[]
[]
[]
[]
[]
[null,"Total",{"$nulls":4},{"$f":"SUBTOTAL(109,tblBungaBisnis[[Nilai ]])","v":{"v":0,"d":"Rp0.00"}}]
[]
[null,"Real Estat"]
[null,"Cantumkan properti aktual apa pun yang dimiliki, dimiliki bersama, atau diminati oleh almarhum dan/atau pasangan/pasangan almarhum, termasuk properti yang dibeli dalam pengembangan rekreasi dan pembagian waktu. Dapatkan salinan akta. Berikan deskripsi real estat beserta alamat fisiknya. Cantumkan nilai pasar wajar properti, berdasarkan penilaian terbaru oleh penilai pajak."]
[null,"Alamat","Pemegang","Telepon","Kontak","Harga Pembelian","Harga Pasar","Catatan"]
[]
[]
[]
[]
[]
[null,"Total",{"$nulls":3},{"$f":"SUBTOTAL(109,tblRealEstat[Harga Pembelian])","v":{"v":0,"d":"Rp0.00"}},{"$f":"SUBTOTAL(109,tblRealEstat[Harga Pasar])","v":{"v":0,"d":"Rp0.00"}}]
[]
[null,"Rencana Pensiun"]
[null,"Cantumkan pensiunan pasti, pembelian uang atau iuran pasti, DPSP atau RRSP kelompok, dll."]
[null,"Perusahaan","Telepon","Tipe Rencana","Penerima","Email","Nilai ","Catatan"]
[]
[]
[]
[]
[]
[null,"Total",{"$nulls":4},{"$f":"SUBTOTAL(109,tblRencanaPensiun[[Nilai ]])","v":{"v":0,"d":"Rp0.00"}}]
[]
[null,"Asuransi"]
[null,"Sertakan living trust, polis asuransi jiwa dengan penerima manfaat yang disebutkan, dan akun investasi yang ditransfer saat kematian, sebagai aset non-wasiat. Jika pengadilan menanyakan tentang aset ini, pelaksana dapat dengan mudah merujuk daftar aset non-wasiat dan menjelaskan ketidakhadirannya dari inventaris wasiat."]
[null,"Penerbit","Nomor Polis","Telepon","Penerima","Nilai Pari ","Nilai Kas ","Catatan"]
[]
[]
[]
[]
[]
[null,"Total",{"$nulls":3},{"$f":"SUBTOTAL(109,tblAsuransi[[Nilai Pari ]])","v":{"v":0,"d":"Rp0.00"}},{"$f":"SUBTOTAL(109,tblAsuransi[[Nilai Kas ]])","v":{"v":0,"d":"Rp0.00"}}]
[]
[null,"Pinjaman Pribadi dan Hipotek"]
[null,"Cantumkan pinjaman pribadi dan hipotek yang pemberi pinjamannya adalah almarhum."]
[null,"Nama Peminjam","Alamat","Telepon","Tipe","Jumlah Asli","Saldo Terhutang ","Catatan"]
[]
[]
[]
[]
[]
[null,"Total",{"$nulls":3},{"$f":"SUBTOTAL(109,tblHipotek[Jumlah Asli])","v":{"v":0,"d":"Rp0.00"}},{"$f":"SUBTOTAL(109,tblHipotek[[Saldo Terhutang ]])","v":{"v":0,"d":"Rp0.00"}}]
[]
[null,"Bunga pada Estat dan Trust lainnya"]
[null,"Cantumkan set yang terdaftar atas nama almarhum yang dimiliki atas nama orang lain (misalnya aset yang dimiliki oleh almarhum sebagai wali amanat atau aset yang dipegang berdasarkan Surat Kuasa)."]
[null,"Nama Estat/Trust","Nama Eksekutor/Wali","Telepon","Alamat","Email","Jumlah Distribusi","Catatan"]
[]
[]
[]
[]
[]
[null,"Total",{"$nulls":4},{"$f":"SUBTOTAL(109,tblReksadana[Jumlah Distribusi])","v":{"v":0,"d":"Rp0.00"}}]
[]
[null,"Efek Pribadi dan Aset lainnya"]
[null,"Cantumkan semua item pribadi misalnya; mobil, permata, seni, barang antik, furnitur. Sertakan barang-barang yang mungkin disimpan di brankas atau tempat penyimpanan aman."]
[null,"Deskripsi Item","Lokasi","Telepon","Kontak","Penerima","Nilai ","Catatan"]
[]
[]
[]
[]
[]
[null,"Total",{"$nulls":4},{"$f":"SUBTOTAL(109,tblAsetLainnya[[Nilai ]])","v":{"v":0,"d":"Rp0.00"}}]

{"sheet":"Liabilitas Wasiat","index":2,"n_rows":58,"n_cols":8,"rows_kept":58,"merged":[[0,1,0,7],[1,1,5,7],[6,1,6,7],[10,1,10,7],[20,1,20,7],[30,1,30,7],[40,1,40,7],[50,1,50,7]]}
[]
[null,"Liabilitas Wasiat"]
[]
[]
[]
[]
[null,"Gunakan lembar kerja ini untuk mengumpulkan detail liabilitas warisan, baik domestik maupun asing. Anda akan memerlukan penilaian setiap liabilitas pada tanggal kematian."]
[]
[null,"Total Aset",{"$nulls":4},{"$f":"SUM(G18,G28,G38,G48,G58)","v":{"v":0,"d":"Rp0.00"}}]
[]
[null,"Hipotek"]
[null,"Lembaga Keuangan ","Alamat","Telepon","Pemegang","Nomor Rekening","Saldo ","Catatan"]
[]
[]
[]
[]
[]
[null,"Total",{"$nulls":4},{"$f":"SUBTOTAL(109,tblRekeningBank2[[Saldo ]])","v":{"v":0,"d":"Rp0.00"}}]
[]
[]
[null,"Pinjaman Pribadi dan Lini Kredit"]
[null,"Lembaga Keuangan","Alamat","Telepon"," Nomor Rekening","Tipe","Saldo ","Catatan"]
[]
[]
[]
[]
[]
[null,"Total",{"$nulls":4},{"$f":"SUBTOTAL(109,tblInvestasiPribadi3[[Saldo ]])","v":{"v":0,"d":"Rp0.00"}}]
[]
[]
[null,"Bunga Bisnis"]
[null,"Nama Bisnis","Alamat"," Telepon"," Kontak","Tipe","Nilai ","Catatan"]
[]
[]
[]
[]
[]
[null,"Total",{"$nulls":4},{"$f":"SUBTOTAL(109,tblBungaBisnis4[[Nilai ]])","v":{"v":0,"d":"Rp0.00"}}]
[]
[]
[null,"Kartu Kredit"]
[null,"Perusahaan Kartu Kredit","Alamat Perusahaan","Telepon","Nomor Kartu","Tanggal Kedaluwarsa ","Saldo ","Catatan"]
[]
[]
[]
[]
[]
[null,"Total",{"$nulls":4},{"$f":"SUBTOTAL(109,tblRealEstat5[[Saldo ]])","v":{"v":0,"d":"Rp0.00"}}]
[]
[]
[null,"Liabilitas Lainnya"]
[null,"Deskripsi Item","Lokasi","Telepon","Kontak","Penerima","Nilai ","Catatan"]
[]
[]
[]
[]
[]
[null,"Total",{"$nulls":4},{"$f":"SUBTOTAL(109,tblRencanaPensiun6[[Nilai ]])","v":{"v":0,"d":"Rp0.00"}}]