Data Maintenance

System maintenance and data cleanup tools

Duplicate Session Cleanup
Year-Group Backfill & Review
Confirm each student's year group for 2026/27. Values that already match the date-of-birth calculation just need a one-click confirm; anything unusual (resits, held-back years) is set here with a pin reason so the August rollover skips it.
Academic year 2026/27
Awaiting confirmation: 0
Pinned: 0
Synced: 0
All students are confirmed for 2026/27. The annual rollover on 1 August keeps them in sync from here.
No students to review.
Session Data Cleanup
Orphaned Invoice Cleanup
Orphaned Invoice Cleanup
Orphaned User Cleanup
Orphaned User References
Orphaned Conversation Cleanup
Orphaned Conversation References
Mark Overdue Invoices
Correct Stale Session Rates

Sessions generated before a billing rate or slot rate was corrected keep the old frozen rate. Use this to bring those sessions onto the correct rate. Only future unbilled sessions, sessions on a draft invoice, and (when ticked) past unbilled sessions are touched — sent or paid invoices are never changed.

Unbilled Delivered Sessions

Scans for students with delivered sessions that were never billed on any invoice — the gap left by students graduating onboarding without the Confirm & Bill step. Flags for review only; resolve each case through the Billing Hub.

Session ⇄ Invoice Links

Sessions record which invoice billed them. When that link goes missing, a paid session can look unbilled. This reads the invoices themselves, writes any missing links back, and lists invoice lines that point at a session which no longer exists.

Invoice Archival

Generate PDF snapshots of old paid invoices, verify them, then permanently delete the records. Archive and delete are strictly separated.

Open Archival Manager