Garderie Services
One secure system that generates every family's government applications automatically — and works out the childcare tuition behind them, splitting what the government subsidy covers from what the family still owes, all kept correct, private, and in step.
Product engineer — design & build
Families
All ▾+ Add FamilyWhere it started.
A daycare office sits on a web of related data: families, the parents and children inside them, each child's program and income bracket, the bank accounts and billing, and government subsidy rates that change every year. Every official application a family needs is built from all of it at once — and for a long time, staff filled those applications in by hand, family by family.
That manual form-filling is the kind of work that quietly eats thousands of hours, and it's unforgiving: one child mapped to the wrong program, one stale subsidy rate, one missing bank account, and an application is wrong or a billing run stalls. The underlying data lived across spreadsheets and tools that never checked with each other, so just keeping it consistent was its own full-time chore.
They needed one secure place where the records, the money, and the paperwork were the same source of truth — where the hard calculations and the form-filling were handled correctly by the system, and where sensitive family and banking data was genuinely protected.
How I thought about it.
I modelled the real relationships first — child to family, family to program and income bracket, billing to bank account and company — so the system understands where every child belongs instead of leaving that in someone's head. Privacy came first alongside it: row-level security, multi-factor login, and admin-only controls on every sensitive screen.
Then I moved the heavy lifting into Supabase Edge Functions running against Postgres views that pull family, child, billing, income, and year-based rate data together. A single action can validate a transaction import, work out each child's tuition — what the government subsidy covers and what the family still owes — and generate a finished, correctly-filled government PDF, so the fiddly, error-prone work shifted from people to the system.
The thing itself.
Families
All ▾+ Add Family- Automatic application generationEvery family's government application and slips are filled and generated from live data in one action — the manual form-filling that ate thousands of hours is gone.
- Tuition & subsidy engineComputes each child's childcare tuition — what the government subsidy pays and what the family still owes — by resolving program, income bracket, and the correct year-based government rates.
- Family CRM + workspaceA searchable family table, and one screen per family for parents, children, income, billing, and bank accounts.
- Transaction pipelineCSV/XLSX imports are validated against company accounts, batch-processed, and exported in bank-ready EFT formats — with missing-bank detection.
- Privacy & security by defaultSensitive family, banking, and government data sits behind row-level security, TOTP multi-factor login, role-gated admin routes, and a full audit history.
- Flawless monday.com integrationAn OAuth-backed sync imports items from monday.com and upserts children and billing through Postgres RPCs — without dropping or duplicating a record.
What changed.
Family applications now generate themselves from live data, so the manual form-filling — easily thousands of hours across a year of families — simply doesn't happen anymore.
The system works out each child's tuition — the government's share and the family's balance — so those numbers are right instead of depending on someone to compute them by hand.
The monday.com import runs cleanly into one source of truth, and transaction files are validated and normalized before anything posts.
Sensitive family and banking data is held behind row-level security and multi-factor access with a full audit trail — privacy handled as a first-class concern, not an afterthought.
Outcomes are qualitative — no client metrics shown.
Under the hood.
Got a process that
should run itself?
Tell me where the work piles up. I'll show you what a calmer, quieter version of it looks like — built around how your team already works.