Talk to an expert

Tell us what you need and we will call you back.

🇮🇳 +91

    Glossary · Accounting & Bookkeeping

    Accounts Receivable Aging Schedule

    Definition

    An accounts receivable aging schedule is a report that groups a business's unpaid customer invoices by how long they have been outstanding, for example 0-30, 31-60, 61-90 and over 90 days. It is built from the sales ledger. It shows which customers pay slowly, how much cash is stuck, and how much the accounts may need to provide for doubtful debts.

    • Written by Gautami Deshpande, reviewed by CA Puja Pradhan

    Read the full entry

    At a glance

    Category
    Accounting & Bookkeeping
    In this entry
    What it means for Indian businesses How to read it · Example

    In practice

    01 What it means for Indian businesses

    A single "trade receivables" figure can look healthy and still hide old balances that may never be paid. The ageing schedule splits that figure into fresh and stale amounts. The further right a balance sits, the lower the chance of collecting it in full.

    Businesses use the schedule at collection reviews and at year-end. Auditors use it to test the provision for doubtful debts. Banks ask for it when they assess the receivables behind a cash-credit limit, and they usually give little or no value to old debts.

    Companies following Schedule III of the Companies Act 2013 also disclose trade receivables in age bands in their financial statements: less than 6 months, 6 months to 1 year, 1-2 years, 2-3 years and more than 3 years, split between undisputed and disputed dues, counted from the due date of payment. This ageing schedule was added to Schedule III with effect from 1 April 2021.

    In detail

    02 How to read it

    1. Check the total

      The grand total must agree with trade receivables in the balance sheet.

    2. Look at the current bucket

      A high share in 0-30 days means customers are paying on terms.

    3. Watch the 61-90 bucket

      This is the early-warning zone. Follow up before these debts harden.

    4. Read the over-90 bucket name by name

      This is where provisions and write-offs come from.

    5. Check concentration

      One or two customers owning most of the old balance is a bigger risk than the total suggests.

    Worked example

    03 Example

    An example, not advice on your facts.

    A Gurugram IT services firm has ₹32,00,000 of receivables:

    Bucket Amount (₹) Action
    0-30 days 18,00,000 Current; collecting on terms
    31-60 days 6,50,000 Gentle reminder
    61-90 days 3,00,000 Formal reminder; escalate
    Over 90 days 4,50,000 Consider a doubtful-debt provision
    Total 32,00,000 Agrees with the balance sheet

    Almost all of the ₹4,50,000 is owed by one client. The firm provides for that amount under its provisioning policy, escalates the ₹3,00,000 and reports the concentration to management. The total looked fine; the ageing told the real story.

    Watch out

    04 Common mistakes

    • Counting age from the wrong date. On 60-day terms, ageing from the invoice date makes current invoices look overdue. Decide whether you age from the invoice date or the due date, label it, and use the due date for Schedule III disclosure.
    • Leaving receipts unapplied. Payments not matched to invoices keep paid invoices on the schedule.
    • Ignoring credit notes. Net credit notes against the original invoice before ageing.
    • No provision on old balances. Carrying 90-plus-day debts at full value overstates assets and profit.
    • Reading only the totals. Totals hide single-customer risk.

    An ageing schedule is the evidence; a provision for doubtful debts is the accounting entry that reduces receivables to the amount expected to be collected. Many businesses set a policy, such as a higher percentage provision for older bands, and apply it consistently.

    Questions

    05 Questions people ask

    What is an aging schedule for accounts receivable?
    It is a report that lists each customer's unpaid invoices and sorts them into age buckets, such as 0-30, 31-60, 61-90 and over 90 days. It helps a business decide whom to chase first and how much to provide for doubtful debts.

    Need help with receivables ageing? See our Accounts Receivable Outsourcing or MIS Reporting Services.

    Review and sources

    Written by Gautami Deshpande, reviewed by CA Puja Pradhan

    Sources: Companies Act, 2013 Schedule III (Division I and II) ageing schedules

    Talk to an expert

    Tell us what you need and the right person calls you back.

    🇮🇳 +91

      By sending this form you agree to our privacy policy.

      Get compliance due-date alerts on WhatsApp. Join →