Ageing analysis in tally


CA Ramsai N (Fresher)     26 June 2013

CA Ramsai N
Fresher 
 61 likes  594 points

| My Other Post

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

Age_wise_Receivables_-01.gif

  1. Set the age periods required for the report.

Ageing-analysis.gif

The Ledger Outstandings report appears with the applied ageing method.

2B_Ageing_Analysis_Report-2.gif

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.

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

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

2B_Ageing_Analysis_Report-5.gif

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.

3GroupAgeing.gif

avater

CA Deepak Rathore (EXPERT)     27 June 2013

CA Deepak Rathore
EXPERT 
 25 likes  281 points

View Profile | My Other Post

while doing this I have an issue one column"ON ACCOUNT' appears

What does it mean???

Second I want to make ageing on the basis of entry date, there is no bill to bill payment

therefore on fifo basis

Can i get rid  of "On ACCOUNT COLUMN problem"

 

1 Like
avater

CA Ramsai N (Fresher)     27 June 2013

CA Ramsai N
Fresher 
 61 likes  594 points

View Profile | My Other Post

Originally posted by : deepak rathore

while doing this I have an issue one column"ON ACCOUNT' appears

What does it mean???

Second I want to make ageing on the basis of entry date, there is no bill to bill payment

therefore on fifo basis

Can i get rid  of "On ACCOUNT COLUMN problem"

 

It will give good results if you maintain the accounts on Bill to bill basis rather on account basis

avater

CA Deepak Rathore (EXPERT)     27 June 2013

CA Deepak Rathore
EXPERT 
 25 likes  281 points

View Profile | My Other Post

bt now can i solve the problem of "ON ACCOUNT"

plz explain

avater

CA Ramsai N (Fresher)     27 June 2013

CA Ramsai N
Fresher 
 61 likes  594 points

View Profile | My Other Post

You can't solve but you can implement from current year.

You can solve but it will become tedious job.

You ve to adopt every bill with "new reference"  and adjust the payment against with "Agaist reference"

 

2 Like
avater

Rajendra Panshikar   27 October 2018

Rajendra Panshikar

 2 points

View Profile | My Other Post

I think Tally should provide more options in creating Age Reports, As mentioned above by Mr.Deepak Rathore it should allow to select age by Transaction Date, on FIFO basis, the On Account/Advance Amount Balance should get Adjusted in order of Totals at Age Brackets and the final age oustanding should appear. i.e.There could be unallocated Advance receipts which should get Auto adjusted based on the brackets, if first bracket example 30-60 has no o/s or negative figure than it keep the balance after adjusting the advance, if there is a advance excess than first bracket it to flow to o/s at 60-90 and so on.

Apart from this, I am seeking more knowledge on this. how do we derive Age reports, if the payment terms based on LC, if Invoice is raised prior Dispatch of Material, What if the SO Order terms despatch/Invoiced partially and payment in Full at the time of Final Dispatch or incase there is partial advances ?, this may even more complicated in case of Multi Currency transaction, As I had worked on not multi currency but on Cross currency transactions !!

Hopefully my query is correct and will have somefeedback. 

Team Thank you in advance

 

Nirav Shihora (Assignment base work)     05 February 2019

Nirav Shihora
Assignment base work 
 1 likes  68 points

View Profile | My Other Post

Your are required to paste Sales Register and Debtors Register exported from tally in the file attached for your working of aging for debtors.

You can also contact Tally service provider who make ADD on for the relevant purpose.

 

Nirav Shihora (Assignment base work)     05 February 2019

Nirav Shihora
Assignment base work 
 1 likes  68 points

View Profile | My Other Post

Your are required to paste Sales Register and Debtors Register exported from tally in the file attached for your working of aging for debtors.
 
 
You can also contact Tally service provider who make ADD on for the relevant purpose.
 


Attached File : 400196 20190205201618 debtorsout .xls downloaded: 121 times
avater

MARUTI ASSOCIATES   15 February 2019

MARUTI ASSOCIATES

 4 points

View Profile | My Other Post

pls give password of protected sheet sir ji

Nirav Shihora (Assignment base work)     15 February 2019

Nirav Shihora
Assignment base work 
 1 likes  68 points

View Profile | My Other Post

pleaae share email i will send unprotected sheet


Leave a reply

Your are not logged in . Please login to post replies

Click here to Login / Register  




Popular Discussion


view more »