Corporate memo 006 // Invoicing
How to Track Freelance Invoices (and Follow Up When Clients Pay Late)
Freelancer invoice tracking is the least glamorous part of being your own boss — and the one that quietly decides when your money shows up. The work can be perfect, the client can be happy, and the invoice can still sit unpaid for 45 days while your rent comes due. When your income changes every month, a late payment doesn't just annoy you. It breaks the budget.
This isn't a course in collections. It's a simple system: send invoices that are hard to ignore, watch them in one place, and follow up on a schedule so nothing drifts. Set it up once and it runs in the background of your business.
Quick note: This is general information about running your invoicing, not tax or legal advice. Late fees and collection rules vary by place and contract — for decisions with real stakes, talk to a qualified professional who knows your situation.
Step 1: Invoice the Moment the Work Ships
Many late payments start with a late invoice. If you finish work on the 5th and invoice on the 20th, you've handed the client a two-week head start on being late — and you've forgotten half the details that make an invoice easy to approve.
Send the invoice the same day the work goes out. Every invoice needs the same six things:
- A unique invoice number. Start at 001 or 1001 and never repeat one. When a client asks "which invoice?", the number ends the confusion.
- The date sent and the due date. Skip "due upon receipt" — pick an actual calendar date.
- Exactly what you're billing for. One line per deliverable or time block, with dates.
- Your payment terms. "Net 14" (due in 14 days) is fair and common. Net 30 is what many clients expect, but you don't have to offer it. Shorter terms are fine, especially for new clients.
- How to pay you. The link, the address, the details — make paying easy.
- Late payment terms, in writing. For example, a line stating the monthly late fee that applies after the due date (check what's allowed where you work). You may never enforce it, but it makes the due date feel real.
Keep a copy of every invoice — not in your head, not in a text thread, but in a file you can find in ten seconds when someone says they never got it.
Step 2: Watch Every Invoice in One Place
When you have three clients paying on three different schedules, "I'll remember" stops working around invoice number six. You need one screen where every invoice's status is obvious at a glance: Paid, Pending, or Overdue.
At minimum, your tracker needs:
- Client and amount — who owes you what.
- Date sent and due date — so "overdue" is a fact, not a feeling.
- Status — Paid, Pending, or Overdue, updated at least weekly.
- Days overdue — calculated for you, not guessed at.
The value of a tracker isn't the formulas. It's that unpaid invoices stop being invisible. A row that changes color when it's overdue beats any memory trick, because the problem you can see is the problem you act on. Check your outstanding total once a week — same day, five minutes. That's the whole routine.
Want a method for what to do with the money once it lands? That's our budget guide for variable income.
Step 3: Set Payment Terms That Protect You
Your terms are the rules of the relationship, and you get to write them before the work starts — not after a payment is late. A few common approaches:
- Deposits for new clients. Asking for 50% up front on a first project is normal in many freelance fields, and it tends to filter out clients who weren't planning to pay.
- Milestone payments on big projects. Split a $3,000 project into three $1,000 milestones instead of one payment at the end. If a client stalls, one milestone is at risk, not the whole project.
- Shorter terms for repeat late payers. A client who always pays at day 45 on net-30 terms gets net-14 terms or a deposit on the next project.
- One payment method, spelled out. "Pay via [your link] by [date]" removes the "I didn't know how" excuse.
Those figures are examples only — pick terms that fit your industry and your clients. The point isn't to be aggressive; it's to make expectations clear before money is owed.
Step 4: Follow Up on a Schedule, Not on Your Nerves
Nobody enjoys chasing payments, so most freelancers follow up when the anxiety gets loud enough — usually too late and too emotional. Replace that with a calm, boring schedule:
- 3 days before the due date: a friendly heads-up. "Hi [name], invoice #1042 for $850 is due Friday — here's the link again in case it's buried." This simple reminder often heads off a late payment.
- The day after the due date: a short nudge. "Just checking on invoice #1042 — let me know if you need anything from me to get it processed."
- 7 days overdue: firmer, still polite. Mention the late payment terms from your invoice.
- 14 days overdue: a phone call if you have the number. Emails are easy to ignore; voices are harder.
- 30 days overdue: pause ongoing work until the balance is current. Say so calmly, in writing.
Notice what's not on this list: waiting three months, then sending an angry email. The schedule does the chasing; you just run the schedule.
Step 5: Know Your Late Payers
Over a few months, your tracker becomes a client report card: total billed, total paid, and outstanding, per client. That's not just bookkeeping; it's information you can act on.
The client who pays late every single time isn't having a rough quarter. They're showing you their process. Adjust accordingly: deposits, shorter terms, milestone billing — or, if the hassle costs more than the work is worth, a polite goodbye that frees up time for better-paying clients.
There's a tax angle too. Every invoice you log is income you can see. If you set aside a percentage of each payment for quarterly taxes (our freelancer tax savings guide walks through the method), your invoice log is your record of what actually landed, which makes the set-aside much easier to keep up with.
Stop Keeping It in Your Head
The system above works in any spreadsheet — but you don't have to build it from scratch. The Freelancer Invoice & Payment Tracker ($8, one-time) is a ready-made version of the tracker described here:
- Invoices tab — log client, invoice number, date sent, amount, due date, and status (Paid / Pending / Overdue from a dropdown). Days overdue counts itself.
- Color flags — rows turn pink when you mark them Overdue, and yellow when a Pending invoice slips past its due date.
- Clients tab — enter each client once; total billed, total paid, and outstanding fill in on their own.
- Dashboard — outstanding total, overdue total, how much of this month's invoices has been paid so far, and your oldest unpaid invoice with the client name and invoice number.
- How-to-use tab — plain setup steps.
Works in Excel and Google Sheets. No macros, no accounts, no subscriptions — your numbers stay in your file. Get the Freelancer Invoice & Payment Tracker ($8)
Pair it with the pay-what-you-want Freelancer Tracker Lite (3 linked tabs, up to 3 clients, budgets off your lowest month): the invoice tracker covers what clients owe you, and Lite plans what you spend. Get Freelancer Tracker Lite (pay what you want)