How should freelancers track unpaid invoices?
Keep every invoice tied to a client, due date, amount, and payment status. Review overdue invoices regularly and follow up using a consistent reminder schedule.
Quick answer
What to know about track unpaid invoices
What is the simplest way to manage overdue invoices?
A central invoice tracker or invoicing app makes it easier to see paid, pending, and overdue invoices without maintaining separate spreadsheets.
Explore the topic
Invoice Payments Guide
Payment terms, reminders, overdue invoices and practical collection workflows.
📊 Invoice Tracking Guide
How to Track Unpaid Invoices (Free Methods + Tools)
If you're manually checking emails to see who has paid, you need a system. Here are three approaches — from a simple spreadsheet to full automation.
📖 6 min read·By InvoicePilot Team
See all unpaid invoices in one place
InvoicePilot shows paid, unpaid, and overdue — with one-click reminders. Free.
Method 1 — The spreadsheet tracker (free)
Create a Google Sheet or Excel file with these columns:
| Invoice # | Client | Invoice Amount | Paid | Balance Due | Due Date | Status | Days Overdue | Last Reminder | Next Follow-up |
|---|---|---|---|---|---|---|---|---|---|
| INV-2026-010 | ABC Corp | ₹59,000 | ₹59,000 | ₹0 | 15/03/26 | ✅ Paid | — | 10/03/26 | — |
| INV-2026-011 | XYZ Ltd | ₹1,18,000 | ₹60,000 | ₹58,000 | 19/03/26 | 🟠 Partial | 0 | 20/03/26 | 27/03/26 |
| INV-2026-012 | StartupX | ₹35,000 | ₹0 | ₹35,000 | 06/03/26 | 🔴 Overdue | 4 | 07/03/26 | 10/03/26 |
Pro tip: Add conditional formatting — red background for overdue, yellow for due within 3 days. Set a recurring Monday morning reminder to check the sheet.
How to Build an Unpaid Invoice Tracker
A useful unpaid invoice tracker should show not only whether an invoice is paid, but also the remaining balance and the next follow-up date. This makes partial payments and overdue invoices much easier to manage.
- ✓Invoice number and client
- ✓Invoice amount and amount paid
- ✓Balance due
- ✓Issue date and due date
- ✓Current status: unpaid, partially paid, paid, or overdue
- ✓Days overdue
- ✓Last reminder sent
- ✓Next follow-up date
Method 2 — Invoice aging report
An aging report groups unpaid invoices by how long they've been outstanding. It instantly shows where your cash flow risk is:
| Age | What it means | Action |
|---|---|---|
| Current (not due yet) | Invoice sent, within terms | No action needed |
| 1–14 days overdue | Slightly late | Send polite email reminder |
| 15–30 days overdue | Concerning | Firm follow-up, CC project manager |
| 31–60 days overdue | Serious | Phone call + formal written notice |
| 60+ days overdue | Bad debt risk | Legal notice or collection action |
Method 3 — Use invoicing software (easiest)
The most reliable system is one that runs itself. Good invoicing software shows you:
📋
Dashboard with paid / unpaid / overdue
One glance shows your full receivables status
🔔
Automatic reminders
Emails go out before and after due date without you doing anything
📊
Aging report built-in
See exactly how much is 0–30, 31–60, 60+ days overdue
📱
Mobile notifications
Stay updated on invoice payment status
Need to create the invoices you want to track? Use our free invoice generator to create and download professional invoices.
Weekly tracking routine (10 minutes every Monday)
1
Open your invoice tracker or dashboard
2
Mark any invoices paid since last week
3
Identify invoices due in the next 7 days — send a pre-due reminder
4
Identify invoices 7+ days overdue — escalate the follow-up
5
Note any invoices 30+ days overdue — consider phone call or legal notice
Simple follow-up workflow for overdue invoices
1
Before the due date: send a polite reminder with the invoice number, amount, and due date.
2
On the due date: confirm that the invoice reached the client or accounts team.
3
1–7 days overdue: send a short payment reminder and ask for the expected payment date.
4
8–30 days overdue: follow up more firmly and keep a written record of the conversation.
5
Longer overdue: review the contract and consider appropriate escalation based on your agreement and local requirements.
Frequently asked questions
What is the simplest way to track unpaid invoices for free?
A simple spreadsheet with columns for client, invoice number, amount, due date, and status (paid/unpaid/overdue) covers most freelancers’ needs — the key is actually updating it weekly, not the tool itself.
What is an invoice aging report?
An aging report groups unpaid invoices by how overdue they are — typically 0-30, 31-60, 61-90, and 90+ days — making it easy to spot which overdue invoices need the most urgent follow-up.
How often should I review unpaid invoices?
Weekly is a good default for most freelancers — a short 10-minute routine to mark paid invoices, flag anything approaching its due date, and escalate follow-up on anything already overdue.
How do I track a partially paid invoice?
Record the original invoice amount, amount paid, remaining balance, due date, and status as partially paid. Keep the next follow-up date in the tracker until the balance is cleared.
Track all your invoices automatically
InvoicePilot shows paid, unpaid, and overdue in one dashboard. Reminders go out automatically.
Start Free — No Credit Card →Payment Reminder Email Templates for Freelancers (2026)
7 copy-paste templates — friendly nudge to firm final notice. Email and WhatsApp scripts both included.
How to Get Clients to Pay Invoices Faster (7 Proven Tips)
Stop chasing payments. These 7 strategies will get your invoices paid on time, every time.
Create a free GST invoice
Generate a professional, GST-ready invoice in under 1 minutes — free, no signup required.