Income and work

Which clients pay late? A payment-behaviour scorecard

A client payment-behaviour scorecard scores days late, reminders needed and part payments, so you can rank clients before you accept the next project.

Editorial illustration for Which clients pay late? A payment-behaviour scorecard

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:

Measure0 points1 point2 points3 points
Average days lateZero or early1 to 7 days8 to 21 daysMore than 21 days
Reminders per invoiceNoneAbout 12 or moreNot used
Part paymentsNoneAnyNot usedNot 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?

ClientAverage days lateReminders per invoicePart paymentsScore
Client A-2 (early)000
Client B6102
Client C18215
Client D35326

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

  1. One row per client, updated once a month.
  2. Review the top three scores first.
  3. Write one decision against each: keep terms, change terms or stop.
SPENDIXAI JOURNAL

Useful ideas start with a clearer picture of your own spending.

Explore your reports