TOOLS CLUB TEMPLATE

Late Payment & Fee Tracker

Chasing a late payment usually takes more than one follow-up, and it’s easy to lose track of who you last contacted, when, and whether a late fee actually applies. This tracker logs every overdue invoice with its follow-up history and any fees applied, in one place.

Join the Tools Club — $7/mo Already a Member? Log In

Included in the $7/mo Tools Club · Works in Excel or Google Sheets · Includes a built-in AI prompt

Who this is for

Businesses that charge late fees and need to track when they apply
Anyone managing multiple overdue accounts at once
Business owners who’ve lost track of a follow-up before
Bookkeepers managing a formal collections process

What's included

Overdue invoice log with original due date and days late
Follow-up history with dates and notes per contact attempt
Late fee calculation and tracking
Built-in AI prompt to draft your next follow-up message based on the history

Why use a template instead of starting from scratch?

Following up on a late payment without a record of what’s already been said and when means either awkwardly repeating yourself or letting an account go quiet too long. A structured log keeps every step of the collection process visible and consistent.

How to Use This Template

Download and open in Excel or Google Sheets

Requires a Tools Club membership — log in first to access the file.

Log an invoice here once it becomes overdue

Note the original due date and how many days late it currently is.

Record each follow-up attempt

Date, method (email, call), and a brief note on the response, if any.

Apply a late fee if your terms include one

The tracker calculates it based on your stated policy.

Run the built-in AI prompt before your next follow-up

Attach the saved file to ChatGPT or Claude and ask for a draft message appropriate to how overdue and how many times you’ve already followed up.

Built-in AI prompt

Once you've filled this template in, it includes a ready-to-use prompt at the bottom of the sheet. Attach your saved file to ChatGPT, Claude, or any AI chat tool and paste it in — you'll get plain-English feedback on a draft follow-up message appropriate to how overdue this specific invoice is and how many times you’ve already reached out, no accounting background required.

Common Mistakes to Avoid

Applying late fees inconsistently

If your terms state a late fee applies, apply it consistently across clients — inconsistent enforcement is harder to defend if ever questioned.

Not documenting follow-up attempts

Without a record, it’s easy to either follow up too aggressively or let too much time pass between contacts — log every attempt.

Escalating tone too quickly

Early follow-ups should generally stay friendly; firmness should increase gradually as an account gets progressively more overdue.

Never deciding on a stopping point

Have a clear internal policy for when an account moves from friendly follow-up to a firmer collections process or, eventually, a write-off decision with your accountant.

Frequently Asked Questions

Can I legally charge a late fee?

This depends on your jurisdiction and, critically, whether your original invoice or contract terms disclosed the late fee upfront — check applicable regulations and clearly state your late fee policy on invoices before relying on it.

What’s a typical late fee amount?

Common approaches include a flat fee or a monthly percentage (often 1-2%) on the overdue balance — check what’s standard and legally permitted in your industry and location.

How many times should I follow up before escalating?

There’s no fixed rule, but a common pattern is a friendly reminder shortly after the due date, a firmer follow-up a couple weeks later, and a final notice before considering further collections action.

Is this included in the free plan?

No, this is a Tools Club template. iLuvAccounting also has a free AR Aging Report Template if you want the broader overdue-balance overview first.

Should I use this alongside the AR Aging Report?

Yes — the aging report shows you which accounts need attention at a glance; this tracker manages the actual follow-up process and history for each one.

What if a client disputes a late fee?

Having your documented terms and a clear follow-up history (both captured in this tracker) makes resolving the dispute much easier than relying on memory.

At what point should I stop extending credit to a chronically late client?

This is a business judgment call — if a pattern is clear in your tracker, consider requiring upfront payment or a deposit for that client going forward.

Related Templates

Related Resources

Want the Full Template Library?

70+ editable templates, each with a built-in AI prompt. $7/month, cancel anytime.

Join the Tools Club