How to calculate interest in tally?

Tally allows you to calculate simple and advanced modeinterest easily and quickly. You don’t need to do much except entering some basic data like percentage, select yes or no for activationetc.

In modern business interest plays a vital role. Interest is the return on the money invested.When money is deposited in bank is eligible for interest; treated as income of the business. Like wise you may be paying the interest on loans, late payments etc. So interest can be treated in both ways income and expense.

Simple Mode interest calculation in tally

Let us do this with a simple example.

Your business borrowed Rs 10000.00 on 01.05.2009 from private finance company, interest @ 12 % per annum .You need to calculate interest on monthly basis and book interest expense at the month end.

Activation of interest calculation in tally

Gateway of tally » F11» Accounting features

Press enter to have the accounting features screen, now type yes against the field “Activate interest calculation

interest-calculation-activation

Save the screen by pressing Ctrl+A or by pressing enter key

Gateway of tally »Accounting info» Ledger» Create

Create Ledger account “Interest paid” as usual if not already created

Create a Ledger named “Private finance company “under group Loans (liability)

TypeYes for the field Activate interest calculation

interest-calculation-activation-in-ledger

Press enter you will see a new screen called interest parameter screen; enter the rate of interest, and the frequency of calculation either monthly or yearly as per requirement.

Here we are calculating interest on monthly basis, select 30-day Month or Calendar Month. Say calendar month.

The interest rate is 12% per annum so find out the rate of interest for one month which is equal to interest rate divided by number of month in a year i.e. 12/12=1.

Enter the rate and interest style as displayed in the below screenshot and save the screen.

interest-parameters

Gateway of tally »Accounting Vouchers »

Press F6 to invoke Receipt voucher entry screen. Next step is to make the Accounting entry of loan receipt by debiting cash and crediting Private finance company on 01.05.2009 as given in the example.

View interest report in tally

On 31st May you can see the interest amount by entering in to following report

Gateway of tally »Display» Statements of Accounts» Interest calculation »Interest Payable

Interest payable report gets displayed .press F2 to select the range of date, select from 01.05.2009 to 31.05.2009

Interest-calculation-report

The report shows you how much interest to be payable at the end of this month. But remember this is only report and nowhere affect in your books of account. Now your next duty is to bring the interest expenses to you books of account.

Booking of interest in tally

Since this is an expense to the company and payable to private finance company you have to prepare a credit note to credit the account of our loan provider.

To do this you have to create a voucher class, how?

Gateway of tally »Accounts info» Voucher Types» Alter

Select the credit note from the list, in the very last field Name of class; type interest-simple just naming the voucher class, you can name it at your choice.

credit-note-for-interest

Now press enter to have a new screen, select Yes for Use class for interest accounting

voucher-class-for-interest

Save the screen by pressing enter key.

So you will prepare Debit note in case interest is receivable; no doubt.

Come back to the Gate way of tally, select  Accounting vouchers for interest booking , select Credit note from right button panel or press Ctrl+F8. A screen will be displayed to select the voucher classas in the screen shot below.Select the class created i.e., Interest simple press enter to come on credit note voucher entry screen

Make sure that the voucher  date is 31.05.2009( Last date of the month).If you are booking on 30th of May interest will be calculated only up to 30th so date is important here.

voucher-class-selection

Now credit the Ledger Private finance company, the amount field is automatically filled by tally and debit the Ledger interest paidwith the same amount and save the entry.

voucher-entry-screen

We have completed the interest calculation and its booking in simple mode the advance mode interest calculation will be discuss in the next post.

You can subscribe our free newsletter below and we will send you more about interest calculation in your inbox.

If you have any queries please use our comment section.

10 Responses to “How to calculate interest in tally?”

  1. bhaskar moni barman says:

    after payment of interest by cedit note do i have to adjust my cash account for payment of interest……….

  2. manjunath says:

    Hi, am running smal finance company and I will be taking interest on perticular client around 3% and 4% of interest on every month and how to recored the same in tally.

  3. Muhammed says:

    Hi,

    When we take more than one loan from same Company with different date and with different interest rate, we have to create each Ledger
    for each loan. Please give me answer.

  4. sumendra says:

    how to interest in tally …..plz send example…

  5. Smita Alphanso says:

    I am working in a pvt. co. My company take various types loan i.e. housing loan, machinery loan & car loan from bank. So, I have one questioned i.e. how can i make the entry of Bank loan statement in tally9 which is given by bank to us. I can do the reco but i don’t know how to do the bank loan statment reco. Please hlp. me.

  6. D.VARALAXMI says:

    I am working in a pvt. co. My company take various types loan i.e. housing loan, machinery loan & car loan from bank. So, I have one questioned i.e. how can i make the entry of Bank loan statement in tally9 which is given by bank to us. I can do the reco but i don’t know how to do the bank loan statment reco. Please hlp. me.

  7. sukanta says:

    PLZ describe DETAILS PROCEDURE FOR ADVANCE MODE OF INTEREST CALCULATION IN TALLY.ERP 9 and how to book in tally

  8. alalliaky says:

    Here are some more links on the topic, Blaylock Wellness Report Acid Reflux

    http://andburninglips.lsdreflux.com
    http://andstomachflu.lsdreflux.com
    http://andchroniccough.lsdreflux.com
    http://andtheurinarytract.lsdreflux.com
    http://anddizzinessandbreathlessness.lsdreflux.com
    http://andmycobacteria.lsdreflux.com
    http://andyougurt.lsdreflux.com
    http://andmissedheartbeats.lsdreflux.com
    http://andburnttongue.lsdreflux.com
    http://affectingear.lsdreflux.com
    http://andwaterbrash.lsdreflux.com
    http://andicecream.lsdreflux.com
    http://aftergallbladdersurgery.lsdreflux.com
    http://andfoodpoisening.lsdreflux.com
    http://andvalve.lsdreflux.com
    http://andtinnitus.lsdreflux.com
    http://acidheartburntreatment.lsdreflux.com
    http://andswollenlarynx.lsdreflux.com
    http://alldaylong.lsdreflux.com
    http://afterlapband.lsdreflux.com
    http://andtonsilliths.lsdreflux.com
    http://andbeets.lsdreflux.com
    http://andchiropracticmessages.lsdreflux.com
    http://adults.lsdreflux.com
    http://andsmoking.lsdreflux.com
    http://andlightyellowishstool.lsdreflux.com
    http://andsinging.lsdreflux.com
    http://andkidneydisease.lsdreflux.com
    http://andthirstininfants.lsdreflux.com
    http://andcharcoal.lsdreflux.com
    http://andcoughandcongestion.lsdreflux.com
    http://aftergallbladderremoval.lsdreflux.com
    http://applecidervingear.lsdreflux.com
    http://andhernias.lsdreflux.com
    http://anddairyproducts.lsdreflux.com
    http://andfootpainrelation.lsdreflux.com
    http://anddigestion.lsdreflux.com
    http://andrunning.lsdreflux.com
    http://andgreenurine.lsdreflux.com
    http://andgastricbypasssurgery.lsdreflux.com
    http://andcereal.lsdreflux.com
    http://andtroublebreathing.lsdreflux.com
    http://andprocessedchicken.lsdreflux.com
    http://andprocessedmeats.lsdreflux.com
    http://afterexercise.lsdreflux.com
    http://andhamburgers.lsdreflux.com
    http://andburnedmouth.lsdreflux.com
    http://andswollenglands.lsdreflux.com
    http://andhomeopathy.lsdreflux.com
    http://andswollenthroat.lsdreflux.com

  9. jyothi says:

    i am using tally erp9 in sundry debtors & creditors creation in ledger bill by bill details i can set yes but it’s not asking the deails in purchase voucher but it(bill-by-bill detials) will show on payment to creditors so please tell me the reason why ican’t get that details in purchase invoice

  10. sachin says:

    dear sir,

    I am accountant in pvt. company, and send the basic Knowledge in auto finance .

    reg,

    sachin

Leave a Reply

© 2014 Accountinghead. All rights reserved. Site Admin · Entries RSS · Comments RSS
Powered by WordPress · Designed by Theme Junkie