Finance Exports

Full term financial summary — fee income by category vs all school expenditure (staff costs, operations, store). Net surplus or deficit. The primary document the BOM reviews each term.

Per-class breakdown — billed, collected, outstanding, collection rate. Payment method split (M-Pesa, bank, cash). Defaulters section. Used for parent meetings and sponsor reporting.

All students with outstanding balances — sorted by amount owed. Includes cumulative balance (carries unpaid from previous terms). Used for follow-up calls and arrears management.

Full staff payroll for the selected month — gross, each deduction, net pay. Includes totals row. The standard document for internal records and BOM approval before bank payment.

Exactly what to remit, to whom, and by when — PAYE to KRA (by 9th), NSSF (by 15th), SHA (by 9th), AHL (by 9th). Amounts per employee and totals. Handed to the bursar for remittance.

Net pay per staff member with bank account details. The document sent to the bank to process salary disbursements. Matches the payroll register's net pay column exactly.

All recorded expenses for the term — date, category, payee, description, receipt number, approver. Grouped by category with subtotals. Standard audit trail document.

Purchases from Smart Store by department — stationery, kitchen, lab, farm. Shows what was bought, when, at what cost. Used for procurement review and BOM reporting.

All of the above in a single Excel workbook — one sheet per report. The document you hand to your auditor or BOM at the end of term. Everything in one file.