A recruiter calls on a Tuesday afternoon. "Hi, this is regarding your application for the backend role." You have applied to thirty-one backend roles in five weeks. You don't know which company this is, which resume you sent, or what you said your expected CTC was.
That call is the reason to track applications: so that when someone gets back to you, you can pick up the conversation in ten seconds and say the same things you said in the form.
The answer, in short: keep one list, one row per application, with about seven columns. Update it at the moment you apply, not at the end of the week. And record which version of your resume went where, because that is the detail you will need most and remember least.
The columns that earn their place
Most tracker templates online have twenty columns. Nobody fills in twenty columns for long. These are the ones that pay for themselves:
- Company and role. Exactly as the posting names it, because "SDE 2" and "Backend Engineer" at the same company can be two different openings.
- Link to the posting. Postings disappear once a role is filled. Save a copy of the job description too, if you can; you will want it before the interview.
- Date applied. Everything about follow-ups depends on this.
- Where you applied. Company careers page, LinkedIn, Naukri, Instahyre, Wellfound, a referral. It changes who you follow up with.
- Resume version. The file name or a short label. More on this below.
- What you told them. Expected CTC and notice period, as you entered them in the form.
- Status and next step. Applied, screening, interview, offer, rejected, gone quiet. Plus one line on what happens next and when.
Notes are optional. A contact name, if there is one, is worth adding.
You can skip the "excitement rating", the "culture fit score" and the colour coding. They feel productive on day one and go stale by day ten.
Why the resume version matters so much
If you tailor your resume for different roles (and you should, at least a little), you will soon have several versions. One leans on your API work, one on your data pipeline project, one is the general version you send to job boards.
When an interviewer says "walk me through the second bullet under your current role", you need to know what that second bullet says on the copy they have. It is a surprisingly bad moment to find out you sent the version that leads with the migration project you were planning to mention later.
Name your files so they explain themselves. Something like "Resume - Backend - Payments focus - Oct" beats "resume_final_v3_new". Then record that name in the tracker row.
If you're unsure how much tailoring is reasonable, our guide to tailoring your resume for each job covers it, including where the line is between rewording and making things up.
What you told them is the other trap
Application forms in India ask for current CTC, expected CTC and notice period constantly, and the forms all phrase it slightly differently. "Expected annual compensation" on one, "Expected CTC (LPA)" on another.
Say you put 18 LPA as expected on one form and 22 on another for a similar role, because you were feeling braver that evening. That's fine. But if the second company's recruiter calls and you quote 18, you've just negotiated against yourself before the first round. Write down the number you entered, every time.
The same goes for notice period. If you said "60 days, negotiable" on the form, don't say "90 days, fixed" on the call.
Spreadsheet, notes app or a tool?
Any of them works, as long as you actually use it. Honestly, the tool matters less than the habit.
A spreadsheet (Google Sheets, Excel) is the default for good reason. Free, sortable, filterable. Freeze the header row, add a filter on status, and sort by date applied. That's most of what you need.
A notes app or Notion board suits people who think in cards and like dragging them between columns. It gets slow past about fifty applications, in my experience, because you can't sort and filter as easily.
A dedicated tracker saves you the setup and some of the typing. The OpenRoles application tracker records which resume version you sent to each company alongside the usual status columns, which is the column people most often forget to fill in themselves.
What doesn't work: relying on your email inbox. Confirmation emails arrive from no-reply addresses with subject lines like "Thank you for your application", with no role named. Searching for them three weeks later is miserable.
Update it the moment you apply
This is the whole habit. Submit the form, fill in the row, then go to the next application. Thirty seconds.
If you batch it ("I'll update the tracker on Sunday"), you'll forget which resume went where by Sunday, and by the second Sunday you'll stop doing it. Everyone who has abandoned a tracker abandoned it this way.
When something changes (a recruiter emails, you get a test link, you get rejected), update the row the same day.
Use it to decide when to follow up
A tracker with dates is also a follow-up list. Once a week, sort by date applied and look at anything that has been sitting at "Applied" for a while.
For an application through a careers page or job board, there often isn't anyone to follow up with, and that's fine. Leave it. For a referral, a week or so of silence is a reasonable point to check in with the person who referred you. For a role where you've already spoken to a recruiter, follow up after the time they said they would get back to you.
We go into timing and wording in following up after applying. The short version: follow up where there is a person, be brief, and don't follow up on the same thing more than twice.
Use it to notice patterns
After a month, your tracker tells you things your memory won't. Look at it once with a cup of tea and ask:
- Which sources ever produced a reply? If referrals got you four calls and job boards got you none from fifty, spend your hours accordingly.
- Which resume version got callbacks? If the payments-focused one is doing better, it may be telling you which roles fit.
- Are you applying to roles a level too high, or too low, judging by who replies?
If the answer is that almost nothing is producing replies, that is useful information too, and usually points at the resume or at where you're applying rather than at bad luck. Applied everywhere and heard nothing back covers what to check.
Close rows out
Mark the rejections. Mark the ones that went quiet after six weeks as closed, so your active list stays readable. It is mildly depressing to do, and it is still better than a list of eighty rows where you can't tell what is live.
When you take an offer, keep the tracker anyway. The next job hunt will start from it, and you'll be glad to know which companies called you back last time.