Income and work

A quarterly client-mix review for freelancers: who paid, who slowed

A client-by-client quarterly review for freelancers: share of income, days to pay and effort, with example outcomes such as raise the price, chase or let go.

Editorial illustration for A quarterly client-mix review for freelancers: who paid, who slowed

A quarterly client-mix review lists every client with three numbers: their share of your income, how many days they took to pay, and how many hours the work took. Divide income by hours to get a rate per client. Clients with a good rate and quick payment are worth protecting. Those with a poor rate or slow payment are candidates for a price rise, a firmer payment term, or a goodbye.

What goes in the client table?

  • Client name.
  • Income in the quarter, using the amount before any GST you collected. Confirm the right treatment with your CA.
  • Share of total income.
  • Average days to pay: payment date minus invoice date.
  • Hours spent, including calls, revisions and messages.
  • Rate per hour: income divided by hours.

In a sheet, with the invoice date in C and the payment date in D, days to pay is =D2-C2. Average it for each client with =AVERAGEIFS($E$2:$E$200,$A$2:$A$200,"Client B"), where column E holds days to pay and column A the client name.

What does a made-up quarter look like?

ClientIncomeShareDays to payHoursPer hour
A₹1,20,00040%1260₹2,000
B₹90,00030%48110₹818
C₹60,00020%2025₹2,400
D₹30,00010%7540₹750
Total₹3,00,000100%-235₹1,277

Income adds up to ₹1,20,000 plus ₹90,000 plus ₹60,000 plus ₹30,000, which is ₹3,00,000. Divided by 235 hours, that is about ₹1,277 an hour overall. Client B, at about ₹818 an hour, is the main drag, as it takes 110 hours.

What should I do about each client?

  1. Client A: strong rate and quick payment, but 40 percent of income. Keep them happy, and also look for one more client to reduce the dependence.
  2. Client B: large share, but slow payment and the most hours. Ask why it takes so much time. Is the scope growing without extra fees? Raise the price, limit the number of revision rounds, or charge for extra work.
  3. Client C: the best rate and quick payment on few hours. Ask whether they have more work, and say so politely.
  4. Client D: slow, low and small. Chase the pending money first. If the pattern continues, decide whether the relationship is worth keeping.

How slow is too slow?

There is no universal number. Compare each client's days to pay with what was agreed, and with your own fixed bills. A client who takes 75 days while your rent is due in 5 is effectively being funded by you. Decide your own limit, say it in your terms, and apply it the same way to everyone.

What is a sensible way to raise a price?

Start with the client where the rate per hour is lowest and the work is least tied to a contract. Tell them in advance, state the new rate and the date it starts, and offer a reason, such as a changed scope. Do not apply a rise retroactively to work already agreed. For contracts and terms, have a professional review them if the sums are large.

Where does SpendixAI come in?

Bank credits from clients can be imported from statements in SpendixAI, with rows reviewed before saving, so you can see what arrived and when. Hours and invoice dates will come from your own records, so keep the client table next to it.

Should I tell the client about the review?

Not the review itself, but the outcome. If you decide to raise a rate or tighten payment terms, tell the client early, in plain words, with a start date. Clients who value your work usually prefer a clear message to a surprise invoice, and the ones who walk away over a reasonable change have already told you something about the mix.

After the review

  • Write one decision for each client: keep, raise, chase, or review next quarter.
  • Set a date for each action.
  • Note the average days to pay beside each client, so next quarter's table shows whether it improved.
  • Keep a list of potential new clients, so you are not choosing from a position of need.
SPENDIXAI JOURNAL

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

Explore your reports