Scholarship Tracker & College Application Tracker, Deadline Countdown, Award Totals, Net Price, Senior Year | Google Sheets Excel Template

Seller's description

Every scholarship and college application in one place, with a countdown on every deadline and a list of what's still missing. This TeamTimeTools workbook adds up what you've applied for and won, and shows what each college will really cost after grants and your outside scholarships. For high school seniors and the parents helping them. Works in Google Sheets and Excel.

WHAT'S INCLUDED
1. Scholarship + College Application Tracker workbook (Google Sheets + Excel), 7 tabs:
- Start Here: plain-English steps.
- Dashboard: number applied for, value applied for, won (all years and first year), win rate, still open, due soon, colleges by status, application fees still to pay, average readiness, and your lowest net price among colleges you're accepted to.
- Setup: student name, class year, reminder window, and the status and plan lists, which you can edit.
- Scholarships (200 rows): amount per year and renewable years, deadline, essay, rec letters, transcript, status, award. It shows total value, days left, a countdown (Due in 6 days, Deadline passed, Won) and Still to do (for example: Essay; 1 rec letter; Transcript).
- Colleges (60 rows): ED / EA / REA / RD / Rolling, application and financial aid priority deadlines, CSS Profile, fee and fee waiver, essays and rec letters, scores and transcript. It shows readiness %, next deadline, fee to pay, net price per year and what's left after loans and work-study.
- Essays (60 rows): word limit vs word count (for example: 30 over the limit) and which applications reuse each essay.
- Deadlines: the next 30 dates from scholarships, applications and aid deadlines, merged and sorted. Nothing to type.
2. Start Here PDF with your Google copy link.

WHY IT'S DIFFERENT
- Scholarships and college applications together. Most trackers do one or the other.
- Real cost, not just sticker price: net price per college, with loans shown separately, and the cheapest acceptance picked out for you.
- Renewable awards counted correctly ($5,000 x 4 years = $20,000).
- A Check column on every list says exactly what's wrong, and that row stays out of the totals until it's fixed.
- Works in Google Sheets AND Excel 2010 or newer, plus LibreOffice. No macros, nothing locked, every header editable.

TESTED
Automated tests compared 5,877 calculated cells with an independent model over 3 rounds: the sample, a full file (200 scholarships, 60 colleges) with planted mistakes, and a cleared file. 28 of 28 checks passed. Google Sheets matched Excel/LibreOffice cell by cell (1,405 cells, 0 differences).

HOW TO GET IT
1. After you buy, go to your Etsy account > Purchases and download the zip. Etsy also emails you a link.
2. Open Scholarship-START-HERE.pdf. Click the link and choose "Make a copy" for Google Sheets, or open the .xlsx in Excel.
3. Look at the sample, clear it and add your first scholarship.

GOOD TO KNOW, PLEASE READ
- An organizer, not advice. It doesn't find scholarships, check eligibility or submit anything.
- You type each FAFSA, CSS Profile and college deadline yourself; dates change every year.
- Sample student, scholarships and colleges are made up.
- One currency. Not designed for Apple Numbers.
- This is a digital download. Nothing physical will be shipped. Because it's a digital file, returns aren't accepted. If something isn't working, send me a message and I'll help.
- For your own family's use. Please don't resell or share the files or links.

HOW THIS WAS MADE
I designed this workbook with help from AI tools, which assisted with the formulas, layout and sample data. I chose the features after comparing the scholarship trackers already on Etsy (most are Google Sheets only and track scholarships without the college side or the cost). I tested every calculation against an independent check before listing.