{"text_format":"3","workbook":"xlsx","n_sheets":6,"sheets":["Mulai","Gambaran umum","Templat Biaya Awal","Contoh Biaya Awal","Templat Laba Rugi","Contoh Laba Rugi"],"not_rendered":{"defined_names":6},"read":"whole","date_system":"1900"}

{"sheet":"Mulai","index":0,"n_rows":8,"n_cols":2,"rows_kept":8}
[null,"TENTANG TEMPLAT INI"]
[null,"Buat Rencana Keuangan Awal Bisnis menggunakan templat ini. "]
[null,"Dapatkan ikhtisar rencana keuangan di lembar kerja Ikhtisar. "]
[null,"Gunakan lembar kerja Templat Biaya dan Templat P&L Awal untuk memperhitungkan Biaya serta Laba & Rugi Awal. "]
[null,"Lembar kerja Contoh Biaya dan Contoh P&L Awal berisi data sampel dalam tabel."]
[null,"Catatan: "]
[null,"Instruksi tambahan telah disediakan di kolom A dalam semua lembar kerja. Teks ini sengaja disembunyikan. Untuk menghapus teks, pilih kolom A, lalu pilih HAPUS. Untuk memperlihatkan teks, pilih kolom A, lalu ubah warna font."]
[null,"Untuk mempelajari selengkapnya tentang tabel, tekan SHIFT, lalu F10 dalam tabel, pilih opsi TABEL, lalu pilih TEKS ALTERNATIF."]

{"sheet":"Gambaran umum","index":1,"n_rows":7,"n_cols":2,"rows_kept":7}
[null,"RENCANA KEUANGAN AWAL BISNIS"]
[null,"Membuat rencana keuangan adalah tempat semua perencanaan bisnis disatukan. Setelah mengidentifikasi produk, pasar target, dan pelanggan target, beserta harga, Anda siap untuk mulai membuat prakiraan biaya, penjualan, dan laba. Item berikut beserta asumsi Anda, akan membantu Anda memperkirakan prakiraan penjualan Anda. Sisi lain dari bisnis adalah pengeluaran yang Anda harapkan akan terjadi. Hal ini penting dilakukan secara berkelanjutan untuk melihat kapan Anda mendapatkan keuntungan. Hal ini juga penting ketika Anda memulai bisnis, untuk mengetahui pengeluaran apa yang perlu didanai sebelum penjualan pelanggan atau uang tunai yang mereka hasilkan diterima. "]
[null,"Biaya Awal yang Diproyeksikan: Tabel di tab berikutnya, Templat Biaya Awal, menyediakan templat kosong dengan beberapa petunjuk untuk memulai.  Tab berikutnya, Contoh Biaya Awal, memperlihatkan contoh item biaya rutin dan biaya satu kali yang mungkin Anda perlukan untuk membuka bisnis. Banyak bisnis dibayar secara kredit dari waktu ke waktu dan tidak memiliki uang tunai yang langsung masuk. Penting untuk memperkirakan kapan uang tunai akan mulai mengalir ke perusahaan dengan membuat asumsi tentang berapa bulan item berulang, selain pengeluaran satu kali, Anda harus mendanai dari tabungan atau investasi awal.  "]
[null,"Model Laba dan Rugi yang Diproyeksikan: Di tab, label Templat P&L, Anda akan menemukan templat kosong untuk melakukan Prakiraan Penjualan dan Model Laba dan Rugi. Tab berikutnya, Contoh P&L, memperlihatkan contoh proyeksi yang diperkirakan sebuah bisnis kecil untuk 12 bulan pertama operasinya. Bagian atas tabel di setiap model menunjukkan proyeksi penjualan dan laba kotor. Ini adalah tempat yang tepat untuk mulai membuat prakiraan penjualan Anda. Bagian berikutnya, di bawah, memerinci pengeluaran berulang yang Anda proyeksikan untuk bulan yang sama. Ini harus konsisten dengan perkiraan biaya awal yang Anda selesaikan di bagian sebelumnya. Di bagian bawah model ini, Anda akan mulai melihat kapan Anda akan mendapatkan keuntungan dan item pengeluaran apa yang paling berdampak pada profitabilitas Anda. "]
[null,"Terus pantau asumsi yang Anda buat untuk memperkirakan Pendapatan dan Biaya Barang yang Dijual. Untuk bisnis yang belum mulai beroperasi, Anda harus memiliki pemahaman tentang cara memperkirakan hal ini untuk produk atau layanan Anda.  Di bawah ini beberapa panduan dalam memperkirakan: "]
[null,"Pendapatan: Mulailah dengan menentukan dari target pasar Anda (kelompok calon pelanggan, bisnis atau konsumen) berapa banyak yang akan menjadi target di tahun pertama. Berapa persentase dari hal berikut yang Anda harapkan untuk ditutup? Berapa rata-rata transaksi bagi mereka untuk membeli produk atau layanan Anda? Berapa banyak yang dapat Anda lakukan di bulan pertama, kedua, dan seterusnya? Anda mungkin ingin memulai dengan angka di bulan pertama dan meningkatkannya dengan persentase, misalnya 10%.  Sebagai contoh, jika Anda menjual layanan kebersihan ke bisnis kecil di kota Anda dan ada 500 bisnis yang menurut Anda membutuhkan layanan tersebut. Jika kontrak rata-rata adalah $250/bulan, maka Anda perlu memperkirakan berapa banyak bisnis yang dapat Anda tandatangani untuk menjadi kontrak di setiap bulan untuk tahun pertama. "]
[null,"Harga Pokok Penjualan (HPP): Ini harus diperhitungkan untuk produk dan beberapa layanan.  Ini adalah biaya yang disertakan untuk menghasilkan produk.  Misalnya, jika Anda menjual pakaian, HPP adalah berapa harga yang Anda bayarkan untuk membeli pakaian dari produsen.  Jika Anda membuatnya sendiri, biaya tersebut akan berupa biaya bahan dan tenaga untuk membuatnya. Untuk layanan, biaya akan berupa biaya tenaga kerja langsung untuk satu jam kerja yang dapat ditagih.  Segala sesuatu di bawah Laba Kotor pada P&L adalah biaya tetap atau overhead untuk keseluruhan bisnis, seperti sewa atau telepon atau bahkan pemasaran. "]

{"sheet":"Templat Biaya Awal","index":2,"n_rows":10,"n_cols":6,"rows_kept":10,"merged":[[1,2,1,5]]}
[null,"BIAYA AWAL"]
[null,"Kedai Kopi Anda",{"$f":"TODAY()","v":"2022-01-18"}]
[]
[null,"ITEM BIAYA","BULAN","BIAYA/ BULAN","BIAYA SATU KALI","TOTAL BIAYA"]
[null,"Iklan/Pemasaran",{"$nulls":3},{"$f":"(C5*D5)+IF(E5>0,E5,0)","v":{"v":0,"d":"Rp0"}}]
[null,"Gaji Karyawan",{"$nulls":3},{"$f":"(C6*D6)+IF(E6>0,E6,0)","v":{"v":0,"d":"Rp0"}}]
[null,"Pajak dan Tunjangan Gaji Karyawan",{"$nulls":3},{"v":0,"d":"Rp0"}]
[null,"Sewa/Pembayaran Sewa/Utilitas",{"$nulls":3},{"v":0,"d":"Rp0"}]
[null,"Ongkos kirim/Pengiriman",{"$nulls":3},{"v":0,"d":"Rp0"}]
[null,"PERKIRAAN ANGGARAN AWAL",{"$nulls":3},{"$f":"SUBTOTAL(109,Awal[TOTAL BIAYA])","v":0}]

{"sheet":"Contoh Biaya Awal","index":3,"n_rows":10,"n_cols":6,"rows_kept":10,"merged":[[1,2,1,5]]}
[null,"BIAYA AWAL"]
[null,{"$f":"'Templat Biaya Awal'!B2","v":"Kedai Kopi Anda"},{"$f":"TODAY()","v":"2022-01-18"}]
[]
[null,"ITEM BIAYA","BULAN","BIAYA/ BULAN","BIAYA SATU KALI","TOTAL BIAYA"]
[null,"Iklan/Pemasaran",3,{"v":300,"d":"Rp300"},{"v":2000,"d":"Rp2,000"},{"$f":"(C5*D5)+IF(E5>0,E5,0)","v":{"v":2900,"d":"Rp2,900"}}]
[null,"Gaji Karyawan",4,{"v":3500,"d":"Rp3,500"},{"v":2,"d":"Rp2"},{"$f":"(C6*D6)+IF(E6>0,E6,0)","v":{"v":14002,"d":"Rp14,002"}}]
[null,"Pajak dan Tunjangan Gaji Karyawan",4,{"v":500,"d":"Rp500"},{"v":2000,"d":"Rp2,000"},{"v":4000,"d":"Rp4,000"}]
[null,"Sewa/Pembayaran Sewa/Utilitas",4,{"v":750,"d":"Rp750"},{"v":3000,"d":"Rp3,000"},{"v":6000,"d":"Rp6,000"}]
[null,"Ongkos kirim/Pengiriman",1,{"v":25,"d":"Rp25"},{"v":25,"d":"Rp25"},{"v":50,"d":"Rp50"}]
[null,"PERKIRAAN ANGGARAN AWAL",{"$nulls":3},{"$f":"SUM(F6:F9)","v":{"v":24052,"d":"Rp24,052"}}]

{"sheet":"Templat Laba Rugi","index":4,"n_rows":23,"n_cols":15,"rows_kept":23,"merged":[[1,2,1,14]]}
[null,"BIAYA AWAL"]
[null,{"$f":"'Templat Biaya Awal'!B2","v":"Kedai Kopi Anda"},{"$f":"TODAY()","v":"2022-01-18"}]
[]
[null,"PENDAPATAN","JAN","FEB","MAR","APR","MEI","JUN","JUL","AGU","SEP","OKT","NOV","DES","YTD"]
[null,"Perkiraan Penjualan Produk",{"v":0,"d":"Rp0"},{"v":0,"d":"Rp0"},{"v":0,"d":"Rp0"},{"v":0,"d":"Rp0"},{"v":0,"d":"Rp0"},{"v":0,"d":"Rp0"},{"v":0,"d":"Rp0"},{"v":0,"d":"Rp0"},{"v":0,"d":"Rp0"},{"v":0,"d":"Rp0"},{"v":0,"d":"Rp0"},{"v":0,"d":"Rp0"},{"$f":"SUM(C5:N5)","v":{"v":0,"d":"Rp0"}}]
[null,"Lebih Sedikit Pengembalian Penjualan & Diskon",{"v":0,"d":"Rp0"},{"v":0,"d":"Rp0"},{"v":0,"d":"Rp0"},{"v":0,"d":"Rp0"},{"v":0,"d":"Rp0"},{"v":0,"d":"Rp0"},{"v":0,"d":"Rp0"},{"v":0,"d":"Rp0"},{"v":0,"d":"Rp0"},{"v":0,"d":"Rp0"},{"v":0,"d":"Rp0"},{"v":0,"d":"Rp0"},{"$f":"SUM(C6:N6)","v":{"v":0,"d":"Rp0"}}]
[null,"Pendapatan Layanan",{"v":0,"d":"Rp0"},{"v":0,"d":"Rp0"},{"v":0,"d":"Rp0"},{"v":0,"d":"Rp0"},{"v":0,"d":"Rp0"},{"v":0,"d":"Rp0"},{"v":0,"d":"Rp0"},{"v":0,"d":"Rp0"},{"v":0,"d":"Rp0"},{"v":0,"d":"Rp0"},{"v":0,"d":"Rp0"},{"v":0,"d":"Rp0"},{"v":0,"d":"Rp0"}]
[null,"Pendapatan lain ",{"v":0,"d":"Rp0"},{"v":0,"d":"Rp0"},{"v":0,"d":"Rp0"},{"v":0,"d":"Rp0"},{"v":0,"d":"Rp0"},{"v":0,"d":"Rp0"},{"v":0,"d":"Rp0"},{"v":0,"d":"Rp0"},{"v":0,"d":"Rp0"},{"v":0,"d":"Rp0"},{"v":0,"d":"Rp0"},{"v":0,"d":"Rp0"},{"v":0,"d":"Rp0"}]
[null,"Penjualan Bersih",{"$f":"SUBTOTAL(109,PendapatanSampel[JAN])","v":{"v":0,"d":"Rp0"}},{"$f":"SUBTOTAL(109,PendapatanSampel[FEB])","v":{"v":0,"d":"Rp0"}},{"$f":"SUBTOTAL(109,PendapatanSampel[MAR])","v":{"v":0,"d":"Rp0"}},{"$f":"SUBTOTAL(109,PendapatanSampel[APR])","v":{"v":0,"d":"Rp0"}},{"$f":"SUBTOTAL(109,PendapatanSampel[MEI])","v":{"v":0,"d":"Rp0"}},{"$f":"SUBTOTAL(109,PendapatanSampel[JUN])","v":{"v":0,"d":"Rp0"}},{"$f":"SUBTOTAL(109,PendapatanSampel[JUL])","v":{"v":0,"d":"Rp0"}},{"$f":"SUBTOTAL(109,PendapatanSampel[AGU])","v":{"v":0,"d":"Rp0"}},{"$f":"SUBTOTAL(109,PendapatanSampel[SEP])","v":{"v":0,"d":"Rp0"}},{"$f":"SUBTOTAL(109,PendapatanSampel[OKT])","v":{"v":0,"d":"Rp0"}},{"$f":"SUBTOTAL(109,PendapatanSampel[NOV])","v":{"v":0,"d":"Rp0"}},{"$f":"SUBTOTAL(109,PendapatanSampel[DES])","v":{"v":0,"d":"Rp0"}},{"$f":"SUM(PendapatanSampel[[#Totals],[JAN]:[DES]])","v":{"v":0,"d":"Rp0"}}]
[null,"Harga Pokok Penjualan",{"$f":"C5*0.4","v":{"v":0,"d":"Rp0"}},{"v":0,"d":"Rp0"},{"v":0,"d":"Rp0"},{"v":0,"d":"Rp0"},{"v":0,"d":"Rp0"},{"v":0,"d":"Rp0"},{"v":0,"d":"Rp0"},{"v":0,"d":"Rp0"},{"v":0,"d":"Rp0"},{"v":0,"d":"Rp0"},{"v":0,"d":"Rp0"},{"v":0,"d":"Rp0"},{"v":0,"d":"Rp0"}]
[null,"Laba Kotor",{"$f":"IFERROR(PendapatanSampel[[#Totals],[JAN]]-C10,\"\")","v":{"v":0,"d":"Rp0"}},{"$f":"IFERROR(PendapatanSampel[[#Totals],[FEB]]-D10,\"\")","v":{"v":0,"d":"Rp0"}},{"$f":"IFERROR(PendapatanSampel[[#Totals],[MAR]]-E10,\"\")","v":{"v":0,"d":"Rp0"}},{"$f":"IFERROR(PendapatanSampel[[#Totals],[APR]]-F10,\"\")","v":{"v":0,"d":"Rp0"}},{"$f":"IFERROR(PendapatanSampel[[#Totals],[MEI]]-G10,\"\")","v":{"v":0,"d":"Rp0"}},{"$f":"IFERROR(PendapatanSampel[[#Totals],[JUN]]-H10,\"\")","v":{"v":0,"d":"Rp0"}},{"$f":"IFERROR(PendapatanSampel[[#Totals],[JUL]]-I10,\"\")","v":{"v":0,"d":"Rp0"}},{"$f":"IFERROR(PendapatanSampel[[#Totals],[AGU]]-J10,\"\")","v":{"v":0,"d":"Rp0"}},{"$f":"IFERROR(PendapatanSampel[[#Totals],[SEP]]-K10,\"\")","v":{"v":0,"d":"Rp0"}},{"$f":"IFERROR(PendapatanSampel[[#Totals],[OKT]]-L10,\"\")","v":{"v":0,"d":"Rp0"}},{"$f":"IFERROR(PendapatanSampel[[#Totals],[NOV]]-M10,\"\")","v":{"v":0,"d":"Rp0"}},{"$f":"IFERROR(PendapatanSampel[[#Totals],[DES]]-N10,\"\")","v":{"v":0,"d":"Rp0"}},{"v":0,"d":"Rp0"}]
[]
[null,"PENGELUARAN","JAN","FEB","MAR","APR","MEI","JUN","JUL","AGU","SEP","OKT","NOV","DES","YTD"]
[null,"Gaji & Upah",{"v":0,"d":"Rp0"},{"v":0,"d":"Rp0"},{"v":0,"d":"Rp0"},{"v":0,"d":"Rp0"},{"v":0,"d":"Rp0"},{"v":0,"d":"Rp0"},{"v":0,"d":"Rp0"},{"v":0,"d":"Rp0"},{"v":0,"d":"Rp0"},{"v":0,"d":"Rp0"},{"v":0,"d":"Rp0"},{"v":0,"d":"Rp0"},{"$f":"SUM(C14:N14)","v":{"v":0,"d":"Rp0"}}]
[null,"Pemasaran/Iklan",{"v":0,"d":"Rp0"},{"v":0,"d":"Rp0"},{"v":0,"d":"Rp0"},{"v":0,"d":"Rp0"},{"v":0,"d":"Rp0"},{"v":0,"d":"Rp0"},{"v":0,"d":"Rp0"},{"v":0,"d":"Rp0"},{"v":0,"d":"Rp0"},{"v":0,"d":"Rp0"},{"v":0,"d":"Rp0"},{"v":0,"d":"Rp0"},{"$f":"SUM(C15:N15)","v":{"v":0,"d":"Rp0"}}]
[null,"Komisi Penjualan",{"v":0,"d":"Rp0"},{"v":0,"d":"Rp0"},{"v":0,"d":"Rp0"},{"v":0,"d":"Rp0"},{"v":0,"d":"Rp0"},{"v":0,"d":"Rp0"},{"v":0,"d":"Rp0"},{"v":0,"d":"Rp0"},{"v":0,"d":"Rp0"},{"v":0,"d":"Rp0"},{"v":0,"d":"Rp0"},{"v":0,"d":"Rp0"},{"v":0,"d":"Rp0"}]
[null,"Sewa",{"v":0,"d":"Rp0"},{"v":0,"d":"Rp0"},{"v":0,"d":"Rp0"},{"v":0,"d":"Rp0"},{"v":0,"d":"Rp0"},{"v":0,"d":"Rp0"},{"v":0,"d":"Rp0"},{"v":0,"d":"Rp0"},{"v":0,"d":"Rp0"},{"v":0,"d":"Rp0"},{"v":0,"d":"Rp0"},{"v":0,"d":"Rp0"},{"v":0,"d":"Rp0"}]
[null,"Lain-lain 1",{"v":0,"d":"Rp0"},{"v":0,"d":"Rp0"},{"v":0,"d":"Rp0"},{"v":0,"d":"Rp0"},{"v":0,"d":"Rp0"},{"v":0,"d":"Rp0"},{"v":0,"d":"Rp0"},{"v":0,"d":"Rp0"},{"v":0,"d":"Rp0"},{"v":0,"d":"Rp0"},{"v":0,"d":"Rp0"},{"v":0,"d":"Rp0"},{"v":0,"d":"Rp0"}]
[null,"Total Pengeluaran",{"$f":"IF(SUM(C14:C18)=0,\"\",SUM(C14:C18))","v":""},"","","","","","","","","","","",{"$f":"SUM(BiayaSampel[[#Totals],[JAN]:[DES]])","v":{"v":0,"d":"Rp0"}}]
[null,"Pendapatan Sebelum Pajak",{"$f":"IFERROR('Templat Laba Rugi'!$C$11-BiayaSampel[[#Totals],[JAN]],\"\")","v":""},{"$f":"IFERROR('Templat Laba Rugi'!$C$11-BiayaSampel[[#Totals],[FEB]],\"\")","v":""},{"$f":"IFERROR('Templat Laba Rugi'!$C$11-BiayaSampel[[#Totals],[MAR]],\"\")","v":""},{"$f":"IFERROR('Templat Laba Rugi'!$C$11-BiayaSampel[[#Totals],[APR]],\"\")","v":""},{"$f":"IFERROR('Templat Laba Rugi'!$C$11-BiayaSampel[[#Totals],[MEI]],\"\")","v":""},{"$f":"IFERROR('Templat Laba Rugi'!$C$11-BiayaSampel[[#Totals],[JUN]],\"\")","v":""},{"$f":"IFERROR('Templat Laba Rugi'!$C$11-BiayaSampel[[#Totals],[JUL]],\"\")","v":""},{"$f":"IFERROR('Templat Laba Rugi'!$C$11-BiayaSampel[[#Totals],[AGU]],\"\")","v":""},{"$f":"IFERROR('Templat Laba Rugi'!$C$11-BiayaSampel[[#Totals],[SEP]],\"\")","v":""},{"$f":"IFERROR('Templat Laba Rugi'!$C$11-BiayaSampel[[#Totals],[OKT]],\"\")","v":""},{"$f":"IFERROR('Templat Laba Rugi'!$C$11-BiayaSampel[[#Totals],[NOV]],\"\")","v":""},{"$f":"IFERROR('Templat Laba Rugi'!$C$11-BiayaSampel[[#Totals],[DES]],\"\")","v":""},{"v":0,"d":"Rp0"}]
[null,"Beban Pajak Pendapatan",{"$f":"IFERROR(C20*0.15,\" \")","v":" "},{"$f":"IFERROR(D20*0.15,\" \")","v":" "},{"$f":"IFERROR(E20*0.15,\" \")","v":" "}," "," "," "," "," "," "," "," "," ",{"$f":"SUM('Templat Laba Rugi'!$C$21:$N$21)","v":{"v":0,"d":"Rp0"}}]
[]
[null,"PENDAPATAN BERSIH",{"$f":"IFERROR(C20-'Templat Laba Rugi'!$C$21,\"\")","v":""},{"$f":"IFERROR(D20-'Templat Laba Rugi'!$D$21,\"\")","v":""},{"$f":"IFERROR(E20-'Templat Laba Rugi'!$E$21,\"\")","v":""},{"$f":"IFERROR(F20-'Templat Laba Rugi'!$F$21,\"\")","v":""},{"$f":"IFERROR(G20-'Templat Laba Rugi'!$G$21,\"\")","v":""},{"$f":"IFERROR(H20-'Templat Laba Rugi'!$H$21,\"\")","v":""},{"$f":"IFERROR(I20-'Templat Laba Rugi'!$I$21,\"\")","v":""},{"$f":"IFERROR(J20-'Templat Laba Rugi'!$J$21,\"\")","v":""},{"$f":"IFERROR(K20-'Templat Laba Rugi'!$K$21,\"\")","v":""},{"$f":"IFERROR(L20-'Templat Laba Rugi'!$L$21,\"\")","v":""},{"$f":"IFERROR(M20-'Templat Laba Rugi'!$M$21,\"\")","v":""},{"$f":"IFERROR(N20-'Templat Laba Rugi'!$N$21,\"\")","v":""},{"$f":"IFERROR(O20-'Templat Laba Rugi'!$O$21,\"\")","v":{"v":0,"d":"Rp0"}}]

{"sheet":"Contoh Laba Rugi","index":5,"n_rows":22,"n_cols":15,"rows_kept":22,"merged":[[1,2,1,14]]}
[null,"BIAYA AWAL"]
[null,{"$f":"'Templat Biaya Awal'!B2","v":"Kedai Kopi Anda"},{"$f":"TODAY()","v":"2022-01-18"}]
[]
[null,"PENDAPATAN","JAN","FEB","MAR","APR","MEI","JUN","JUL","AGU","SEP","OKT","NOV","DES","YTD"]
[null,"Perkiraan Penjualan Produk",{"v":5000,"d":"Rp5,000"},{"v":13000,"d":"Rp13,000"},{"v":16000,"d":"Rp16,000"},{"v":7000,"d":"Rp7,000"},{"v":14500,"d":"Rp14,500"},{"v":16400,"d":"Rp16,400"},{"v":22500,"d":"Rp22,500"},{"v":23125,"d":"Rp23,125"},{"v":24549,"d":"Rp24,549"},{"v":22000,"d":"Rp22,000"},{"v":25000,"d":"Rp25,000"},{"v":27349,"d":"Rp27,349"},{"$f":"SUM(C5:N5)","v":{"v":216423,"d":"Rp216,423"}}]
[null,"Lebih Sedikit Pengembalian Penjualan & Diskon",{"v":0,"d":"Rp0"},{"v":-350,"d":"-Rp350"},{"v":0,"d":"Rp0"},{"v":-206,"d":"-Rp206"},{"v":-234,"d":"-Rp234"},{"v":0,"d":"Rp0"},{"v":0,"d":"Rp0"},{"v":-280,"d":"-Rp280"},{"v":-1200,"d":"-Rp1,200"},{"v":-1600,"d":"-Rp1,600"},{"v":0,"d":"Rp0"},{"v":-2400,"d":"-Rp2,400"},{"$f":"SUM(C6:N6)","v":{"v":-6270,"d":"-Rp6,270"}}]
[null,"Pendapatan Layanan",{"v":0,"d":"Rp0"},{"v":0,"d":"Rp0"},{"v":0,"d":"Rp0"},{"v":0,"d":"Rp0"},{"v":0,"d":"Rp0"},{"v":250,"d":"Rp250"},{"v":350,"d":"Rp350"},{"v":100,"d":"Rp100"},{"v":0,"d":"Rp0"},{"v":0,"d":"Rp0"},{"v":1245,"d":"Rp1,245"},{"v":1360,"d":"Rp1,360"},{"v":3305,"d":"Rp3,305"}]
[null,"Pendapatan lain ",{"v":0,"d":"Rp0"},{"v":0,"d":"Rp0"},{"v":0,"d":"Rp0"},{"v":0,"d":"Rp0"},{"v":0,"d":"Rp0"},{"v":0,"d":"Rp0"},{"v":0,"d":"Rp0"},{"v":1500,"d":"Rp1,500"},{"v":0,"d":"Rp0"},{"v":0,"d":"Rp0"},{"v":0,"d":"Rp0"},{"v":0,"d":"Rp0"},{"v":1500,"d":"Rp1,500"}]
[null,"Penjualan Bersih",{"$f":"SUBTOTAL(109,PendapatanSebenarnya[JAN])","v":{"v":5000,"d":"Rp5,000"}},{"$f":"SUBTOTAL(109,PendapatanSebenarnya[FEB])","v":{"v":12650,"d":"Rp12,650"}},{"$f":"SUBTOTAL(109,PendapatanSebenarnya[MAR])","v":{"v":16000,"d":"Rp16,000"}},{"$f":"SUBTOTAL(109,PendapatanSebenarnya[APR])","v":{"v":6794,"d":"Rp6,794"}},{"$f":"SUBTOTAL(109,PendapatanSebenarnya[MEI])","v":{"v":14266,"d":"Rp14,266"}},{"$f":"SUBTOTAL(109,PendapatanSebenarnya[JUN])","v":{"v":16650,"d":"Rp16,650"}},{"$f":"SUBTOTAL(109,PendapatanSebenarnya[JUL])","v":{"v":22850,"d":"Rp22,850"}},{"$f":"SUBTOTAL(109,PendapatanSebenarnya[AGU])","v":{"v":24445,"d":"Rp24,445"}},{"$f":"SUBTOTAL(109,PendapatanSebenarnya[SEP])","v":{"v":23349,"d":"Rp23,349"}},{"$f":"SUBTOTAL(109,PendapatanSebenarnya[OKT])","v":{"v":20400,"d":"Rp20,400"}},{"$f":"SUBTOTAL(109,PendapatanSebenarnya[NOV])","v":{"v":26245,"d":"Rp26,245"}},{"$f":"SUBTOTAL(109,PendapatanSebenarnya[DES])","v":{"v":26309,"d":"Rp26,309"}},{"$f":"SUM(PendapatanSebenarnya[[#Totals],[JAN]:[DES]])","v":{"v":214958,"d":"Rp214,958"}}]
[null,"Harga Pokok Penjualan",{"$f":"C5*0.4","v":{"v":2000,"d":"Rp2,000"}},{"v":5200,"d":"Rp5,200"},{"v":6400,"d":"Rp6,400"},{"v":2800,"d":"Rp2,800"},{"v":5800,"d":"Rp5,800"},{"v":6560,"d":"Rp6,560"},{"v":9000,"d":"Rp9,000"},{"v":9250,"d":"Rp9,250"},{"v":9819.6,"d":"Rp9,820"},{"v":8800,"d":"Rp8,800"},{"v":10000,"d":"Rp10,000"},{"v":10939.6,"d":"Rp10,940"},{"v":86569.20000000001,"d":"Rp86,569"}]
[null,"Laba Kotor",{"$f":"IFERROR(PendapatanSebenarnya[[#Totals],[JAN]]-C10,\"\")","v":{"v":3000,"d":"Rp3,000"}},{"$f":"IFERROR(PendapatanSebenarnya[[#Totals],[FEB]]-D10,\"\")","v":{"v":7450,"d":"Rp7,450"}},{"$f":"IFERROR(PendapatanSebenarnya[[#Totals],[MAR]]-E10,\"\")","v":{"v":9600,"d":"Rp9,600"}},{"$f":"IFERROR(PendapatanSebenarnya[[#Totals],[APR]]-F10,\"\")","v":{"v":3994,"d":"Rp3,994"}},{"$f":"IFERROR(PendapatanSebenarnya[[#Totals],[MEI]]-G10,\"\")","v":{"v":8466,"d":"Rp8,466"}},{"$f":"IFERROR(PendapatanSebenarnya[[#Totals],[JUN]]-H10,\"\")","v":{"v":10090,"d":"Rp10,090"}},{"$f":"IFERROR(PendapatanSebenarnya[[#Totals],[JUL]]-I10,\"\")","v":{"v":13850,"d":"Rp13,850"}},{"$f":"IFERROR(PendapatanSebenarnya[[#Totals],[AGU]]-J10,\"\")","v":{"v":15195,"d":"Rp15,195"}},{"$f":"IFERROR(PendapatanSebenarnya[[#Totals],[SEP]]-K10,\"\")","v":{"v":13529.4,"d":"Rp13,529"}},{"$f":"IFERROR(PendapatanSebenarnya[[#Totals],[OKT]]-L10,\"\")","v":{"v":11600,"d":"Rp11,600"}},{"$f":"IFERROR(PendapatanSebenarnya[[#Totals],[NOV]]-M10,\"\")","v":{"v":16245,"d":"Rp16,245"}},{"$f":"IFERROR(PendapatanSebenarnya[[#Totals],[DES]]-N10,\"\")","v":{"v":15369.4,"d":"Rp15,369"}},{"v":128388.79999999999,"d":"Rp128,389"}]
[]
[null,"PENGELUARAN","JAN","FEB","MAR","APR","MEI","JUN","JUL","AGU","SEP","OKT","NOV","DES","YTD"]
[null,"Gaji & Upah",{"v":2500,"d":"Rp2,500"},{"v":2500,"d":"Rp2,500"},{"v":3500,"d":"Rp3,500"},{"v":5000,"d":"Rp5,000"},{"v":5000,"d":"Rp5,000"},{"v":5000,"d":"Rp5,000"},{"v":8000,"d":"Rp8,000"},{"v":9000,"d":"Rp9,000"},{"v":9000,"d":"Rp9,000"},{"v":9000,"d":"Rp9,000"},{"v":9000,"d":"Rp9,000"},{"v":9000,"d":"Rp9,000"},{"$f":"SUM(C14:N14)","v":{"v":76500,"d":"Rp76,500"}}]
[null,"Pemasaran/Iklan",{"v":400,"d":"Rp400"},{"v":450,"d":"Rp450"},{"v":450,"d":"Rp450"},{"v":450,"d":"Rp450"},{"v":900,"d":"Rp900"},{"v":900,"d":"Rp900"},{"v":900,"d":"Rp900"},{"v":900,"d":"Rp900"},{"v":900,"d":"Rp900"},{"v":900,"d":"Rp900"},{"v":1200,"d":"Rp1,200"},{"v":1200,"d":"Rp1,200"},{"$f":"SUM(C15:N15)","v":{"v":9550,"d":"Rp9,550"}}]
[null,"Komisi Penjualan",{"v":250,"d":"Rp250"},{"v":650,"d":"Rp650"},{"v":800,"d":"Rp800"},{"v":350,"d":"Rp350"},{"v":725,"d":"Rp725"},{"v":820,"d":"Rp820"},{"v":1125,"d":"Rp1,125"},{"v":1156.25,"d":"Rp1,156"},{"v":1227.45,"d":"Rp1,227"},{"v":1100,"d":"Rp1,100"},{"v":1250,"d":"Rp1,250"},{"v":1367.45,"d":"Rp1,367"},{"v":10821.150000000001,"d":"Rp10,821"}]
[null,"Sewa",{"v":1250,"d":"Rp1,250"},{"v":1250,"d":"Rp1,250"},{"v":1250,"d":"Rp1,250"},{"v":1250,"d":"Rp1,250"},{"v":1250,"d":"Rp1,250"},{"v":1250,"d":"Rp1,250"},{"v":1250,"d":"Rp1,250"},{"v":1250,"d":"Rp1,250"},{"v":1250,"d":"Rp1,250"},{"v":1250,"d":"Rp1,250"},{"v":1250,"d":"Rp1,250"},{"v":1250,"d":"Rp1,250"},{"v":15000,"d":"Rp15,000"}]
[null,"Total Pengeluaran",{"$f":"IF(SUM(C14:C17)=0,\"\",SUM(C14:C17))","v":{"v":4400,"d":"Rp4,400"}},{"v":4850,"d":"Rp4,850"},{"v":6000,"d":"Rp6,000"},{"v":7050,"d":"Rp7,050"},{"v":7875,"d":"Rp7,875"},{"v":7970,"d":"Rp7,970"},{"v":11275,"d":"Rp11,275"},{"v":12306.25,"d":"Rp12,306"},{"v":12377.45,"d":"Rp12,377"},{"v":12250,"d":"Rp12,250"},{"v":12700,"d":"Rp12,700"},{"v":12817.45,"d":"Rp12,817"},{"$f":"SUM(BiayaSebenarnya[[#Totals],[JAN]:[DES]])","v":{"v":111871.15,"d":"Rp111,871"}}]
[null,"Pendapatan Sebelum Pajak",{"$f":"IFERROR('Contoh Laba Rugi'!$C$11-BiayaSebenarnya[[#Totals],[JAN]],\"\")","v":{"v":-1400,"d":"-Rp1,400"}},{"$f":"IFERROR('Contoh Laba Rugi'!$D$11-BiayaSebenarnya[[#Totals],[FEB]],\"\")","v":{"v":2600,"d":"Rp2,600"}},{"$f":"IFERROR('Contoh Laba Rugi'!$E$11-BiayaSebenarnya[[#Totals],[MAR]],\"\")","v":{"v":3600,"d":"Rp3,600"}},{"$f":"IFERROR('Contoh Laba Rugi'!$F$11-BiayaSebenarnya[[#Totals],[APR]],\"\")","v":{"v":-3056,"d":"-Rp3,056"}},{"$f":"IFERROR('Contoh Laba Rugi'!$G$11-BiayaSebenarnya[[#Totals],[MEI]],\"\")","v":{"v":591,"d":"Rp591"}},{"$f":"IFERROR('Contoh Laba Rugi'!$H$11-BiayaSebenarnya[[#Totals],[JUN]],\"\")","v":{"v":2120,"d":"Rp2,120"}},{"$f":"IFERROR('Contoh Laba Rugi'!$I$11-BiayaSebenarnya[[#Totals],[JUL]],\"\")","v":{"v":2575,"d":"Rp2,575"}},{"$f":"IFERROR('Contoh Laba Rugi'!$J$11-BiayaSebenarnya[[#Totals],[AGU]],\"\")","v":{"v":2888.75,"d":"Rp2,889"}},{"$f":"IFERROR('Contoh Laba Rugi'!$K$11-BiayaSebenarnya[[#Totals],[SEP]],\"\")","v":{"v":1151.949999999999,"d":"Rp1,152"}},{"$f":"IFERROR('Contoh Laba Rugi'!$L$11-BiayaSebenarnya[[#Totals],[OKT]],\"\")","v":{"v":-650,"d":"-Rp650"}},{"$f":"IFERROR('Contoh Laba Rugi'!$M$11-BiayaSebenarnya[[#Totals],[NOV]],\"\")","v":{"v":3545,"d":"Rp3,545"}},{"$f":"IFERROR('Contoh Laba Rugi'!$N$11-BiayaSebenarnya[[#Totals],[DES]],\"\")","v":{"v":2551.949999999999,"d":"Rp2,552"}},{"$f":"SUM(C19:N19)","v":{"v":16517.649999999998,"d":"Rp16,518"}}]
[null,"Beban Pajak Pendapatan",{"$f":"C19*0.15","v":{"v":-210,"d":"-Rp210"}},{"v":390,"d":"Rp390"},{"$f":"E19*0.15","v":{"v":540,"d":"Rp540"}},{"$f":"F19*0.15","v":{"v":-458.4,"d":"-Rp458"}},{"$f":"G19*0.15","v":{"v":88.64999999999999,"d":"Rp89"}},{"$f":"H19*0.15","v":{"v":318,"d":"Rp318"}},{"$f":"I19*0.15","v":{"v":386.25,"d":"Rp386"}},{"$f":"J19*0.15","v":{"v":433.3125,"d":"Rp433"}},{"$f":"K19*0.15","v":{"v":172.79249999999982,"d":"Rp173"}},{"$f":"L19*0.15","v":{"v":-97.5,"d":"-Rp98"}},{"$f":"M19*0.15","v":{"v":531.75,"d":"Rp532"}},{"$f":"N19*0.15","v":{"v":382.79249999999985,"d":"Rp383"}},{"$f":"SUM('Contoh Laba Rugi'!$C$20:$N$20)","v":{"v":2477.6474999999996,"d":"Rp2,478"}}]
[]
[null,"PENDAPATAN BERSIH",{"$f":"IFERROR(C19-'Contoh Laba Rugi'!$C$20,\" \")","v":{"v":-1190,"d":"-Rp1,190"}},{"$f":"IFERROR(D19-'Contoh Laba Rugi'!$D$20,\" \")","v":{"v":2210,"d":"Rp2,210"}},{"$f":"IFERROR(E19-'Contoh Laba Rugi'!$E$20,\"\")","v":{"v":3060,"d":"Rp3,060"}},{"$f":"IFERROR(F19-'Contoh Laba Rugi'!$F$20,\"\")","v":{"v":-2597.6,"d":"-Rp2,598"}},{"$f":"IFERROR(G19-'Contoh Laba Rugi'!$G$20,\"\")","v":{"v":502.35,"d":"Rp502"}},{"$f":"IFERROR(H19-'Contoh Laba Rugi'!$H$20,\"\")","v":{"v":1802,"d":"Rp1,802"}},{"$f":"IFERROR(I19-'Contoh Laba Rugi'!$I$20,\"\")","v":{"v":2188.75,"d":"Rp2,189"}},{"$f":"IFERROR(J19-'Contoh Laba Rugi'!$J$20,\"\")","v":{"v":2455.4375,"d":"Rp2,455"}},{"$f":"IFERROR(K19-'Contoh Laba Rugi'!$K$20,\"\")","v":{"v":979.1574999999991,"d":"Rp979"}},{"$f":"IFERROR(L19-'Contoh Laba Rugi'!$L$20,\"\")","v":{"v":-552.5,"d":"-Rp553"}},{"$f":"IFERROR(M19-'Contoh Laba Rugi'!$M$20,\"\")","v":{"v":3013.25,"d":"Rp3,013"}},{"$f":"IFERROR(N19-'Contoh Laba Rugi'!$N$20,\"\")","v":{"v":2169.157499999999,"d":"Rp2,169"}},{"$f":"IFERROR(O19-'Contoh Laba Rugi'!$O$20,\"\")","v":{"v":14040.002499999999,"d":"Rp14,040"}}]