Job Application and OA Tracker Template 2027: Deadlines, Scores, and Follow-Ups

A useful job application tracker should answer three questions in seconds: What is due next? What happened in the last stage? What action will I take now? For internship and new-grad recruiting, that requires more than company, role, and status. You also need the assessment invitation time, deadline exactly as shown, time zone, normalized local deadline, platform, duration, score, verification state, interview date, and a dated follow-up.

This template works in Excel or Google Sheets. It is designed for candidates managing multiple applications and online assessments without turning every portal update into a separate note.

Job application and OA tracker at a glance

Use one row per role, even when several roles belong to the same company. A single row should preserve the history of that application instead of being overwritten whenever the status changes.

Section	Essential fields	Why it matters
Role identity	Company, role, location, job URL, application date	Prevents similarly named positions from becoming mixed together
Application context	Priority, resume version, referral or contact	Shows what you submitted and who may know the application
OA logistics	Platform, invite received, deadline as shown, time zone, normalized deadline, duration	Protects against missed deadlines and time-zone mistakes
OA result	Assessment status, raw score, score scale or verification	Separates completion from interpretation
Next step	Application status, next action, follow-up date, interview date	Turns passive waiting into a controlled workflow
Notes	Technical issue, recruiter instruction, exception, or decision	Preserves only the context needed to act correctly

The accompanying workbook has four sheets: Applications, Dashboard, Lists, and Read Me. The main table includes 100 editable rows, status dropdowns, formula-driven deadline and follow-up flags, and a dashboard for personal pipeline metrics.

Copy the core tracker columns

If you prefer to build the tracker yourself, paste this header row into a blank sheet. Keep the column names stable so formulas, filters, and dashboard metrics remain predictable.

Priority | Company | Role | Location | Job URL | Application Date | Resume Version | Referral / Contact | Application Status | OA Platform | OA Invite Received | Deadline as Shown | Deadline Time Zone | Normalized Deadline (Local) | Duration (Min) | OA Status | Score | Score Scale / Verification | Next Action | Follow-Up Date | Days to Deadline | Follow-Up Flag | Interview Date | Notes

Do not combine Deadline as Shown, Deadline Time Zone, and Normalized Deadline (Local) into one field. They serve different purposes:

• Deadline as Shown is the audit trail. Paste the wording from the invitation, such as September 8 at 11:59 PM ET.
• Deadline Time Zone removes ambiguity. Use an explicit label such as America/New_York (ET) when possible.
• Normalized Deadline (Local) is a real spreadsheet date and time converted to the zone in which you plan your work.

This three-field method helps when an email, portal, and calendar appear to disagree. It also makes a later correction traceable. Never let a conversion replace the original wording.

Set up controlled status dropdowns

Free-form statuses create reporting noise. OA complete, Completed OA, and Finished assessment may mean the same thing to you, but formulas treat them as different values.

Use a small controlled list for application status:

Researching
Ready to Apply
Applied
OA
Recruiter Screen
Technical Screen
Interview
Final Round
Offer
Rejected
Withdrawn

Use a separate list for assessment status:

Not Received
Invited
Scheduled
In Progress
Completed
Expired
Technical Issue
Withdrawn

Google Sheets supports in-cell dropdowns and dropdown chips. Excel data validation can enforce the same categories. Keep employer portal wording in Notes when it matters, but map the row to one consistent internal status for filtering.

Build deadline and follow-up reminders

Assume the headers are in row 1 and the first application is in row 2. If the normalized deadline is in column N, use this formula in Days to Deadline:

=IF(N2="","",N2-NOW())

Format the result as a number with one decimal place. A value of 1.5 means roughly 36 hours remain. NOW() is appropriate because OA deadlines often include a specific hour. By contrast, Google documents TODAY() as returning the current date without a time component, which is useful for day-level follow-up reminders.

If the follow-up date is in column T and application status is in column I, use:

=IF(OR(T2="",I2="Rejected",I2="Withdrawn",I2="Offer"),"",IF(T2<TODAY(),"OVERDUE",IF(T2=TODAY(),"DUE TODAY","UPCOMING")))

Then add conditional formatting:

• Red fill when Days to Deadline is below zero.
• Amber fill when the deadline is between zero and two days away.
• Red fill for OVERDUE follow-ups.
• Amber fill for DUE TODAY.
• Green fill for an Offer; muted gray for Rejected.

Microsoft and Google both support formula-driven conditional formatting. Test the rules with one fictional row before trusting them, then verify the workbook and computer time zones.

Record scores without creating false comparisons

The number alone is not enough. Store the raw value in Score, then use Score Scale / Verification for context, such as:

600-point scale; verified
Percentage score; employer-specific test
All visible tests passed; hidden-test result unavailable
Completed; no score released

Do not compare a CodeSignal score, a HackerRank test-case result, and a company-specific percentage as if they share one scale. Even within one provider, an employer may apply its own review process. The tracker should preserve evidence, not invent a universal cutoff.

For the same reason, separate Completed from Verified. A candidate can finish an assessment while identity verification, result processing, or recruiter review remains pending.

Give every active row one next action

An application becomes difficult to manage when the row says only waiting. Replace that state with a concrete action and a date.

Good next actions are observable:

• Confirm assessment system requirements.
• Complete the OA before the personal buffer deadline.
• Send availability to the recruiter.
• Follow up after the stated review window.
• Prepare two project stories for the technical screen.
• Close the row if the role is no longer active.

Set the follow-up date based on employer communication when available. If a recruiter says decisions take two weeks, use that information. If no timeline is provided, choose a reasonable personal review date and label it as your reminder, not a promised company response date.

After an OA, update four fields immediately: OA Status, Score, Score Scale / Verification, and Next Action. If a technical problem occurred, record the time, error, screenshots retained, support ticket, and recruiter contact in concise terms. Avoid storing confidential assessment content.

Use a dashboard without overreading it

A personal dashboard is useful for workflow health, not for estimating the hiring market. Start with these metrics:

Metric	Definition	Useful question
Total applications	Roles with a company value	Is the search active enough for the target timeline?
OA invites	Rows with invited, scheduled, in-progress, or completed OA status	Are applications producing assessments?
OA completed	Rows marked completed	Is assessment workload accumulating?
Interviews	Rows with an interview date or interview-stage status	Which roles now need deeper preparation?
Follow-ups due	Overdue plus due-today reminders	What communication must happen now?
OA-to-interview conversion	Interview rows divided by OA-invite rows	Is the current preparation and role selection producing next rounds?

Interpret conversion rates only after enough rows exist and the statuses are complete. A small sample can swing dramatically after one update. Results also reflect role fit, resume screening, hiring capacity, location, and timing, not only coding performance.

When comparing resume versions, avoid changing several variables at once. A backend resume sent to infrastructure roles and a general resume sent to product roles do not create a clean experiment. Use the tracker to form questions, then inspect the underlying applications before drawing conclusions.

A twice-daily review routine

Review the tracker once near the start of the day and once before ending work.

1. Sort by Days to Deadline and verify anything due within 48 hours.
2. Filter Follow-Up Flag for OVERDUE and DUE TODAY.
3. Check Invited, Scheduled, and In Progress assessments.
4. Record completed assessments and any released score or verification state.
5. Add newly scheduled interviews and one preparation focus.
6. Mark closed roles as rejected or withdrawn instead of deleting them.

Use a personal buffer deadline earlier than the employer deadline, but keep the employer deadline in the normalized field. Your action might read Take OA by Saturday 2 PM, while the authoritative deadline remains Sunday 11:59 PM PT.

Keep the tracker accurate and private

A tracker can contain job URLs, recruiter names, email addresses, interview dates, and performance notes. Store only what helps you act. Do not enter passwords, government identifiers, private assessment questions, confidential company material, or unnecessary personal information about interviewers.

If the sheet is shared, remove contact details and private notes first. Protect formula and list ranges from accidental edits. In Excel, a table's calculated columns and structured references can expand with new rows. In Google Sheets, dropdowns and conditional formatting can be applied to a bounded future range.

Back up the workbook periodically, especially during a high-volume recruiting week. A CSV export preserves values but may not preserve validation, formulas, formatting, or multiple sheets, so keep the native workbook as the primary file.

Frequently asked questions

What should I include in a job application tracker?

At minimum, track company, role, job URL, application date, current status, next action, and follow-up date. For OA-heavy recruiting, add the platform, invitation time, deadline exactly as shown, explicit time zone, normalized local deadline, duration, completion state, score, and score context.

How should I track an OA deadline in another time zone?

Preserve the deadline exactly as written, store the stated time zone separately, and convert it into a real local spreadsheet date and time. Confirm the conversion against the invitation or portal. Set a personal buffer deadline, but never replace the employer's original deadline with the buffer.

Should I record online assessment scores?

Yes, when a result is available, but store the score together with its scale and verification state. Do not compare scores across different platforms or employer-specific assessments without evidence that the scales and review processes are equivalent.

When should I follow up after an OA?

Use the employer's stated timeline first. If no timeline is given, set a personal reminder rather than assuming a company deadline. The follow-up should be brief, identify the role and assessment completion date, and ask whether any additional information is needed.

Is Excel or Google Sheets better for an application tracker?

Both work. Google Sheets is convenient for cross-device access and simple sharing. Excel tables, structured references, and calculated columns are useful for a durable local workbook. Choose the option you will update consistently, then verify its time-zone and recalculation behavior.

Final takeaway: a strong tracker preserves the employer's exact deadline, creates a normalized local deadline for action, records scores with context, and gives every active application one dated next step. The spreadsheet is successful when it tells you what to do next without asking you to remember what happened last week.

Sources and Further Reading

• Google Sheets: TODAY function
• Google Sheets: Create an in-cell dropdown list
• Google Sheets: Add and edit a dropdown
• Google Sheets: Use conditional formatting rules
• Microsoft Excel: Using structured references with Excel tables
• Microsoft Excel: Use calculated columns in a table
• Microsoft Excel: Use conditional formatting to highlight information

Employer deadlines, assessment platforms, scoring, and follow-up timelines vary by role and recruiting cycle, so the invitation and recruiter communication remain authoritative.*