Admin Portal
Bookkeeping, packages, credits, tutor pay runs, and reports
Admin Dashboard
Teacher Sheet Workflow
Create linked teacher lesson spreadsheets, assign students, preview/import completed lesson rows, and create the next pay-cycle tabs. Generated teacher sheets are protected, system columns are hidden, Sheet1 is removed, and the Admin tab includes a pay-cycle selector with one additional historical pay cycle. Assigning students supports tickboxes for bulk assignment. v4.11 uses a faster roster-only refresh; use Create/Check Current Pay-Cycle Tabs separately when you need new tabs/protections.
Teacher Spreadsheets
| Teacher | Source | Students | Updated | Actions |
|---|---|---|---|---|
| Loading... | ||||
Archived Teacher Sheets
Closed tutors' linked spreadsheets appear here. They are kept for audit/reference but excluded from scheduled imports and Force Sync.
| Teacher | Source | Students | Archived | Actions |
|---|---|---|---|---|
| No archived teacher sheets. | ||||
Assign Students to Teacher Sheet
Select one or more students, then update the teacher sheet roster once. Existing assignments are safely skipped/reactivated. The selected-students list is retained across searches.
0 selected
Loading students...
Currently selected students
No students selected.
Lesson Import
Choose a specific teacher pay-cycle sheet to preview/import.
Normal import imports only clean rows. Amendments require approval.
Preview import results will appear here.
Month-to-Date Bookkeeping Summary
Student packages are cash inflow until sessions are taught. NZD and KRW receipts are tracked separately. Enter the current KRW per NZD spot rate to estimate NZD contractor fees and convert the KRW stream for management reporting.
Opening Unearned Revenue
-
Unused paid credits outstanding at selected start date
Gross Cash Received This Month
-
Positive NZD student payments only
Refunds This Month
-
Actual NZD cash refunded to students
Net Cash Movement This Month
-
Gross receipts less refunds
Earned Revenue This Month
-
Value of completed/consumed session credits
Unearned Revenue at Period End
-
Unused paid credits outstanding at selected end date
Tutor Pay Due at Period End KRW
-
Completed lessons unpaid as at selected period end
Tutor Pay Due at Period End NZD
-
Period-end KRW due converted at entered FX rate
Sales less Contractor Fees NZD
-
Earned revenue in selected period less contractor fees for sessions completed in selected period
Refund Rounding / Manual Adjustment
-
Difference between actual refunds and credit values reversed
NZD Reconciliation Difference
-
Unexplained difference after known refund adjustments
KRW-Received Package Stream
These are packages paid into the Korean won account. They are excluded from NZD cash inflow and NZD earned revenue above, but are tracked here in KRW. The NZD equivalent uses the same spot rate entered above.
KRW Opening Unearned Revenue
-
Unused KRW credits outstanding at selected start date
KRW Gross Cash Received
-
Positive KRW receipts only
KRW Refunds
-
Actual KRW refunds paid
KRW Net Cash Movement
-
KRW receipts less refunds
KRW Earned This Month
-
Consumed KRW session-credit revenue
KRW Unearned Revenue at Period End
-
Unused KRW credits outstanding at selected end date
KRW Stream Tutor Cost
-
Unpaid tutor pay attached to KRW-funded sessions
KRW Sales less Contractor Fees
-
KRW earned sales less contractor fees for KRW-funded sessions in selected period
KRW Sales less Contractor Fees NZD Equivalent
-
KRW stream result converted using spot rate
Alerts
Loading alerts...
Student Overview
Current student balances are credit-based. Invoices create student + level credits; teacher sheet import — student-level invoicess consume those credits.
| Student | Level | Total Credits | Consumed | Available | Status | Last Session | |
|---|---|---|---|---|---|---|---|
| Loading... | |||||||
Recent Activity
Loading...
Alerts
Low-session alerts refresh automatically. Zero-session alerts remain until dismissed unless the student receives more credits. Pay-run alerts appear one week before the 7th of every second month.
Loading alerts...
Record Student Payment / Create Session Package
This creates an invoice, payment record, package, and one SessionCredits row per purchased lesson. Tick Korean account if the student paid into the KRW bank account; otherwise the package is treated as NZD-received.
Recent Packages
| Select | Package | Student | Level | Sessions | Remaining | Receipt | Status | Date |
|---|---|---|---|---|---|---|---|---|
| Loading... | ||||||||
Process Refund
Select a student first. The portal will show all used and unused paid session credits for that student. Refunds create a negative row in Payments. Unused refunded credits reduce unearned revenue. Used refunded credits keep tutor/session history intact but are marked as refunded for audit purposes.
Refund Ledger / Edit Refund
Refunding unused sessions voids/refunds the affected session credits so they no longer count as available or unearned revenue. Editing a refund will void or unvoid the newest unused credits first. Used-session refund lines are kept for audit/history and cannot be removed from this edit screen.
| Refund | Date | Student | Sessions | Amount | Credit Value | Adjustment | Reason | Action |
|---|---|---|---|---|---|---|---|---|
| Load refunds to begin. | ||||||||
Edit Selected Refund
Recent Payments & Refunds
| Date | Payment | Student | Invoice | Currency | Amount | Method | Reference |
|---|---|---|---|---|---|---|---|
| Loading... | |||||||
Bulk Modify Packages
Use this for error correction. Enter one or more package IDs separated by commas. Positive session delta adds paid credits; negative delta voids newest available credits only. Consumed credits will not be removed.
Modify Invoice / Package
Use this for correction of an entered invoice. Changes are cascaded to the linked package, payment row, session credits, and unpaid imported session reports where appropriate. If consumed lessons are affected or the change would create negative available sessions, the backend will require confirmation.
Creates missing Payments, Packages and SessionCredits from paid manual invoices.
Use this when a student has paid more than once and you need to edit the exact invoice.
| Invoice | Paid Date | Student | Level | Sessions | Amount | Package | Action | |
|---|---|---|---|---|---|---|---|---|
| Load invoices to begin | ||||||||
Edit Selected Invoice
Session Credit Ledger
Select a student to view their session-credit ledger. You can then filter by status. Each row shows the credit ID, linked package ID, purchase date, and consumption date where applicable.
Choose a student to view their credits.
| Credit ID | Package ID | Status | Student | Level | Purchase Date | Consumed At | Revenue | Consumed Report |
|---|---|---|---|---|---|---|---|---|
| Choose a student to view credits. | ||||||||
Create Tutor Pay Run
Select one or more tutors and a period. The backend creates one separate draft pay run per selected tutor and blocks only tutors with overlapping pay runs.
Pay Runs
| Run | Tutor | Period | Sessions | Gross KRW | Status | Actions |
|---|---|---|---|---|---|---|
| Loading... | ||||||
Draft Pay Run Detail
Click a draft pay run to view lesson-type quantities, rates and totals.
Tutor Information / Onboarding
These fields match the personal-information columns in the bulk remittance template. Tutors can view this information in their portal but cannot edit it themselves.
Saved Tutor Information
| Tutor | Address | Phone | Bank Account | Updated | Action | |
|---|---|---|---|---|---|---|
| Loading... | ||||||
Add / Update Tutor Rate
Current Rates
| Level | Rate KRW | Effective From | Effective To | Active | |
|---|---|---|---|---|---|
| Loading... | |||||
Reports
Select a student to see session history and tutor notes, or select a tutor to see session history and pay history.
Report Output
Choose a student or tutor above.
Add New User
Create students, teachers/tutors, or other admins directly from the portal. Access codes are required only for admin users; teachers no longer log into a tutor portal.
Admin User Notes
Notes are chronological and admin-only. They are not visible in the student or tutor portals.
Select a user to view notes.
Close User Workflow
Use this for final closure, not ordinary deactivation. In v4, tutor closure archives linked teacher sheets so they stop syncing. Student closure does not refund or abandon credits automatically; process any refund from Packages & Payments.
Select a user to see the closure warning.
Select a user and click Preview Close.
Manage Users
| User ID | Role | Name | Contact | Timezone | Level | Status | Actions | |
|---|---|---|---|---|---|---|---|---|
| Loading... | ||||||||