Client Tracker Spreadsheet, Project Tracker, Freelance CRM, Lead and Follow Up Tracker, Time Log, Small Business, Google Sheets & Excel
Every lead, project, deadline, and follow-up in one place. Move each project through your stages, log your hours, and this tracker flags what's past due, who needs a follow-up today, and which projects ran over. It works out your real hourly rate for every client and shows which lead sources bring in the best work.
★ WHY IT STANDS OUT
• Pipeline stages with a weighted pipeline value and win rate
• Follow up today, Past due, Over hours, and Waiting on payment flags
• Effective hourly rate for every project and client
• Booked work by lead source, so you know where to spend your marketing time
• Plain-English Insights panel with live, formula-driven sentences
• What-If inputs so you can test a change before you make it
• 10-minute numbered Quick Start on the Start Here tab
• Quick Entry tab sized for your phone in the Google Sheets app
• Business categories shared across every LeafLedgerCo Small Business Tool
• Free 2028 update
★ WHAT'S INCLUDED
SPREADSHEET (one .xlsx file that works in Google Sheets and Microsoft Excel)
• Start Here: a numbered 10-minute Quick Start and a color key
• Dashboard: active projects, active work, weighted pipeline, booked this year, effective hourly rate, follow-ups due, a month-by-month table and chart, and a What-If (raise rates, book more projects, work faster)
• Plain-English Insights like "2 follow-ups are due. Start with Nursery website photos (Green Thumb Nursery)."
• Projects: client, stage, quote, start, due, estimated and logged hours, paid, next follow-up, days to due, effective rate, weighted value, and next step
• Clients: business, contact, lead source, projects, booked revenue, hours, effective rate, and notes
• Time Log and Pipeline (by stage and by lead source)
• Quick Entry: today's to-do list and a fast time log for your phone
• Settings and Categories: target rate, weekly hours, follow-up days, stage chances, lead sources, and shared business categories
PRINTABLE PAGES (5 pages, in both US Letter and A4)
• Cover, Client Intake form, Project Planner, Time Log, and a Pipeline & Follow-Up tracker
★ HOW TO USE IT IN GOOGLE SHEETS
1. Download the files from the link in your purchase receipt email.
2. In Google Drive, click New > File upload and choose Client-Project-Tracker.xlsx.
3. Open it and choose File > Save as Google Sheets. Work in that copy.
4. On your phone, open that copy in the free Google Sheets app and use the Quick Entry tab.
★ HOW TO USE IT IN MICROSOFT EXCEL
1. Open Client-Project-Tracker.xlsx in Excel (desktop, web, or mobile).
2. If you see a Protected View bar, click Enable Editing.
3. Save a personal copy, then follow the 10-minute Quick Start on the first tab.
★ PRINTING
Print the PDF at home or at a print shop. Choose "Actual size" or "Fit" in your print settings. Print every page or only the ones you need. The pages use thin lines and little color to save ink.
★ PART OF A SET
LeafLedgerCo's Small Business Tools share the same 15 business categories (and the Side Hustle Income & Tax Tracker uses them too), so your numbers line up across the Pricing Calculator, Inventory & COGS Tracker, Bookkeeping & P&L, Invoices, Client & Project Tracker, Craft Fair Tracker, Marketing Planner, and Launch Planner.
★ PLEASE NOTE
• This is a DIGITAL DOWNLOAD. Nothing will be shipped to you.
• Download your files from the link in your purchase receipt email (a computer is easiest).
• FREE 2028 UPDATE: when the 2028 edition is ready, I'll add it to this listing and you can download it at no extra cost from your original purchase download link. I'll also email buyers when the update is ready.
• Amounts are shown in US dollars. You can change the currency format in your spreadsheet app.
• You need a free Google account or Microsoft Excel to use the spreadsheet, and a PDF reader to print.
• The listing photos show example data so you can see how it works. Your file arrives blank.
• This is an organizing and planning tool, not tax, legal, or accounting advice.
• For personal use only. Please do not share or resell the files.
• Colors may look slightly different on screen than on paper.
★ ABOUT HOW THIS WAS MADE
This product was designed with AI assistance under my direction. I planned it, set its features and look, and reviewed and tested the spreadsheet formulas and printable pages before listing.
Questions? Use the contact form on this store, or reply to your receipt email. I'm happy to help you get set up.