In the old app (signed in), press F12, open Console, paste the export line you were given, and choose the downloaded file below. This replaces the data stored here with the file's contents.
Loads the week's classes from the Teacher Scheduler in the planner AND from the teachers' time sheets, so an individual class a teacher added on their own time sheet shows up here too. Classes are matched to your money classes by name (capital letters don't matter, and "(Sub)" ticks the Sub box). Anything that doesn't match gets a drop-down. Then fill in headcounts.
| Date | Time | Class | Teacher | Sub | # students |
|---|
Export your spreadsheet as a CSV file, then upload it here. Use columns named Date, Time, Class, Teacher, Learners or Students, Sub, and Notes. Class and teacher names should match the names in this app.
Choose a CSV file to preview it.
| Date | Time | Class | Teacher | Sub | Learners | Revenue | Pay | Profit | Status |
|---|
No longer used. The Add entry tab now loads each week's classes from the Teacher Scheduler instead. This old list is kept only as a record and can be ignored.
| Date | Time | Class | Teacher | Sub | Learners | Revenue | Teacher pay | Profit |
|---|
Teacher and class breakdown tables still show revenue and P&L before the PayPal loan deduction.
| Teacher | Classes | Students | Hours | Revenue | Pay | P&L |
|---|
| Class | Sessions | Students | Avg students | Revenue | P&L |
|---|
| Metric | Month A | Month B | Difference |
|---|
| Month | Sessions | Learners | Revenue | Pay | Profit | Avg revenue |
|---|
| Teacher | Sessions | Learners | Hours | Revenue | Pay | Profit |
|---|
| Class | Sessions | Learners | Avg learners | Revenue | Profit |
|---|
| Day | Sessions | Learners | Revenue | Profit | Avg revenue |
|---|
Price is the full listed price per student. Revenue per entry is calculated as price × your keep rate × number of students. Duration is used to calculate teacher pay (hours × teacher's hourly rate).
Hourly rate is what each teacher earns per hour coached. Sub flat rate (optional) overrides the hourly calculation when an entry is marked as a sub.