14 June 2013

Tally Tip: How to easily enter calculated figures in Tally

Here is a quite simple but effective Tip for Tally users. It happens while doing entries in Tally that some times you have to calculate the figures and then enter the total of that calculated figures in amount column. For example if you have to enter  the price of a particular item as its MRP + 1.25% extra then what would you do? Probably what you would do  is draw the calculator and then  calculate the sum of MRP + 1.25% and then enter that amount in Tally.

Some smart tally users would just press Ctrl +N and then calculate the sum in the calculator pane and then again press Ctrl +M and then retype that figure in the amount column.

Now the Tip is that there is one more smarter way to do this. While you are at amount figure just press Alt+C and see what happens.


You would find that cursor automatically moves to calculator pane. Here what ever calculation you do and press enter then you would find that final amount automatically shifts to amount column in main pane. You can see the formula entered by me in the calculator pane. The final amount is automatically shifted to Amount column.

Wow! No need for calculator, no need to remember the figures and no need of copy pasting. Isn't it a cool tip?

11 June 2013

Tally Tutorial :How to Book Your Interest, Learn How to do it in Tally.ERP 9

In my, previous tutorial on Tally I have explained How to calculate Interest on your transactions. This is the part two and last part of this series. First of all you should learn how to calculate interest in Tally and then you should know how to book it in Tally.ERP9. 
In the later part of that tutorial we have seen that Tally has the flexibility to automatically calculate the interest on time given by us and conditions given by us. 
To continue the previous example we simply assume that a payment was made on July 31st and we have to calculate and book the interest on the amount till that date and accept the payment.
To do so we have to pass a debit note for the interest amount to book it. But to do it automatically we have to create a special class in Debit Note voucher. As we know that voucher class in Tally are for automate certain process so this class named Simple Interest is made to calculate the interest. So first of all alter the voucher type of Debit Note and create a class named Simple Interest.
Simple Interest Class
 Now put the option Use class for interest calculation to yes and accept the voucher class.

Debit Voucher Alteration

Now pass the debit note voucher by selecting the class simple interest. 
Debit Note with voucher class
Choose the date you want and see that interest figure would automatically appear on the selection screen. Below are the screen shots of the interest calculated on different dates and the references to them as made by us.

Interest as on June 1

Interest as on July 31st

Interest as on Aug 31st

As the payment of 2000000 has been made on July 31st so we would accept the payment but first book the interest upto July 31st. After debit voucher the ledger balance would be like this with added interest.
Ledger Balance after Debit voucher
Now enter the receipt voucher. The bill by bill reference of the receipt  would look like this.
Bill By Bill reference of receipt voucher.
Now you can see the pend ency of ABC Customer after the receipt. Here just go to Display -> Account books-> ledger and then press B for bill wise details. You would see that Rs. One lac is pending and the number of days due is 30. and Interest amount is due. Again when this due amount is paid then you pass a debit voucher on that date and settle the final amount. 
Pending Payment
I hope this has made pretty clear about how you can book your Interest on Tally.ERP 9. Your questions and queries are welcomed in comments.