← All templates

Finance & banking

Receivables ageing report template (US)

A general template under US law. Laws differ from state to state, so check it against your state's law or with a lawyer licensed there. We are not a law firm and do not give legal advice.

Fill in this template
  • Written for US law, with your state left to fill in
  • Fill the blanks in your browser
  • Print or save as PDF; Word is 15 points
  • Start right away, sign in to download

Preview — US standard

Accounts Receivable Aging Report

Company: Company Name

As of: Report Date

Prepared by: Preparer Name

CustomerTotal BalanceCurrent1-30 Days Past Due31-60 Days61-90 DaysOver 90 DaysCredit LimitLast Payment DateNotes
Customer 1$Total 1$Current 1$30 Days 1$60 Days 1$90 Days 1$Over 90 1$Limit 1Last Payment 1Notes 1
Customer 2$Total 2$Current 2$30 Days 2$60 Days 2$90 Days 2$Over 90 2$Limit 2Last Payment 2Notes 2
Customer 3$Total 3$Current 3$30 Days 3$60 Days 3$90 Days 3$Over 90 3$Limit 3Last Payment 3Notes 3
Customer 4$Total 4$Current 4$30 Days 4$60 Days 4$90 Days 4$Over 90 4$Limit 4Last Payment 4Notes 4
Customer 5$Total 5$Current 5$30 Days 5$60 Days 5$90 Days 5$Over 90 5$Limit 5Last Payment 5Notes 5
Total$Grand Total$Total Current$Total 30$Total 60$Total 90$Total Over 90
Percent of total100%Current Percent%30 Percent%60 Percent%90 Percent%Over 90 Percent%

Key Measures

Days sales outstanding (DSO): DSO days

Allowance for doubtful accounts: $Allowance

Collection Actions

CustomerAmountActionOwnerDate
Customer A$Amount AAction, such as Call, Reminder Letter, Credit Hold or CollectionsOwner ADate A
Customer B$Amount BAction BOwner BDate B

Collection activity must follow fair debt collection rules where they apply; consumer debts are subject to the FDCPA and state law.

Reviewed by: Reviewer Name and Signature

Fill it in and download →

Frequently asked questions

Do I need an account to use this template?

Start right away and fill it in in your browser; signing in is needed to download or print. It takes seconds, and every new account gets free points.

How do I save it once filled in?

Fill in the blanks online, then print it or save it as PDF. An editable Word file is 15 points.

Are my files private?

Your files are kept in private storage no one else can reach, and are deleted from the servers automatically within two days at most.

Related templates