FL Admin Portal v4.11

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

TeacherSourceStudentsUpdatedActions
Loading...

Archived Teacher Sheets

Closed tutors' linked spreadsheets appear here. They are kept for audit/reference but excluded from scheduled imports and Force Sync.
TeacherSourceStudentsArchivedActions
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.
StudentEmailLevelTotal CreditsConsumedAvailableStatusLast 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

SelectPackageStudentLevelSessionsRemainingReceiptStatusDate
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.
Choose a student to see used and unused refundable sessions.
SelectStatusDatePackageLevelValueReport
Choose a student

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.
RefundDateStudentSessionsAmountCredit ValueAdjustmentReasonAction
Load refunds to begin.

Edit Selected Refund

Select a refund above to edit it.
Credit IDPackageStatusLevelPurchase DateAmountReport
No refund selected.

Recent Payments & Refunds

DatePaymentStudentInvoiceCurrencyAmountMethodReference
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.

Example: 2 adds two credits to each package; -1 voids one available credit.

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.

InvoicePaid DateStudentLevelSessionsAmountPackageAction
Load invoices to begin

Edit Selected Invoice

Select an invoice to see linked credits and irregularity warnings.

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 IDPackage IDStatusStudentLevelPurchase DateConsumed AtRevenueConsumed 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.

Hold Ctrl/Command to select more than one tutor.

Pay Runs

RunTutorPeriodSessionsGross KRWStatusActions
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

TutorEmailAddressPhoneBank AccountUpdatedAction
Loading...

Add / Update Tutor Rate

Current Rates

LevelRate KRWEffective FromEffective ToActive
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.

Not required for students or teachers.

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 IDRoleNameEmailContactTimezoneLevelStatusActions
Loading...