# Interest Calculation in TallyPrime

Interest is a legitimate return on money invested and chargeable in the business world on loans and also on delayed payments. Interest can be calculated on the basis of Simple or Compound Interest. With TallyPrime you can make the required configurations and view the reports on interest calculated based on these configurations. In TallyPrime, calculation of interest will be based on outstanding receivables or payables.

## Enable Interest Calculation in TallyPrime

- Press
**F11**(Features) > set**Enable Interest Calculation**to**Yes**.

If you do not see this option:- Set
**Show more features**to**Yes**. - Set
**Show all features**to**Yes**.

- Set
- Press
**Ctrl+A**to save the**Company Features Alteration**screen.

## Calculate Interest Using Simple Parameters

Interest calculation on outstanding balances is allowed for any ledger account. Configure the interest rate, and style of calculation in the ledger master, to start calculating interest on outstanding amounts. Interest on outstanding balances can also be calculated transaction-by-transaction.

**Gateway of Tally**>**Alter**>**Ledger**> select the bank ledger > and press**Enter**.

Alternatively, press**Alt+G**(Go To) >**Alter Master**>**Ledger**> select the bank ledger > and press**Enter**.- Set the option
**Activate interest calculatio**n to**Yes**. The**Interest Parameters**screen appears. - In the
**Calculate Interest Based On**field select the**Date Type**, as required.

The option to calculate interest based on either Bank reconciliation date or voucher date will be displayed for ledgers grouped under Bank Accounts , Bank OCC A/c and Bank OD A/c. The interest calculated on:**Voucher Date**will be displayed in the**Ledger Interest**report.**Bank/Reco Date**will be displayed in**Bank Reconciled Transactions**report.

- Set
**Include transaction date for interest calculation**, as needed. This can be enabled**For Amounts added**and/or**For Amounts Deducted**. - Enter the
**Rate**of interest. - Select the
**Interest Style**, as required. The rate of interest will be calculated on the basis of the interest style applied.**Note:**If the interest style selected is**365-day Year**, then the interest will be calculated for 365 days irrespective of the number of days in the calendar year. If**Calendar Year**is selected as the interest style, then the rate of interest will be calculated on 365 days or 366 days, depending on the number of days as per the calendar. - Select the required details in as needed.

- Press
**Ctrl+A**to save.

## Calculate Interest Transaction-by-Transaction

Calculation of interest can be done bill-by-bill for accounts grouped under Sundry Debtors and Sundry Creditors.

- In the party ledger, set the option
**Activate interest calculation**to**Yes**. The**Interest Parameters**screen appears. - Set the option
**Calculate Interest Transaction-by-transaction**to**Yes**. - The option
**Include transaction date for interest calculations: For amounts added**,**For amounts deducted**is provided in the**Interest Parameters**screen. This option allows you to exclude or include the transaction date for amounts added and deducted. For example, for a sundry debtor ledger, there was an invoice raised for Rs. 50,000 on 1st of April 2020, against which an amount of Rs. 20,000 was received on the same day. Now you may want to include the invoice amount and exclude the received amount, for the purpose of calculating interest on 1st April 2020. - Set the option
**Override Parameters for each Transaction**to**Yes**, to change the parameters while recording vouchers. - Enter the
**Rate**of interest. - Select the
**Interest Style**, as required. The rate of interest will be calculated on the basis of the interest style applied.

- To exclude or include the transactions, you can use the options as shown below:

For amounts deducted

For amounts added

Yes

No

Yes

Includes both the additions and deductions on the transaction date to the amount. Interest is calculated after considering the amount of the transaction date.

The additions done on the transaction date will be considered from the next day onwards, whereas, the deductions are considered on the transaction date for calculating interest.

No

The additions are included on the transaction date, and the deductions are excluded from calculating interest on the transaction date. The interest on the deductions is calculated on the next day.

Excludes both the additions and deductions on the transaction date. The interest is calculated on the net amount from the next day.

**Note:**The terms additions and deductions are used in relation to the opening balance (either zero or any value). When any amount is added to opening balance, it should be treated as addition, and when any amount is reduced from opening balance, it should be treated as deduction. In other words, the ‘interest calculation for the day’ means opening balance + additions – deductions, which is the closing balance of the day.

## Calculate Interest Using Advanced Parameters

The advanced parameters are used when interest rates change periodically. Using the advanced parameters, you can configure the number of days, balance type, and applicable from date that are to be considered for calculating interest.

*In this section*

### Set advanced interest parameters for a party

- In the
**Interest Parameters**screen of the party ledger, press**F12**(Configure) and set**Use advanced interest parameters**to**Yes**. - Set the option
**Calculate Interest Transaction-by-Transaction**to**Yes**, to calculate interest for each transaction. - Set the option
**Override Parameters for each Transaction**to**Yes**to display the**Interest Parameters**screen while recording the transaction. The defined parameters can be modified during voucher entry. - Set the option
**Override advanced parameters**to**Yes**. - Set
**Include transaction date for interest calculation**, as needed. This can be enabled**For Amounts added**and/or**For Amounts Deducted**. - Enter the
**Rate**of interest. - Select the
**Interest Style**, as required. The rate of interest will be calculated on the basis of the interest style applied. - Select the balance on which the interest has to be calculated. Interest can be calculated on credit balance, debit balance or both credit and debit balances.
- Select the
**Applicability**of the interest as required. If**Past Due Date**is selected, then the number of days after which interest has to be applied can be specified. - Select the date from which interest is applicable in the
**Calculate From**field. - Select the applicable
**Rounding**method. Select**Not Applicable**for saving values as is without rounding off. - Define multiple slabs with different rates and applicability, as needed. The
**Interest Parameters**screen with multiple slabs appears as shown below:

- Press
**Ctrl+A**to accept the configuration. - Press
**Ctrl+A**to save the ledger.

In case of the above configuration, interest will be calculated at 5% starting from 10th day after due date and at 10% starting from 60th day after due date. Similarly, multiple slabs can be configured with different interest style, applicability, calculate from parameter and round off value.

### Set advanced interest parameters for bank ledgers

- In the
**Interest Parameters**screen of bank ledger, select**Bank/Reco Date**to**Calculate Interest Based on**. - Enter the
**Rate**, and**Interest Style**as required. - Enter the applicability period.
- Press
**Enter**and enter the interest calculation details for another period. The**Interest Parameters**screen appears as shown below:

- Press
**Enter**. - Press
**Ctrl+A**to save the ledger.

## Calculate Interest on Group

The Group Interest Calculation statement is a list of all accounts and sub-groups belonging to the selected group. It displays the current balance in each account or sub-group, and the total interest.

**Alt+G**(Go To) > type or select**Group Interest Calculation**.

Alternatively,**Gateway of Tally**>**Display More Reports**>**Statements of Accounts**>**Interest Calculations**>**Group**.- Select a
**Group**, for example,**Current Liabilities**.

**Note:**The Cr in the interest amount indicates that it is a liability. - Press
**Enter**to drill down to the**Ledger Interest**report.

## Calculate Interest on Ledger Balances

You can get a report on the ledger balances for the interest amount.

**Alt+G**(Go To) > type or select**Ledger Interest Calculation**.Alternatively,

**Gateway of Tally**>**Display More Reports**>**Statements of Accounts**>**Interest Calculations**>**Ledger**.- Select an account. The
**Ledger Interest**report appears as shown below:

## View Interest Amount on Invoices

You can calculate interest on each invoice for the outstanding period. Transaction by transaction or bill-by-bill interest can be calculated for party ledgers (grouped under Sundry Debtors and Sundry Creditors). For calculating interest on each bill, the bill-wise details should be enabled for the company and the party.

The Ledger Interest report displays the interest calculated for the selected ledger. If a part of the amount is settled, then interest is calculated only on the amount pending to be repaid.

**Alt+G**(Go To) > type or select**Ledger Interest Calculation**> select the**Ledger**.

Alternatively,**Gateway of Tally**>**Display More Reports**>**Statements of Accounts**>**Interest Calculations**>**Ledger**.- Press
**Ctrl+H**(Change View) > select**Bill-wise Details**> and press**Enter**.

- Press
**Alt+F5**(Detailed) to view the calculation and the period.

Note:If part of the amount is settled, the interest gets calculated on the remaining balance. Now check the interest amount due.

Note:The Cr in the interest amount indicates that it is a liability.

The interest liability and expense can be accounted by recording a journal entry. Interest can also be recorded using debit notes and credit notes with voucher class.

## Record Transaction for Interest Calculation in TallyPrime

**Gateway of Tally**>**Vouchers**>**F5**(Payment).

Alternatively, press Alt+G (Go To) >**Create Voucher**> press**F5**(Payment).- Press
**Ctrl+H**(Change Mode) > select**Single Entry**> and press**Enter**. - Select the bank ledger and party ledger. Enter the bank details in the
**Bank Allocations**screen. The**Bank Allocations**screen appears as shown below:

- Press
**Ctrl+A**to save the**Bank Allocations**screen. - Press
**Ctrl+A**to save the voucher.