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
| Customer | Total Balance | Current | 1-30 Days Past Due | 31-60 Days | 61-90 Days | Over 90 Days | Credit Limit | Last Payment Date | Notes |
| Customer 1 | $Total 1 | $Current 1 | $30 Days 1 | $60 Days 1 | $90 Days 1 | $Over 90 1 | $Limit 1 | Last Payment 1 | Notes 1 |
| Customer 2 | $Total 2 | $Current 2 | $30 Days 2 | $60 Days 2 | $90 Days 2 | $Over 90 2 | $Limit 2 | Last Payment 2 | Notes 2 |
| Customer 3 | $Total 3 | $Current 3 | $30 Days 3 | $60 Days 3 | $90 Days 3 | $Over 90 3 | $Limit 3 | Last Payment 3 | Notes 3 |
| Customer 4 | $Total 4 | $Current 4 | $30 Days 4 | $60 Days 4 | $90 Days 4 | $Over 90 4 | $Limit 4 | Last Payment 4 | Notes 4 |
| Customer 5 | $Total 5 | $Current 5 | $30 Days 5 | $60 Days 5 | $90 Days 5 | $Over 90 5 | $Limit 5 | Last Payment 5 | Notes 5 |
| Total | $Grand Total | $Total Current | $Total 30 | $Total 60 | $Total 90 | $Total Over 90 | |||
| Percent of total | 100% | 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
| Customer | Amount | Action | Owner | Date |
| Customer A | $Amount A | Action, such as Call, Reminder Letter, Credit Hold or Collections | Owner A | Date A |
| Customer B | $Amount B | Action B | Owner B | Date 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
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.
