How to Track Unpaid Invoices

The aging-bucket framework

Every accounts-receivable system in the world tracks unpaid invoices using the same four aging buckets. Memorize them — they organize every conversation about cash flow:

0–30 days past invoice date. Current. Most B2B clients pay during this window. No action needed beyond ensuring the invoice reached the right person.
31–60 days. Past due. Send a friendly reminder around day 35, a more formal one around day 50 if still unpaid.
61–90 days. Seriously past due. Send a formal demand letter. Pause new work for the client until the account is current.
90+ days. Likely bad debt. Decide whether to escalate to collections, small claims, or write off. Probability of full collection drops sharply past 90 days.

The weekly AR review

The single most-impactful habit is a recurring weekly AR review — 30 minutes, same day every week, the only purpose is to look at every unpaid invoice and decide what (if anything) needs to happen this week. The workflow:

Pull the aging report. From your invoice tracker, accounting software, or both. Sort by days past due, descending.
Anything in 31–60 bucket: send a reminder if you have not in the last week.
Anything in 61–90 bucket: formal demand letter or phone call. Pause new work for that client.
Anything 90+: decide path forward this week, not “soon.” Collections, small claims, or write-off — pick one.
Anything you marked for follow-up last week: follow up.

Without the recurring time block, weeks pass and accounts age silently into the bad-debt zone. The single 30-minute block per week is what prevents that.

Reminder cadence and tone

The right reminder cadence escalates progressively without burning the relationship:

Day 3–7 past due — friendly check-in. “Hi [name] — just wanted to confirm you received invoice INV-XXX dated [date]. Let me know if anything is needed.” Email or call. Tone is light. Many slow payments are not refusals; they are forgotten or stuck in AP.
Day 14 — first formal reminder. Email with a copy of the original invoice attached. State the amount, the due date that has passed, and a new clear pay-by date (typically 5–7 business days out).
Day 21–28 — escalation. Reference the late-fee policy from the original invoice. Phone call to the client's AP or the decision-maker, not just email. Most B2B accounts pay within a week of the phone call.
Day 35–45 — formal demand letter. Mailed or emailed letter referencing the invoice, the contract or work agreement, prior reminder attempts, the amount due, and a final deadline. State what happens next if the deadline is missed (collections, small claims).
Day 60+ — escalation path. Collections agency, small claims court, or bad-debt write-off. Each has different cost/recovery tradeoffs.

The tools that make this manageable

You need three things to run AR well: clean invoices, a tracker that shows the aging at a glance, and reminder/demand letter templates ready to send. The Professional Invoice Template Pack includes all three:

Invoice + tracker + reminder letter

Professional Invoice Template Pack

Complete invoicing toolkit with tracker, payment receipts, and late-payment letters

$19.99View Invoice Pack →

Preventing unpaid invoices in the first place

The cheapest collection is the one you never need. Three habits dramatically reduce the share of invoices that go past due:

Send the invoice the same day work is completed. Memory fades fast — invoices sent 10 days after completion get paid 10 days later (or more).
State payment terms and late-fee policy on every invoice. Clients who see a late-fee clause pay on time more reliably than clients who do not.
Offer one or two friction-free payment methods. ACH, payment link (Stripe, PayPal), or credit card with surcharge. Make it as easy as possible to actually pay.

Tools and resources

Invoice calculator — totals with tax, discount, shipping, balance due
Profit margin calculator
Break-even calculator — how unpaid receivables affect break-even
What to include on a formal invoice
Free vs paid invoice templates
Freelancer business hub

For the broader finance toolkit — invoicing, P&L, expense tracking, proposals — the Complete Finance Bundle ($44.99) packages everything together.

Unpaid invoice tracking FAQs

How often should I review unpaid invoices?

Weekly is the practical minimum. Set a recurring 30-minute block — pick a day, stick to it. Pull the AR aging report, send any reminders that are due, escalate anything past 60 days. Daily review is overkill except during cash-flow crunches; monthly review is too infrequent and lets things drift past collection-effective windows.

When should I send the first reminder?

A friendly reminder around 3–7 days past the due date is usually appropriate. The tone is light: "Just wanted to confirm you received invoice INV-XXX." Many slow payments are not refusals — they are forgotten or stuck in the client's AP system. A friendly reminder resolves a large fraction without escalation.

When should I get more formal?

At 14–21 days past due, send a formal late-payment notice referencing the original invoice number, the amount due, the late-fee policy from the original invoice, and a clear pay-by date. Tone stays professional, not confrontational. Most B2B accounts pay within a week of the formal notice once they realize you are tracking it.

When should I stop sending reminders and escalate?

Past 60 days, your collection probability drops sharply. By 90 days it falls again. At 60+ days, options include: a formal demand letter with a specific deadline before further action; turning the account over to a collection agency (you typically keep 50–70% of recovered amounts after their fee); pursuing small claims court for amounts under your state's small claims limit; or writing off as bad debt for tax purposes if the relationship is unrecoverable.

Should I charge late fees?

Late fees are only enforceable if they were disclosed in the original invoice or signed agreement. Common rates: 1.5% per month (18% APR) or a flat fee ($25–$50) after a stated grace period. Even when you do not actually collect them, having them stated on the invoice signals that you treat payment seriously — most clients pay faster when they see a late-fee clause.

What about partial payments?

Apply them per your written policy (which should be on the invoice). The most common approach is: partial payment applies to the oldest invoice first, then to late fees, then to current invoices. State this clearly in your payment terms so you are not adjudicating it mid-dispute. Some businesses apply partial payments to the late fee first to protect the principal — both approaches are defensible if disclosed.