View Bills Age-wise in TallyPrime: 2 Methods + Examples

Absolutely! Here’s how to view bills (purchase or sales) age-wise in TallyPrime:

There are two main approaches to achieve this:

Method 1: Using the Outstandings Report (Group or Ledger)

1. Go to the Gateway of Tally (Alt+F12) in TallyPrime.
2. Navigate to one of the following options depending on your preference:
   • Display > Statements of Accounts > Outstandings > Group (for bills related to a specific supplier/customer group).
   • Display > Statements of Accounts > Outstandings > Ledger (for bills related to a specific supplier/customer account).

Alternatively, you can use keyboard shortcuts:

* Press `Alt+G` (Go To) and type or select "Group Outstandings" or "Ledger Outstandings."

3. For Group Outstandings: Select the desired supplier/customer group (e.g., Sundry Debtors for receivables, Sundry Creditors for payables).
4. For Ledger Outstandings: Select the specific supplier/customer account.

1. Ageing Analysis:

5. Press F6 (Ageing Method) to configure the age analysis settings.

• Ageing by Bill Date: Considers the voucher entry date for displaying outstanding amounts.
• Ageing by Due Date: Considers the due date mentioned in the bill for displaying outstanding amounts.

2. Define Age Slabs:

6. Set the desired age periods (e.g., 0-30 days, 31-60 days, etc.) for categorizing outstanding bills. You can achieve this by:
   • Entering values directly in the “From” and “To” fields for each age slab.
   • Utilizing the “Set” buttons to define pre-defined ranges (e.g., 1-30, 31-60).

3. View Bills Age-wise:

The report will display information like:

• Party: Name of the supplier/customer.
• Last Bill Date: Date of the most recent bill.
• Total: Total outstanding amount for this party.
• Age Slabs: User-defined categories representing different outstanding bill age ranges.
• Amount (for each Age Slab): Breakdown of the total outstanding amount according to the defined age slabs. This shows how much is outstanding for a specific period.

Example (Using Sundry Debtors Group and Ageing by Due Date):

Benefits of Using Outstandings Report Method:

• Analyzes outstanding receivables (for sales) or payables (for purchases) based on their age.
• Helps identify overdue payments and prioritize collection efforts.
• Provides insights into overall payment collection efficiency.

Method 2: Using the Bills Receivable/Payable Report (with Ageing Method)

1. Go to the Gateway (Alt+F12) in TallyPrime.
2. Navigate to one of the following options depending on your requirement:
   • Display > More Reports > Statements of Accounts > Outstandings > Receivables (for outstanding sales bills).
   • Display > More Reports > Statements of Accounts > Outstandings > Payables (for outstanding purchase bills).

Alternatively, you can use keyboard shortcuts:

* Press `Alt+G` (Go To) and type or select "Bills Receivable" or "Bills Payable."

1. Ageing Analysis:

3. Press F6 (Ageing Method) to configure the age analysis settings as explained in Method 1 (Ageing by Bill Date or Due Date).

2. View Bills Age-wise:

The report will display information similar to the Group/Ledger Outstandings report, but specifically focused on outstanding bills (receivable or payable).

Choosing the Right Method:

1. Group/Ledger Outstandings:

If you want to analyze outstanding bills for a specific supplier/customer group or account.

2. Bills Receivable/Payable:

If you need an overall view of outstanding sales or purchase bills categorized by age.

Additional Considerations:

You can utilize filters.