A. Pendapatan (Income)
| Kategori | Amaun (RM) | |----------|------------| | Yuran PIBG | =SUMIF(Transaksi!D:D, "Yuran PIBG", Transaksi!E:E) | | Sumbangan Ibu Bapa | =SUMIF(Transaksi!D:D, "Sumbangan", Transaksi!E:E) | | Hasil Aktiviti (Karnival, dll) | =SUMIF(Transaksi!D:D, "Aktiviti", Transaksi!E:E) | | Jumlah Pendapatan | =SUM(range amaun pendapatan) |
B. Perbelanjaan (Expenditure)
| Kategori | Amaun (RM) | |----------|------------| | Program Akademik | =SUMIF(Transaksi!D:D, "Akademik", Transaksi!F:F) | | Sukan & Kokurikulum | =SUMIF(Transaksi!D:D, "Sukan", Transaksi!F:F) | | Kebajikan Pelajar/Guru | =SUMIF(Transaksi!D:D, "Kebajikan", Transaksi!F:F) | | Pengurusan & Pentadbiran | =SUMIF(Transaksi!D:D, "Pentadbiran", Transaksi!F:F) | | Jumlah Perbelanjaan | =SUM(range amaun perbelanjaan) |
C. Lebihan / Kurangan
Sebelum kita melihat contoh jadual, pastikan laporan anda mengandungi 4 komponen asas ini:
| A | B | C | |---|---|---| | Item | Amount (RM) | Notes | | Baki Bawa Hadapan (1 Jan 2025) | 5,200.00 | From 2024 closing | | Jumlah Pendapatan (YTD) | 12,850.00 | From Sheet 2 | | Jumlah Wang Diterima | 18,050.00 | | | Jumlah Perbelanjaan (YTD) | (7,420.00) | From Sheet 3 | | Baki Semasa (Tunai/Bank) | 10,630.00 | =C4+C5 | | of which: Bank Account | 9,800.00 | | | of which: Petty Cash | 830.00 | | contoh excel laporan kewangan pibg sekolah
Key Formula:
=SUM(range_of_income) - SUM(range_of_expenses)
| Description | Amount (RM) | |-------------|--------------| | Baki Buku Tunai (Excel Balance) | 10,630.00 | | (+) Deposit belum dikreditkan bank | + 500.00 | | (–) Cek belum dikeluarkan (No. V010) | – 320.00 | | (–) Cek belum dikeluarkan (No. V011) | – 180.00 | | Baki Bank (mengikut penyata bank) | 10,630.00 | Sebelum kita melihat contoh jadual, pastikan laporan anda
Formula:
=B2+B3-B4-B5— must equal bank statement closing balance.