Ask Joey ™ a Question

How to prepare an AR aging analysis?

This method categorizes the expenses based on a schedule that categorizes the number of days or months outstanding. Management must apply a percentage uncollectible estimate to each aging bucket.

Once management has the percentage estimate for each bucket, you multiply the figures, and you get the expected uncollectible amount for each aging bucket. The total reserve is then the sum of the uncollectible estimates for each aging bucket!

AR aging analysis

You might also be interested in...

  • How do you calculate the allowance for bad debt reserve using the percentage of accounts receivable method?

    This method computes the estimated allowance for uncollectible accounts based on the amount of year-end accounts receivables. This amount will be the amount that will compute as the year-end allowance account balance. You will then be able to back into the current year expense (aka the recorded bad debt expense).

  • How to calculate the allowance for bad debt reserve using the percentage of sales method?

    Under the percentage of sales method, the company would multiply the amount of credit sales in the year by the bad debt expense % estimate. The company would then record the additional bad debt expense to the income statement and increase the allowance reserve.

  • What are the methods used to estimated bad debt under the allowance method?

    The allowance method is the option that is allowed under U.S. GAAP. U.S GAAP leaves it up to the company to determine how they want to implement the allowance method. There are three common options include the percentage-of-sales method, the percentage-of-AR method, and the aging of AR method: