Listen to this article
You've applied to fourteen roles in the last three weeks. Three of them you can't quite remember if you tailored the CV for. One recruiter asked you to follow up "next week" and you can't remember which week that was. Somewhere in your inbox is an interview invite you might have missed under a promotional email. This is what happens when you try to track job applications from memory and a scatter of email threads — it doesn't fail because you're disorganized, it fails because no one can hold fourteen parallel timelines in their head while also writing cover letters. The fix isn't willpower. It's one place that holds the facts so your head doesn't have to.
Why Your Applications Start Blurring Together
At one or two applications a week, memory works fine. Past five or six live at once — each at a different stage, each with its own next step and its own silence to interpret — the mental load stops being about remembering and starts being about reconstructing. You open your sent folder and try to piece together what happened, which is slower and less reliable than just having written it down the first time.
The cost shows up in specific, avoidable ways: missing a follow-up window because you forgot you were waiting, reapplying to a company that already rejected you, or worse, mixing up which version of your CV a company received. If you're not sure how much you actually tailored each application, how much to tailor your CV for each application is worth reading alongside this — tailoring and tracking solve different halves of the same problem: sending the right thing, and knowing what you sent.
What a Job Application Tracker Actually Needs to Capture
A good job application status tracker doesn't need to be elaborate. It needs six fields, consistently filled in:
- Company and role — exact title, because "Marketing Manager" at three different companies looks identical a week later.
- Date applied — the anchor for every deadline and follow-up decision that comes after.
- Source — where you found it, so you can go back to postings that keep producing results.
- Status — Applied, Screening, Interviewing, Offer, Rejected, Withdrawn. Six labels cover almost everything.
- Next action and date — the single most useful field in the whole sheet. "Follow up if no reply by [date]" turns a vague intention into something you'll actually do.
- Notes — who you spoke to, what was asked, anything you'd want to remember before a second interview.
Skip fields you won't maintain. A tracker with thirty columns for salary bands, referral sources, and culture notes looks thorough on day one and empty by day ten, because filling it in becomes its own chore. The reader losing track of things doesn't need more fields — they need the six that matter, filled in every time.
Build Your Own Job Search Spreadsheet in 10 Minutes
If you're starting from nothing, a spreadsheet is the fastest way to get organized this afternoon. Open Google Sheets or Excel, put the six fields above across the top row as headers, and add one row per application. Use data validation on the status column so you're picking from a fixed dropdown list rather than typing "interviewing" one week and "interview stage" the next — small inconsistencies like that make the sheet harder to scan later.
Sort by next-action date, not by when you applied. The question you actually need answered every morning isn't "what did I do three weeks ago" — it's "what needs to happen today." A sheet sorted by application date buries that answer under everything else.
Colour-code status if it helps you scan faster — green for interviewing, grey for rejected, yellow for awaiting reply — but treat colour as a bonus, not a replacement for the status column itself. Colour doesn't export, doesn't filter reliably, and disappears the moment you copy the sheet somewhere else.
The Status Column: Keeping It Honest
The status column is only useful if it's current, which means updating it the moment something happens rather than batching updates for "later." Later is a myth in an active job search — there's always another application to write, another posting to check, another version of the CV to adjust. The habit that actually survives is: apply, immediately log it; hear back, immediately update it. Ten seconds now instead of an hour of reconstruction later.
Watch for the trap of leaving applications in "Applied" indefinitely. If three weeks have passed with no reply, that's not still "Applied" — it's effectively a soft no, and treating it that way frees up mental space to focus on roles that are actually moving. If you're unsure whether it's time to nudge a company for a response, when and how to follow up on a job application covers the timing and the wording. And if a posting has been sitting untouched for weeks with no real hiring activity behind it, it might be worth checking whether it's a ghost job posting before you invest more effort chasing it.
Where a DIY Spreadsheet Starts Working Against You
A spreadsheet has no memory of its own — it only knows what you type into it, and only when you remember to open it. At low volume that's a minor inconvenience. Once you're managing more than a dozen live applications across different stages, the gaps start to cost you: a follow-up date that quietly passes because nothing nudged you, a status that's three days stale because you were mid-interview-prep and didn't get back to the sheet, a second tab you started for "roles I'm still deciding whether to apply to" that never gets reconciled with the main one.
None of this is because you're bad at spreadsheets. It's because a spreadsheet is a passive record, and an active job search needs something that reminds you, not just something that remembers for you when asked.
A Tracker Built for This, Not Repurposed for It
Every job search guide — including this one, until now — points you toward a template you build yourself. That's genuinely fine to start with, and the spreadsheet above will get you organized today. But Kaeros can also point you to something the generic templates can't: the Application Tracker, powered by Erioun, offered to Kaeros customers as a purpose-built alternative to stretching a spreadsheet to do a job it wasn't designed for. It's the tracking side of the job search, built as its own product rather than a sheet with more tabs added over time.
If you're already working with Kaeros on your CV — or considering it — pairing a real tracking system with a CV that's actually been reviewed by a human closes both gaps at once: what you're sending, and where it stands. If you haven't had your CV looked at yet, a free CV review is a real person telling you what's working and what isn't, before you send out application fifteen.
A Five-Minute Weekly Habit That Keeps the System Alive
Whichever tool you use, the system only holds up with a short weekly check-in. Once a week, look at every row and ask three questions: is the status still accurate, is there a next action with a real date attached, and is anything overdue for a follow-up. That's it — five minutes, not an audit.
The goal was never a perfect spreadsheet or a beautifully designed tracker. It's knowing, at a glance, exactly where every application actually stands — so the next thing you do with your job search is a deliberate choice, not a scramble to remember what you already did.