Key takeaways
- Set one fee plan per level and school year.
- One enrollment row drives net fees, payments, and balance.
- Schedule installments so Overdue status is automatic.
- Send notices from BALANCES, not from memory.
A small school collects tuition from a hundred families in a hundred different ways: full payment in June, quarterly installments, a discount for the second sibling, a uniform charge in August. The registrar's notebook cannot hold all of that, so balances are recomputed by hand before every exam week. SchoolDesk PH gives each enrollment one row where fees, discounts, charges, payments, and balance are calculated from the records.
Set fee plans per level
A fee plan holds tuition, miscellaneous, and books for one level and school year, and the total is calculated. Enrollments reference the plan, so a fee change is made once.
Discounts are entered per enrollment, which keeps sibling and early-bird arrangements visible instead of buried in a note.
Enroll and schedule installments
An enrollment links a student to a plan with the date and discount. Net fees, payments, and balance are formula-driven, and other charges like uniforms are added as their own rows.
Installments carry a milestone, due date, and amount due; balance, days overdue, and status update by themselves.
Record every payment against the enrollment
Payments name the enrollment, the installment, the method, and the reference. Partial payments simply leave a balance on the installment and on the enrollment.
Because each payment is tied to an ID, a parent's question about a June payment is answered by filtering, not by searching a drawer.
Collect from the balance list
BALANCES mirrors every enrollment with the student's level and Paid, Partial, or Unpaid status, and the dashboard shows overdue installments and outstanding balances.
A weekly pass through CHECKS catches enrollments pointing at unknown students and installments pointing at missing enrollments before notices go out.
Review exceptions every week
Resolve duplicate IDs, missing links, overdue balances, negative amounts, and open operational items in CHECKS before using the dashboard for decisions.
SchoolDesk PH Private Google Sheets Web App is designed for use with a Google account, Google Sheets, and Apps Script, using owner-only deployment by default.
No DepEd or LGU permit compliance, grading or report cards, class scheduling, attendance, payroll, official receipts, tax filing, or automatic SMS reminders.
Frequently asked questions
Can two siblings have different discounts?
Yes. The discount is entered per enrollment, so each child's arrangement is recorded separately.
Does it produce report cards or attendance?
No. It is a fees and collections system; academic records stay in your existing process.
How are uniforms and field trips handled?
Add them as other charges against the enrollment; net fees and balance update automatically.
Does this replace official records?
No. No DepEd or LGU permit compliance, grading or report cards, class scheduling, attendance, payroll, official receipts, tax filing, or automatic SMS reminders.
