Income and work

A four-step payment reminder schedule for freelance invoices

A four-step reminder schedule for unpaid freelance invoices, with timing, a tone for each message and a tracker column that records when each was sent.

Editorial illustration for A four-step payment reminder schedule for freelance invoices

A simple schedule for chasing payment has four steps: a friendly note just before the due date, a polite check shortly after, a firm request with a date, and a formal message with your next step. Spacing them at set intervals removes the awkwardness, because you are following a routine and not making a personal judgement each time.

What are the four reminders and when are they sent?

StepWhenToneOne-line idea
Reminder 12 days before the due dateFriendlySharing the invoice again so it is ready for the next payment run.
Reminder 23 days after the due datePoliteChecking whether the payment has been scheduled.
Reminder 310 days after the due dateFirmAsking for a confirmed payment date.
Reminder 420 days after the due dateFormalStating what happens next if there is no date, such as pausing further work.

These intervals are suggestions. Make them longer for a client who always pays in 45 days and shorter for a new client you do not yet know.

A schedule does not make a slow payer fast. It gives you a calm, repeatable way to ask and a dated record that you did.

What should each message actually say?

  • Reminder 1: invoice number, amount, due date and a thank you. No pressure.
  • Reminder 2: ask whether it has gone to accounts, and whether they need anything from you, such as a PO number or a bank detail.
  • Reminder 3: say the invoice is now overdue and ask for a specific date.
  • Reminder 4: factual and calm. State the amount, the days overdue, the earlier messages and what you will do next.

Keep every message short, with the invoice number in the first line, and send it on the same channel the client uses to answer.

How do I record the reminders in a tracker?

One row per invoice. Columns: invoice number in A, client in B, amount in C, due date in D, then four columns for the dates you sent each reminder, and a last column for the paid date in I. A status formula tells you what is due today:

=IF(I2<>"","Paid",IF(TODAY()>=D2+20,"Reminder 4 due",IF(TODAY()>=D2+10,"Reminder 3 due",IF(TODAY()>=D2+3,"Reminder 2 due",IF(TODAY()>=D2-2,"Reminder 1 due","Not yet")))))

It reads from the due date, so it shows the step the invoice has reached by date. You still enter the date you actually sent each message. Filter the status column for anything other than Paid or Not yet to get today's list.

What if the client replies but still does not pay?

Write down what they said and the date they promised, then restart the clock from that promise. If the promised date also passes, treat it as a new overdue and go to the next step. Do not allow a chain of verbal promises to replace the schedule.

When should I involve someone else?

If an invoice is still unpaid after the fourth reminder, decide who else can help: the person who commissioned the work, the client's accounts team, or a professional such as a lawyer or your professional body. For large amounts, ask a lawyer about the right way to proceed. This article covers record-keeping and tone, not legal steps.

When the money arrives, the credit appears in your bank statement. Importing that into SpendixAI gives you the date it landed, which is the date to enter in your tracker.

Set it up in ten minutes

  1. Add the four reminder columns and the status formula to your invoice sheet.
  2. Save four short message templates in your notes.
  3. Each Monday, filter for anything due and send the reminder.
  4. Record the date you sent it, every time.
SPENDIXAI JOURNAL

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

Explore your reports