Most candidates lose consulting offers to calendar math, not case math. They apply to twelve firms from memory, miss one office deadline by a day, and call it bad luck. The thesis is simple: recruiting is a pipeline with five stages, and if a firm row cannot name a next action with a date on it, you do not have a system. After this piece you will know the columns that matter, how to run a twenty-minute weekly ritual, how to log networking without turning it into a scrapbook, and where to open a board Ned built for this exact job.
Why spreadsheets fail consulting recruiting
A generic job tracker answers one question: did I apply. Consulting recruiting answers five. Are you still deciding. Is the portal submitted. Is a real round booked. Do you have written numbers. Is this cycle closed.
Firms do not run one shared calendar. McKinsey publishes school- and role-specific windows; as of the 2026 U.S. undergrad and non-MBA master's cycle, full-time Business Analyst applications opened around July with an August 11, 2026 deadline on McKinsey's campus pages, while Business Analyst Intern applications ran earlier with a March 29, 2026 deadline. Bain describes a process that can include application review, a recruiter conversation, digital assessment, and case interviews. BCG publishes an interview process that moves from application through skills and case work. None of that fits a two-column sheet labeled "Applied" and "Waiting."
The volume is the other reason the mood fails. At Harvard Business School, consulting still absorbed 21% of the Class of 2025 by function on HBS's employment data. When that many serious candidates chase the same portals, the people who keep a living pipeline simply make fewer avoidable mistakes. Yale's Office of Career Strategy puts the same idea in quieter language: track companies, deadlines, materials, expected responses, and networking contacts in one place. Consulting just needs stricter stages.
The five columns that actually work
Ned built a free public board at /resources/consulting-application-tracker. It runs in the browser with no account. Five stages only:
| Stage | What it means | What "next action" looks like |
|---|---|---|
| Interested | You might apply | Coffee chat booked, or a decide-by date |
| Applied | Portal submitted | Confirm test or first-round window |
| Interviewing | A real round is booked | Case or PEI prep for that format |
| Offer | Written numbers | Compare bands, ask recruiting clarifying questions |
| Rejected | This cycle is closed | One thank-you to the person who helped, then move on |
Do not invent a sixth column called Waiting. Waiting is Applied with a reminder date. Do not invent "Maybe later." Kill the card or give it a decide-by day.
On each card, store only what moves the row:
- Firm and office
- Role (intern, BA/AC, experienced hire)
- Deadline that actually binds you this week (application, assessment, or interview)
- One next action with a calendar day
- The person you talked to, if any
If you cannot name the next action, the card is decoration. After you sign in, the same idea lives next to your cases at /tracker. Use whichever you will open on Sunday. Consistency beats feature count.
A worked pipeline for one week
Here is a reproducible week for a candidate targeting three firms. Invented names, real logic.
Monday inventory (start of week):
| Firm | Stage | Binding date | Next action |
|---|---|---|---|
| Northbridge Strategy | Interested | Decide by Wed | Alumni call Tue 6pm; then apply or kill |
| Harbor Consulting | Applied | Assessment by Fri | Finish Harbor's online test Thu night |
| Redwood Partners | Interviewing | First round Mon | Two scored cases this weekend |
Sunday review, twenty minutes later:
| Firm | Move | Why |
|---|---|---|
| Northbridge | Kill to Rejected (self-cut) | Call revealed office focus you do not want |
| Harbor | Stay Applied | Test done; set reminder for recruiter reply +14 days |
| Redwood | Stay Interviewing | First round still Mon; add PEI story drill Wed |
That is the whole point of a tracker. Three decisions, not three feelings. If you run this every Sunday for eight weeks, you will have made roughly twenty-four explicit moves. Candidates who "keep it in their head" make maybe six, and two of those are panic submissions the night before a deadline.
Ned's rule. Every firm card needs one next action with a day attached. No day means the card is hope, and hope is how people double-apply to McKinsey while forgetting Bain.
Deadline hygiene that survives office variance
Deadlines move by office, school, and role. Screenshot calendars from last year are folklore. Confirm on the firm careers page or your career office note for your school, put the real date on the card, and set a reminder two days before, not the morning of.
A practical hygiene checklist:
- Source the date from the firm page or an official campus note, not a group chat.
- Write the date as YYYY-MM-DD so sorting works.
- Separate application deadline from assessment deadline from interview date. They are different binding events.
- When a recruiter emails a new window, edit the card the same day. Do not leave the old date sitting there as a trap.
- If two offices share a brand but different portals, they are two cards.
For planning across a season, pair this board with a verified deadline system such as the consulting application deadlines 2026 guide. The board holds your live state; the deadline guide holds the external calendar you checked against.
How to log networking without drowning in notes
Networking belongs on the firm card, not in a separate novel. When you talk to someone, capture four fields and stop:
| Field | Example |
|---|---|
| Who | Jordan Lee, Harbor Chicago, alum of your school |
| Date | 2026-09-16 |
| One insight | Office values clear client-facing examples over industry jargon |
| Follow-up | Thank-you sent; reconnect after application with one sentence on the test |
Referral conversations get one extra flag: asked / not asked / referred. Do not escalate every coffee into a referral ask. Bain and peers still hire plenty of people who networked cleanly and applied on time without a warm intro. Track referral status so you do not ask twice, and so you know whom to thank if an interview lands.
A weekly cap helps. Send at most three follow-ups in the Sunday ritual. More than that usually means you are avoiding case work. For message templates that stay short, use CoachNed's networking follow-up kit from the free tools hub when you need wording, not another system.
What changes when a card hits Interviewing
Applied is document work. Interviewing is format-specific practice. The moment a round is booked, the next action stops being "wait for email" and becomes "prep for that assessment or that interview type."
Examples:
- BCG live case week is not the week to invent a new resume version.
- A PEI-heavy McKinsey first round needs story depth, not another market-sizing drill.
- Bain digital assessment week needs the assessment, then a scored case for the live round that follows.
When the card moves to Interviewing, put this week's practice on the card itself. "Two structure drills + one full case before Thursday" beats "prep more." CoachNed's open practice paths fit that discipline: everything is open for seven days with no card, then $120 for a recruiting season or $49 a month. Start with a five-minute first rep at /start, or jump into a live voice case at /interview when you want a full debrief.
Offer and Rejected need less drama than people give them. Offer means read the written numbers and ask recruiting clarifying questions before you negotiate in your head. Rejected means one note to the person who helped, then the next firm. Leave the card in Rejected so you do not re-apply by accident next month.
Run this tonight: twenty-minute board setup
Open the free board at /resources/consulting-application-tracker. Create cards for every firm you are honestly considering this cycle. Cap Interested at eight. For each card, fill firm, office, role, binding date, and one next action with a day. Kill two Interested cards before you finish. If nothing moves on Sunday, the board failed; if two cards move and one follow-up goes out, the board worked.
Then schedule the weekly ritual for the same twenty minutes every Sunday:
- Move anything that changed stage.
- Kill two Interested cards you will not apply to.
- Put this week's cases on every Interviewing card, format-specific.
- Send at most three networking follow-ups.
That is the system. Columns, ritual, deadline hygiene, networking logs. Ned built the board so you would stop improvising the pipeline under pressure.
CoachNed is not affiliated with McKinsey, BCG, Bain, Deloitte, or any firm named above.
Frequently asked questions
What should a consulting application tracker include?
Five stages (Interested, Applied, Interviewing, Offer, Rejected), firm and office, role, the binding deadline for this week, one next action with a date, and the contact you talked to if any. Extra tabs for resume versions and cover letters help only if they change the next action.
Is there a free consulting application tracker I can use without signing up?
Yes. CoachNed's public board at /resources/consulting-application-tracker runs in the browser with no account. If you want the same pipeline next to your cases after you sign in, use /tracker.
How often should I update my consulting application tracker?
Once a week on a fixed slot, plus the same day whenever a recruiter changes a date or books a round. Daily tinkering is usually avoidance; weekly ritual with dated next actions is how pipelines stay honest.
How do I track networking and referrals in the same system?
Put the contact on the firm card: who, date, one insight, follow-up date, and referral status (asked / not asked / referred). Do not maintain a separate contact novel that never changes the application row.
When should I move a firm from Applied to Interviewing?
Applied is document work. Interviewing is format-specific practice. The moment a round is booked, the next action stops being "wait for email" and becomes "prep for that assessment or that interview type."
When a real assessment or interview is booked on the calendar. An automated "application received" email is still Applied. A Casey invite, SOVA window, or first-round slot is Interviewing, and it should trigger format-specific prep that week.?
Applied is document work. Interviewing is format-specific practice. The moment a round is booked, the next action stops being "wait for email" and becomes "prep for that assessment or that interview type."
Sources
- McKinsey US undergraduate and master's campus career pages — 2026 Business Analyst Intern (March 29, 2026) and full-time Business Analyst (August 11, 2026) application windows as published for campus recruiting. Checked 2026-09-24.
- Bain hiring process overview — official description of application review, recruiter contact, interviews, and case interviews for consulting roles. Checked 2026-09-24.
- BCG consulting interview process — firm-published stages from application through skills and case interviews. Checked 2026-09-24.
- HBS employment data: Consulting function — Class of 2025 consulting function share (21%) and related compensation figures. Checked 2026-09-24.
- Yale OCS Job Search Tracking Tool — institutional guidance to track applications, deadlines, materials, and networking contacts together. Checked 2026-09-24.