Ageing Analysis Tool

Calculate ageing days, place each row in an age bucket, and summarise the buckets — for receivables, payables, inventory or any dated list.

Open Ageing Analysis Tool Back to all tools

You need

A sheet with the dates to age: a start and end date, or one date. A column of on-time (credit) days is optional.

You get

Ageing_Analysis.xlsx with a row-level sheet (named after your source sheet) and an “Ageing Summary” sheet.

Your file stays in your browser tab. The tool reads and processes it there and does not upload it. The page loads the SheetJS library from cdnjs.cloudflare.com, so it needs an internet connection to open. How privacy works

How to use it

1. Upload

Choose a .xlsx, .xlsm, .xls or .csv file. The tool lists the sheets with row and column counts and a preview.

2. Data settings

Pick the source sheet and the row where data starts (header in row 1 → enter 2; header in row 3 → enter 4).

3. Ageing method

Start vs End date — ageing = end date − start date (e.g. invoice date and payment date).
Date vs Fixed date — ageing = the fixed date you enter − the row’s date.
Date vs Today — ageing = today − the row’s date. “Today” is the date on your device, so the same file gives different results on different days.

4. On-time days (grace period)

Choose no grace period, a fixed number of days, or a column of days. Ageing starts counting after the grace period; it never goes below 0. When you use grace days, the output also shows Raw Days and On-Time Days.

5. Age buckets

Enter ranges as Lower-Upper, comma separated, e.g. 0-30,31-60,61-90,91-180,181-999999. A lower limit cannot be higher than its upper limit.

6. Summary rules

Add rules such as Count of Invoice No or Sum of Amount. Available functions: Count, Sum, Average, Min, Max. At least one rule is needed before you can run.

7. Run, review, export

Press Run Ageing Analysis. The summary cards show Total Rows, Valid Rows, Skipped (Invalid Dates) and Unclassified. Below are a preview of the first 200 rows and the bucket-wise summary. Press Download Ageing Analysis Excel to save the full results; New Calculation starts over.

Good to know. Rows with a missing or unreadable date are skipped and counted under “Skipped”. Rows whose ageing falls outside every bucket are labelled “Unclassified”.

Typical uses

Vendor and debtor ageing, MSME outstanding analysis, inventory and advance ageing, GRN-pending analysis, internal audit reviews.