A shop chases money it is owed by memory. Here Amount owed sits on every row, so the balance is read before anyone opens the record.
Clients
The list that tells you who owes you money.
Most customer lists are a phone book. This one puts the balance next to the name, so opening it answers a question instead of asking one.
4 clients
ID# 21361VIP
JEJennifer Ewald+1 (408) 555-0142jennifer.ewald@example.com
Amount owed$3,940
21 May 2026
Lifetime spend$18,240
Jobs done7
Open balance$3,940
Last visit6 wks
2026 Honda Prologue · ceramic, 5 yr2022 Audi Q5 · full front PPF
12 Aug 2026Ceramic coating · 5 yr$2,400
03 Jun 2026Full front PPF · Audi Q5$1,540
21 Feb 2026Paint correction$780
ID# 21362Suspended
MNMax Nelson+1 (925) 555-0178max.nelson@example.com
Amount owed$0
21 May 2026
Lifetime spend$6,110
Jobs done4
Open balance$0
Last visit11 mo
2023 Tesla Model Y · sedan tint
02 Oct 2025Sedan tint · 5 windows$420
19 Mar 2025Ceramic top up$180
ID# 21364
ZHZakar Henley+1 (510) 555-0119z.henley@example.com
Amount owed$1,180
14 May 2026
Lifetime spend$4,860
Jobs done3
Open balance$1,180
Last visit2 wks
2025 Ford F-150 · full front PPF
14 May 2026Full front PPF$1,180
08 Jan 2026Windshield film$340
ID# 21365Fleet
CFCrosstown Fleet+1 (916) 555-0163ops@example.com
Amount owed$8,420.50
09 May 2026
Lifetime spend$61,300
Jobs done34
Open balance$8,420.50
Last visit4 days
11 vehicles · fleet tint + PPF3 new vans · booked for Sept
09 May 2026Fleet tint · 6 vans$5,240
02 May 2026PPF · 2 trucks$3,180
18 Apr 2026Fleet ceramic · 4 vans$4,120
One clientOpen a row and the whole history is there: the properties they own, what they have spent, and what is still outstanding.
JE
Jennifer EwaldID# 21361 · client since May 2024
VIPLifetime spend$18,240
Jobs done7
Open balance$3,940
Last visit6 wks
2026 Honda Prologue · ceramic, 5 yr2022 Audi Q5 · full front PPF
Work history
12 Aug 2026Ceramic coating · 5 yr$2,400
03 Jun 2026Full front PPF · Audi Q5$1,540
21 Feb 2026Paint correction$780
The record
Three parts, and the first one is the person.
A client is filed under Client Details, Properties and Invoice Terms. Details is who they are and how to reach them, Properties is what they bring you, which is what the list filters by, and Invoice Terms is how they are billed.
First nameJennifer
Last nameEwald
Customer tagVIP
Phone number+1 (408) 555-0142
Contact emailjennifer.ewald@example.com
Primary addressBalfour Rd, Brentwood, CA
CityBrentwood
StateCA
Zip code94513
CountryUnited States
Company nameNot a company
Preferred contact methodSMS
Client sourceGoogle
NotesLeft empty until the shop has something to say
Property 12026 Honda Prologue
ServiceCeramic, 5 yr
Property 22022 Audi Q5
ServiceFull front PPF
Jobs on file7
Lifetime spend$18,240
Last visit6 wks ago
Payment termsDue on completion
Deposit to book30%
Preferred paymentCard on file
Invoice sent bySMS and email
Open balance$3,940
RemindersAfter 3 and 7 days
TaxLocal sales tax
DiscountVIP, 10% on ceramic
JEJennifer EwaldVIP
Phone+1 (408) 555-0142
Emailjennifer.ewald@example.com
Primary addressBalfour Rd, Brentwood, CA 94513United States
Preferences
Contact bySMSCame fromGoogle
The address is a place, not a line of text. It is searched on a map and kept as one, so a mobile job knows where it is going.
Client source sits on the record itself. Where the name came from stays with the name, so lead management is reading the same field you are.
Company is empty for most people. Fill it and the same record carries a fleet, which is how one client holds eleven properties.
Why it matters
A name is not a customer. A record is.
Everything the shop learns about somebody lands on the same record, so the next person who picks up the phone already knows them.
A boat, a jet, the glass on their office. The record holds every property they bring you, and each one keeps its own history.
The last job, the coating on the car, what they still owe. It is one search away when the phone rings.
Or see where a new name comes from in lead management.