Ageing analysis in tally

Tally 24811 views 10 replies

Age-wise Analysis of a Single Ledger Account

Go to Gateway of Tally > Display > Statements of Accounts > Outstandings > Ledger
Select the ledger account.
Select F6: Age wise from the button bar in the Ledger Outstandings screen.
Select the Ageing method

Set the age periods required for the report.

The Ledger Outstandings report appears with the applied ageing method.

Age-wise Analysis for a Group

Go to Gateway of Tally > Display > Statements of Accounts > Outstandings > Group
Select a Group, e.g. Sundry Debtors
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.

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

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

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.

Go to Gateway of Tally > Display > Statements of Accounts > Outstandings > Bills Receivable
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.

Replies (10)

CA Deepak Rathore

EXPERT

281 Points Joined December 2010

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"

CA Ramsai N

Fresher

594 Points Joined October 2011

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

CA Deepak Rathore

EXPERT

281 Points Joined December 2010

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

plz explain

CA Ramsai N

Fresher

594 Points Joined October 2011

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"

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