Ageing Analysis Report

Ageing analysis of bills outstanding is done to identify the bills for which amount is due for a long period of time. These bills can be classified as bad debts or provisions can be created for such losses in the books of accounts depending on the results of ageing analysis.

In Tally.ERP 9, the ageing analysis can be applied on Ledger or Group Outstandings and Bills Receivables or Payables screen.

Age-wise Analysis of a Single Ledger Account

1. Go to Gateway of Tally > Display > Statements of Accounts > Outstandings > Ledger

2. Select the ledger account.

3. Select F6: Age wise from the button bar in the Ledger Outstandings screen.

4. Select the Ageing method

5. Set the age periods required for the report.

The Ledger Outstandings report appears with the applied ageing method.

Age-wise Analysis for a Group

1. Go to Gateway of Tally > Display > Statements of Accounts > Outstandings > Group

2. Select a Group, e.g. Sundry Debtors

3. Click F6: Age-wise button and select one of the two Methods of Ageing:  Ageing by Bill Date or Ageing by Due Date. Set the age periods required for the report.

The Group Outstandings report appears with the applied ageing method.

4. Click F12: Configure button and set the option Show Nett Balances to Yes.

Age-wise Analysis for a Group will be displayed as shown.

Note: You cannot print Reminder letters  to a group from here. Use Multi-Account Printing available in Gateway of Tally to print the same.

Age-wise Analysis for Bills Receivable/Payable report

Let us consider Bills Receivable report for example.

1. Go to Gateway of Tally > Display > Statements of Accounts > Outstandings > Bills Receivable

2. Click F6: Age-wise button and select one of the two Methods of Ageing:  Ageing by Bill Date or Ageing by Due Date. Set the age periods required for the report.

The Bills Receivable report appears with the applied ageing method.