How do I keep track of unpaid invoices?

The simplest system: maintain an invoice status list with five states — Draft, Sent, Paid, Overdue, Cancelled. Review your "Sent" and "Overdue" invoices weekly. invoicePrivate tracks statuses for you in the invoice list — just update the status when payments come in.

What should I do when an invoice becomes overdue?

Follow up on the same day the invoice goes overdue. Most late payments are simple oversights. A polite, professional email is usually enough. Escalate to a firmer tone at 7 days, and consider formal demand letters or collections at 14+ days. Document all follow-up communications.

How long should I keep paid invoice records?

Most countries require 5–10 years for tax and legal purposes. UK and Germany require 10 years, the US generally requires 7 years, and Australia requires 5 years. When in doubt, keep records for 10 years.

Can I use a spreadsheet to track invoices?

Yes, a spreadsheet works well at low volume. Create columns for: invoice number, client, amount, issue date, due date, status, and payment date. Sort by status to quickly see outstanding invoices. At higher volume (30+ invoices/month), dedicated software saves meaningful time.

Free Private Invoice Generator — No Account, No Sign-Up

Sending an invoice is half the job. Knowing what you've sent, what's been paid, and what's sitting overdue in a client's inbox — that's the other half. Without a tracking system, invoices disappear into the noise: buried in email threads, forgotten follow-ups, missed payment dates.

Here's how to build a tracking system that keeps your receivables visible — no complex software required.

The Core Problem: Invoice Chaos

Without a tracking system, invoices get lost. You might:

Forget to follow up on an overdue payment
Lose track of which version of an invoice was sent
Fail to notice that a client paid twice (or not at all)
Have no clear picture of your monthly receivables

The solution isn't necessarily expensive software — it's a clear, consistent process.

Invoice Statuses: The Foundation of Tracking

Every invoice should have one of five statuses at all times:

Draft — Created but not yet sent. Not yet a payment request.
Sent — Delivered to the client. Payment clock is running.
Paid — Payment received and confirmed. Archive.
Overdue — Past the due date without payment. Needs immediate follow-up.
Cancelled — Voided for any reason. No payment expected.

invoicePrivate tracks these statuses for you. Every invoice in your list shows its current status, and you can update it as payments come in.

The Minimal Tracking Workflow

When You Create an Invoice

Set the invoice to Draft. Include the correct due date. Double-check the client name, amount, and payment details before sending.

When You Send the Invoice

Mark it as Sent. Note the exact date sent. This starts your payment window — if it's Net 30, your due date is 30 days from today.

When a Payment Arrives

Match the payment to the invoice and mark it Paid. For bank transfers, match by amount + client name. Keep the transaction reference if available.

When an Invoice Goes Overdue

Mark it Overdue and trigger your follow-up process immediately. A same-day follow-up signals that you're attentive and serious about your payment terms.

How to Follow Up on Overdue Invoices

Most late payments are simple oversights. A professional follow-up process:

Day 1 Overdue — Friendly Check-in

"Hi [Name], I noticed invoice #INV-001 for [amount] was due on [date]. Could you confirm when payment will be processed? Let me know if you have any questions."

Day 7 Overdue — Firm Reminder

"Hi [Name], I'm following up on invoice #INV-001 for [amount], now 7 days overdue. Please process payment by [new date] to avoid a late payment fee of [X]%."

Day 14+ Overdue — Escalation

Consider a phone call, a formal demand letter, or — for significant amounts — involving a collections agency or taking legal action through small claims court.

Monthly Invoice Review

Set aside 15 minutes at the start of each month to review:

All invoices still in "Sent" status — are they overdue?
All invoices in "Overdue" status — what's the latest follow-up status?
Total receivables — how much is outstanding and when is it due?
Revenue booked this month — paid invoices from the past 30 days

This 15-minute habit gives you a complete picture of your financial position and ensures nothing falls through the cracks.

Invoice Numbering for Easy Tracking

A consistent numbering system makes tracking and cross-referencing easy. Recommended formats:

INV-2025-001 — Year-sequential. Easy to sort and filter by year.
INV-001 — Simple sequential. Good if you invoice infrequently.
CLIENT-001 — Client-prefixed. Good if you have a few key clients with high invoice volume.

Whichever you choose, stick to it — consistency makes searching and reconciling faster.

When to Upgrade to Full Invoicing Software

A local invoice generator handles most freelancer and small business needs. Consider upgrading to full invoicing software when you:

Have more than 2–3 employees who need to send invoices
Need direct payment gateway integration (Stripe, PayPal built-in)
Require accounting integration (QuickBooks, Xero)
Send more than 30–40 invoices per month
Need automated payment reminders

For everyone else, a simple tracking workflow plus a good invoice generator is all you need.

How to Track Your Invoices: A Simple System for Freelancers