{"product_id":"tutor-session-log-invoice-tracker","title":"Tutor Session and Invoice Log Spreadsheet","description":"\u003cp\u003eThis tutor session log is for private tutors who teach several pupils at different rates and lose track of who still owes what. Every lesson goes on one row, and the file keeps taught, invoiced and paid apart, because only the last of those is money in the bank.\u003c\/p\u003e\u003cp\u003eIt answers the question most tutors face at the end of a week: what have I taught that nobody has paid for yet?\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003ePlease read:\u003c\/strong\u003e This is a tracker tool only, not financial, tax, legal, medical or any other professional advice or advisory service. It records and calculates what you enter; you are solely responsible for checking all figures, rates, dates and results and for every decision you make. By purchasing, downloading or using it, you accept these terms (your statutory consumer rights are not affected).\u003c\/p\u003e\u003ch2\u003eWhat each lesson row records\u003c\/h2\u003e\u003cul\u003e\n\u003cli\u003e\n\u003cstrong\u003ePupil, subject and level\u003c\/strong\u003e for up to 300 sessions\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eHours and rate:\u003c\/strong\u003e a 45-minute lesson and a two-hour session sit on the same list, and three different rates can too\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eWorth:\u003c\/strong\u003e hours times rate, calculated on every row so you never do the arithmetic\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eAn invoice number\u003c\/strong\u003e on the row, so chasing a payment is a lookup instead of a search through folders\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch2\u003eSix states, counted\u003c\/h2\u003e\u003cp\u003eEach session is booked, taught, invoiced, paid, cancelled or a no show. The states are colored and counted, and the unpaid figure totals everything taught or invoiced that has not been settled. That makes this a lesson tracker and a tutoring invoice list in one place.\u003c\/p\u003e\u003cp\u003eThe file also works out your average realized rate: what you actually earned divided by the hours you taught. Once cancellations and no shows are in, that number is often lower than the rate you advertise, and it is the honest one for a self employed tutor to plan around.\u003c\/p\u003e\u003ch2\u003eSix connected tabs\u003c\/h2\u003e\u003cul\u003e\n\u003cli\u003e\n\u003cstrong\u003eStart Here and Setup:\u003c\/strong\u003e a quick walkthrough and your own settings\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eSessions:\u003c\/strong\u003e the main log, one lesson per row\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eTasks:\u003c\/strong\u003e invoices to raise, parents to chase and resources to prepare\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eToday:\u003c\/strong\u003e what is booked this week\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eDashboard:\u003c\/strong\u003e reads all of it, so unpaid invoices and hours taught are always on view\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch2\u003eA filled-in term to learn from\u003c\/h2\u003e\u003cp\u003eThe worked example covers a term and a half: 145 sessions across eight pupils and three subjects, with 183 hours taught, some sessions still unpaid and an average realized rate worked out. A blank copy is ready for your own private tutor business.\u003c\/p\u003e\u003ch2\u003eWorks with\u003c\/h2\u003e\u003cul\u003e\n\u003cli\u003eMicrosoft Excel 2016, 2019, 2021 and Microsoft 365, on Windows and Mac, and LibreOffice\u003c\/li\u003e\n\u003cli\u003eGoogle Sheets with a free Google account. The Google Sheets version is a real workbook you make your own copy of, not a PDF with a link in it.\u003c\/li\u003e\n\u003cli\u003eNo dynamic arrays, no macros, no add-ins and no subscription\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch2\u003eWhat you download\u003c\/h2\u003e\u003cul\u003e\n\u003cli\u003eThe Excel workbook filled with a worked example\u003c\/li\u003e\n\u003cli\u003eA blank Excel workbook ready for your own entries\u003c\/li\u003e\n\u003cli\u003eThe instruction guide, which has one-click links to the Google Sheets versions (filled and blank)\u003c\/li\u003e\n\u003cli\u003eThe terms of use as a PDF\u003c\/li\u003e\n\u003c\/ul\u003e\u003cp\u003eYour files are ready to download as soon as payment clears, and the Start Here tab walks you through setup in a few minutes. The template is for personal and business use on your own devices, so please do not share or resell the files. Questions before or after you buy? Use our contact page and we will help.\u003c\/p\u003e\u003ch2\u003eFrequently asked questions\u003c\/h2\u003e\u003ch3\u003eCan I use it in Google Sheets instead of Excel?\u003c\/h3\u003e\u003cp\u003eYes. You download Excel workbooks for Excel 2016 or later on Windows and Mac, and the instruction guide has one-click links to make your own copy in Google Sheets with a free Google account.\u003c\/p\u003e\u003ch3\u003eCan I charge different rates for different pupils?\u003c\/h3\u003e\u003cp\u003eYes. Rate is entered per session, so several rates and lesson lengths can sit on the same list, and worth is calculated on every row.\u003c\/p\u003e\u003ch3\u003eHow does it show what I am still owed?\u003c\/h3\u003e\u003cp\u003eEach session has one of six states. The unpaid total adds up everything taught or invoiced that has not been marked paid.\u003c\/p\u003e\u003ch3\u003eCan I keep track of invoice numbers?\u003c\/h3\u003e\u003cp\u003eYes. Each session row has an invoice number, so finding and chasing a payment is a quick lookup.\u003c\/p\u003e\u003ch3\u003eHow many sessions does it hold?\u003c\/h3\u003e\u003cp\u003eThe Sessions tab has room for 300 sessions, each with pupil, subject, level, hours and rate.\u003c\/p\u003e","brand":"OPXVIA","offers":[{"title":"Default Title","offer_id":67597870596190,"sku":"OPX-189","price":20.0,"currency_code":"CAD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0769\/2094\/6782\/files\/tutor-session-log-invoice-tracker-01.jpg?v=1790833006","url":"https:\/\/opxviashop.com\/products\/tutor-session-log-invoice-tracker","provider":"OPXVIA","version":"1.0","type":"link"}