Interest Calculation In Tally .ERP 9

-

1. What is Interest?

Any charge for the privilege of borrowing money and expressed as annual percentage rate (APR) is referred to as Interest in dictionary of business. It can also refer to as the amount of ownership a stock holder has in a company, usually expressed as a percentage.

2. Break Down of Interest Rate

Interest can be broken down as : simple and compound
Simple interest : It is the rate set on the principal amount originally lent to the borrower that the borrower has to pay for the ability to use the money.
Compound interest : It is the interest on both the principal and the compounding interest paid on that loan.

3. How to Activate Simple Interest Calculation in Tally. ERP 9 ?

MappingFrom Gateway of Tally navigate to Features Screen by pressing F11 on the keyboard.
Action to performIn the company feature screen enable the option activate interest calculation by typing ‘Yes’ and to set maintain bill-wise details: to Yes . It is important to set Use advanced parameters to No for Simple interest calculation.    

 5. Benefits of Calculation of Interest with Tally.ERP 9

  • If we forget to account any interest receivable or payable, with the help of Tally.ERP 9 now we can avoid all such uncertainties by generating interest calculation report.
  • This interest amount generated is correct amount because of Tally 9 database calculation.
  • Interest calculation in Tally.ERP 9 is very much suitable for bank loan, personal loan or general business loan's interest.
  • 4. Parameters of calculation of interest satisfy different type of user’s needs. Some may be interested to calculate interest on current credit balance or some may interest on total amount but Tally.ERP 9 provide both facility in parameters about calculation of interest.

     4. Learning to Pass an Entry and see How Interest Calculation Feature Works in Tally.ERP 9

Example : On 01-04-2018 Sold goods to XYZ Ltd (Sundry Debtor) for Rs. 1,00,000/- for a credit period of 60 days. Agreed an interest of 20% p.a., on delayed payment. XYZ Ltd cleared it’s payment on 31-07-2018. How to calculate interest as agreed and account the same in Tally.
Solution :
BriefExplanation
Step 1 :Create Party LedgerTwo possibilities : We have to create a customer ledger with interest activated or we can edit existing ledger for activating interest calculation for that particular party.

Mapping : Gateway of Tally > Accounts Information >  Ledger > Alter/Create

Action to perform : In the ledger creation/Alteration screen set the following option :
  • Default credit period: 30 days (as given in the example of 30 days credit)
  • Activate Interest calculation: Yes and press Enter Key.

Setting Interest rates parameters :
  • Set calculate Interest Transaction by transaction to : Yes, This option will calculate interest on each transaction.
  • Override parameters for each transaction: activating this option will help you to change the following parameters while passing entries in voucher books.
    •  
    • Rate : Enter the rate as decided here 20%
    • Per.  : Here four interest style is given 1) 30 Days Month 2) 365 Day Year 3) Calendar Month 4) Calendar Year. Select 365 Day Year.
Step 2 :F8 :  Sales Voucher Entry
  • From Gateway of Tally.ERP  9  navigate to Accounting Voucher Screen by pressing V on the keyboard
  • Now press F8 to pass a Sales Voucher
  • Under party ledger Name select XYZ Ltd and enter bill details and press enter.
  • Now we will see interest parameters screen. This parameter appears because we have chosen over ride interest parameters while activating interest for the ledger.
  • Press enter and save the sales voucher.
Step 3 :Generating Interest calculation reportIn the given example, the credit period set is 60 days which ends on 31.05.2018. The amount to be paid by XYZ company is overdue by 60 days. As agreed the party due an interest of 20% p.a., to the total number of over due days. To know the total interest go to :

Mapping : Gateway of Tally>Display>Statement of Account > Interest Calculations>Interest Receivable.

And to view the Interest calculation report do the following :
  • Choose the period by clicking Period button or “F – 2” from Keyboard. 01-06-2018 to 31-07-2018
  • Interest calculation summary screen will appear now for the given period blocked
  • Press enter to drill down until voucher level
Step 4 :Passing Interest receivable entry
  • Gateway of Tally  >  Accounting Voucher  >  Click “F – 7” for Journal
  • Create Interest account under Indirect Incomes
  • Now Debit XYZ Ltd with the amount generated by Interest calculation summary screen and account interest in books by crediting Interest Account.

Comments

Post a Comment

Popular posts from this blog

Statutory And Taxation In Tally.ERP 9

-
Image
Statutory and Taxation Tally.ERP 9 supports the various taxes applicable in India. You can maintain accurate books of accounts and generate error-free returns by detecting the missing information in the transactions, if any, and correct them before filing returns. You can use statutory and taxation features in Tally.ERP 9 by enabling the required options in the  Company Operations Alteration  screen. To enable statutory and taxation features 1.  Go to   Gateway of Tally  >  F11: Features  >  F3: Statutory  . 2.  Enable the required options in the  Company Operation Alteration  screen as shown below:
Read more

Vouchers In Tally.ERP 9

-
Image
As a business owner, you have to continuously record transactions for the purpose of accounting, inventory management and statutory compliance. If you are already using Tally.ERP 9, then like many other users of Tally, you must be quite acquainted with vouchers that are available in Tally.ERP 9. However, if you are new to Tally.ERP 9, then we would like to take you through the basic vouchers to make it easier for you. Below is an outline of the commonly used vouchers in Tally.ERP 9 with details on how to use them. ✳️Accounting vouchers in Tally.ERP 9 ✓ Sales Voucher in Tally ✓ Purchase Voucher in Tally ✓ Payment Voucher in Tally ✓ Receipt Voucher in Tally ✓ Contra Voucher ✓ Journal Voucher ✓ Credit Note Voucher in Tally ✓Debit Note Voucher in Tally ✳️Inventory vouchers in Tally.ERP 9 ✓ Physical Stock Verification ✓ Material In and Material Out Voucher ✓ Delivery Note and Receipt Note Vouchers in Tally ✳️Order Vouchers in Tally.ERP 9 ✓ P...
Read more

Creating an Location Or Godown In Tally.ERP 9

-
Image
A godown is a place where stock items are stored. You can specify where the stock items are kept. You can obtain stock reports for each godown and account for the movement of stock between locations/godowns. You can create Locations/Godowns in   Single  mode and   Multiple  mode Creating a Single Location/Godown To create a Location/Godown 1.  Go to   Gateway of Tally > Inventory Info. > Locations/Godowns > Create (under Single Godown).  The   Location/Godown Creation screen  is displayed as shown: 2.  Specify the  Name  of the Location/Godown. 3.  Enter an   Alias  name for the Location/Godown name, if required. 4.  Specify the Location/Godown   Under  which the Location/Godown is to be categorised. Use  Alt + C  to create the parent Location/Godown if it is not in the list. Select   Primary  , if it is not a sub Location/Godown of any Location/G...
Read more