How to Keep Track of Job Applications
Applications rarely fall apart for lack of effort. They fall apart on dates: a test link that expired, a closing date that passed, a recruiter calling about a role you cannot place. A plain record, updated the same day, prevents all three.
With two or three applications open, memory copes. Past that, each employer sits at a different stage with its own deadlines, and invitations arrive by email with a window to complete them in. Online tests, recorded video interviews and assessment centre dates all land at different times, often from different senders, and one missed email can end an application that was going well.
A good record answers three questions at a glance: what is due next, where you stand with each employer, and what you need to prepare for the next stage. It does not need to be clever. It needs to be the one place everything goes, updated as things happen rather than pieced together at the end of the week.
Below is what to record for each application, a spreadsheet layout you can copy into Excel or Google Sheets, the habits that keep it accurate, when to follow up, an honest comparison of a spreadsheet with a dedicated tracker, and how the free CogniPrep application tracker handles the same job.
What to record for every application
Nine things, most of which take seconds to note on the day and a long time to find again later. The dates and the provider matter most, because they decide what you prepare and when.
Employer and role
The company and the exact job title from the advert, plus the team, location or reference number. Large employers often run several similar vacancies at once, and a recruiter will expect you to know which one you applied for.
The advert itself
Save the link, and paste the full description somewhere as well. Adverts tend to disappear once a vacancy closes, which is exactly when you need them: the night before an interview, to remind yourself what they asked for.
Date applied and what you sent
The submission date, and which version of your CV or resume and cover letter went with it. If you tailor documents for each role, the file name is enough to find the right one later.
Current stage
Researching, applied, online tests, video interview, assessment centre or final interview. One word is enough, because its job is to tell you what to prepare for next.
Every deadline and appointment
The closing date, the test deadline, the video interview due date, the assessment centre day and any interview, each with its time and time zone. A deadline written down without a time is a guess.
The assessment provider
Online test invitations usually name the platform, either in the email or in the link. Note it the day it arrives: practising the right format is the most useful preparation you can do before a test.
Contacts
The recruiter or hiring manager’s name and email, and anyone you met at a careers fair or spoke to on a call. Add when you last heard from each of them.
Notes after each stage
The questions you were asked, what went well, what you would change, and anything said about next steps or timing. Written the same day, these become the best material you have for the next round.
Outcome
Offer, unsuccessful, withdrawn or still in progress, with the date and any feedback. Closed rows are worth keeping, because together they show where in the process your applications tend to stop.
Not sure which platform an invitation is for? See which assessment provider am I taking, or look the employer up in the employer guides before the invitation arrives.
A spreadsheet layout you can copy
One row per application, one column per fact. Copy these headings into Excel, Google Sheets or Numbers, set up the two dropdowns, and the template is done.
| Column | What goes in it | Format |
|---|---|---|
| Employer | Company name, plus the division or brand if it belongs to a larger group. | Format: Text |
| Role | The exact job title from the advert, with the location, team or reference number. | Format: Text |
| Advert link | The URL of the advert. Paste the full description into a second tab or a document too. | Format: Link |
| Date applied | The day you submitted. Leave it blank while you are still researching. | Format: Date |
| Documents sent | File names of the CV or resume and the cover letter you used. | Format: Text |
| Stage | Where you are now in this employer’s process. | Format: Dropdown: Researching, Applied, Online tests, Video interview, Assessment centre, Final interview |
| Next date | The next deadline or appointment, with its time. | Format: Date and time |
| Next date is for | Closing date, online tests due, video interview due, assessment centre or interview. | Format: Dropdown |
| Time zone | The time zone the invitation uses, when it is not your own. | Format: Text |
| Assessment provider | The test platform named in the invitation email or link. | Format: Text |
| Contact | Recruiter or hiring manager, with an email address. | Format: Text |
| Last contact | The last time you heard from them or wrote to them. | Format: Date |
| Follow up on | When you will chase if nothing has arrived by then. | Format: Date |
| Notes | Questions asked, how each stage went, what to change next time. | Format: Long text |
| Outcome | Whether it is still open, and how it ended. | Format: Dropdown: In progress, Offer, Unsuccessful, Withdrawn |
Three settings make the sheet far easier to live with. Freeze the header row so the column names stay visible. Filter Outcome to In progress and sort by Next date, so the top row is always the most urgent. And add a colour rule to Next date for anything in the coming week. One limit to plan around: a row has room for one next date, while a live application can have several. Either overwrite Next date as each one passes, or keep every date in a second tab with Employer, What, Date and Time zone columns.
Five habits that keep it accurate
A tracker is only as good as its last update. These five habits take a few minutes each and are the difference between a record you trust and one you have to double-check.
- 1
Log it the same day you apply
Do it before you close the tab. The advert link, the version of your documents and the closing date are all in front of you at that moment, and none of them is easy to recover a month later.
- 2
Record dates the moment an invitation arrives
Test and video interview invitations usually carry a deadline. Copy the date, the time, the time zone and the provider into your record as soon as you read the email, then decide when you will do it. An invitation left sitting in an inbox is how deadlines get missed.
- 3
Write notes straight after each stage
Within a few hours of an interview or assessment day, while the questions are still fresh. They feed the next round with the same employer and the first round with the next one.
- 4
Review everything once a week
Pick a fixed slot. Sort by next date, look at what falls in the coming fortnight, plan practice for it, chase anything past its follow-up date and close the applications that are over.
- 5
Close what has finished
Mark the outcome as soon as you know it, withdrawals included. A short active list is one you will actually read, and the closed rows keep the history.
When and how to follow up
A follow-up should be easy to answer: short, specific about which role, and asking one question. Timing depends on what the employer has already told you.
After you apply
If the advert or the confirmation email says when you will hear, wait until that point has passed. If it says nothing, a common rule of thumb is a week or two before a polite check-in. Look at the employer’s careers portal first: many show a status, and confirmation emails often come from addresses nobody reads.
After an interview
A short thank-you email the same or the next day is a common courtesy in the US, and elsewhere it rarely does any harm. Keep it to a few lines: thanks, one specific point from the conversation, and that you remain interested.
When the date they gave has passed
Send one polite email to your contact, naming the role and when you applied or interviewed, and ask whether there is an update on timing. A second chase a week or so later is the limit. After that, treat silence as an answer and spend the energy on live applications.
When another offer forces the timing
Tell the employers you are still waiting on, say when you need to decide, and ask whether they can give you an answer by then. It is a normal request, and the worst outcome is that they say they cannot.
When the process is high volume
Graduate schemes, internships and other programmes with large applicant numbers usually run on portals and automated emails rather than individual replies. Chasing a recruiter there tends to achieve little, and the FAQs on the careers site often answer the timing question already.
Every time, update the record
Change Last contact and Follow up on whenever you write or hear back. It stops you chasing twice in one week, and it shows at a glance who owes whom a reply.
A follow-up that is easy to answer
Subject: Graduate Analyst application, reference 4417
Hello Sam,
I applied for the Graduate Analyst role earlier this month and wanted to ask whether there is an update on timing for the next stage.
I’m still very keen on the role, and happy to send anything else that would help.
Thanks,
Alex
Spreadsheet or dedicated tracker?
A spreadsheet is a perfectly good tracker, and nobody needs to pay for one. The honest question is whether you need the two things it cannot do: remind you, and tell you what to practise.
What a spreadsheet does well
It is free, it works in Excel, Google Sheets or Numbers, and it holds anything you care to add a column for. You own it, you can share it with a careers adviser or a mentor, and you can start in five minutes. For many job searches it is all you need.
What a spreadsheet cannot do
It cannot remind you. A date in a cell does nothing until you open the file, which is the exact failure a tracker exists to prevent. It also knows nothing about the stages themselves, so it cannot tell you what a given employer’s online tests involve or what to practise before an assessment centre.
When a spreadsheet is enough
A handful of applications, mostly interviews arranged directly with a recruiter, where dates arrive by phone or as calendar invitations and there is little to practise in between. Plenty of experienced-hire searches look like this.
When a dedicated tracker earns its place
Many applications open at once, each with tests, recorded interviews and assessment days on deadlines set by email. Graduate, internship and apprenticeship seasons look like this, and it is where reminders and a prep plan per application save the most.
A middle way is to keep the spreadsheet and add every date to your phone calendar with an alert. That closes the reminder gap without new software. It does not help with preparation, and it depends on you copying each date across correctly by hand.
How the CogniPrep tracker works
It lives in your CogniPrep dashboard under Applications, and it is built around the problem this guide started with: dates slipping past while you prepare for the wrong thing.
Four steps to add an application
Pick the company from a directory of employers or type any name, choose the role, say where you are up to, and add a date if you have one. The date is optional, so you can log an employer while you are still researching it.
Six stages, four outcomes
Researching, Applied, Online tests, Video interview, Assessment centre and Final interview, shown in the typical order. Not every employer uses all six, so you move straight to the one you are at. Each application is In progress, Offer, Unsuccessful or Withdrawn; a closed one stays as a record, but its dates leave your calendar and stop sending reminders.
Every date in the process
Application deadline, Online tests due, Video interview due, Assessment centre and Final interview, or any other date under a name you choose. Times are optional and time zone aware, and each application holds up to 12 dates.
Two reminder emails per date
One three days before and one the day before. A date added at short notice skips straight to the final reminder. Both are sent during the day in the date’s own time zone, never overnight.
In your calendar
Connect Google Calendar directly, or subscribe from Apple Calendar or Outlook to a private feed with one tap. Any other calendar app can use the private feed URL. Deadlines show as free time, while assessment centre and final interview days block time as busy.
A prep plan for the next stage
For online tests, it lists practice for the assessment providers that employer is known to use, drawn from CogniPrep’s sourced employer directory, or for the provider your invitation names if you tell it. Video and final interview stages get a practice video interview, and the assessment centre stage gets all six exercise formats. While you are researching or have just applied, the plan looks ahead to the tests.
Progress you cannot fake
Set a deadline and the unfinished tasks are laid out one a day up to it. A task ticks itself off when you actually complete that practice; nothing is ticked by hand. Each stage also links the relevant guides, plus the employer’s guide page where one exists.
What it costs, and what it keeps
The tracker is free with a free CogniPrep account and has no paywall of its own. Some practice it points you to, such as paid provider games, interview access or the full assessment centre library, needs a one-time unlock. You can run up to 40 active applications, and each is deleted two years after it was last changed.
What it does not hold is free text: there is no field for notes, contact names or the advert link. Keep those in a short document or a few spreadsheet columns alongside, and let the tracker handle the dates, the reminders and the practice. For what each stage involves, read the job application process, stage by stage.
Let the dates come to you
Add each application in four short steps, get reminder emails before every deadline and test date, and see what to practise for the next stage. Free with a CogniPrep account.
Frequently asked questions
What is the best way to keep track of job applications?
One list, kept in one place and updated the same day something happens. The tool matters less than the habit: a spreadsheet updated daily beats an app opened once a month. What a list cannot do on its own is warn you before a deadline, so pair it with calendar alerts or a tracker that sends reminders.
What should a job application tracker include?
At minimum: employer, role, a link to the advert, date applied, current stage, every deadline and appointment with its time, the assessment provider if there are online tests, a contact, notes after each stage and the outcome. The table above turns that list into columns.
Is there a free job application tracker template?
Copy the columns from the table above into a blank sheet in Excel or Google Sheets and set up the two dropdowns; that is the whole template. If you would rather have reminders and a prep plan, the CogniPrep application tracker is free with a free account.
Do I still need my own list if I apply through job boards?
Usually, yes. Sites such as LinkedIn and Indeed keep a list of jobs you applied for through them, and each employer’s careers portal shows its own status, but none of them sees the others, and none holds the test deadlines that arrive later by email. Your own list is the only place they all meet.
Should I keep a record of rejections?
Yes. Mark the outcome and keep the row. Over a few months the closed rows show where your applications tend to stop: mostly at the online tests suggests practising the formats, mostly after interviews suggests rehearsing answers out loud. Some employers also limit how soon you can reapply, which is worth noting against the row.
How do I avoid missing an online test deadline?
Write the deadline, time and time zone into your record the moment the invitation arrives, set an alert a couple of days before it, and decide there and then when you will sit the test. Leave room for technical problems rather than starting in the final hour.
Can I use the CogniPrep tracker alongside a spreadsheet?
That works well, because the tracker holds stages, dates and practice rather than free-text notes. Let it handle the reminders, the calendar and the prep plan, and keep notes, contacts and saved adverts wherever you already write things down.
Use this next
The application tracker
Every application’s stage and dates in one place, with reminder emails and a prep plan for the next stage.
Which assessment provider am I taking?
How to tell from the invitation which test platform you are about to sit.
Employer guides
Which assessments individual employers are known to use, and how to prepare for them.
The week before your assessment
What to do with the days between an invitation and the test itself.