Tutor Lesson & Payment Kit | Excel Student Balance Tracker

Keep private lessons and payments in one Excel workbook.

For independent tutors who bill per lesson: log lessons, allocate payments, and review each student’s balance. Amber input cells and fictional examples make it clear where to start.

INCLUDED

• Student roster for 25 students or aliases

• 100 lesson rows with hourly charges

• Partial-payment and credit balances

• Missing-input and duplicate-ID flags

• Plain-text quick-start guide and one-business license

HOW IT WORKS

Add unique student IDs. Enter one row per lesson with hours, rate and billing type. Update the cumulative payment allocated to that lesson as installments arrive. Review charges and balances by student.

REQUIREMENTS AND FIT

Requires Microsoft Excel, not included. No macros. Other spreadsheet apps have not been verified. One currency, USD display. Tax, invoices, booking, prepaid packages and refund transactions are excluded. This is a lesson allocation ledger, not a payment-date cash-flow report. Fix flagged entries before relying on balances.

Digital ZIP download only. Example data is fictional. One tutoring business may use the workbook; do not redistribute or resell the blank template. Cover artwork is illustrative; gallery screenshots show the actual workbook.