Preparing agewsie details of debtors from tally

Tally 32144 views 7 replies

ABHINANDAN JAIN

CA Student

891 Points Joined August 2009

I want to prepeare a Agewise schedule of Sundry Debtors.

For that i hv also tried :

Gateway of tally----Display----Statement of accounts----Outstanding----Group----sundy Debtors---F6-Selected Ageing by Bill Date----Period selected---After this a report is generated

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.

Further queries:

1. For the purpose of showing it in internal audit report :Wht to select after F6 in b/w ageing by bill date vs Ageing by Due date

2.Wheher report genered after period selection can be relied upon..whether it depicts the true picture of ageing of drs...?

3. If i want it to see in Excel,then pls tell me the step by step procedure of exporting report into excel.

4.if u know suggest any other method to prepare age wise schedule of debtors from tally

5. any other suggestion u want to give..

thank you..

Replies (7)

Ganeshbabu K

Audit and Tax Advisory

48564 Points Joined May 2012

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

ABHINANDAN JAIN

CA Student

891 Points Joined August 2009

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

Manoj Garg

Support on Tally Excel Password Recove

1987 Points Joined September 2008

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

ABHINANDAN JAIN

CA Student

891 Points Joined August 2009

@ Manoj garg

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

Manoj Garg

Support on Tally Excel Password Recove

1987 Points Joined September 2008

No @ abhinandan jain,

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

ABHINANDAN JAIN

CA Student

891 Points Joined August 2009

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..