Build an accounts receivable aging schedule
Intermediate AccountantAccounts receivable aging helps accounting teams see which invoices are current and which ones are slipping overdue. It is a standard reporting view because it highlights collection priorities and gives a quick read on credit risk.
In this exercise, you will build a simple aging schedule from a list of 15 open invoices. The report date is fixed in B1 so everyone gets the same result.
Your main task is to classify each invoice in E4:E18 into the correct aging bucket. The summary table at the bottom is already set up and will update from your bucket labels.
The values in A21:A25 are the exact bucket names to use: Current, 1-30 days, 31-60 days, 61-90 days, and 90+ days.
Your task:
- Fill the Aging bucket column in E4:E18.
- Use the bucket names shown in the sheet to decide which label belongs to each invoice.
Keep the report date fixed when your bucket formula refers back to B1.
Need some help?
Hint 1
If it helps, first think about each invoice as a number of days relative to the fixed report date in B1.
Hint 2
Use a blank helper column if you want to break the problem into steps. First calculate days outstanding with =DATEDIF(C4,$B$1,"d") or =$B$1-C4, then use that result in your bucket formula.
Hint 3
Pay extra attention to invoices that fall right on a bucket boundary. Testing dates around 30, 60, and 90 days can help you confirm your labels.
Build an accounts receivable aging schedule
Intermediate AccountantAccounts receivable aging helps accounting teams see which invoices are current and which ones are slipping overdue. It is a standard reporting view because it highlights collection priorities and gives a quick read on credit risk.
In this exercise, you will build a simple aging schedule from a list of 15 open invoices. The report date is fixed in B1 so everyone gets the same result.
Your main task is to classify each invoice in E4:E18 into the correct aging bucket. The summary table at the bottom is already set up and will update from your bucket labels.
The values in A21:A25 are the exact bucket names to use: Current, 1-30 days, 31-60 days, 61-90 days, and 90+ days.
Your task:
- Fill the Aging bucket column in E4:E18.
- Use the bucket names shown in the sheet to decide which label belongs to each invoice.
Keep the report date fixed when your bucket formula refers back to B1.
Need some help?
Hint 1
If it helps, first think about each invoice as a number of days relative to the fixed report date in B1.
Hint 2
Use a blank helper column if you want to break the problem into steps. First calculate days outstanding with =DATEDIF(C4,$B$1,"d") or =$B$1-C4, then use that result in your bucket formula.
Hint 3
Pay extra attention to invoices that fall right on a bucket boundary. Testing dates around 30, 60, and 90 days can help you confirm your labels.