# Tutor payroll spreadsheet template for online academies

> Build a tutor payroll sheet with a row per class, outcome-based pay formulas, and monthly totals for each teacher and payment currency.

URL: https://halqora.com/blog/teacher-payroll-spreadsheet-template
Last updated: 2026-10-21

Published: 2026-10-21 · By Halqora team

A tutor payroll spreadsheet template needs a row per class with the date, teacher, student, outcome, scheduled minutes, lateness, rate, and calculated pay. A monthly summary totals each teacher's pay separately by payment currency, with unresolved outcomes held for review before payout.

> **Key facts:** - Halqora's [fixed payroll rules](https://halqora.com/features/payroll) allow up to 2 minutes of teacher lateness without a deduction.
> - At 3 to 5 minutes late, Halqora deducts a flat 5% of class pay under the same [teacher pay rules](https://halqora.com/features/payroll).
> - As of 21 October 2026, [JazzCash's Payoneer withdrawal page](https://jazzcash.com.pk/move-money/international-remittance) states a USD 5 minimum and a 3% Payoneer withdrawal fee.

> **Definition:** Outcome-based pay means calculating class earnings from the recorded result and the written pay rule, rather than from scheduled time alone.

## What does a teacher payroll spreadsheet need?

A teacher payroll spreadsheet needs a class log, a written rules reference, and a monthly summary. Keep payout records separate from earned pay so a transfer fee cannot quietly change the class calculation. Protect formula cells and leave uncertain outcomes visible for review. A blank outcome should never look like an approved unpaid class.

Start with these steps:

1. Agree on the outcome names and what evidence each outcome needs.
2. Enter the class rate and payment currency on each class row.
3. Protect calculation columns while leaving input cells editable.
4. Review unresolved rows before approving the monthly summary.
5. Save the approved period with its payout references.

Keep the rate used for each class on that row. Referencing a teacher's current rate throughout an old log can change past earnings when you update the rate later.

Write your [payroll rules tied to class outcomes](https://halqora.com/blog/teacher-payroll-rules-class-outcomes) before building formulas. A spreadsheet can apply a decision consistently, but a formula cannot settle an unwritten policy.

## What belongs in the class log tab?

The class log needs a separate row for each class, including classes that did not happen. Use consistent teacher and student identifiers so spelling changes do not split monthly totals. The table below is a copyable column structure. The example inputs describe a 30-minute class with a USD 4.00 class rate and 3 minutes of teacher lateness.

| Column name | Example value, with units | Formula or rule |
| --- | --- | --- |
| Date | Class date | Store a date value, not a text note |
| Teacher | Teacher identifier | Use the same identifier throughout |
| Student | Student identifier | Keep the class traceable |
| Scheduled minutes | 30 minutes | Use the scheduled class length |
| Outcome | completed | Dropdown: completed, missed_by_student, missed_by_teacher, cancelled_with_notice, cancelled_late, emergency_exception |
| Minutes late | 3 minutes | Admin-recorded whole minutes |
| Wait minutes | Blank for a completed class | Required for student no-shows |
| Rate per class | USD 4.00 | Preserve the agreed class rate |
| Currency | USD; alternatives GBP or PKR | Total currencies separately |
| Deduction | USD 0.20 | Example: USD 4.00 × 5% = USD 0.20 |
| Pay | USD 3.80 | Example: USD 4.00 − USD 0.20 = USD 3.80 |

These dropdown values are suggested spreadsheet labels, rather than a claim about Halqora's stored statuses. Keep a notes field beside the table for the admin's decision and its reason.

## How do you turn lateness, no-shows, and cancellations into formulas?

Pay formulas should implement written rules and return a review flag when evidence is missing. Halqora's fixed outcome rules are an example starting point: completed classes receive full pay through 2 minutes late, a flat 5% deduction at 3 to 5 minutes, and a minute-based deduction beyond 5 minutes. Your spreadsheet should keep cancellation decisions separate from those completed-class calculations.

Beyond 5 minutes, the example minute-rate deduction is class rate divided by scheduled minutes, multiplied by minutes late. Count lateness from the scheduled start, and floor the resulting pay at 0. Do not deduct just the minutes beyond the grace period. Explain that boundary in your [teacher lateness policy](https://halqora.com/blog/teacher-lateness-policy).

For student no-shows, Halqora requires an admin-recorded wait of at least half the class, rounded up to a whole minute. A qualifying wait earns full class pay; a shorter wait earns 0. Missing wait data needs review.

Example implementation: the following spreadsheet formula uses named inputs matching the column meanings. The factor 0.95 means full pay minus the 5% deduction. Adapt the names to your sheet's cell references.

```text
=IF(outcome="completed",
  IF(2>=late,rate,
    IF(5>=late,rate*0.95,MAX(0,rate-late*rate/minutes))),
  IF(outcome="missed_by_student",
    IF(wait="","REVIEW",
      IF(wait>=ROUNDUP(minutes/2,0),rate,0)),
    IF(outcome="missed_by_teacher",0,"REVIEW")))
```

Validate scheduled minutes and rates before applying the formula. Require lateness input for completed classes. The formula deliberately holds cancellations, emergency exceptions, and unfinished outcomes for an admin decision. Do not let a summary silently ignore text flags and appear ready to pay.

Student billing and teacher earnings are separate decisions. A family charge does not establish the teacher's entitlement. Document your cancellation pay policy before replacing review flags with amounts.

According to Clasify's teacher management page, checked 21 October 2026, student-missed lessons pay the teacher by default, and that setting is configurable. Clasify may fit better if you want that paid-by-default approach or need to change the no-show setting. Halqora's half-class wait rule is fixed.

## How should the monthly summary total teachers and currencies?

The monthly summary should group approved class pay by teacher, month, and payment currency. Use conditional sums against the class log rather than retyping amounts. Show unresolved rows beside each teacher's total so the reviewer sees whether the amount is ready to pay. Keep the summary tied to class dates, with payout dates recorded separately.

Give the summary separate fields for earned pay, approved adjustments, payout status, and transfer reference. Keep a reason for every manual adjustment. A clean total without an explanation is harder to check than a visible correction.

Reconcile the summary back to the class log before payment. Confirm that every scheduled class has a final outcome or a review flag. Check that a corrected outcome has not left a duplicate row behind.

Maintain annual contractor totals too. As of 21 October 2026, the [IRS instructions for Form 1099-NEC](https://irs.gov/instructions/i1099mec) give a USD 2,000 nonemployee compensation reporting threshold for payments made in 2026 onward, previously USD 600. This is general information, not legal or tax advice; check with an adviser in your country.

## How do you record payout costs for Wise (wise.com), Payoneer, and wallets?

Payout costs belong beside the payroll calculation, with the route, actual fee, fee currency, and transfer reference. Keep the teacher's earned amount visible even when the amount received differs. Provider pricing can depend on the route and currency. Use dated fee information for planning, then reconcile the payout record to the provider's actual transaction.

The supplied provider pricing, as of 21 October 2026, gives these route-specific references:

- According to [Payoneer's pricing page](https://payoneer.com/pricing), sending to another Payoneer account in the same country costs up to USD/EUR/GBP 4.00; across countries, up to 1% plus up to USD 4.00.
- JazzCash says it charges nothing for the Payoneer withdrawal route; Payoneer's standard 3% withdrawal fee applies, with a USD 5 minimum withdrawal.
- According to [Wise (wise.com)'s UK business pricing page](https://wise.com/gb/pricing/business), setup costs GBP 50 once, and sending starts at 0.24%, varying by currency.

Do not subtract a setup fee from every class. Record the cost where the cost belongs, and state who bears transfer fees in your written payment arrangement.

## Where do payroll spreadsheets break?

Payroll spreadsheets become difficult when the class log, teacher outcomes, and payment records stop agreeing. The warning sign is repeated reconstruction: checking messages for wait times, asking which rate applied, or tracing an unexplained deduction. A formula may calculate correctly while using incomplete inputs. More formulas will not fix missing decisions or unclear responsibility.

Give someone responsibility for resolving exceptions before approval. Preserve the approved period so later edits do not quietly change a paid total. Keep an adjustment trail when a correction affects a later payout.

If each pay period requires rebuilding the class history, review the [signs your academy has outgrown spreadsheets](https://halqora.com/blog/signs-academy-outgrown-spreadsheets). The useful question is whether the spreadsheet still gives teachers an understandable explanation of earnings without repeated manual investigation.

## How Halqora handles this

Halqora is management software for online academies that schedules, bills, and calculates teacher pay for one-to-one classes. Teachers record outcomes and completed-class reports; admins record late minutes, wait minutes, and emergency exceptions. Payroll for a period waits until completed-class reports are in.

Halqora calculates class pay from the teacher's hourly rate and class duration, without currency conversion. Teachers see the matching earnings. The class and payroll rules are fixed. Halqora creates draft teacher payments; an admin makes the transfer elsewhere and marks the payment paid.

See how [automatic teacher payroll](https://halqora.com/features/payroll) applies recorded outcomes to earnings.

## Sources

- Clasify teacher management, checked 21 October 2026
- [Payoneer pricing](https://payoneer.com/pricing), checked 21 October 2026
- [JazzCash international remittance and Payoneer withdrawals](https://jazzcash.com.pk/move-money/international-remittance), checked 21 October 2026
- [Wise (wise.com) UK business pricing](https://wise.com/gb/pricing/business), checked 21 October 2026
- [IRS instructions for Form 1099-NEC](https://irs.gov/instructions/i1099mec), checked 21 October 2026

## Questions

### Can I run tutor payroll in Google Sheets?

Yes. Keep a row for each class, use outcome dropdowns, and calculate pay with protected formulas. Keep monthly class logs and a summary by teacher and currency. Ask another person to check exceptions and totals before paying. A spreadsheet becomes harder to manage when outcomes, rate changes, and payout records need repeated manual checks.

### How do I handle teachers paid in different currencies?

Record each class rate in the currency you pay that teacher, then total each teacher and currency separately. Do not add USD, GBP, and PKR into a single payable amount. If you convert totals for management reporting, state the exchange rate and date and label the result approximate. Keep that reporting figure separate from the payment instructions.

### Should the spreadsheet deduct payout fees from teacher pay?

Write down who bears payout costs before calculating the transfer. Keep earned pay, provider fees, and the amount received in separate fields. As of 21 October 2026, JazzCash says its Payoneer withdrawal route has no JazzCash charge, but Payoneer's standard 3% withdrawal fee applies. Record the actual fee for the route used rather than applying that percentage to every payout.

### Do I need to track annual totals for US contractors?

For a US business paying US contractors, keep annual compensation totals so you can check reporting obligations. According to the IRS instructions, the Form 1099-NEC reporting threshold is USD 2,000 for payments made in 2026 onward, previously USD 600. This is general information, not legal or tax advice; check with an adviser in your country.