Modify Age Invoice For Free

Aging involves categorizing a company's unpaid customer invoices and credit memos by date ranges. Schedules can be customized over various time frames, although typically these reports list invoices in 30-day groups, such as 30 days, 31?60 days, and 61?90 days past the due date.

To calculate the A/R aging of her customer's account, she'll multiply the average accounts receivable by the fiscal year and divide by the total credit sold to determine that it takes approximately 60 days to receive payment from this customer.

The age of an invoice is the number of days between the specified invoice date and the aging date.

To calculate the age of an invoice in days, you can use a formula that subtracts the invoice date from today's date using the `TODAY` function. For example, if your invoice date is in cell C5, you can use the formula `=TODAY()-C5` to calculate the age of the invoice in days ¹.

A typical aging report groups receivables into buckets based on the elapsed time since the invoice was due, such as current, 1-30 days, 31-60 days, 61-90 days and over 90 days. Aging is primarily used to help gauge the quality of a company's receivables.

An accounts receivable (AR) aging report tells how long an invoice has been due for payment. All the unpaid invoices, along with the complete customer details, will be listed out in aging reports, giving you a good overview of the actual health of your receivables and cash flow.

A typical aging report groups receivables into buckets based on the elapsed time since the invoice was due, such as current, 1-30 days, 31-60 days, 61-90 days and over 90 days. Aging is primarily used to help gauge the quality of a company's receivables.