Question

I would like to know how to create an AR Aging table in IDEA?

Answer 1

Aging table for AR can be created for any company with the help of followings steps;

1. First of all know the total value of accounts receivable.

2. Next you must know the past records and policy of company about collection and pendency of accounts receivable.

3. Make a 30 days buckets for all invoices.

4. Divide all accounts receivables on the basis of 30 days buckets such as between; 0-30 days, 31-60 days, 61-90 days and 90 + days etc.

5. Finally you will get list of divided accounts receivables in all buckets respectively.

For example;