▶
▶College Application & Scholarship Command Center
The essay gets all the attention. The calendar decides.
Families pour months into 650 words and then lose a school to a portal task nobody checked — a recommender who said yes in the corridor and was never formally invited inside the system, a financial aid form that opened in October and closed while everyone was still editing an essay. The work that determines the outcome is not the writing. It is the tracking, which is why there are twenty tabs and not eight. Every dated item across every school lands in one sorted view with a live countdown and an overdue flag: 41 items in the worked sample, and only nine of them application deadlines. The file also computes net price the way federal law actually defines it, cost of attendance minus gift aid only, with loans and work-study shown separately below the line. In the sample, two offers with an identical published cost of attendance turn out to be $10,459 apart over four years.
- Deadline Calendar — every dated item across every school in one sorted view with a live countdown and an overdue flag; 41 items in the sample, only nine of them application deadlines
- Award Comparison — net price computed as cost of attendance minus gift aid only, loans and work-study in labelled columns below the line, plus a four-year projection with an increase you enter yourself
- Essay Tracker — prompt, word cap, live word count, margin under the cap, reader and final date, with a reuse map that turns 14 supplements into 7 drafts
- Recommenders — asked, formally invited inside the portal, materials sent, submitted per school, thank-you sent, on a grid that makes a missing letter impossible to miss
- Application Costs — fees, waivers, score sends, CSS Profile fees and travel with a running total, and the nine official fee-waiver indicators printed in full
Overview
The essay gets all the attention. The calendar decides.
Families pour months into 650 words and then lose a school to a portal task nobody checked — a recommender who said yes in the corridor and was never formally invited inside the system, a financial aid form that opened in October and closed while everyone was still editing an essay. The work that determines the outcome is not the writing. It is the tracking, which is why there are twenty tabs and not eight. Every dated item across every school lands in one sorted view with a live countdown and an overdue flag: 41 items in the worked sample, and only nine of them application deadlines. The file also computes net price the way federal law actually defines it, cost of attendance minus gift aid only, with loans and work-study shown separately below the line. In the sample, two offers with an identical published cost of attendance turn out to be $10,459 apart over four years.
It never predicts anybody's odds of admission — there is no chance-me score, no probability column and no chances number anywhere in it. It never states a named college's deadline, application fee, test policy, required forms or deposit as a fact; every one of those is a cell you fill in, with a verified-on date beside it. The test-policy column ships blank on purpose, because the national trackers actively contradict each other. And it never stores a password.
What's Included
20 connected tabs:
- Four full themes — Editorial, Colorful, Light and Dark (.xlsx), the same complete engine in each
- Quick-Start-Guide.pdf — start to finish in minutes
- ACCESS-YOUR-TEMPLATE.pdf — one click opens your own copy in Google Sheets
- README and LICENSE — delivered as one ZIP, instant download
Key Benefits
Why this one
41 dated items in the sample, and only nine are application deadlines. The rest are portal tasks, aid forms, score sends and mid-year reports — the ones that quietly go missing.
Federal law defines it as cost of attendance minus grant aid only (20 U.S.C. §1015a). A loan moves the bill; it does not shrink it. This workbook computes it that way on every row and puts the borrowing in two clearly-labelled columns below the line.
In the worked sample, two offers with the same published cost of attendance separate by $10,459 over four years purely because one college put more gift aid on the table — and a private nonprofit with a $65,470 sticker nets out cheaper than every out-of-state public offer on the list.
The Essay Tracker's reuse map finds the overlap, counts words against each cap live, and shows the margin under it before anyone pastes into a portal.
Recommenders are tracked from asked, to formally invited inside the portal, to submitted, school by school — so the difference between a corridor yes and a portal invitation is visible while there is still time.
Every figure the file prints sits on Reference & Sources with a name, a URL and the day it was checked, beside a plain list of the numbers this file refuses to print and why.
Who It's For
Built for
- Seniors applying to more than three schools, where the tracking stops fitting in one head
- Parents who want the affordability conversation had in September rather than April
- Families comparing award letters and unsure which offer is actually cheaper
- Anyone chasing recommenders, portal tasks and aid forms across nine separate systems
How It Works
Up and running in minutes
Open the hosted copy link included with your purchase and choose File → Make a copy. Every formula is portable, so nothing breaks in the move
Type, state, admission plan, deadline, portal, fee, waiver flag, reach / target / likely band, and why each school is on the list
Every requirement, portal task, aid form and score send becomes a dated item on one sorted calendar with a countdown and an overdue flag
Prompts, word caps and the reuse map on one tab; asked, invited, submitted and thanked on the other
Cost of attendance minus gift aid only, loans and work-study below the line, and four years projected before anybody sends a deposit
Why It's Different
Not another template
Almost every file in this lane is a to-do list with a deadline column. The outcome is decided elsewhere: in the portal task nobody opened, the recommender who was never formally invited, the aid form that closed in the middle of an essay draft, and the award letter read as though a loan were a discount. This one tracks those four things properly, and refuses to guess at anything it cannot source.
Delivery & Compatibility
Instant, and works with what you use
As soon as your order is complete you get instant access to download your files. Prefer Google Sheets for real-time updates and dropdowns? It's fully optimized. More comfortable in Excel? It works just as well.
Built and tested in the latest Excel (Office 365). On Mac we recommend the Google Sheets version — the template is not compatible with Apple Numbers. Available in English. The template ships with sample data so every screen works on open; clear it whenever you're ready. The images and video show that sample data to demonstrate how it looks in use.
FAQ
Questions, answered
Does it work in Google Sheets?
Yes. Open the hosted copy link included with your purchase and choose File to Make a copy, or import the .xlsx into Drive. The same download opens in Microsoft Excel, and every formula is portable, so nothing breaks in the move.
Does it tell us our chances of getting in?
No. There is no chance-me score, no probability column and no chances number anywhere in it. It tracks the work; it does not predict the decision.
Why are the college-specific cells blank?
Because the file never states a named college's deadline, application fee, test policy, required forms or deposit as a fact. Each is a cell you fill in with a verified-on date beside it. The test-policy column ships blank on purpose, since the national trackers actively contradict each other.
How does the award comparison work?
Net price is computed as cost of attendance minus gift aid only, per 20 U.S.C. §1015a. Loans and work-study are shown separately below the line, and a four-year projection applies an annual increase you enter yourself.
Is anything pre-loaded?
Yes — a complete worked sample you can read before typing a single thing: nine schools, 41 dated items, 14 supplemental essays, 22 recommender invitations and six award letters.
Can I get a refund on a digital download?
Because delivery is instant, all sales are final — but message us with any issue and we'll make it right.
This is a tracking and arithmetic tool, not admissions, financial, tax or legal advice. It does not predict admission odds, does not state any named college's deadline, fee, test policy, required forms or deposit as fact, does not subtract loans or work-study from net price, and stores no passwords. It stops at the deposit and does not budget a semester. Net price follows the federal definition at 20 U.S.C. §1015a. The figures shown are a worked sample, not a customer: Naomi Reyes is a fictional persona and the nine colleges are invented names. Every screen in the photos and the video is a render of the real recalculated file, not a mock-up. For personal use only. © 2026 NicheToolkitHub — no resale or redistribution.
