HomeBizPaperworkAll templates

THOUGHTFUL SPREADSHEET TEMPLATES

Client CRM

Keep the next follow-up in sight.

Keep every lead, client, follow-up, deal and invoice in one file, and see who to call today and who pays you most.

Spreadsheet templateDigital product
Client CRM — Dashboard product preview shown in a laptop

A closer look at Client CRM.

A TOOL THAT FITS YOUR DAY

Client CRM,
with a little more clarity.

This Client CRM is a ready-to-use spreadsheet for Google Sheets and Excel. Add each lead and client with status, source, phone, email and first contact. Log every deal with service, value and stage, from New lead to Won or Lost, and the Pipeline tab shows the money in each stage, the weighted value, your win rate and the open deals to chase next. Plan every call-back on Follow-Ups: late ones turn red, today's turn gold, and the Dashboard lists the next five. Keep a Contact Log of calls, emails, meetings and DMs, and Clients shows the last contact and next follow-up for each person by itself. Track invoices with due and paid dates (overdue ones turn red), and Income by Client shows deals won, paid this year and all time, unpaid and each client's share of your income. The Dashboard shows active clients, open pipeline, late follow-ups, paid this month vs your goal, won this month, win rate, unpaid invoices and paid this year. Type in the yellow cells; everything else is calculated for you.

Designed for small businesses keeping client relationships organised.

01 / THE DETAILS

Start Here

quick setup guide

02 / THE DETAILS

Dashboard

active clients, open pipeline, follow-ups late, paid this month vs goal, won this month, win rate, unpaid invoices, paid this year, charts, follow-ups due, top clients

03 / THE DETAILS

Clients

leads and clients with status, source, phone, email, city, first contact, last contact, next follow-up, paid this year and unpaid

04 / THE DETAILS

Deals

deals with service, stage, value, chance, weighted value, opened, expected close, closed on and days open

05 / THE DETAILS

Pipeline

deals and money in each stage, open pipeline, win rate, average deal, days to win and open deals to chase

06 / THE DETAILS

Follow-Ups

call-backs with due date and done date, late ones in red

07 / THE DETAILS

Contact Log

up to 1,500 calls, emails, meetings and DMs with next step

08 / THE DETAILS

Invoices

invoices with sent, due, amount, paid date and method, overdue in red

09 / THE DETAILS

Income by Client

deals won, won value, paid this year and all time, unpaid, last payment and share of income

10 / THE DETAILS

Setup

business name, monthly income goal, quiet days and every dropdown list

SIMPLE BY DESIGN

A few things
worth knowing.

Before you get started

  • Your client details stay in your own file. Share it carefully.
  • Check the matching Etsy listing for current availability, included files and setup instructions.
  • Enter your own information and review the results. Check the listing for supported spreadsheet software before purchase.

MAKE ROOM FOR YOUR EVERYDAY

Make Client CRM
part of your day.

Find the full template and included files on Etsy.

One digital product. Secure checkout on Etsy.