Laporan Keuangan Koperasi Sekolah Excel Apr 2026

Di sel E2 tulis =D2-C2 (jika saldo awal 0). Untuk baris berikutnya, =E2 + D3 - C3 . Seret rumus ke bawah.

Oleh: Tim Edukasi Akuntansi Pendahuluan Koperasi sekolah adalah organisasi ekonomi yang beranggotakan siswa, guru, dan karyawan di lingkungan sekolah. Tujuannya meliputi mendidik siswa tentang prinsip koperasi, melayani kebutuhan warga sekolah, serta menjadi laboratorium kewirausahaan. Agar operasionalnya sehat dan transparan, koperasi sekolah wajib menyusun laporan keuangan secara periodik.

| | Jumlah (Rp) | |----------------|-------------| | Penjualan Bersih | =SUM(Penjualan!E:E) | | Pendapatan Jasa (simpan pinjam, fotokopi, dll) | (masukkan manual) | | Total Pendapatan | =SUM(B2:B3) |

Contoh entri: Setoran modal awal, pembelian barang dagang, penjualan tunai, pembayaran listrik. Kolom yang diperlukan: | Tanggal | Nama Barang | Qty | Harga Satuan | Total Jual | HPP per unit | Total HPP | Laba Kotor | |---------|-------------|-----|--------------|------------|--------------|-----------|------------| laporan keuangan koperasi sekolah excel

| | Jumlah (Rp) | |-----------|-------------| | Harga Pokok Penjualan (HPP) | =SUM(Penjualan!G:G) | | Beban Gaji/Kasih jaga | (entri manual) | | Beban Listrik & Air | (entri manual) | | Beban Perlengkapan | (entri manual) | | Total Beban | =SUM(B6:B9) |

| | Nilai (Rp) | PASIVA | Nilai (Rp) | |----------|------------|------------|-------------| | Kas | =Kas!E[baris terakhir] | Simpanan Pokok | 1.000.000 | | Persediaan Barang | =Stok!H[total nilai] | Simpanan Wajib | 2.500.000 | | Peralatan (rak, timbangan) | 500.000 | SHU Belum Dibagi | =LabaRugi!B12 | | Total Aset | =SUM(B2:B4) | Total Pasiva | =SUM(D2:D4) |

Rumus: =B4 - B10 Langkah 6: Neraca (Sheet Neraca ) Neraca harus seimbang (Aset = Kewajiban + Ekuitas). Di sel E2 tulis =D2-C2 (jika saldo awal 0)

Gunakan SUM di bagian bawah untuk menghitung total penjualan, total HPP, dan total laba kotor bulanan. Buat sheet Stok dengan kolom: Nama Barang, Stok Awal, Pembelian, Penjualan (Qty), Stok Akhir. Rumus Stok Akhir = Stok Awal + Pembelian - Penjualan . Langkah 5: Laporan Laba/Rugi (Sheet LabaRugi ) Buat format seperti ini:

Total Jual = Qty * Harga Satuan Total HPP = Qty * HPP per unit Laba Kotor = Total Jual - Total HPP

A1: Tanggal | B1: Uraian | C1: Masuk | D1: Keluar | E1: Saldo E2 = 1000000 (saldo awal) E3 = E2+C3-D3 , copy ke bawah. copy ke bawah.

A3: Penjualan | B3: =SUM(Sheet1!C:C) A4: HPP | B4: 600000 A5: Beban Listrik | B5: 50000 A7: Laba Bersih | B7: =B3-B4-B5

Contoh sederhana:

IMEI Check iPhone or Serial number for apple warranty check.
IMEI check service for iPhone or Apple devices that allows you to verify apple check warranty, Find My iPhone status, model, size, color, serial number, coverage status, SIM lock, and other details. It also offers the ability to check any Apple device, including MacBook, iMac, iPad, Watch and AirPod. This service can help you to determine the authenticity of the device and ensure that it's in good condition before purchasing it.


Just enter Serial Number or IMEI
Check
Paid Services
Carrier and SIMLock Check IMEI(INSTANT)
Carrier and SIMLock Check IMEI(INSTANT)
USD   1.70*
MacBook iCloud CLEAN/LOST check (INSTANT)
MacBook iCloud CLEAN/LOST check (INSTANT)
USD   3.30*
GSX+Sold By+Replacement+Case+Repairs IMEI/SN check (INSTANT)
GSX+Sold By+Replacement+Case+Repairs IMEI/SN check (INSTANT)
USD   4.10*
iCloud Remove - CLEAN IMEI/SN (iPHN 15-15 PRO MAX) (75% Success ratio)(SLOW)
iCloud Remove - CLEAN IMEI/SN (iPHN 15-15 PRO MAX) (75% Success ratio)(SLOW)
USD 140.00

SHOW MORE


How i can find IMEI?
laporan keuangan koperasi sekolah excel
In settings
Go to Settings > General > About and look for your device's IMEI
laporan keuangan koperasi sekolah excel
Dial *#06# to get IMEI
Before trying anything else, you can try simply dialing *#06# on your iPhone (or any mobile phone), this should retrieve the IMEI number. Give it a moment and the IMEI will appear on the screen this little number dial trick actually works to retrieve the IMEI on other cell phones too, not just the iPhone.
laporan keuangan koperasi sekolah excel
On the back side of iPhone
The iPhone 5/5c/5s/6/6+ and the original iPhone have the IMEI number engraved on the back of the phone, near the bottom.
laporan keuangan koperasi sekolah excel
On the SIM tray
To find imei number, you need to remove Sim tray from the device, and then you can find IMEI/SN on it (not on all devices you can find IMEI/SN on the sim tray).