Preparing agewsie details of debtors from tally

1)normally every one use ageing by due date

2)u can beleive report generated by tally if you confirm that tally was entered with true values 

3)alt+E you can export to excel 

4)for more tips and tally auditors version guide

/forum/tally-erp-9-sample-reports--244467.asp#.UVKdsBwZ114

Thank you

i think u hv forgotten to ans my first ques i.e. in agewise report generated..one coloumn at last i.e."On Account Column" wht does this column denotes..?

Originally posted by : ABHINANDAN JAIN
	Thank you i think u hv forgotten to ans my first ques i.e. in agewise report generated..one coloumn at last i.e."On Account Column" wht does this column denotes..? In report screen ..One more column is showing i.e. "on Account " at last. So my ques is wht does this 'on account' column denotes. Read more at: /forum/details.asp?mod_id=246235&offset=0#.UWoTiaCPjrM

In tally we have the option to maintain bill by bill records of sales or purchases. When we get payment from debtors we have the option to adjust the payment against old bills. If we dont have the reference of any past bills, we have to adjust it on account. and vice versa for purchase case.

Manoj Garg

Mobile:+91-9927199217

www.datacure.blogspot.com

www.passwordtally.blogspot.com

www.datacure.webs.com

@ Manoj garg

Can  we say  "on account column" indicate the new debtors created out of new sale made during current month..is it correct?

No @ abhinandan jain,

New sales always comes to new reference. It is a payment adjusted without providing any reference. or vice versa.

Still not clear..How "on account column" denotes the payment adjusted..this column is showing in agewise reportof  debtors..i.e. payment is not received..still have confusion..

also:

1. If there is both Dr & Cr balance showing in agewise report generated in F6,then wht should we give for the purpose of internal audit report..i mean only dr balance or Net (i.. dr-cr) balance.

2. After clicking Alt+E. for exporting any data &  then ESC ---giving file name as ABC.xls in Output File format column,then not able to recognise where the file has been exported..i mean the destination..how to solve this prob..

3. Suggest any other thing that we can annexe with respect to sundry debtors in Internal audit report other than agewise report.

Thanks for giving ur valauble time..

For you,

I have prepared excel please try your self.

For any further query give you email.