How to Track Freelance Invoices So Clients Pay on Time

By Cedar & Ledger

Most late payments from clients aren't bad intent. The invoice got buried, the terms were vague, or nobody followed up. A simple invoice log and a follow-up routine fix most of that.

Before the work starts

1. Agree on terms in writing. Rate, what's included, when you'll invoice, and when payment is due (for example, "due 14 days from invoice date"). Invoice Payment Terms Explained: Net 15, Net 30 and More covers how to pick them. An email the client replies "OK" to is better than nothing.
2. Ask who pays invoices. At bigger companies the person you work with often isn't the one who pays. Get the billing contact's email up front.
3. Consider a deposit for new clients or large projects. Many freelancers ask for a share up front. How to Ask Freelance Clients for a Deposit (Example Numbers) covers picking an amount and invoicing the deposit and balance.

Every invoice

• Give it a number (INV-001, INV-002...) so you and the client can refer to it. How to Number Your Invoices (Simple System) covers picking a format and fixing mistakes.
• Include the basics: your name or business, the client, invoice date, due date, what the work was, the amount, and how to pay. What to Put on a Freelance Invoice (Checklist + Example) has the full checklist with an example invoice.
• Log it the day you send it: client, number, amount, sent date, due date, status.

A weekly check

Once a week, open the log and sort by due date:

• Due in the next few days: nothing to do, or a friendly reminder if the client has been slow before.
• A few days past due: a short, polite note: "Just checking that invoice INV-014 for $450, due Oct 10, reached you. Let me know if you need anything from me."
• Two weeks or more past due: follow up again, copy the billing contact, and pause new work if your agreement allows it. How to Follow Up on a Late Invoice (Example Numbers) has a full 1/7/14/30-day reminder schedule with example wording.
• Paid: mark the date and amount. Partial payments get their own note.

Know your numbers

The same log tells you who your best clients are, how long each one takes to pay on average, and how much is outstanding right now. That makes it easier to plan, raise rates, or drop a client who's always late. To work out what your rate should be in the first place, How to Set Your Freelance Hourly Rate (Example Numbers) works backward from a yearly target.

Tools

A notes app or simple sheet works if you check it weekly. If you'd like a ready-made spreadsheet, the Freelancer Invoice + Client Tracker ($9, Excel and Google Sheets) logs invoices with due dates and status, shows what is paid, open or overdue, and totals billed, paid and outstanding. If you also want to track expenses and set money aside for taxes, see the Side Hustle Income & Expense Tracker ($7).

This is general information, not legal, tax or financial advice. Cedar & Ledger makes plain spreadsheet templates for money and small business: cedarandledger.vercel.app.

Try the free freelance rate calculator (find your hourly floor) →

Try the free invoice due date and late fee calculator →

Try the free PayPal fee calculator →

Related template: read about the freelancer invoice template

See all Cedar & Ledger templates