Ad Free CAclubindia and Daily Updates on your Mobile. Subscribe Now!

Tally 9 - how to see cash payments above 20,000 alone ?

Merina (Student) (310 Points)

10 April 2013

Hi, I am checking the cash book of a company in Tally 9 where I could see some payments above 20,000 here and there! Kindly let me know how can I see all cash payments above 20,000 alone (Displaying only Cash payments above 20,000) in Tally 9?

Regards

Reply
Follow
Share

11 Replies

Ganeshbabu K (Audit and Tax Advisory) (48564 Points)
Replied 10 April 2013

GO TO CASH LEDGER

SELECT F2 AND CHANGE PERIOD TO WHOLE YEAR

GO TO F8 AND CHANGE IT TO COLOUMNAR VIEW

SELECT VALUES SORT FROM ASSCENDING TO DESCENDING

THERE YOU CAN GET

UPLOAD TO EXCEL FOR UR REFERENCE

2 Like

Upgrade to CAclubindia Pro. Subscribe Now!

Ganeshbabu K (Audit and Tax Advisory) (48564 Points)
Replied 10 April 2013

FOR OTHER GUIDENCE U MAY REFER TO

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

2 Like

(Guest)

or after changing the period of cash ledger to full year.., by using ALT + F12 you can enter the required range of data to sort amount in excess of 20,000/-

Only drawback is that it will even sort contra entries..

2 Like

CA MANOJ (CA, MBA, B.Com) (141 Points)
Replied 10 April 2013

Aanya you are right but after sorting the data alphabatically u can also get the data as per your requirement as contra entries will be shown in a group and rest entries will of your need.

1 Like

Renuka Thakur (Articled Assistant) (82 Points)
Replied 10 April 2013

Hi, in tally9. Go to cash ledger, select the period by using F2 As above. Press Alt+F12. type in that " voucher having ledger amount more than 20000" and then press enter...all cash payment of more than 20,000 will be displayed.

2 Like

Upgrade to CAclubindia Pro. Subscribe Now!

Sachin Bhoyar (Practicing Chartered Accountant) (35 Points)
Replied 10 April 2013

In tally9. Go to cash ledger, select the period by using F2 As above. Press Alt+F12. type in that " voucher having ledger amount more than 20000" and " voucher having voucher type name containing payment" then press enter...all cash payment of more than 20,000 will be displayed.

2 Like

Shrinivas mishra (Article) (32 Points)
Replied 16 April 2013

so simple go to cash ledger press alt+f12 now give condition "Voucher" Ledger Amount" greater than" 20000" enter and enter.............

2 Like

Accounting Home Services (Finance Executive ) (734 Points)
Replied 23 September 2013

go in to cash ledger(DAL) - change period which you want(F2) - press F12 go in to sorting method take option amount wise (increasing\decreasing) - now u can view as u want......?