Back to Blog

How to Track Unpaid Invoices: A Simple Receivables Tracker for Freelancers

Short answer: To track unpaid invoices, keep one list with five columns: invoice number, client, amount, due date, and status. Review it once a week at a set time. Mark what was paid, flag what is late, and note how many days each client takes to pay. That habit catches problems early.

Most late payments don't start as disasters. They start as an invoice nobody looked at for three weeks.

If you've ever scrolled through your sent email to figure out who still owes you money, this post is for you. Here's a tracker you can set up in ten minutes, and a weekly check that keeps it honest.

What is a receivables tracker?

A receivables tracker is a single list of every invoice you've sent and whether it has been paid. "Receivables" is the money clients owe you. The tracker answers one question at any moment: who owes me what, and since when?

It doesn't need to be fancy. It needs to be complete, current, and in one place.

What should a tracker include?

Five columns do almost all of the work:

  • Invoice number (example: 1042). Lets you and the client point at the same document.
  • Client (example: Harbor Studio). Lets you see who is slow.
  • Amount (example: $2,400). Shows what's at stake.
  • Due date (example: Nov 20). The date your follow-ups count from.
  • Status (Draft, Sent, Paid, or Late). The answer to "who owes me?"

The numbers and names above are examples, not real clients.

Two optional columns are worth adding once you have the habit: date sent and date paid. With those two dates you can measure something most freelancers never see.

How do you know how fast a client really pays?

Count the days from the date you sent the invoice to the date the money arrived. That's your days-to-paid for that invoice.

Do this for a handful of invoices per client and patterns show up:

  • A client who always pays within a week is a client you can leave alone.
  • A client who always pays well after the due date needs a shorter due date, an earlier heads-up, or a deposit up front.
  • A client who pays small invoices fast and large ones slowly may have an approval step for bigger amounts. Ask who signs off.

You aren't guessing who is slow. You're reading your own records.

What does a ten-minute weekly check look like?

Pick one time per week and keep it. Monday morning works for a lot of people. Then run this:

  1. Mark what's paid. Check your bank or payment account and update the list.
  2. Flag what's late. Anything past its due date gets "Late."
  3. Look ahead. List invoices due in the next seven days. A short heads-up on a large one is cheap.
  4. Pick the next action for each late invoice. A polite reminder, a direct call, or a question about who approves payment.
  5. Send anything that's still unsent. The easiest invoice to lose track of is the one you never sent. Invoice the day the job wraps.

That's the whole routine. If it takes more than ten minutes, your list is probably split across too many places.

Why does "paid" sometimes not match your bank balance?

An invoice can be paid before the money is in your bank account. If clients pay by card through Stripe, Stripe sends funds to your bank on a payout schedule, and your bank may take extra time after that (Stripe: Receive payouts).

So keep two ideas apart: the client paid and the money is in my account. Your tracker's "Paid" status is about the first. When you check against your bank, you're checking the second.

What mistakes make trackers fail?

  • Splitting the list. Half in a spreadsheet, half in your inbox. Keep one list.
  • Updating only when you remember. Tie it to the weekly check.
  • Skipping drafts. If an invoice is drafted but unsent, mark it. Unsent invoices don't get paid.
  • Never recording the paid date. Without it you can't measure days-to-paid.
  • Tracking amounts but not due dates. The due date is what your follow-ups count from.

How does this work in InvoiceMedley?

If you'd rather not keep a spreadsheet, InvoiceMedley lets you create a professional invoice in minutes, email it with a PDF attached, and track which invoices are sent and which are paid in one place. Connect your own Stripe account and each invoice carries a Pay Now button, so the client can pay by card right away.

The tracker above works either way. The habit matters more than the tool.

Coming soon: automatic payment reminders, recurring invoices, and QuickBooks and Xero sync.

Plans are $19 a month for Starter, $49 for Professional and $99 for Enterprise.

Sources

Frequently asked questions

What should I track for each invoice?

Five things: the invoice number, the client, the amount, the due date, and the status (draft, sent, paid, or late). Add the date it was paid and you can also work out how long each client takes to pay.

How often should I check my unpaid invoices?

Once a week, at a fixed time. Ten minutes is enough: mark what's been paid, flag what's overdue, and look at what's due in the next seven days.

How do I measure how fast clients pay?

Count the days from the date you sent the invoice to the date the money arrived, for each client. After a few invoices you'll see which clients need a shorter due date or an earlier heads-up.

Do I need accounting software to track receivables?

No. A spreadsheet with five columns works. The point is one list you check on a schedule. Software helps when the list gets long or you want the invoice and its status in the same place.

14-day free trial, card required, cancel anytime before it ends. Start at invoicemedley.com

Start your 14-day free trial. Card required, cancel anytime before it ends.

Get started