Skip to content

Invoice Aging Calculator

How old every unpaid invoice is, and which bucket it has fallen into.

Quick Tool Overview

The Invoice Aging Calculator ages every unpaid invoice against its due date and places it in the standard receivables buckets — current, 1–30, 31–60, 61–90 and over 90 days — reporting both the count and the value in each, because they tell different stories.

What it does
Ages unpaid invoices into buckets
You give it
A list of unpaid invoices with due dates
You get back
Count and value in each age band
Best for
Knowing which debts are actually at risk
Invoice Tools Free, unlimited use No sign-up Runs in your browser

About the Invoice Aging Calculator

The age of a debt is the best single predictor of whether it will ever be paid. An invoice thirty days overdue is usually an administrative problem. One ninety days overdue is a commercial one, and the recovery rate falls sharply with every month after that.

This takes a list of unpaid invoices — pasted from a spreadsheet, an accounting export or typed by hand — and works out the age of each against its due date, placing it in the standard buckets every accounts-receivable ledger uses: current, 1–30, 31–60, 61–90 and over 90 days.

It reports the value in each bucket as well as the count, because those tell different stories: twenty small invoices in the 1–30 bucket is a process problem, while one large invoice past ninety days is a conversation you should already be having. Nothing you paste is uploaded — the whole calculation runs in your browser.

Key features of the Invoice Aging Calculator

Standard buckets

The bands every accounts-receivable ledger uses.

Aged from the due date

Not the invoice date, which makes Net 60 look overdue.

Count and value

Twenty small recent invoices is a different problem from one large old one.

Part payments handled

The balance ages, not the original amount.

Nothing uploaded

A receivables ledger is a list of who owes you what.

How to use the Invoice Aging Calculator

  1. 1

    Paste your unpaid invoices

    Number, customer, due date and amount, from a spreadsheet or an export.

  2. 2

    Set the date to age against

    Today, or a month end if you are reporting.

  3. 3

    Read the buckets

    Count and value in each, because they tell different stories.

  4. 4

    Look at the oldest first

    Age predicts recoverability better than size does.

  5. 5

    Export the working

    CSV of every invoice with its age and bucket.

Frequently asked questions

The standard bands an accounts-receivable ledger groups unpaid invoices into: current (not yet due), 1–30 days overdue, 31–60, 61–90, and over 90. After ninety days the exact age stops changing what you do about it.

Reviews of the Invoice Aging Calculator

What people who use the Invoice Aging Calculator think of it. Reviews come from visitors and are posted as written.

No ratings yet

Yours would be the first.

  • 5 0 reviews rated 5 stars
  • 4 0 reviews rated 4 stars
  • 3 0 reviews rated 3 stars
  • 2 0 reviews rated 2 stars
  • 1 0 reviews rated 1 star

Write a review

Used this tool? Your rating helps the next person decide.

Your rating

Plain text only — links, email addresses and HTML are not accepted. Your name and review are shown publicly; nothing else is collected. See the privacy policy.

0 reviews

Newest first

No reviews yet

Be the first to rate the Invoice Aging Calculator. It takes half a minute and no account.

Write the first review

More invoice tools