Online Tutor Income and Expense Spreadsheet for Lesson Payouts
An online tutor's money arrives in small pieces: a weekly payout from a tutoring platform after its cut, a parent's prepaid pack of ten lessons, a late-cancel fee. This sheet keeps each source separate so the deposits still make sense at month end.
How a online tutor gets paid, and what that means for the sheet
Most online tutors are paid by a platform that pays out weekly after taking its fee, by families who pay per lesson, or by both. A platform deposit is smaller than the lessons you taught. Log the payout as Income when it lands. If the platform lists its commission, you may log the gross amount and the commission as an Other expense instead.
Prepaid packs need a rule. Log a pack as Income on the day the parent pays, and write 'pack of 10' in the Description so later lessons can be matched to it. If a family stops early and you refund the rest, enter the refund as its own Other expense row on that day.
One example month, logged
Invented numbers, to show the shape. Each row below is one line on the Transactions tab.
| Client | What it was | Income |
|---|---|---|
| Nguyen family | Prepaid pack of 10 algebra lessons | $650 |
| Mapleton Tutoring Marketplace | Weekly payout, lessons taught after platform fee | $520 |
| Okafor family | SAT prep sessions, May | $220 |
| Lakeside Language Academy | Monthly small-group Spanish class contract | $900 |
| Income total | $2,290 | |
| Category | What it was | Expense |
|---|---|---|
| Software & subscriptions | Video call plan, annual | $150 |
| Software & subscriptions | Online whiteboard, monthly | $12 |
| Equipment | Graphics tablet for live handwriting | $79 |
| Equipment | USB headset with microphone | $65 |
| Home office | Ring light and desk lamp | $45 |
| Marketing | Featured profile on tutoring marketplace | $40 |
| Other expense | Printed practice workbooks | $28 |
| Professional fees | Background check for school contract | $40 |
| Contractors | Illustrator for worksheet templates | $120 |
| Expense total | $579 | |
In this example the month ends with $2,290 in, $579 out and $1,711 left before you set anything aside for tax.
The P&L tab sorts the same rows by category:
| Expense category | Month total |
|---|---|
| Software & subscriptions | $162 |
| Equipment | $144 |
| Contractors | $120 |
| Marketing | $40 |
| Home office | $45 |
| Professional fees | $40 |
| Other expense | $28 |
| Expense total | $579 |
Where a online tutor's purchases go
- Equipment: A graphics tablet, headset, webcam or second screen goes under Equipment, one row per item. If a tablet arrives bundled with a drawing app subscription, split it: the hardware as Equipment, the app as Software & subscriptions.
- Software & subscriptions: Video call plans, online whiteboards, quiz tools and scheduling apps go here. Many tutors stay on a free plan until a student needs a feature, so add the row only when you start paying. A yearly plan is one row on its payment date.
- Home office: A lamp, ring light, backdrop or chair that you use during lessons fits Home office. Log each receipt once. If a purchase serves your lesson corner and something else in the house, write the split in the Description.
- Other expense: Printed workbooks, flashcards, practice-test books and platform commission lines that do not fit elsewhere belong in Other expense. A store receipt that lists paper and a headset should be split into two rows by category.
Four tracking tips for a online tutor
- Add the platform's payout ID or week number to the Description, such as 'payout wk 12'. When a deposit does not match your lesson count, you can find the week and the gap in a minute.
- Record each family's prepaid pack as one row on the day it is paid. In the Invoices tab, keep an open line for any family that still owes you for lessons you already taught.
- Before each school term, type your expected lesson income into the Cash Flow tab month by month. Exam season and holidays change how many lessons you teach, so the lowest month shows how thin a slow stretch could get.
- If a platform pays out in a different currency, log the amount that reached your bank and put the original currency in the Description. The bank figure is the one you can match to a statement.
Two formulas worth a cell of their own
These use the kit's Transactions tab (Type in column B, Category in C, Client / Vendor in E, Amount in F). Excel and Google Sheets both support SUMIFS.
- Spend in your biggest category, here Software & subscriptions:
=SUMIFS(Transactions!F:F,Transactions!B:B,"Expense",Transactions!C:C,"Software & subscriptions")returns $162 on the example month. - Income from one client:
=SUMIFS(Transactions!F:F,Transactions!B:B,"Income",Transactions!E:E,"Nguyen family")returns $650 on the example month.
Questions
How do I track tutoring platform payouts that are less than my lesson total?
Log the deposit as Income on the day it arrives. If the platform statement lists a commission, you can instead log the full lesson amount and the commission as an Other expense. Pick one method and use it for every payout.
How do I record a student who cancels late and pays a fee?
Log the fee as an Income row on the day it is paid, with the student name and 'late cancel' in the Description. If you waive the fee, log nothing, because no money moved and the Transactions tab only holds real payments.
Already built
The Freelancer Finance Spreadsheet Kit has the Transactions, Invoices, P&L, Cash Flow and Tax Set-Aside tabs wired together, with this kind of example data on every tab. One Excel file, $29.
Free: the Tax Set-Aside tab as a standalone Excel file
One working tab: type your quarterly income, expenses and the rate you choose, and it shows what is still to put aside. Confirm your email and the file arrives right away, plus an occasional note (at most one a week) on tracking freelance money. Unsubscribe in one click. Privacy.
The same sheet for other freelancers
- All freelancer spreadsheet guides by profession
- Freelance Consultant Income and Expense Spreadsheet Template
- Freelance Graphic Designer Income and Expense Spreadsheet
- Income and Expense Spreadsheet for Freelance Photographers
- Freelance Social Media Manager Income and Expense Spreadsheet
- Freelance Translator Spreadsheet for Per-Word Income and Costs
- Freelance UX Designer Income and Expense Spreadsheet
- Freelance Video Editor Spreadsheet for Income and Expenses
- Freelance Virtual Assistant Income and Expense Spreadsheet
- Freelance Voice-Over Artist Income and Expense Spreadsheet
- Income and Expense Spreadsheet for Freelance Web Developers
- Freelance Writer Income and Expense Spreadsheet for Articles
More freelancer finance guides
- Excel or Google Sheets for freelancer finances? What actually differs
- Freelance expense categories for a spreadsheet: a starter list that stays short
- How to build a freelance income and expense tracker in a spreadsheet
- A simple 12-month cash flow forecast for freelancers
- Freelancer profit and loss (P&L) in a spreadsheet: a one-page layout
- Freelancer runway: three spreadsheet formulas for how long your cash lasts
- Freelancer tax set-aside: what goes into the number, and how to track it
- Invoice tracker spreadsheet: formulas for paid, due and overdue
- Budgeting on irregular freelance income: the baseline-pay method
- How to track freelance income by client in a spreadsheet
General information about using spreadsheets, not financial, tax or accounting advice. Example numbers are invented. Categories are for tracking and do not say what is deductible.