Go to Reports -> Aging Report. This report categorizes your club's account receivables according to the length of time the debt has been outstanding. You can select the cut-off date of your choice and can export the report to CSV:
What is Accounts Receivable Aging
Accounts receivable aging is a periodic report that categorizes a facility's accounts receivable according to the length of time an invoice has been outstanding. It is used as a gauge to determine the financial health of a facility's customers. If the accounts receivable aging shows a facility's receivables are being collected much slower than normal, this is a warning sign that business may be slowing down or that the facility is taking greater credit risk in its sales practices.
Accounts receivable aging, as a management tool, can indicate that certain customers are becoming credit risks, and may reveal whether the facility should keep doing business with customers that are chronically late payers. Accounts receivable aging has columns that are typically broken into date ranges of 30 days and shows total receivables that are currently due, as well as receivables that are past due.
Accounts Receivable Aging Report
The report, or table, depicting accounts receivable aging provides details of specific receivables based on age. The specific receivables are aggregated at the bottom of the table to display the total receivables of a facility, based on the number of days the invoice is past due. The typical column headers include 30-day windows of time, and the rows represent the receivables of each customer. Here's an example of an accounts receivable aging report.
Allowance for Doubtful Accounts
Accounts receivable aging is useful in determining the allowance for doubtful accounts. When estimating the amount of bad debt to report on a facility’s financial statements, the accounts receivable aging report is useful to estimate the total amount to be written off. The primary useful feature is the aggregation of receivables based on the length of the invoice that has been past due. A facility applies a fixed rate of default to each date range. Invoices that have been past due for longer periods of time are given a higher default rate as a result of the higher likelihood of default. The sum of the products from each outstanding date range provides an estimate regarding the number of uncollectible receivables.
Benefits and Improving Accounts Receivable Aging
The findings from accounts receivable aging reports may be improved in various ways. First, accounts receivable are derivations of the extension of credit. If a facility experiences difficulty collecting accounts, as evidenced by the accounts receivable aging report, specific customers may be extended business on a cash-only basis. Therefore, the aging report is helpful in laying out credit and selling practices. Also, accounts receivable aging reports mailed to customers along with the month-end statement provide a detailed account of outstanding items. Therefore, an accounts receivable aging report may be utilized by internal as well as external individuals.