Free Tool
Free Accounts Receivable (AR) Aging Calculator
Enter outstanding invoice totals for each aging bucket (0–30, 31–60, 61–90, 90+ days) to see the total AR, percentage breakdown, and focus areas for collections.
Tool workspace
Run the tool below, then copy or reuse the cleaned output in your spreadsheet or finance workflow.
- Track which invoices are overdue and need follow-up.
- Aging buckets help prioritize collection efforts.
- High 90+ day balances may need provision for bad debt.
Output
Total AR: $90,000.00
Aged over 60 days: $15,000.00
| Bucket | Amount | % of total |
|---|---|---|
| 0–30 days | $50,000.00 | 55.6% |
| 31–60 days | $25,000.00 | 27.8% |
| 61–90 days | $10,000.00 | 11.1% |
| 90+ days | $5,000.00 | 5.6% |
Input stays in your browser. No upload is required for these free tools.