Free AR Aging Report Template (Excel)

Download and open in Excel or Google Sheets

Works identically in either — no macros or add-ins needed.

List every outstanding invoice with its due date

Pull these from your Accounts Receivable Ledger or invoicing records.

Let the template calculate days overdue and assign the bucket

This happens automatically based on today’s date and each invoice’s due date.

Review the totals by bucket and by customer

The oldest bucket (90+ days) is generally where the collection risk is highest.

Run the built-in AI prompt to prioritize follow-up

Attach the saved file to ChatGPT or Claude and ask which accounts to contact first given the amounts and ages involved.

Only reviewing the aging report occasionally

Run this regularly — weekly or biweekly — so a newly overdue invoice doesn’t sit unnoticed for a full reporting cycle.

Treating every overdue invoice the same regardless of age

A 5-day-late invoice usually just needs a friendly reminder; a 90+ day invoice needs a firmer, more direct approach — the aging buckets exist specifically to guide that judgment.

Not following up on the oldest balances first

The longer an invoice goes unpaid, the less likely it becomes collectible — prioritize the 90+ day bucket even if the dollar amounts are smaller than more recent ones.

Ignoring a pattern with a specific customer

A single customer who consistently lands in the older buckets is a signal worth addressing directly — consider adjusting their payment terms going forward.