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.
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 | Amount | Issue Date | Due Date | Status | Days Overdue | Notes |
|---|---|---|---|---|---|---|---|
| INV-2026-010 | ABC Corp | ₹59,000 | 01/03/26 | 15/03/26 | ✅ Paid | — | |
| INV-2026-011 | XYZ Ltd | ₹1,18,000 | 05/03/26 | 19/03/26 | 🟡 Pending | 0 | Reminder sent |
| INV-2026-012 | StartupX | ₹35,000 | 20/02/26 | 06/03/26 | 🔴 Overdue | 4 | Follow up today |
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
Know the moment a client views or pays an invoice
Weekly tracking routine (10 minutes every Monday)
Open your invoice tracker or dashboard
Mark any invoices paid since last week
Identify invoices due in the next 7 days — send a pre-due reminder
Identify invoices 7+ days overdue — escalate the follow-up
Note any invoices 30+ days overdue — consider phone call or legal notice
Track all your invoices automatically
InvoicePilot shows paid, unpaid, and overdue in one dashboard. Reminders go out automatically.
Start Free — No Credit Card →