How to Track Freelance Invoices (So Nobody Pays You Late Without You Noticing)

Free freelance rate calculator: invoices only help if the rate behind them covers your costs.

A freelance invoice tracker doesn't need to be accounting software. For most freelancers and side hustlers, a single spreadsheet with the right columns and one habit (checking it weekly) is enough to see who owes you, what's overdue, and how much you've actually collected. This guide shows the columns to use, a days-overdue formula you can paste into Google Sheets or Excel, and a simple follow-up schedule for late invoices.

Late payments usually aren't dramatic. A client forgets, an invoice lands in the wrong inbox, or the person who approves payments is on vacation. The real problem is when you forget too, because the invoice only lived in your sent folder.

Why freelancers need an invoice tracker

When you have two clients, you can keep it in your head. Around the fifth or sixth open invoice, things start to slip: you're not sure whether a partial payment covered the whole thing, or whether that "net 30" invoice is now 45 days old.

A tracker gives you three answers at a glance:

1. Who owes you money right now (and how much).
2. What's overdue, and by how many days.
3. What you've billed versus collected this month or year, which is the number that actually pays your rent.

It also makes tax time and budgeting easier, because every invoice and payment date is already in one place.

The columns your freelance invoice tracker needs

Start with one row per invoice and these columns:

That's it. You can add a notes column for things like "sent reminder Oct 3," which is surprisingly useful when you need to follow up a second time.

Invoice tracker formulas for Google Sheets (and Excel)

Say your columns are laid out as A (Invoice #) through K (Days overdue), with data starting on row 2. These formulas go in row 2 and can be copied down.

Balance due (column I):

=IF(F2="", "", F2 - N(G2))

Status (column J), if you want it calculated instead of picked from a dropdown:

=IF(F2="", "", IF(I2<=0, "Paid", IF(N(G2)>0, "Partial", "Unpaid")))

Days overdue (column K):

=IF(AND(N(I2)>0, E2<>"", TODAY()>E2), TODAY()-E2, 0)

This returns 0 for anything paid or not yet due, and the number of days late for anything still open past its due date.

Summary totals (put these somewhere above or on a separate tab):

Total billed:      =SUM(F2:F)
Total collected:   =SUM(G2:G)
Outstanding:       =SUM(I2:I)
Overdue balance:   =SUMIF(K2:K, ">0", I2:I)
Collection rate:   =IFERROR(SUM(G2:G) / SUM(F2:F), 0)

(In Excel, replace open ranges like F2:F with a fixed range such as F2:F500.)

Add conditional formatting on the Days overdue column, for example red when it's above 0, and the overdue invoices will jump out every time you open the sheet.

A worked example (made-up numbers)

Here's a made-up example to show how it reads. A freelance writer has four invoices open in October:

• Invoice 2026-011: $600 billed, $600 paid. Balance $0, Paid.
• Invoice 2026-012: $1,200 billed, $500 paid. Balance $700, Partial, not yet due.
• Invoice 2026-013: $450 billed, $0 paid, due 12 days ago. Balance $450, 12 days overdue.
• Invoice 2026-014: $900 billed, $0 paid, due next week. Balance $900, Unpaid.

Totals: $3,150 billed, $1,100 collected, $2,050 outstanding, $450 overdue. Without the sheet, the 12-day-old invoice is the one that quietly turns into 40 days.

A simple follow-up schedule for overdue invoices

The tracker tells you when to follow up. Here's a polite, plain schedule many freelancers use as a starting point:

• A few days before the due date: a friendly heads-up ("Just a reminder that invoice 2026-013 is due Friday").
• 1 to 3 days overdue: a short note with the invoice attached again. Most late payments are simple oversights.
• About 7 days overdue: follow up again and ask whether anything is holding it up (wrong contact, missing PO number, etc.).
• 14+ days overdue: a firmer message that references your agreed terms, and consider pausing new work until the balance is cleared.

Log each reminder in the notes column so you're never guessing whether you already sent one.

Ways to reduce late payments before they happen

A tracker catches late invoices. These habits help prevent them:

• Put clear terms on every invoice: the due date (not just "net 30"), the amount, and how to pay.
• Agree on payment terms before you start, ideally in writing, so the invoice isn't the first time the client hears about them.
• Ask for a deposit on larger projects. Many freelancers take part of the fee up front.
• Invoice promptly. An invoice sent the day work is delivered tends to get paid sooner than one sent three weeks later.
• Late fees are an option, not a default. If you want to charge them, put them in your agreement up front, and check what's allowed where you and your client are located.

Freelance invoice tracker FAQ

What is the best way to track freelance invoices?

For most freelancers, a spreadsheet is enough: one row per invoice with the client, invoice date, due date, amount billed, amount paid, balance due, and days overdue. Check it once a week. If you send dozens of invoices a month or need automatic reminders, dedicated invoicing software may be worth it.

Can I track invoices in Google Sheets?

Yes. Google Sheets handles everything a basic invoice tracker needs: balance-due and days-overdue formulas, summary totals with SUM and SUMIF, and conditional formatting to highlight overdue invoices. The formulas in this article work in Google Sheets and, with fixed ranges, in Excel.

How do I calculate how many days an invoice is overdue?

Subtract the due date from today's date, but only when there's still a balance and today is past the due date. In Google Sheets or Excel: =IF(AND(balance>0, TODAY()>due_date), TODAY()-due_date, 0), replacing balance and due_date with your cell references.

When should I follow up on an unpaid invoice?

A common approach is a friendly reminder just before the due date, a short follow-up 1 to 3 days after, another around a week late, and a firmer message (referencing your agreed terms) after about two weeks. Adjust the timing to your clients and keep a note of every reminder you send.

What payment terms should a freelancer use?

Net 14 and net 30 are both common, and some freelancers ask for payment on receipt or a deposit up front. Shorter terms usually mean you get paid sooner, but what works depends on your clients. Whatever you choose, agree on it before the work starts and print the actual due date on the invoice.

This guide is general information, not tax, legal, or financial advice. Pricing depends on your market and skills, and tax and payment rules vary by location and situation. Talk to a qualified professional about your own situation. Examples use made-up numbers.