Recruitment Tracker

Manage open roles and every applicant against them — source, stage, interviews, ratings and expected pay — with a live hiring funnel.

A recruitment tracker template is a ready-made database that lists your open roles and every candidate who applies for them, with their source, stage, interviews, ratings and salary expectations, so the whole hiring pipeline can be managed and measured in one place.

Sign in with your Edesy account, then click Use template in the preview to copy the base, with its sample rows, into your workspace.

Category

Human Resources

Tables

Openings, Candidates

Fields

30

Views

grid, kanban, calendar, form, dashboard

Updated

2026-11-19

Tables, columns and sample rows

The 2 linked tables in this template, with their real columns, field types and sample rows. Copy the template to edit them in Edesy Tables.

Openings

12 fields · 3 sample rows

  • Openings (Grid)
  • By status (Kanban)
RoleTextDepartmentSingle selectLocationSingle selectHiring managerTextPositionsNumberStatusSingle selectBudget (CTC)CurrencyOpened onDateCandidatesLink to another tableApplicantsCountHiredRollupDays openFormula
Senior Frontend EngineerEngineeringBengaluruVikram Rao2Open₹35,00,00015 Oct 2026Karthik Subramanian, Emily Watson, Aarav Jain3135
Account ExecutiveSalesMumbaiNeha Kapoor1Open₹22,00,00030 Oct 2026Fatima Sheikh, Noah Williams2020
Product DesignerMarketingRemote – IndiaLucas Fernandes1On hold₹20,00,00030 Sep 2026Ritika Bose1050
Field details
Role · Text
Department · Single select
Engineering, Sales, Marketing, Operations, Finance, People, Support
Location · Single select
Bengaluru, Mumbai, Remote – India, London
Hiring manager · Text
Positions · Number
Status · Single select
Open, On hold, Filled, Closed
Budget (CTC) · Currency
INR
Opened on · Date
Candidates · Link to another table
Links to Candidates
Applicants · Count
Hired · Rollup
sum of Hired (0/1) via Candidates
Days open · Formula
IF({Opened on}, DATETIME_DIFF(TODAY(), {Opened on}, 'days'), BLANK())

Candidates

18 fields · 6 sample rows

  • All candidates (Grid)
  • Pipeline (Kanban)
  • Interviews (Calendar)
  • Apply (Form)
  • Funnel (Dashboard)
CandidateTextOpeningLink to another tableEmailEmailPhonePhoneLinkedInURLResumeAttachmentSourceSingle selectApplied onDateStageSingle selectNext interviewDateRatingRatingCurrent CTCCurrencyExpected CTCCurrencyNotice period (days)NumberRecruiterTextHired (0/1)FormulaExpected hikeFormulaNotesLong text
Karthik SubramanianSenior Frontend Engineer[email protected]+91 98400 12121LinkedIn25 Oct 2026Final round21 Nov 20264/5₹28,00,000₹34,00,00060Pooja Shetty021%
Emily WatsonSenior Frontend Engineer[email protected]Careers page1 Nov 2026Interview20 Nov 20263/5₹30,00,000₹36,00,00030Pooja Shetty020%
Aarav JainSenior Frontend Engineer[email protected]Referral20 Oct 2026Hired5/5₹26,00,000₹32,00,00030Pooja Shetty123%
Fatima SheikhAccount Executive[email protected]+91 99200 34343Naukri9 Nov 2026Screening₹15,00,000₹20,00,00090Sana Mirza033%
Noah WilliamsAccount Executive[email protected]Agency4 Nov 2026Offer4/5₹18,00,000₹22,00,00030Sana Mirza022%
Ritika BoseProduct Designer[email protected]LinkedIn10 Oct 2026Rejected2/5Pooja Shetty0Portfolio light on systems work.
Field details
Candidate · Text
Opening · Link to another table
Links to Openings
Email · Email
Phone · Phone
LinkedIn · URL
Resume · Attachment
Source · Single select
LinkedIn, Naukri, Referral, Careers page, Agency, Campus
Applied on · Date
Stage · Single select
Applied, Screening, Interview, Final round, Offer, Hired, Rejected
Next interview · Date
Rating · Rating
Current CTC · Currency
INR
Expected CTC · Currency
INR
Notice period (days) · Number
Recruiter · Text
Hired (0/1) · Formula
IF({Stage} = 'Hired', 1, 0)
Expected hike · Formula
IF(AND({Current CTC}, {Expected CTC}), ({Expected CTC} - {Current CTC}) / {Current CTC}, BLANK())
Notes · Long text

Form view “Apply for a role” asks for: Candidate, Opening, Email, Phone, LinkedIn, Resume, Current CTC, Expected CTC, Notice period (days), Notes.

Why each part of the base is there

Openings: Positions, Status and Budget (CTC)

Positions says how many people the role needs, Status runs Open, On hold, Filled and Closed, and the CTC budget sets the ceiling recruiters can compare expected CTC against before taking a candidate further.

Openings: Applicants, Hired and Days open

Applicants counts linked candidates and Hired sums the Hired (0/1) formula across them, so each role shows progress against Positions. Days open counts from the Opened on date and highlights roles that are stuck.

Candidates: Source

LinkedIn, Naukri, Referral, Careers page, Agency or Campus. Over time it shows which channels produce hires, not just applications, which is useful before you renew a job board subscription or agency contract.

Candidates: Stage, Next interview and Rating

Stage runs Applied, Screening, Interview, Final round, Offer, Hired and Rejected and drives the Pipeline kanban. Next interview populates the Interviews calendar, and Rating records the panel's 1 to 5 score for comparing candidates.

Current CTC, Expected CTC, Expected hike and Notice period

Salary expectations are captured as annual CTC in rupees, and Expected hike shows the jump as a percentage. Notice period (days) tells you when a candidate could realistically join, which often decides between two good finalists.

Resume, LinkedIn, Recruiter and Notes

The CV and profile stay attached to the candidate record, Recruiter shows who owns the candidate, and Notes keeps interview feedback in one place instead of in email threads.

About the Recruitment Tracker template

This recruitment tracker has two linked tables. Openings holds each role with its department, location, hiring manager, number of positions, status, a CTC budget in rupees and the date it opened; it counts its applicants, sums how many have been hired and works out how many days the role has been open. Candidates holds every applicant linked to an opening, with email, phone, LinkedIn profile, resume, source, application date, stage, next interview date, a 1 to 5 rating, current and expected CTC, notice period in days, the recruiter and notes. Formulas mark hired candidates and calculate the expected hike as a percentage of current CTC. Views include a candidate pipeline kanban, an interviews calendar, a hiring funnel dashboard, an openings board by status and an Apply for a role form that candidates fill in with their CV.

Who it is for

It is aimed at founders, HR generalists and in-house recruiters who hire a handful to a few dozen people a quarter and track candidates in spreadsheets or email folders today. It reflects how hiring works in India: salaries are recorded as annual CTC, notice period is captured in days because 30 to 90 day notice is common, and sources include Naukri, LinkedIn, referrals, campus and agencies. Recruitment agencies can also keep one copy per client.

How to use it

  1. 1

    Click Use this template, sign in with your Edesy account, and click Use template in the preview to copy the base into your workspace.

  2. 2

    Add your open roles in Openings with the hiring manager, number of positions and CTC budget, and edit the Location and Department options.

  3. 3

    Share the Apply for a role form on your careers page or job posts; each application becomes a candidate linked to the opening they chose.

  4. 4

    Move candidates across the Pipeline board as they are screened, interviewed and offered, set Next interview dates and give each a rating after interviews.

  5. 5

    Review the Funnel dashboard and the Days open figure on each opening weekly to see where candidates drop out and which roles are taking too long.

Connected templates in other Edesy apps

Recruitment Tracker: frequently asked questions

Yes. The Apply for a role form asks for name, the opening, email, phone, LinkedIn, resume, current and expected CTC, notice period and notes. Share its link and each application becomes a candidate linked to that opening.

Each candidate has a Hired (0/1) formula that is 1 when Stage is Hired. The opening's Hired field sums it across linked candidates, so you can compare it with the Positions you need to fill.

Yes. Set the Next interview date on a candidate and it appears on the Interviews calendar view. Update the date after each round so the calendar always shows what is coming up.

If you have the candidates as a CSV or Excel file, import it into the Candidates table, map the columns, set Source for those rows and link each candidate to the right opening.

Yes. Add them to the workspace as commenters or viewers. Commenters can leave feedback as comments on a candidate record, with @mentions to bring in the recruiter, without changing the data.

Add an automation with a form-submitted trigger on the Apply form, and have it post a message to a connected Slack channel or call a webhook so the application reaches the recruiter's tool of choice.

About the app

Yes. Copy the template, then import a .csv, .tsv or .xlsx file into any of its tables and map the columns. Delete the sample rows first if you do not need them.

Yes. An automation runs when a record is created, updated or matches a filter, when a form is submitted, on a schedule or when a date arrives, and can update or create records, call a webhook or post to a connected Slack channel.

Related templates