{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Neraca","Bagan tahun ke tahun"],"not_rendered":{"charts":2,"external_links":2},"unopened":[{"sheet":"Bagan tahun ke tahun","index":1,"reason":"not_a_worksheet"}],"read":"whole","date_system":"1900"}

{"sheet":"Neraca","index":0,"n_rows":49,"n_cols":4,"rows_kept":49}
[]
[null,"Nama Perusahaan Anda",null,"Neraca"]
[]
[null,"Aset"]
[null,"Aset lancar:","2019","2020"]
[null,"Tunai",0,0]
[null,"Investasi",0,0]
[null,"Inventaris",0,0]
[null,"Piutang dagang",0,0]
[null,"Pengeluaran yang dibayar di muka",0,0]
[null,"Lainnya",0,0]
[null,"Total aset lancar",{"$f":"SUBTOTAL(109,asetlancar[2019])","v":0},{"$f":"SUBTOTAL(109,asetlancar[2020])","v":0}]
[]
[null,"Aset tetap:","2019","2020"]
[null,"Properti dan perlengkapan",0,0]
[null,"Penyempurnaan penyewaan",0,0]
[null,"Ekuitas dan investasi lain",0,0]
[null,"Depresiasi yang kurang terakumulasi",0,0]
[null,"Total aset tetap",{"$f":"SUBTOTAL(109,asettetap[2019])","v":0},{"$f":"SUBTOTAL(109,asettetap[2020])","v":0}]
[]
[null,"Aset lainnya:","2019","2020"]
[null,"Goodwill",0,0]
[null,"Total aset lainnya",{"$f":"SUBTOTAL(109,asetlainnya[2019])","v":0},{"$f":"SUBTOTAL(109,asetlainnya[2020])","v":0}]
[]
[null,"Total aset",{"$f":"asetlainnya[[#Totals],[2019]]+asettetap[[#Totals],[2019]]+asetlancar[[#Totals],[2019]]","v":0},{"$f":"asetlainnya[[#Totals],[2020]]+asettetap[[#Totals],[2020]]+asetlancar[[#Totals],[2020]]","v":0}]
[]
[null,"Utang dan ekuitas pemilik"]
[null,"Utang jangka pendek:","2019","2020"]
[null,"Utang dagang",0,0]
[null,"Gaji aktual",0,0]
[null,"Kompensasi aktual",0,0]
[null,"Utang pajak penghasilan",0,0]
[null,"Pendapatan yang diterima di muka",0,0]
[null,"Lainnya",0,0]
[null,"Total utang jangka pendek",{"$f":"SUBTOTAL(109,utangjangkapendek[2019])","v":0},{"$f":"SUBTOTAL(109,utangjangkapendek[2020])","v":0}]
[]
[null,"Utang jangka panjang:","2019","2020"]
[null,"Utang hipotek",0,0]
[null,"Total utang jangka panjang",{"$f":"SUBTOTAL(109,utangjangkapanjang[2019])","v":0},{"$f":"SUBTOTAL(109,utangjangkapanjang[2020])","v":0}]
[]
[null,"Ekuitas pemilik:","2019","2020"]
[null,"Modal investasi",0,0]
[null,"Laba ditahan",0,0]
[null,"Total ekuitas pemilik",{"$f":"SUBTOTAL(109,ekuitaspemilik[2019])","v":0},{"$f":"SUBTOTAL(109,ekuitaspemilik[2020])","v":0}]
[]
[null,"Total utang dan ekuitas pemilik",{"$f":"ekuitaspemilik[[#Totals],[2019]]+utangjangkapanjang[[#Totals],[2019]]+utangjangkapendek[[#Totals],[2019]]","v":0},{"$f":"ekuitaspemilik[[#Totals],[2020]]+utangjangkapanjang[[#Totals],[2020]]+utangjangkapendek[[#Totals],[2020]]","v":0}]
[]
[]
[null,"Saldo",{"$f":"SUM(C25-C46)","v":0},{"$f":"SUM(D25-D46)","v":0}]