Key Takeaways
- Use a clear status system for every invoice: Draft, Sent, Viewed, Overdue, Paid, Void
- Review your accounts receivable weekly — a 10-minute habit that prevents invoices from falling through cracks
- Spreadsheets work for tracking 1-10 invoices; beyond that, switch to invoicing software with built-in tracking
- The follow-up cadence matters: reminder before due date, on due date, and at 3/7/14 days past due
- Aging reports show you at a glance how much is outstanding and for how long — run one weekly
- Automate everything you can: status updates, reminders, payment matching, and aging reports
Table of Contents
As a freelancer or small business owner, few things are more stressful than realizing you have thousands of dollars in unpaid invoices that you lost track of. It happens more often than anyone admits: you send an invoice, get busy with work, and three months later discover the client never paid — and you never followed up.
This guide shows you how to build a simple, reliable system for tracking unpaid invoices — whether you use a spreadsheet or dedicated software — so nothing falls through the cracks.
The Invoice Status System
Every invoice should have a clear status at all times. Here's the status system we recommend:
| Status | Meaning | Action Required |
|---|---|---|
| Draft | Invoice created but not yet sent | Review and send |
| Sent | Invoice sent to client | Confirm receipt in 2-3 days |
| Viewed | Client opened the invoice | Wait for payment (if using tracking) |
| Due Soon | Payment due within 3 days | Send pre-due reminder |
| Overdue | Past due date, not yet paid | Send follow-up reminders |
| Paid | Payment received and matched | None — mark complete |
| Partial | Partial payment received | Follow up on remaining balance |
| Void | Invoice cancelled | None — keep in records |
The key discipline is updating the status as soon as something changes. When a payment arrives in your bank account, immediately mark the corresponding invoice as "Paid."
Method 1: Spreadsheet Tracking (For Small Operations)
If you send fewer than 10 invoices per month, a spreadsheet is a perfectly valid tracking method. Here's the recommended structure:
| Column | Purpose |
|---|---|
| Invoice # | Your sequential invoice number |
| Client | Client name |
| Amount | Invoice total (with currency) |
| Date Sent | When the invoice was sent |
| Due Date | Payment deadline |
| Status | Draft / Sent / Overdue / Paid / Void |
| Date Paid | When payment was received |
| Payment Method | Wire / Wise / Stripe / ACH |
| Notes | Follow-up actions, PO numbers, etc. |
Spreadsheet Pros
- Free
- Simple to set up
- Full control over layout and fields
- No learning curve
Spreadsheet Cons
- No automated reminders
- No automatic status updates
- No payment matching
- Easy to forget to update
- Doesn't scale beyond 10-20 active invoices
Method 2: Invoicing Software (For Growing Businesses)
Once you have more than 10 active invoices or more than 5 regular clients, dedicated invoicing software saves significant time and prevents errors.
What Good Software Handles Automatically
- Status tracking — Automatically moves invoices from "Sent" to "Overdue" when the due date passes
- Payment reminders — Sends follow-up emails at intervals you define
- Payment matching — Links incoming payments to the correct invoice
- Aging reports — Shows you all outstanding invoices grouped by how overdue they are
- Dashboard overview — Total outstanding, total overdue, total paid this month
The Weekly Accounts Receivable Review
Regardless of whether you use a spreadsheet or software, build this 10-minute weekly habit:
- Check for new payments — Review your bank account for incoming payments and match them to invoices
- Review approaching due dates — Any invoices due in the next 7 days? Send a pre-due reminder if you haven't already
- Follow up on overdue invoices — Any invoices past due? Send the appropriate follow-up based on how many days overdue
- Review aging — Anything in the 30+ day category? Escalate with a phone call or more formal follow-up
- Update statuses — Make sure every invoice reflects its current state
This weekly review takes about 10 minutes and ensures no invoice goes more than 7 days without attention.
The Follow-Up Cadence
Here's the exact follow-up sequence we recommend for unpaid invoices:
| Timing | Action | Tone |
|---|---|---|
| 3 days before due | Friendly reminder email | Light, helpful |
| Due date | "Invoice due today" notification | Neutral, informational |
| 3 days overdue | First follow-up | Professional, assumes oversight |
| 7 days overdue | Second follow-up | Firmer, requests specific date |
| 14 days overdue | Final notice | Clear consequences (late fees, work pause) |
| 30 days overdue | Phone call or escalation | Direct but professional |
| 60+ days overdue | Formal demand / collections consideration | Business-formal |
Key Metrics to Track
Beyond individual invoice status, track these aggregate metrics to understand your accounts receivable health:
- Total outstanding — How much money is owed to you right now
- Average days to payment — How long it typically takes clients to pay after invoicing
- Overdue percentage — What percentage of your invoices are past due
- Collection rate — What percentage of invoiced amount is ultimately collected
If your average days to payment is climbing or your overdue percentage is above 20%, it's time to tighten your payment terms and follow-up process.
Track Every Invoice, Automatically
Velora shows you exactly which invoices are paid, pending, and overdue — with automated reminders and payment matching. One dashboard, zero manual tracking.
Try Velora FreeWhen to Escalate
Most late payments resolve with a simple reminder. But some don't. Here's when to escalate:
- 30 days overdue — Call the client directly. Email is easy to ignore; phone calls are not.
- 45 days overdue — Send a formal written demand via email and certified mail (if you have a physical address).
- 60 days overdue — Pause any ongoing work for the client until the balance is resolved.
- 90 days overdue — Consider a collections agency (for amounts over $500) or small claims court (for amounts under your jurisdiction's limit).
- 120+ days overdue — Write off the debt for accounting purposes and move on. Document it for your tax records.
Conclusion: Build a System, Not a Habit
Tracking unpaid invoices shouldn't depend on your memory or willpower. Build a system — whether that's a spreadsheet with a weekly review habit or invoicing software with automated tracking — and let the system do the work. The founders who get paid consistently are not the ones who chase invoices hardest; they're the ones who built a process that catches late payments early and follows up automatically.
Frequently Asked Questions
- What is the best way to track unpaid invoices?
- The best approach depends on your volume. For fewer than 10 active invoices, a simple spreadsheet with columns for invoice number, client, amount, date sent, due date, status, and notes works well. Beyond 10 active invoices, use dedicated invoicing software (like Velora, FreshBooks, or QuickBooks) that tracks status automatically, sends reminders, and generates aging reports.
- How often should I check on unpaid invoices?
- Review your accounts receivable at least once per week. This takes about 10 minutes: check which invoices are approaching their due date, which are past due, and whether any payments have come in that need to be matched. This weekly habit prevents any invoice from falling through the cracks for more than a few days.
- What is an accounts receivable aging report?
- An aging report groups your unpaid invoices by how long they've been outstanding: Current (not yet due), 1-15 days overdue, 16-30 days overdue, 31-60 days overdue, and 60+ days overdue. It gives you a snapshot of your outstanding receivables and helps you prioritize follow-up — invoices in the 30+ day categories need immediate attention.
- When should I write off an unpaid invoice?
- Consider writing off an invoice after 90-120 days of non-payment if you've exhausted your follow-up process. Before writing it off: send a final demand letter, consider whether the amount justifies a collections agency or legal action ($500+ usually does), and document the write-off for your tax records (you may be able to deduct the bad debt). For ongoing clients, stop new work until the outstanding balance is resolved.
- Should I use a spreadsheet or software to track invoices?
- Spreadsheets work for very small operations (1-10 active invoices). Switch to software when: you have more than 10 active invoices, you've ever lost track of an unpaid invoice, you want automated reminders, or you need to match payments to invoices. The time savings from software — even free options like Wave — justify the switch quickly.
Create cleaner invoices with your US LLC
Invollc makes invoicing international clients simple, fast, and compliant. Built specifically for founders with a US LLC.
Try Invollc Free