Who pays late? Three questions for your open invoices

by Robert Gonsalves | Nov 13, 2026 | Field Notes | 0 comments

A cup of coffee, a notepad and a pen on a wooden desk

I had this tool for almost a year before I finished it. That is the first thing I learned, and it has little to do with software. I kept measuring and never cut the piece. But once I started using personal AI assistants, I had an online active nag to help me follow through. Here is my first pass.

Here is what it does. You drop in a QuickBooks sales report. It looks at three things about each customer: when they last ordered, how often, and how much they spend. Each answer gets a score from 1 to 5, compared only with your other customers. Then every customer lands in a group: who to keep close, who to call, who to let rest.

Three things I learned along the way.

1. Simple beats clever. I started with ten groups. On a short customer list, most sit empty, so the home page shows seven. Longer lists can split out a few more. If a group needs a paragraph to explain, it is probably one group too many.

2. Your customer list stays home. Nobody should have to hand over a customer list to learn who their best customers are. The tool runs in your browser. Your data is never shared.

3. The groups are signals, not verdicts. A short list makes the groups rougher. A good customer who had a slow quarter can look like a slipping one. The sort tells you where to look. You know the person, and you decide.

Two plain day-count rules sit on top of the scores. A customer quiet for 45 days gets flagged to check on, and one quiet for 180 days counts as gone cold. You can change both numbers.

Using the tool reminded me of customers I enjoyed but lost track of. One I have since called, and we're working together again. That's the real harvest: not a report, but a short list of people worth a call this week.

Try the Customer Check with your own QuickBooks sales report. It takes a few minutes, and your customer list never leaves your computer.

Written by

Related Posts

0 Comments

Submit a Comment

Your email address will not be published. Required fields are marked *

Save to list