My original tracker is still up and running and updated to reflect current budget amounts as of 29 July 2020, if you’d prefer to use that one, or want to understand more about My Tech High and the history of this tracker click here.
UPDATE 11-11-2020: I’ve added support to select the full year program or half year program which will adjust all of your budgets based on whether you’re starting in August or January. By default it will assume the full year program but make sure you select the half year program if you’re starting in January so that you don’t have your budgets doubled in the spreadsheet!
I have been maintaining this tracker for a couple years now and I’ve been so happy to see it help so many people! This year as My Tech High announced funding increases for their students I decided it was time to update my reimbursement tracker too. I started by just updating the formulas to reflect the new amounts. I tried to convince myself I was done then… but then I spent a week totally revamping the whole process and basically rebuilding the whole thing. So let me tell you what’s new and how to use it 🙂
- Multiple Students in One Workbook: This was by far and away the biggest add. You can now manage the schedules and budgets for all of your students in one workbook (assuming you have less than 20 students, if you have more than 20 students then I really hope you have better organization skills than I do and heaven bless you!)
- Budgets Categorized by Class instead of Budget Block: Maybe no one else ran into this but it would bother me all the time. In my old workbook all expenses were matched up with their budget block. So if you had a combined custom core for Math/English/Science that was one category. This was fine unless you changed your Science class from being custom built to being 3rd party. Then you’d have to go in and change all of your expenses to be associated either with this new 3rd party science class or with the new “Custom Core – Math, English” category. Now you simply select the subject the expense is associated with and it will follow that subject into whatever bucket you have it in at the time.
- Custom Formatting: This may not have been the most important, but it was the most satisfying part of the process! I’ve changed the font to be a little prettier, added lots of color coding and generally made the whole thing more visually pleasing.
So let’s jump in to how to use it. If you don’t want to read through all of this I’ve made a little video tutorial that you can watch that shows you all of the steps.
The first thing you need to do is make a COPY of my spreadsheet. I frequently get edit requests for the master spreadsheet from people who miss that step, and then you have to wait until I see the email and respond to it… and I will tell you to make a copy 😛 So save yourself some time and don’t skip that step! Ok, here’s the link to the Google Sheet- MTH Reimbursement Tracker 2.0. Let’s start with how to make your own copy. To do this you go to File->Make a copy…
After you do that a box will pop up asking for a name for this document. I usually name it something like “MTH [school year] so that I don’t my workbooks mixed up in future years.
Once you click OK your copy will pop up and you’re ready to begin filling it out. I’ve tried to lock as many of the ranges that you shouldn’t be changing as possible so you don’t accidentally mess up something that you won’t be able to fix, so if you get a warning box saying not to change something – please try to heed it! The first thing you will need to do is select if your children are participating in the full year or half year program. If you’re starting (or already started) in September pick full year, if you’re starting in January pick half year. This will adjust your budget amounts to be either the full amounts or halved amounts depending on when you started the program.
The first thing you will do is enter your students’ names and grades in the Students sheet. You can also pick a color for each student which will just make the rest of the workbook prettier – and making it pretty is what’s most important right? Once you’ve done that go to the bottom of the page and click the “Schedules” worksheet.
You will see that your students’ names have already been populated and options corresponding to your students’ grades will show up. I like to go to the bottom and hide all of the schedules that are for non-existent students – just to make the experience a little bit cleaner for myself. To do this simply select the first row of empty schedules and then select all the way down to the last row. Then right click and you will see the option to “hide rows”, click that and all the extra schedules to disappear.
In the first column the only selection you need to make is whether your student is doing History or Science this year. Don’t change anything in the 2nd column. In the 3rd column you will select whether the classes are going to be custom built, 3rd party or My Tech High Direct. You will notice that as you change these selections that the funds in the second column change to correspond with the budgets you will receive from My Tech High. The 4th column is optional but it gives you a space to write out your course descriptions. You can use this as a place to take notes of things you want to do or to write out your official course descriptions that you will submit to My Tech High. If you use it for writing your official descriptions you might notice that in the last column there is a character counter. It will tell you how many characters you have left before you exceed the course description character limit in InfoCenter. You’re welcome to write more characters in the worksheet, no one will see this other than you. Ok you’ve finished the hard part now on to where the magic happens! Open up the budgets worksheet and we’ll continue on 🙂
On the right it shows a budget breakdown for each of your students. At the top it tells you how much money you have remaining to spend. You will not need to make any changes to these columns because everything will be calculated automatically. Here’s what my kids’ budgets look like right now. You can see that I’m over budget for Sam in a couple of categories but it doesn’t take those negative amounts away from the total available to spend because you can’t spend over the limit for any particular category.
Let’s go on to the purchase list. Here you will simply enter in the items you have purchased, the price paid and then select the student and subject the purchase is associated with. As you do that you will notice that all of the “remaining” balances will update to show you how much is left in each category. If you select a subject with a student that doesn’t have that subject on their schedule the item will turn red and you’ll get an error message off to the side so that you can make sure to put that expense with a valid student/subject combination. Ok one last worksheet to go! Go ahead and click on the “Reimbursement Cover Sheet”
You won’t need the reimbursement cover sheet until it’s time to submit your receipts but I find this to be really handy. At the top of the page you can select a student and a budget and then the rest of the workbook populates with all of the purchases for that period. I will print this page to a PDF and then use it to help me make sure I have all of my receipts together before submitting them at reimbursement time. I use the free program PDFBinder and put the cover sheet first and then add all of the receipts in the order they’re listed on my cover sheet. This makes it easy for MyTechHigh to see at a glance what all of my expenses were and help me get reimbursed faster. Once you’ve already made one submission and you need to make another then if you go back to the Budgets worksheet and check off the “Submitted?” boxes on the expenses that you’ve already been reimbursed for, then when you go back to the Cover Sheet worksheet you’ll see that it only displays the receipts that you haven’t yet been reimbursed for. So that can be handy for helping you keep organized.
One last tip for anyone who considers themselves lightly advanced. If you want to sort your purchases – Select all of the purchase list cells by clicking on the “Item Purchased” cell and dragging your mouse until you are down to the submitted column on your last row. Then go to the “Data” menu and select “Sort range”.
Check the “Data has a header row” box and then you can sort things however you like. I usually like to sort by student, then by subject and then by cost high to low. The sorting won’t stay as you enter in more items, but I find this to be handy as I’m trying to keep organized – especially when I’m getting ready to submit.
And that’s it! Hopefully this helps you to better keep track of your MyTechHigh expenses and budget in the coming years! If you notice anything that I’ve missed please comment below so that I can get it fixed! If this is useful to you consider making a donation to my site, or making a purchase through one of my affiliate links to help me keep this site going. If you’re looking for more ideas on what curriculum you want to use check out my curriculum recommendations post or if you’re looking for ideas on how to schedule your day check out my homeschool scheduling post. Happy Homeschooling 🙂
Here’s a link to the spreadsheet again, just so you don’t have to hunt through the article to find it – MyTechHigh Reimbursement Tracker 2.0.
Side note: Everything above shows actual items I’ve been reimbursed for and course descriptions I’ve had approved. Feel free to use the descriptions and purchase list for inspiration for your own child’s schedule. Just a quick plug for a couple of things we’ve especially loved –
- Kiwi Crates – these have been SO much fun for all of my kids and they’ve learned a ton from them. I’ve gotten 1 subscription and made my three kids share it and it’s been great. I thought I was going to like the Kiwi Crate but it’s been so much better than I’d expected. If you use my referral link you get $10 off of your subscription 🙂
- Tuttle Twins these books are AMAZING at teaching your kids about the role of government and how laws work. They are definitely from a libertarian perspective and they’re very engaging – I’ve even had lots to think about and discuss after reading them! As of the time of this writing promo code FORTY works to get you 40% off of the retail price.
Disclaimer: I have no affiliation with My Tech High other than as a parent to students within the program. This tracker is provided free of charge and without warranty. I intend to keep all formulas and information current and accurate however I accept no liability for any faults in the program. Use at your own risk.