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
Tables
Openings, Candidates
Fields
30
Views
grid, kanban, calendar, form, dashboard
Updated
2026-11-19
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.
12 fields · 3 sample rows
| RoleText | DepartmentSingle select | LocationSingle select | Hiring managerText | PositionsNumber | StatusSingle select | Budget (CTC)Currency | Opened onDate | CandidatesLink to another table | ApplicantsCount | HiredRollup | Days openFormula |
|---|---|---|---|---|---|---|---|---|---|---|---|
| Senior Frontend Engineer | Engineering | Bengaluru | Vikram Rao | 2 | Open | ₹35,00,000 | 15 Oct 2026 | Karthik Subramanian, Emily Watson, Aarav Jain | 3 | 1 | 35 |
| Account Executive | Sales | Mumbai | Neha Kapoor | 1 | Open | ₹22,00,000 | 30 Oct 2026 | Fatima Sheikh, Noah Williams | 2 | 0 | 20 |
| Product Designer | Marketing | Remote – India | Lucas Fernandes | 1 | On hold | ₹20,00,000 | 30 Sep 2026 | Ritika Bose | 1 | 0 | 50 |
18 fields · 6 sample rows
| CandidateText | OpeningLink to another table | EmailEmail | PhonePhone | LinkedInURL | ResumeAttachment | SourceSingle select | Applied onDate | StageSingle select | Next interviewDate | RatingRating | Current CTCCurrency | Expected CTCCurrency | Notice period (days)Number | RecruiterText | Hired (0/1)Formula | Expected hikeFormula | NotesLong text |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Karthik Subramanian | Senior Frontend Engineer | [email protected] | +91 98400 12121 | 25 Oct 2026 | Final round | 21 Nov 2026 | 4/5 | ₹28,00,000 | ₹34,00,000 | 60 | Pooja Shetty | 0 | 21% | ||||
| Emily Watson | Senior Frontend Engineer | [email protected] | Careers page | 1 Nov 2026 | Interview | 20 Nov 2026 | 3/5 | ₹30,00,000 | ₹36,00,000 | 30 | Pooja Shetty | 0 | 20% | ||||
| Aarav Jain | Senior Frontend Engineer | [email protected] | Referral | 20 Oct 2026 | Hired | 5/5 | ₹26,00,000 | ₹32,00,000 | 30 | Pooja Shetty | 1 | 23% | |||||
| Fatima Sheikh | Account Executive | [email protected] | +91 99200 34343 | Naukri | 9 Nov 2026 | Screening | ₹15,00,000 | ₹20,00,000 | 90 | Sana Mirza | 0 | 33% | |||||
| Noah Williams | Account Executive | [email protected] | Agency | 4 Nov 2026 | Offer | 4/5 | ₹18,00,000 | ₹22,00,000 | 30 | Sana Mirza | 0 | 22% | |||||
| Ritika Bose | Product Designer | [email protected] | 10 Oct 2026 | Rejected | 2/5 | Pooja Shetty | 0 | Portfolio light on systems work. |
Form view “Apply for a role” asks for: Candidate, Opening, Email, Phone, LinkedIn, Resume, Current CTC, Expected CTC, Notice period (days), Notes.
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.
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.
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.
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.
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.
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.
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.
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.
Click Use this template, sign in with your Edesy account, and click Use template in the preview to copy the base into your workspace.
Add your open roles in Openings with the hiring manager, number of positions and CTC budget, and edit the Location and Department options.
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.
Move candidates across the Pipeline board as they are screened, interviewed and offered, set Next interview dates and give each a rating after interviews.
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.
A complete job application form with experience, notice period, documents and a declaration.
16 questionsEdesy BoardsCandidate Pipeline TemplateTrack candidates from application through screening and interviews to an offer, with ratings on each card.
6 columns · 6 sample cardsEdesy SignJob Offer LetterAn Indian job offer with role, CTC break-up, joining date, probation and offer validity, which the candidate accepts by signing.
2 signer roles · 25 fieldsEdesy FlowHiring WorkflowApplications are routed by role family to the right department leader, the HR director approves and signs every hire, the CV is filed in Google Drive and talent acquisition starts the offer process.
13 steps · 5 rolesYes. 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.
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.
Record daily check-ins per employee and get each person’s attendance rate and hours worked automatically.
2 tables · 17 fieldsEmployee Info SheetOne clean record per employee — role, contact, emergency details, documents and tenure — in a searchable staff directory.
1 table · 17 fieldsCOVID-19 Quarantine TrackerLog each employee who is isolating, their test results and symptoms, and see exactly when they are cleared to return.
1 table · 14 fieldsEmployee Onboarding TemplateRun every new hire through a shared plan — before day one to the 90-day mark — with owners, due dates and live progress per person.
2 tables · 23 fieldsEmployee Referral TrackingCollect referrals from staff, move candidates through the hiring stages and keep referral bonuses straight per employee.
2 tables · 24 fieldsEmployee Schedule TemplatePlan shifts by person, role and location, with paid hours per shift and a weekly total checked against each person’s cap.
2 tables · 18 fields