Receivables Aging Report

This receivables aging report turns a list of invoices into the classic aged debtors table. Paste or drop your open invoices with customer, invoice date, amount and any payments, set the as-of date and default terms, and it shows each invoice's due date, days overdue and bucket, then a summary by customer across current, 1–30, 31–60, 61–90, 91–120 and over 120 days, with totals. It runs in your browser.

Aging buckets

BucketDays past due
CurrentNot yet due
1–301 to 30
31–6031 to 60
61–9061 to 90
91–12091 to 120
Over 120121 or more

When to use it

  1. Prepare a month-end aged debtors report.
  2. Decide which customers to chase first.
  3. Estimate a bad-debt allowance.
  4. Review credit limits.
  5. Report receivables to a lender.

How to Use

  1. Set the as-of date and default terms.
  2. Paste or drop the invoice list.
  3. Review each invoice's bucket.
  4. Read the summary by customer.

Features

  1. Due date from terms or column
  2. Six aging buckets
  3. Partial payments
  4. Summary by customer
  5. Overdue share
  6. CSV export
  7. 100% client-side

FAQs

What is an aging report?

A table of unpaid invoices grouped by how long they are overdue, usually by customer.

How are days overdue counted?

From the due date — invoice date plus terms, or the due date you supply — to the as-of date.

Are part-paid invoices included?

Yes, at their remaining balance.

What should I do with 90+ day balances?

Chase them hard and consider a bad-debt provision.

Is anything uploaded?

No. Everything runs in your browser.

Technical Details

For each invoice the due date is taken from a due-date column or the invoice date plus payment terms. Open amount = invoice amount − amount paid; days overdue = as-of date − due date. Open amounts are placed in the current, 1–30, 31–60, 61–90, 91–120 or over-120-day bucket, and totalled by customer and overall, with the overdue share and the amount over 90 days.

Finance & Tax Tools

Finance & Tax Tools

  • Markup and Margin Converter
  • 12-Month Cash Flow Forecast
  • Withholding Tax Calculator (Pakistan)
  • Rental Yield and Cap Rate Calculator
  • Rent vs Buy Calculator
  • Property Transfer Cost Calculator
  • Tip Pool Calculator
  • Wedding Budget Planner