How to Track Your Commission Income and Client Relationships With Your Own Records

If you work on commission, you probably know this frustration: the company tracks their numbers, not yours.

The dealership CRM shows units sold. The brokerage system shows closed transactions. The carrier portal shows policies written. But none of them answer the questions that actually matter to you:

• How much did I actually take home this month after splits and fees?
• Which types of deals are worth my time?
• Am I on track for my income goals?
• Can I prove my income for a mortgage or apartment application?
• Who referred me business, and did I thank them?
• Which past clients might buy again — and when should I reach out?

Your employer's software serves the company. You need something that serves you.

---

Why Keep Your Own Records?

Let's be clear: this isn't about duplicating company data or exporting anything you're not supposed to. It's about maintaining your own personal financial records — something you have every right to do.

What company systems typically track:

• Gross transaction amounts
• Company revenue and metrics
• Activity for compliance/management oversight
• Pipeline and forecasting (for their planning)

What you need to know for yourself:

• Your actual take-home after commission splits
• Time invested per deal (is that $500 commission worth 20 hours of work?)
• Which lead sources or client types pay off for you
• Income history for taxes, loans, and life decisions

These are different questions. Company software answers theirs. You need to answer yours.

---

The Simple System: Track What You Earn, Not What You Sell

Here's the key mindset shift: You're not tracking deals. You're tracking your income.

When a deal closes, you don't need to recreate the company's records. You just need to note:

1. Date — When did you get paid?
2. Amount — What hit your account (net of splits/fees)?
3. Source — What type of deal or client was this?
4. Time — Roughly how many hours did this take?

That's it. Four fields. Takes 30 seconds per transaction.

Example: Real Estate Agent

Date	Amount	Source	Hours
Dec 15	$4,200	Buyer - referral	18
Dec 18	$6,800	Seller - cold lead	45
Dec 22	$3,100	Buyer - past client	8

Now you can see:

• Total income this month: $14,100
• Best hourly rate: Past client buyer ($387/hr)
• Worst hourly rate: Cold lead seller ($151/hr)

The company system would show three closed transactions. Your system shows which types of business are actually profitable for you.

---

What This Helps You Do

1. Prove Income for Loans and Leases

Commission earners often struggle to prove income because:

• Pay stubs vary wildly month to month
• Bank deposits don't explain what they are
• No W2 until year-end (and even then, it's just one number)

Your own records create a clear paper trail:

• "Here are my last 12 months of commission income"
• "Average monthly: $X"
• "Source breakdown shows consistent deal flow"

Landlords and lenders love clarity. A simple spreadsheet of your income by month is often more convincing than a confusing pay stub.

2. Know Your Real Hourly Rate

Commission work hides the truth about your time.

A $10,000 commission sounds great — until you realize you spent 80 hours on that deal. That's $125/hour.

Meanwhile, that "small" $2,000 deal took 5 hours. That's $400/hour.

Without tracking time yourself, you'll keep chasing big commissions while ignoring the deals that actually pay better per hour worked.

3. Spot Patterns the Company Can't Show You

Your personal records can reveal:

• Which lead sources pay off: Referrals vs. cold leads vs. online inquiries
• Which client types are worth your time: First-time vs. repeat vs. high-maintenance
• Seasonal patterns in your income: When to push hard, when to take vacation
• Whether you're improving: Is your average deal getting more profitable over time?

Company dashboards show company metrics. Your dashboard shows your metrics.

4. Plan Your Finances With Real Numbers

When you know your actual income patterns, you can:

• Set realistic savings goals
• Know when you can afford a major purchase
• Estimate quarterly tax payments accurately
• Negotiate better splits with data to back you up

---

Beyond Income: Your Relationships Are Your Business

Here's what commission earners often miss: the company owns the CRM, but you built the relationships.

When you leave or change companies, the client list stays behind. But the people who trust you? That's yours — if you've kept track.

What Company CRMs Track:

• Transaction history (for the company)
• Lead status and pipeline (for management)
• Communication logs (for compliance)
• Account ownership (that can be reassigned)

What You Should Track for Yourself:

• Who referred you business — and when you last thanked them
• Personal details that build trust — kids' names, hobbies, how they like to communicate
• When to follow up — not for the company's pipeline, but for your relationship
• Who might need you again — and roughly when (2 years for a home buyer, 5 years for a car, etc.)

This isn't about stealing company data. It's about remembering the people — the human details that make you good at your job.

The Relationship Details That Matter

Think about what makes clients come back to you instead of whoever answers the phone:

• "She remembered my daughter was starting college"
• "He knew I prefer texts over calls"
• "She followed up at exactly the right time"
• "He sent a note when my dad passed away"

Company CRMs don't track this. They track transactions. You need to track relationships.

A Simple Relationship System

For each important contact in your network, note:

Field	Example	Why It Matters
Name	Sarah Chen	Obviously
How we met	Referral from Tom (2023)	Remember to thank referral sources
Last contact	Oct 2024 - closed on house	Know when you last connected
Next touchpoint	Oct 2025 - 1 year anniversary	Prompt for natural follow-up
Personal notes	Twins starting kindergarten, loves hiking	Build real connection
Referral source?	Yes - sent me 2 clients	Track who sends you business

This takes 60 seconds per person. And it's the difference between "just another salesperson" and "the one who actually remembers me."

Your Network Is Your Safety Net

Commission jobs can be volatile. Companies restructure. Territories change. Managers leave.

But if you've maintained your own relationship records:

• You know who to reach out to if you change companies
• You have a list of people who trust you (not your employer)
• You can rebuild faster because you remember the details
• Your referral sources come with you

The company tracks customers. You should track your network — clients, referral partners, mentors, colleagues, and anyone else who matters to your career.

---

What NOT to Do

Let's be direct about boundaries:

Don't export or copy company data you're not authorized to take. If your employment agreement restricts data access, respect that. Your personal records should be exactly that — personal notes about your own earnings and relationships.

Don't copy the company's database. There's a difference between "I remember Sarah likes texts and referred me two clients" and bulk-exporting the CRM. The first is relationship memory. The second may violate your employment agreement.

Don't include confidential business information. For income tracking, you don't need deal details — just your take-home. For relationships, focus on personal details (how you met, when to follow up), not proprietary business data.

Don't use company time or resources to maintain personal records. This is your own system, maintained on your own time, for your own benefit.

Don't claim your records are official company documents. When proving income, be clear: "These are my personal records of commission income received."

Do remember: You have every right to maintain personal financial records and to remember the people you've built relationships with. That's not company property — that's your professional life.

The goal is simple: know what you earned, how long it took, who matters in your network, and what it all means for your career.

---

Getting Started: The 5-Minute Setup

You don't need fancy software to start. A simple spreadsheet works fine.

Step 1: Create Your Income Tracker (2 minutes)

Make a spreadsheet with these columns:

• Date Paid
• Net Amount (what you actually received)
• Deal Type (your own categories: buyer/seller, new/repeat, referral/cold, etc.)
• Estimated Hours
• Notes (optional)

Step 2: Backfill Recent History (3 minutes)

Look at your last 3 months of bank deposits or pay stubs. Add each commission payment with your best guess on hours spent.

Don't overthink it. "About 20 hours" is fine. Precision isn't the point — patterns are.

Step 3: Make It a Habit

Every time you get paid, take 30 seconds to add a row. That's it.

At the end of each month, spend 5 minutes reviewing:

• Total income
• Average per deal
• Best and worst hourly rates
• Any surprises?

---

When to Upgrade From Spreadsheets

Spreadsheets work great for tracking income. But they have limits:

Spreadsheets are good for:

• Simple income logging
• Basic totals and averages
• Exporting for tax time

Spreadsheets struggle with:

• Automatic calculations (profit per hour, trends over time)
• Reminders and follow-ups
• Connecting income to relationships and time tracking
• Generating reports for loan applications

If you find yourself spending more than 15 minutes a month maintaining your spreadsheet — or if you need better reports for proving income — it might be time for a dedicated tool.

---

The Bigger Picture: Your Numbers, Your Career

Here's what changes when you track your own income:

You stop guessing. "I think I'm doing okay" becomes "I averaged $8,400/month this quarter, up 12% from last quarter."

You make better decisions. When you see that referral clients pay $300/hour and cold leads pay $120/hour, you know where to focus.

You own your story. When applying for a mortgage, negotiating a split, or planning a career move, you have data — not just feelings.

You're prepared. If you change companies, your income history goes with you. If you need to prove earnings, you have documentation ready.

Commission work is unpredictable enough. Your understanding of it doesn't have to be.

---

Quick Reference: What to Track

Field	What to Record	Why It Matters
Date Paid	When money hit your account	Cash flow timing, monthly totals
Net Amount	Your actual take-home	Real income, not gross transactions
Deal Type	Your categories (buyer/seller, referral/cold, etc.)	See which types are profitable
Hours	Rough estimate of time invested	Calculate true hourly rate
Notes	Anything useful for memory	Context for patterns

---

Why Commission Work Is Really Relationship Work

Here's what the best commission earners already know: the deal is the outcome, but the relationship is the asset.

Think about where your best deals actually come from:

• A past client who remembered you
• A referral from someone you helped years ago
• A repeat customer who trusts you
• A colleague who sent business your way

Company CRMs track deals. But your career runs on relationships — and those relationships have patterns you can learn from, if you're tracking the right things.

The Questions That Actually Matter

Forget "units sold" and "gross revenue." Here's what drives a commission career:

• Which referral sources are actually valuable? (Not all referrals are equal)
• Who haven't I talked to in too long? (Before they forget you exist)
• What's my real hourly rate by client type? (Time is the hidden variable)
• Who sends me business — and have I thanked them? (Referrers need nurturing too)

These aren't in the company CRM. They're in your relationship patterns.

---

How Velvet Ledger Makes This Visible

Spreadsheets can track income. But they can't easily answer "which relationships are driving my career?"

Velvet Ledger connects the dots between your income, your time, and your people — so you see patterns that spreadsheets hide.

Your Referral Sources, Your Way

Create your own referral source categories that match how you think about your business:

• "Past customers"
• "Tom's network" (that one friend who sends everyone your way)
• "LinkedIn connections"
• "Open house walk-ins"
• "Service department handoffs"

Then see which sources actually pay off:

Referral Source	Contacts	Converted	Total Commission	Avg Deal
Past customers	45	12 (27%)	$18,400	$1,533
Tom's network	8	6 (75%)	$9,200	$1,533
Cold walk-ins	120	8 (7%)	$11,600	$1,450

Now you know: Tom's referrals convert at 75%. Past customers come back. Cold walk-ins rarely convert — but when they do, they're worth it.

This isn't about writing people off. It's about knowing where to focus your energy and which relationships to nurture.

And sometimes, it reveals where you need to strengthen:

• "I'm spending money on social media ads, but only 3% of those leads convert — what's going wrong?"
• "Service department handoffs used to convert at 40%, but dropped to 15% this quarter — time to talk to the service manager"
• "I assumed referrals were my best source, but past customers actually convert at 2x the rate — I should be following up more"

Without your own tracking, you'd never see these patterns. You'd just keep doing what you've always done.

No other personal CRM lets you customize referral tracking like this — because they're built for "contact management," not for understanding where your business actually comes from.

See Who's Going Cold Before They're Gone

Velvet Ledger flags relationships that need attention:

• At-risk (90+ days): "You haven't contacted Sarah in 3 months"
• Dormant (180+ days): "These 8 past customers haven't heard from you in 6+ months"
• Never followed up: "You met these people but never reconnected"

For commission work, this is the difference between "I should probably reach out to some people" and "Here are the 5 people most likely to send you business if you call them this week."

Connect Every Dollar to a Relationship

Log a commission. Link it to a contact. Now you see:

• Lifetime value by contact: "Sarah Chen: 3 deals, $14,200 total"
• Referral chains: "Tom referred Sarah, who referred Mike — $32,000 from one relationship"
• Who's due for a thank-you: "These 4 people sent you business this quarter"

Your network isn't just names in a list. It's a map of how your income actually flows.

See the Full Picture of Each Relationship

Not everyone who walks in buys today. But some browsers become your best customers.

Log appointments and interactions to a contact — even without a transaction. Then when they do buy, you see the full story:

• "Sarah browsed 3 times before her first purchase — then bought twice more"
• "Contacts from Tom's referrals: 80% convert within 6 months"
• "These 12 people visited but never purchased — worth a follow-up?"

This isn't about tracking "time spent" like a timesheet. It's about seeing which relationships are warming up, which have already paid off, and which might just need one more touchpoint.

The company CRM shows you who bought. Velvet Ledger shows you who's becoming a customer — and who might need a nudge.

Privacy That Matters

When you're keeping personal records outside company systems, privacy isn't optional:

• No data selling — your relationships aren't a product
• No ads — your attention stays on your work
• No AI training — your client details stay private
• Full export — CSV anytime, your data is always portable

This is your career data. It should stay yours.

---

Start Today

You don't need permission to understand your own finances. You don't need company software to know what you earn or who matters in your network.

Option 1: Start with a spreadsheet

1. Add your last few commission payments with rough hours
2. Add 10 people who matter most to your business
3. Note when you last talked to each one
4. See what the numbers tell you

This works. It's free. It gets you started.

Option 2: Start with Velvet Ledger

1. Import your contacts (or start fresh)
2. Log income as it comes in — 30 seconds per transaction
3. Let the system calculate your hourly rates and flag dormant relationships
4. See your Four Profits dashboard: Income, Time, Relationships, What's Ahead

Try it free for 30 days →

No credit card required. Your data stays private. Export anytime.

---

Your employer tracks what matters to them — transactions, pipeline, company metrics.

It's time you tracked what matters to you.