Medical school application tracker: what to track and why

Build a tracker that supports a decision

The point of an application tracker is to help you decide what to do next and verify what remains outstanding. A long sheet full of dates can still leave both questions unanswered.

Start with a manageable set of fields. Keep one row per school in a school summary, and separate rows for individual tasks when one application has several moving pieces. Give both the same school label so you can connect the work without copying a changing deadline into many places.

The downloadable CSV is a school-summary starter. It contains a clearly labeled fictional example and a blank row; replace the example before using it for your own cycle. It has no formulas, school database, automated reminders or verified deadline feed.

The fields worth keeping

Field	What to enter	Why it matters
School and program	The exact program you intend to apply to	Different programs can have different instructions
Application service	The service used by that program	Keeps separate systems identifiable
Official source URL	School instructions or the relevant official portal	Lets you verify the record
Checked date	When you last reviewed that source	Makes stale information visible
Deadline type and time zone	What must be submitted or received, and when	Prevents different deadlines being treated as one
Personal target	Your own planned completion date	Keeps your goal separate from a requirement
Current status	A precise statement of what you have completed or observed	Avoids an ambiguous “done”
Next action and estimate	One output, with a realistic time estimate	Connects the tracker to your day
Waiting on	The dependency and next follow-up	Separates action from waiting
Confirmation	Where you recorded submission or receipt	Supports a final check

A blank checked date means you have not recorded when the source was reviewed. A missing requirement is unknown, not evidence that the school has no requirement.

Keep primary and secondary dates separate

The AAMC’s AMCAS deadlines page describes regular MD program deadlines and directs applicants to verify current information. Do not assume that a date on that page is the deadline for every later component of a school’s application.

For osteopathic programs, AACOM’s application-process guidance points applicants toward application instructions and individual college information. Record the actual program’s requirements rather than copying a date from another school.

If a deadline is relative to an invitation, record the instruction and the invitation date. If you calculate a date from that information, note that it is your calculation and verify it when needed. Do not mark an uncertain calculation as an official school-published date.

Use statuses that describe evidence

Instead of one checkbox called “Complete,” use states that name what you know. Examples include “Draft saved,” “Submitted; confirmation recorded,” “Receipt not yet confirmed,” and “Needs verification.” These are suggested tracker labels, not universal portal statuses.

For letters, distinguish requesting a letter, the writer submitting it, and the school showing receipt. Do not assume that progress at one stage confirms another. Keep confidential letter content out of the tracker; you generally need the status and next action, not the letter itself.

Turn the school row into today’s task

A useful row might say: “Fictional Harbor program; secondary draft ready; next action: check the prompt and character limit in the portal; estimated time: 30 minutes.” That gives you something concrete to do without treating your spreadsheet as the authority on school rules.

At the start of a work session, review the nearest confirmed deadlines, then choose an unblocked action that fits your available time. At the end, update the status and record the next action while it is fresh. You can explore that process in the priority planner.

Keep the record private and maintainable

Use access-controlled storage, check sharing settings before sending a link, and avoid recording information you do not need. If an advisor needs one draft, that does not automatically mean they need your full school list, personal notes and costs.

Set a recurring review for the fields that change. Keep your original source links and confirmations available. The goal is a small record you can maintain reliably, not a large dashboard that looks complete while hiding uncertainty.