Client Tracker Mini CRM

Description

Client Tracker Spreadsheet for Freelancers & Small Businesses | Mini CRM with Lead Pipeline, Communication Log, Task Gantt & Invoice Tracker for Google Sheets and Excel

What’s Included (your download)

• Client-Tracker.xlsx — the blank workbook, ready for your business (7 sheets: Dashboard, Client Database, Lead Management, Communication Log, Task Tracker, Gantt, Invoice Tracker)
• Client-Tracker-SAMPLE.xlsx — the same workbook filled in with a fictional freelancer’s real-looking data, so you can see every number working before you type your own
• Quick-Start-Guide.pdf — a 5-page illustrated setup guide: open it in Sheets or Excel, sheet-by-sheet tour, a 10-minute first setup and a calm weekly routine
• Free updates: if we improve this file, your updated copy is free in your account library

Product Details

Overview

A mini-CRM that lives in a spreadsheet you already own — no subscription, no new app to learn, no client data sitting on someone else’s server. The Client Tracker keeps your whole client business in one file: who your clients are, where every lead honestly stands, what was said and when, what you owe people, and who owes you. A live Dashboard pulls it all together, a 12-week Gantt pictures your workload, and an Invoice Tracker quietly totals what you are still owed. It was built for one-person and small businesses who have outgrown sticky notes and memory, but who do not need — and do not want to pay monthly for — a full CRM platform.

What’s Included

• Dashboard — clients, pipeline by stage, invoiced / collected / outstanding totals, overdue flags and follow-ups due, all calculated live
• Client Database — 200 clients with contact details, source, status and an automatic Lifetime Value per client, totalled from your invoices
• Lead Management — a 7-stage pipeline (New → Contacted → Call Done → Proposal Sent → Negotiation → Won / Lost) with estimated value, win chance and an automatic weighted value per lead
• Communication Log — 300 entries: date, person, type, one-line summary and follow-up tracking
• Task Tracker — 100 client tasks with priorities, statuses and automatic Days Left / Overdue / Due soon flags
• Gantt — a 12-week timeline of your first 15 tasks that draws itself from the Task Tracker dates, with a movable start date
• Invoice Tracker — 200 invoices with automatic balance-due and days-late columns
• A filled SAMPLE copy and a 5-page Quick-Start Guide, included free with every purchase

Key Benefits

• Know what you’re owed, always — outstanding, overdue and collected figures are never more than one glance away
• Leads stop going quiet — follow-up dates flag themselves DUE on the Dashboard the morning they arrive
• One file, whole business — clients, leads, conversations, tasks and invoices finally agree with each other, because they are the same file
• Honest pipeline numbers — weighted values show what your pipeline is realistically worth, not what you hope it’s worth
• Your data stays yours — works fully offline; nothing is uploaded, synced or sold

Who Is This For?

• Freelancers and consultants juggling more clients than memory can hold
• Solo service providers — designers, writers, coaches, developers, photographers, virtual assistants
• Small agencies and studios (2–10 people) who want one shared source of truth without CRM software bills
• Sellers adding a services arm who need their client work organised in the same no-fuss style as their shop records

How It Works

1. Download the workbook and open it in Google Sheets (free) or Excel — the Quick-Start Guide walks you through the two-minute setup, including saving your own working copy.
2. Type only in the gold cells. Add your clients, your open leads with their honest stage, and every unpaid invoice.
3. Grey cells do the rest: IDs, weighted values, balances, days-late, flags, the Dashboard and the Gantt all calculate themselves.
4. Run your week from the Dashboard: chase what’s flagged, log each conversation in ten seconds, and watch the outstanding figure fall as payments land.

Why It’s Different

Most spreadsheet CRMs are a single flat contact list with a new name. This one is a working system: the sheets feed each other, so an amount typed once on an invoice updates a client’s Lifetime Value and your outstanding total at the same time. It also flows directly into our Bookkeeping Bundle instead of living in a separate file silo — client work here, money in the Bundle, nothing duplicated. And unlike template packs that quietly assume the newest software, every formula here is an ordinary one, tested in older Excel (2010 onwards) and Google Sheets, printed plainly in the guide: what works, works everywhere.

Delivery & Compatibility

Instant download after payment confirmation — the files also wait for you permanently in My Account → Downloads (5 downloads, 365 days; lost files are re-issued free on request). You receive two .xlsx workbooks and one PDF guide. Works in Google Sheets (free — upload and “Save as Google Sheets”) and Microsoft Excel 2010 or newer on Windows and Mac. No macros, no add-ons, no subscription. Capacities: 200 clients, 200 leads, 300 communication entries, 100 tasks, 200 invoices; the Gantt pictures the first 15 tasks over a 12-week window. Dates and follow-up flags compare against the current date, so they are always up to date when you open the file.

Disclaimer

This is an organisational tool for your own client records. It is not CRM software, accounting software or a payment service, and it does not send invoices, emails or reminders for you. Figures are calculated from the data you enter — accuracy depends on keeping entries current. Client names must be spelled the same way on every sheet for automatic totals (like Lifetime Value) to connect. Not tax, legal or financial advice.

Pairs well with

Small-Business & Seller Bookkeeping Bundle — the money side of the same business; this tracker is the client side, and the two are designed to sit together instead of your records living in separate file silos.