{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Arus Kas","Bagan Arus Kas"],"not_rendered":{"charts":1,"defined_names":5},"read":"whole","date_system":"1900"}

{"sheet":"Arus Kas","index":0,"n_rows":61,"n_cols":16,"rows_kept":61,"merged":[[0,1,0,15],[1,1,1,15]]}
[null,"Perkiraan Arus Kas Bisnis Kecil"]
[null,"Nama Perusahaan"]
[null,"Tanggal awal",{"$f":"TODAY()","v":"2019-04-24"}]
[null,"Peringatan saldo kas minimum",null,{"$f":"Kas_minimum","v":0},{"$f":"Kas_minimum","v":0},0,0,0,0,0,0,0,0,0,0]
[]
[null,null,"Awal","Jan 18","Feb 18","Mar 18","Apr 18","Mei 18","Jun 18","Jul 18","Agu 18","Sep 18","Okt 18","Nov 18","Des 18","Total"]
[null,"Kas di tangan (awal bulan)",null,{"$f":"C53","v":0},{"$f":"D53","v":0},0,0,0,0,0,0,0,0,{"$f":"M53","v":0},{"$f":"N53","v":0}]
[]
[null,"PENERIMAAN KAS"," ","Jan 18","Feb 18","Mar 18","Apr 18","Mei 18","Jun 18","Jul 18","Agu 18","Sep 18","Okt 18","Nov 18","Des 18","Total"]
[null,"Penjualan kas",{"$nulls":13},{"$f":"SUM(D10:O10)","v":0}]
[null,"Laba dan tunjangan",{"$nulls":13},0]
[null,"Penagihan piutang dagang",{"$nulls":13},0]
[null,"Bunga, pendapatan lainnya",{"$nulls":13},0]
[null,"Dana pinjaman",{"$nulls":13},0]
[null,"Kontribusi pemilik",{"$nulls":13},0]
[null,"TOTAL PENERIMAAN KAS",null,{"$f":"SUM(D10,D12:D15,(D11*-1))","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUBTOTAL(109,PenerimaanKas[Total])","v":0}]
[null,"Total kas tersedia",{"$f":"(C7+PenerimaanKas[[#Totals],[ ]])","v":0},{"$f":"(D7+PenerimaanKas[[#Totals],[Jan 18]])","v":0},{"$f":"(E7+PenerimaanKas[[#Totals],[Feb 18]])","v":0},{"$f":"(F7+PenerimaanKas[[#Totals],[Mar 18]])","v":0},{"$f":"(G7+PenerimaanKas[[#Totals],[Apr 18]])","v":0},{"$f":"(H7+PenerimaanKas[[#Totals],[Mei 18]])","v":0},{"$f":"(I7+PenerimaanKas[[#Totals],[Jun 18]])","v":0},{"$f":"(J7+PenerimaanKas[[#Totals],[Jul 18]])","v":0},{"$f":"(K7+PenerimaanKas[[#Totals],[Agu 18]])","v":0},{"$f":"(L7+PenerimaanKas[[#Totals],[Sep 18]])","v":0},{"$f":"(M7+PenerimaanKas[[#Totals],[Okt 18]])","v":0},{"$f":"(N7+PenerimaanKas[[#Totals],[Nov 18]])","v":0},{"$f":"(O7+PenerimaanKas[[#Totals],[Des 18]])","v":0}]
[]
[null,"KAS DIBAYARKAN"," ","Jan 18","Feb 18","Mar 18","Apr 18","Mei 18","Jun 18","Jul 18","Agu 18","Sep 18","Okt 18","Nov 18","Des 18","Total"]
[null,"Iklan",{"$nulls":13},{"$f":"SUM(D20:O20)","v":0}]
[null,"Komisi dan biaya",{"$nulls":13},0]
[null,"Pekerja kontrak",{"$nulls":13},0]
[null,"Program manfaat karyawan",{"$nulls":13},0]
[null,"Asuransi (selain kesehatan)",{"$nulls":13},0]
[null,"Pengeluaran bunga",{"$nulls":13},0]
[null,"Bahan dan perlengkapan (dalam HPP)",{"$nulls":13},0]
[null,"Konsumsi dan hiburan",{"$nulls":13},0]
[null,"Bunga hipotek",{"$nulls":13},0]
[null,"Pengeluaran kantor",{"$nulls":13},0]
[null,"Pengeluaran bunga lainnya",{"$nulls":13},0]
[null,"Pensiun dan rencana pembagian laba",{"$nulls":13},0]
[null,"Pembelian untuk jual kembali",{"$nulls":13},0]
[null,"Sewa atau sewa-guna",{"$nulls":13},0]
[null,"Sewa atau sewa-guna: kendaraan, perlengkapan",{"$nulls":13},0]
[null,"Perbaikan dan pemeliharaan",{"$nulls":13},0]
[null,"Perlengkapan (tidak dalam HPP)",{"$nulls":13},0]
[null,"Pajak dan lisensi",{"$nulls":13},0]
[null,"Perjalanan",{"$nulls":13},0]
[null,"Kebutuhan Umum",{"$nulls":13},0]
[null,"Upah (dikurangi kredit karyawan)",{"$nulls":13},0]
[null,"Biaya lainnya",{"$nulls":13},0]
[null,"Biaya lainnya",{"$nulls":13},0]
[null,"Biaya lainnya",{"$nulls":13},0]
[null,"Lain-lain",{"$nulls":13},0]
[null,"SUBTOTAL",null,{"$f":"SUBTOTAL(109,Pengeluaran[Jan 18])","v":0},{"$f":"SUBTOTAL(109,Pengeluaran[Feb 18])","v":0},{"$f":"SUBTOTAL(109,Pengeluaran[Mar 18])","v":0},{"$f":"SUBTOTAL(109,Pengeluaran[Apr 18])","v":0},{"$f":"SUBTOTAL(109,Pengeluaran[Mei 18])","v":0},{"$f":"SUBTOTAL(109,Pengeluaran[Jun 18])","v":0},{"$f":"SUBTOTAL(109,Pengeluaran[Jul 18])","v":0},{"$f":"SUBTOTAL(109,Pengeluaran[Agu 18])","v":0},{"$f":"SUBTOTAL(109,Pengeluaran[Sep 18])","v":0},{"$f":"SUBTOTAL(109,Pengeluaran[Okt 18])","v":0},{"$f":"SUBTOTAL(109,Pengeluaran[Nov 18])","v":0},{"$f":"SUBTOTAL(109,Pengeluaran[Des 18])","v":0},{"$f":"SUBTOTAL(109,Pengeluaran[Total])","v":0}]
[null,"KAS DIBAYARKAN"," ","Jan 18","Feb 18","Mar 18","Apr 18","Mei 18","Jun 18","Jul 18","Agu 18","Sep 18","Okt 18","Nov 18","Des 18","Total"]
[null,"Pembayaran pinjaman pokok",{"$nulls":13},{"$f":"SUM(D47:O47)","v":0}]
[null,"Pembelian modal",{"$nulls":13},0]
[null,"Biaya mulai lainnya",{"$nulls":13},0]
[null,"Untuk memesan dan/atau eskro",{"$nulls":13},0]
[null,"Penarikan pemilik",{"$nulls":13},0]
[null,"TOTAL KAS DIBAYARKAN",null,{"$f":"Pengeluaran[[#Totals],[Jan 18]]+SUBTOTAL(109,KasDibayarkan[Jan 18])","v":0},{"$f":"Pengeluaran[[#Totals],[Feb 18]]+SUBTOTAL(109,KasDibayarkan[Feb 18])","v":0},{"$f":"Pengeluaran[[#Totals],[Mar 18]]+SUBTOTAL(109,KasDibayarkan[Mar 18])","v":0},{"$f":"Pengeluaran[[#Totals],[Apr 18]]+SUBTOTAL(109,KasDibayarkan[Apr 18])","v":0},{"$f":"Pengeluaran[[#Totals],[Mei 18]]+SUBTOTAL(109,KasDibayarkan[Mei 18])","v":0},{"$f":"Pengeluaran[[#Totals],[Jun 18]]+SUBTOTAL(109,KasDibayarkan[Jun 18])","v":0},{"$f":"Pengeluaran[[#Totals],[Jul 18]]+SUBTOTAL(109,KasDibayarkan[Jul 18])","v":0},{"$f":"Pengeluaran[[#Totals],[Agu 18]]+SUBTOTAL(109,KasDibayarkan[Agu 18])","v":0},{"$f":"Pengeluaran[[#Totals],[Sep 18]]+SUBTOTAL(109,KasDibayarkan[Sep 18])","v":0},{"$f":"Pengeluaran[[#Totals],[Okt 18]]+SUBTOTAL(109,KasDibayarkan[Okt 18])","v":0},{"$f":"Pengeluaran[[#Totals],[Nov 18]]+SUBTOTAL(109,KasDibayarkan[Nov 18])","v":0},{"$f":"Pengeluaran[[#Totals],[Des 18]]+SUBTOTAL(109,KasDibayarkan[Des 18])","v":0},0]
[null,"Kas di tangan (akhir bulan)",{"$f":"C17","v":0},{"$f":"D17-KasDibayarkan[[#Totals],[Jan 18]]","v":0},{"$f":"E17-KasDibayarkan[[#Totals],[Feb 18]]","v":0},{"$f":"F17-KasDibayarkan[[#Totals],[Mar 18]]","v":0},{"$f":"G17-KasDibayarkan[[#Totals],[Apr 18]]","v":0},{"$f":"H17-KasDibayarkan[[#Totals],[Mei 18]]","v":0},{"$f":"I17-KasDibayarkan[[#Totals],[Jun 18]]","v":0},{"$f":"J17-KasDibayarkan[[#Totals],[Jul 18]]","v":0},{"$f":"K17-KasDibayarkan[[#Totals],[Agu 18]]","v":0},{"$f":"L17-KasDibayarkan[[#Totals],[Sep 18]]","v":0},{"$f":"M17-KasDibayarkan[[#Totals],[Okt 18]]","v":0},{"$f":"N17-KasDibayarkan[[#Totals],[Nov 18]]","v":0},{"$f":"O17-KasDibayarkan[[#Totals],[Des 18]]","v":0}]
[]
[null,"DATA PENGOPERASIAN LAINNYA"," ","Jan 18","Feb 18","Mar 18","Apr 18","Mei 18","Jun 18","Jul 18","Agu 18","Sep 18","Okt 18","Nov 18","Des 18","Total"]
[null,"Volume penjualan (dolar)",{"$nulls":13},{"$f":"SUM(DataOperasionalLainnya[[#This Row],[Jan 18]:[Des 18]])","v":0}]
[null,"Saldo piutang",{"$nulls":13},{"$f":"SUM(DataOperasionalLainnya[[#This Row],[Jan 18]:[Des 18]])","v":0}]
[null,"Saldo piutang macet",{"$nulls":13},{"$f":"SUM(DataOperasionalLainnya[[#This Row],[Jan 18]:[Des 18]])","v":0}]
[null,"Inventaris di tangan",{"$nulls":13},{"$f":"SUM(DataOperasionalLainnya[[#This Row],[Jan 18]:[Des 18]])","v":0}]
[null,"Saldo utang dagang",{"$nulls":13},{"$f":"SUM(DataOperasionalLainnya[[#This Row],[Jan 18]:[Des 18]])","v":0}]
[null,"Depresiasi",{"$nulls":13},{"$f":"SUM(DataOperasionalLainnya[[#This Row],[Jan 18]:[Des 18]])","v":0}]

{"sheet":"Bagan Arus Kas","index":1,"n_rows":37,"n_cols":4,"rows_kept":37,"merged":[[1,1,34,16],[36,1,36,2]]}
[]
[null,"Bagan kombinasi yang memperlihatkan peringatan Kas di Tangan Minimum dan Perkiraan Arus Kas ada di sel ini."]
{"$rows_empty":34}
[null,"Peringatan saldo kas minimum",null,{"$f":"[0]!Kas_minimum","v":{"v":0,"d":"Rp0"}}]