Fortnightly KPI tracker
Enter billed children each day, then wage expense and trading income after each pay run. Status colours update automatically against your targets.
Average children / day
Wage ratio
Tip: scroll sideways on the table to reach Week 2, wages and status columns.
| Period start | Fortnight ending | Days open | Week 1 — billed children | Week 2 — billed children | Attendance | Wages & income | Variance | ||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Mon | Tue | Wed | Thu | Fri | Mon | Tue | Wed | Thu | Fri | Total child-days | Avg / day | Att. status | Wage expense $ | Trading income $ | Wage % | Wage status | Vs target days | Vs pref. wage % | |||
Each fortnight (~5 minutes after payroll)
- Open Fortnight log and find the row for this pay period.
- Confirm Days open (usually 10). Public holidays still count if parents are charged. Only unpaid Christmas days reduce this.
- Enter Mon–Fri billed children for Week 1 and Week 2. Total child-days and average calculate automatically.
- Enter Wage expense $ = full pay run for Wages & Salaries + Contractors – Staff (exclude super).
- Enter Trading income $ for the same 14 days (Sales + gov rebates + kinder recon + other trading).
- Read attendance status and wage status: OK, Watch, or Action.
1. Fill rooms toward 28 children per day (about 280 child-days per normal fortnight).
2. Keep wages + temp contractors at about 64 cents per dollar of income (never plan above 66%).
3. If attendance drops toward 25/day, reduce roster and temp hours in the same fortnight — do not hold a 28-child wage base on 25-child revenue.
Pay cycle & definitions
- First period: Mon 13 Jul – Fri 24 Jul 2026, then every 14 days.
- Wage expense = Wages & Salaries + Contractors – Staff paid in the fortnight (excludes super).
- Trading income = Sales + government rebates + kindergarten reconciliation + other trading income for the fortnight.
- Parents pay public holidays; only the 5 Christmas close-down days are unpaid.
- Data saves automatically in this browser. Use Backup JSON before clearing browser data, and Export CSV for spreadsheets.
This page is limited to the Owner permission group. Sign in with an Owner account to open it from the menu. Keep it off shared family devices if wage figures are sensitive.