Free Invoice Generator

Invoice aging report

Upload a CSV of your unpaid invoices, or paste it in, and the sheet groups what you are owed by how many days late it is, for each currency and each client. The file stays on your device.

Your unpaid invoices

Export from your spreadsheet or accounting tool. It needs at least an amount and a due date for each invoice.

Commas, semicolons or tabs. A paste straight from a spreadsheet works.

Days overdue are counted to this date.

Only matters for dates written with slashes or dots.

What an aging report shows

An accounts receivable aging report sorts what customers owe you by how long it has been due. The usual groups are not yet due, 1 to 30 days overdue, 31 to 60, 61 to 90 and over 90. The further right the money sits, the less likely it is to be paid without a push, which is why the oldest debts are listed first.

An invoice counts as overdue from the day after its due date. Amounts in different currencies are kept apart, because adding pounds to euros gives a number that is not either.

What the file needs

  • One row per unpaid invoice, with a header row first.
  • An amount still owed, such as 1250.00, 1,250.00 or 1.250,00. Currency signs are ignored, and a minus or brackets make it a credit, which reduces the total.
  • A due date, as 2026-10-31, 31/10/2026, 10/31/2026 or 31 Oct 2026. For slashed dates the page works out which way round they are where it can, and asks where it cannot.
  • Optional: client, invoice number, currency, and a status column, where rows marked paid, settled, closed or void are left out.

What this report does not do

  • It does not convert currencies. Each currency has its own column.
  • It does not know about part payments unless the amount column is what is still owed. Export the balance, not the original total, if your tool has both.
  • It does not keep anything. Close the tab and the data is gone. Nothing is sent to us.

Related

For an invoice that is late, the payment reminder email generator writes the follow-up, and the late payment interest calculator works out what statutory interest it has run up. For one figure to track month by month, the DSO calculator turns the total owed into days sales outstanding. The guide to chasing a late invoice sets out what to send when.

Last updated 5 October 2026