It means calculating Age of Debtors i.e.number of days from which amount is due from debtors

 

Points to be considered while creating debtor ageing report

  1. While creating ledgers of parties, we have to mention credit period.
  2. Mention invoice no. Of the parties while doing entries of sale and receipt of payment.(New Reference/Against Reference/Advance or On Account)

    For new bills

    Select N ew Ref

    Enter invoice no.

    Credit period allowed

    Put Amount of bill

     

    Receipt of payment(if bill avlbl)

    Select A gst Ref

    Enter invoice no.

    Credit period allowed

    Put Amount of bill

     

    Payment received in advance

    Select =A dvance

    Enter A dvance date

    Credit period allowed

    Put Amount of bill

     

    Where  bill number not available

    Select O n Account

    Put Amount of bill

  3. After completing all the entries, we have to create periodically debtor aging report.
    • Select Co. In tally
    • Display
    • Statement of accounts
    • Outstanding
    • Receivables
    • Select period
    • F6 age wise
    • Ageing by due date
    • Select criteria as required by company 
      • From 0 to 30 days
      • From 30 to 60 days
      • 60 to 180 days
  4. Then export in Excel (Alt E --> Esc --> Put file Name --> Select Excel format --> Ctrl A or Enter Enter)
  5. After discussing with the management, we have to make provisions for the bad debts and write off the actual bad debts occurred during our period.

tally (First bill payment).jpg

 

DEBTOR AGING ASSIGNMENT

  1. Sales made to A Ltd 30000+ vat 5%(Bill No S01 dated 01/04/2016)
  2. Sales made to B Ltd 80000+ vat 5%(Bill No S02 dated 01/05/2016)
  3. Sales made to A Ltd 100000+ vat 5%(Bill No S03 dated 01/06/2016)
  4. Amount received from B Ltd towards Bill S02 ( Rs 70000 by cheque and balance by cash) on 01/07/2016
  5. Rs 80000 received by cheque towards Bill No S03 on 1/08/2016
  6. Advance received from C ltd by NEFT Rs 10000 form goods to be sold on 1/09/2016
  7. Sales made to C Ltd 20000+ vat 5%(Bill No S04 dated 01/10/2016
  8. Amt received from C ltd by cash in full settlement Rs 7000 on 1/11/2016
  9. On 31 March 2017, The company estimates that only Rs 25000 more is recoverable from A ltd regarding both bills
  10. Rs 20000 received from A ltd in full settlement by cash on 1/05/2017
Go Ad-free
CA Maninder Singh's photo - Co-founder, Teachoo

Made by

CA Maninder Singh

CA Maninder Singh is a Chartered Accountant for the past 14 years. He also provides Accounts Tax GST Training in Delhi, Kerala and online.