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."
  1. For Group Outstandings: Select the desired supplier/customer group (e.g., Sundry Debtors for receivables, Sundry Creditors for payables).
  2. For Ledger Outstandings: Select the specific supplier/customer account.

1. Ageing Analysis:

  1. 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:

  1. 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):

PartyLast Bill DateTotal0-30 Days31-60 Days>60 Days
ABC Company2024-05-20Rs. 10,000Rs. 5,000Rs. 3,000Rs. 2,000
XYZ Enterprises2024-05-15Rs. 8,000Rs. 8,000

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:

  1. 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.

Comments

Leave a Reply

Your email address will not be published. Required fields are marked *