How to track clients and invoices without a CRM

What to track

Most follow-ups get missed because the next step isn't written down. For each client or lead, keep:

• Name and contact details
• Stage: new, talking, proposal sent, won or lost
• The next action and its date
• Value of the work
• Invoice number, due date and whether it has been paid

A 15 minute weekly routine

1. Check what is overdue. Reply to anyone waiting on you first.
2. Chase unpaid invoices. A short, friendly reminder on the due date is normal.
3. Give every open lead a next step. If you can't name one, close the lead.
4. Look at the month ahead. Compare what is invoiced with what you expect, while you still have time to act.

Which tool should you use?

A spreadsheet is free and flexible, but it won't remind you of anything unless you set it up that way. A one-file tracker gives you a ready structure without a monthly fee. A CRM makes sense when several people share clients or you need automated emails and integrations.

When you have outgrown a simple tracker

• More than one person needs to update the same client at the same time
• You miss leads even though you keep up the routine
• You need your email, calendar and invoicing connected

Client details are personal data, so keep your file somewhere secure and back it up. Your invoices may also need to meet local tax rules, so check what applies where you work.

Common questions

Is a spreadsheet good enough for tracking clients?

Often, yes, for a solo business. The habit of reviewing it each week matters more than the tool.

How often should I follow up with a lead?

Set a date for the next step each time you make contact. A week is a sensible default if you have heard nothing.

When is it worth paying for a CRM?

When a team shares clients, or when the time lost to manual follow-ups costs more than the subscription.