Hiring & Recruiting Tracker — Google Sheets + Offline App for Small Business

**Sending job postings is easy. Keeping track of 20 applicants across 5 stages, 3 open roles, and 2 ongoing background checks — that's where things fall apart.**

The Hiring & Recruiting Tracker is a clean tracking system built for small business owners and office managers who are hiring without an ATS.

**This purchase includes two versions — use whichever fits your setup:**

🗂 **Google Sheets version** — click the included link, make a copy to your Google Drive, and start adding candidates immediately. No setup, no script to run.

💻 **Standalone offline app** — a single `.html` file that opens in any browser. No login, no internet required, no Google account needed. Data saves automatically in your browser.

Both versions have identical features: five-tab structure, color-coded stages, live dashboard, charts, and full sample data pre-loaded.

---

### WHAT YOU GET

**Dashboard**
Live view of your entire pipeline at a glance:
- Open roles, total applicants, candidates in interview, offers extended
- Stage breakdown table with count and % of pipeline
- Offer acceptance rate and average days to hire
- Pipeline funnel chart + applicants by source chart

**Applicant Tracker**
Your main log. Every candidate, one row:
- Name, role, department, source, stage, applied date
- Days Since Applied — calculates automatically, no entry needed
- Contact info, resume link, notes
- Stage column color-codes on update: Applied → Phone Screen → Interview → Background Check → Offer Extended → Hired / Rejected

**Interview Log**
One row per interview round per candidate:
- Round (1, 2, 3, Final), type (Phone / Video / On-Site / Technical / etc.)
- Score 1–5 with automatic green/yellow/red highlighting
- Recommendation (Strong Yes → Strong No) with color coding
- Interviewer names and notes

**Background Check Log**
Track every check type per candidate:
- Criminal, Credit, Employment Verification, Education Verification, Reference, Drug Test, MVR
- Provider, requested date, completion date
- Status (Pending / In Progress / Completed) and Result (Clear / Flag) — both auto-color

**Offer Tracker**
Log every offer with full detail:
- Offered salary, final salary, start date
- Response deadline — turns red automatically if overdue and no response yet
- Status (Pending Response / Accepted / Declined / Negotiating / Rescinded)

**Instructions Tab**
Full plain-English setup guide, tips, and a privacy note for sharing with your team.

---

### HOW IT WORKS

**Google Sheets version:**
1. Open the included `google-sheets-link.txt`
2. Click the link — Google will ask "Make a copy?"
3. Click yes — your private editable copy opens immediately
4. Clear the sample data rows and start adding your candidates

**Standalone offline app:**
1. Open `hiring-tracker.html` in any browser (Chrome, Edge, Firefox, Safari)
2. Sample data is pre-loaded — explore the dashboard and tabs
3. Clear the sample data and add your first candidate
4. Everything saves automatically — no account, no sync, no setup

No plugins. No add-ons. No monthly fee.

---

### WHY THIS BEATS MANAGING IT IN A PLAIN SPREADSHEET

❌ No manually formatting headers every time you start a new hiring cycle
❌ No forgetting to check if a background check is still outstanding
❌ No "wait, did we ever send that offer?" — Offer Tracker has deadlines, not just names
❌ No losing track of who scored what in which interview round

✅ Everything is in one place, color-coded, and live
✅ Dashboard tells you where your pipeline stands without scrolling through rows
✅ The Days Since Applied column shows you who's been waiting too long

---

### WHO THIS IS FOR

- Small business owners handling their own hiring
- Office managers coordinating a multi-step hiring process
- Operations leads managing both HR and day-to-day responsibilities
- Anyone who's ever said "I thought you followed up with them"

---

### WHAT'S INCLUDED

- `hiring-tracker.html` — the standalone offline app, opens in any browser
- `google-sheets-link.txt` — one-click copy link to your Google Sheets version
- `README.txt` — instructions for both versions
- Sample data pre-loaded in both versions so you can see exactly how it works before you clear it

---

### FAQ

**Do I need a Google account?**
Not if you use the standalone `.html` app — it runs entirely offline in your browser. If you prefer Google Sheets, a free Google account is all you need.

**Do I need to know how to code?**
No. The Sheets version is a copy link — click and go. The HTML app is a file you open like any document.

**Where does my data go in the offline app?**
It saves automatically to your browser's local storage. It never leaves your device. Export to CSV any time from the toolbar.

**Can I add custom stages or departments?**
In Sheets: yes — edit the Data Validation dropdowns. In the HTML app: the stage list is in the file; contact support for help customizing it.

**Does this work on mobile?**
Both versions are optimized for desktop. The Sheets version is readable on mobile via the Google Sheets app.

**Will the dashboard update automatically?**
Yes in both versions — the dashboard reflects your current data at all times.

**Can I use this for multiple open roles at once?**
Yes. Each row in the Applicant Tracker includes the role applied for, so you can track 10+ open roles in the same sheet or app.

---

### PAIRS WITH

→ **Freelancer CRM & Lead Tracker** — once you hire, manage your contractors and clients in the same ecosystem