Accounting template
Accounts Receivable Aging Report Template
See which customers owe money and for how long. Each invoice lands in an aging bucket automatically.
Opening a template uses no credits.
What's inside
| Row | A | B | C | D | E |
|---|---|---|---|---|---|
| 1 | Invoice | Client | Amount | Days | Bucket |
| 2 | 1001 | Client A | 12,000 | 12 | =IF(D2<=30,"0-30",IF(D2<=60,"31-60","60+")) |
| 3 | 1002 | Client B | 8,500 | 45 | =IF(D3<=30,"0-30",IF(D3<=60,"31-60","60+")) |
| 4 | 1003 | Client C | 4,300 | 75 | =IF(D4<=30,"0-30",IF(D4<=60,"31-60","60+")) |
| 5 | 60+ total | =SUMIF(E2:E4,"60+",C2:C4) |
Preview with sample numbers. Formulas are shown in green.
The formulas, explained
E2 =IF(D2<=30,"0-30",IF(D2<=60,"31-60","60+"))
Places the invoice in an aging bucket by days outstanding.
C5 =SUMIF(E2:E4,"60+",C2:C4)
Total amount more than 60 days overdue.
Make it yours by asking
Try a request like this in Tabstra:
"Create an accounts receivable aging report with invoice, client, amount, days outstanding and aging bucket, with totals per bucket"