A payment-behaviour scorecard gives each client a few points for how they actually pay: how many days late, how many reminders they needed and whether they paid in parts. Add the points, rank the clients, and use the ranking before you say yes to the next project. It replaces a vague feeling about who is slow with a number you can point to.
What should the scorecard measure?
- Average days late: payment date minus due date, averaged across the client's invoices. Early payment counts as zero or below.
- Reminders needed: the average number of reminders sent per invoice.
- Part payments: how many invoices were paid in parts.
- Optional: number of disputes, and the number of invoices, so you know how much data is behind the score.
How do I turn the measures into points?
Keep it simple and write your thresholds in the sheet so you can change them. Example scoring:
| Measure | 0 points | 1 point | 2 points | 3 points |
|---|---|---|---|---|
| Average days late | Zero or early | 1 to 7 days | 8 to 21 days | More than 21 days |
| Reminders per invoice | None | About 1 | 2 or more | Not used |
| Part payments | None | Any | Not used | Not used |
The total runs from 0 to 6. A lower score is a better payer. These cut-offs are only examples. If most of your clients pay in 30 days, your lines might sit higher.
Collect at least three invoices per client before you trust a score. A new client has no score yet, so treat them as unknown and ask for a part payment up front until you have seen how they pay.
Review the scorecard before you quote, not after you sign. A higher price or a part payment up front is much easier to ask for at the start of a project than in the middle of it.
What are the formulas?
With the average days late in B2, reminders per invoice in C2 and the count of part payments in D2:
- Late points: =IF(B2<=0,0,IF(B2<=7,1,IF(B2<=21,2,3)))
- Reminder points: =MIN(2,ROUNDUP(C2,0))
- Part-payment points: =IF(D2>0,1,0)
- Total: add the three cells.
What does a scored list look like?
| Client | Average days late | Reminders per invoice | Part payments | Score |
|---|---|---|---|---|
| Client A | -2 (early) | 0 | 0 | 0 |
| Client B | 6 | 1 | 0 | 2 |
| Client C | 18 | 2 | 1 | 5 |
| Client D | 35 | 3 | 2 | 6 |
Client B scores 1 for lateness and 1 for reminders, a total of 2. Client C scores 2 for lateness, 2 for reminders and 1 for part payments, a total of 5. Client D reaches the top of the scale on lateness and reminders, and adds the part-payment point, for 3 plus 2 plus 1, which is 6.
How do I use the ranking before accepting a project?
- Score 0 to 1: normal terms are fine.
- Score 2 to 3: ask for a clear payment date in writing before you start.
- Score 4 or more: ask for a part payment in advance, or shorter milestones, or both.
These are your own business choices. The scorecard only tells you what you are choosing between. If you decide to accept a client with a high score, you can still plan for it by assuming their payments will arrive late when you build your cash plan.
Where does the data come from?
The payment dates come from your bank credits and the due dates from your invoices. SpendixAI can import the statements so the credit dates are on record, although the due dates and reminders live in your own sheet.
Keep it small
- One row per client, updated once a month.
- Review the top three scores first.
- Write one decision against each: keep terms, change terms or stop.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


