Tally has an interesting feature i.e. Calculating Interest on any sum.
There is two way to Calculate Interest in TallyERP.9.
The advanced parameters are particularly useful where interest rates change from time to time.
· Go to Gateway of Tally> F11: Features > Accounting Features > Set Activate Interest Calculation to Yes. > Set Use Advanced Parameters to Yes.
For Ledgers created under the Group Sundry Debtors/Sundry Creditors, the Interest Parameters sub-screen is displayed as shown below:
For Ledgers created under the Group Bank Accounts, or if the option Calculate Interest Transaction by Transaction is set to No, then the Interest Parameters sub-screen is displayed as shown below.
To view the report on Outstanding balances:
Go to Gateway of Tally> Display> Statements of Accounts.> Interest Calculations> Ledgers> XY Bank
Activate and specify interest calculations in ledger masters.
The following extra options now become available:
Note: To obtain the option Calculate from Date Specified during Entry, you must have Override advanced parameters set to Yes. The option is required if you want to specify interest to be calculated at different rates for different periods. If you choose to override parameters then information would be asked during voucher/invoice entry. The interest information is required after the bill-wise details have been entered.
Report on Interest Calculated on outstanding transactions/bills
Go to Gateway of Tally-> Display->Statements of Accounts->Interest Calculations->Ledger->CP Ltd
Press the button F1: Detailed on the Button bar to see the calculation and the period. Previous transactions are calculated from Effective date of Transaction as default. Date Specified during Entry has not been used.
Note: Part monies received have been accounted for and interest calculated on the balance.
A look at Calculate From Dates Specified during Voucher Entry
You have set up the Interest Parameters for CP Ltd to calculate on Dates specified during Voucher Entry.
We will take one invoice and put in the interest information.
To view the interest amount:
Go to Gateway of Tally-> Display->Statements of Accounts->Interest Calculations->Ledger->CP Ltd.
Book Entries and adjustment of interest
We have seen the reports on interest amounts calculated in different ways but these have not been brought into books! They simply give you the interest implications. You must book them now.
How to enter the calculated interest amounts?
Use Debit Notes and Credit Notes with Voucher Classes
Use Debit notes for Interest receivable and Credit Notes for Interest Payable. Interest is calculated on Simple or Compound basis and separate classes should be used for them.
Set-up Debit/Credit Note Classes for interest entries
Set up Debit Notes. Credit Notes will behave the same way.
Go to Gateway of Tally->Accounts Info.->Voucher Types->Create/Alter
· Alter the Voucher Type Debit Note.
· Tab down to the field Class.
· Type the name of the Class.
Likewise, create a Class – Compound Interest and set Yes to Amounts to be treated as Compound Interest.
Accept the Voucher Type and return to the Gateway of Tally. Create a ledger account Interest Received under Group Indirect Income.
Voucher Entry for booking Interest
1. Go to Gateway of Tally->Accounting Voucher
2. Select Ctrl+F9: Debit Note
3. There are two situations for interest adjustment:-
1. Simple Interest – Interest amounts are not debited onto the same bills. Create a fresh reference for it.
2. Compound Interest – Amounts are auto-debited to the selected bills. Bill-wise details will not appear in this case.
1. Interest on balances only
Bill-wise interest entry
· Credit Interest Received
When you debit the party account, a list of bills for which interest is applicable pops up. Select the bills to adjust. Note that even cleared bills appear.
Select the respective interest bills from the list . The debit amount is filled up with the total. Select New Ref in the bill-wise allocation. In the interest sub-screen, ensure that the rate of interest is 0. Now, Credit Interest Received. The amount is already filled in.
Your voucher will resemble the one below:
Entries for compound interest are exactly the same as for Simple Interest where all you do is select the Voucher Class Compound Interest. Also the Bill-wise details popup sub-screen does not come up as the amounts are added onto the bills.
Select the required bill from the list and complete a Debit Note.
Now display Outstandings for CP Ltd
The Bill reference CP/00466993 is the invoice onto which interest has been compounded.
A new Reference no 2 has been created for Simple Interest due from CP Ltd.
Entries for Interest on Balances only
Again, the issues are Simple and Compound Interest
Make the following entries in a Debit note with Compound Interest Voucher Class
· Debit Bank Ltd (the amount is automatically filled up with the calculated interest)
· Credit Interest Received
And nothing needs to be done! The Bank Account has been increased by the amount of interest due and the Income account of Interest Received also credited.
Make the same entry as above.
However, since it has the effect of increasing the Bank Ltd account with the amount due (compound effect), you must make a journal entry to reverse it. The reversal entry would be something like this:
· Debit Interest Receivable (a current asset account)
Use a normal Journal voucher for this entry.
We have to necessary go this route to take advantage of the auto filling of the interest amount which can appear only when we use the Bank Ltd account in Debit Note in the first place.