Split Age Invoice For Free

Companies will use the information on an accounts receivable aging report to create collection letters to send to customers with overdue balances. Accounts receivable aging reports may be mailed to customers along with the month-end statement or a collection letter that provides a detailed account of outstanding items.

The age of an invoice is calculated as the elapsed time between its due date and the report date. When calculating aging, open customer invoices (aka receivables) are grouped into buckets based on when payment is due. An open receivable is considered ?current? until its due date.

What Is an Aging Schedule? An aging schedule is an accounting table that shows a company's accounts receivables, ordered by their due dates. Often created by accounting software, an aging schedule can help a company see if its customers are paying on time.

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.

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.

In the AR Review, invoice aging uses the invoice date. You cannot use 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.