www.TallyERP9Help.Com
Select Your Language :

7.   Interest Calculation based on Bank Date / Voucher Date in Tally.ERP 9

The interest calculation feature is enhanced with the facility to calculate interest on ledger balance as per Bank balance provided in Bank Reconciliation Statement using simple and advanced parameters based on bank/reconciliation date. However, to allow users to predefine auto-calculation of interest based on voucher date, the Date Type - Voucher Date is also made available along with Bank/Reconciliation Date in the bank ledger master.

Note: In all releases of Tally.ERP 9, the interest was being calculated, by default, on Voucher Date. In Tally.ERP 9 release 4.8, the option to calculate interest on Bank/Reconciliation Date has been provided. Hence, only the newly provided feature will be explained here.

To capture the transaction details of reconciled vouchers and provide flexibility to drill-down to the last level of voucher entry, a new report - Bank Reconciled Transactions has been introduced.

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

·         Reconciliation date will be displayed in Bank Reconciled Transactions report.

Bank Master - Interest Calculation on Bank/Reconciliation Date using Simple Parameters

Go to Gateway of Tally > Accounts Info. > Ledger > Create

Ensure the option - use advanced parameters below Activate Interest Calculation of F11: Features > F1: Accounts is set to No.

Create the ledger Canara Bank A/c by grouping it under Bank Accounts and set the option - Activate Interest Calculation to Yes.

Interest Calculatins in Tally.ERP9
[15]

In the Interest Parameters screen, select the Bank/Reco Date as the Date Type in the Calculate Interest Based on field. Provide the other parameters as shown and accept the Interest Parameters and the bank Ledger Creation screen:

Interest Calculatins in Tally.ERP9
[16]

Bank Master - Interest Calculation on Bank/Reconciliation Date using Advanced Parameters

In the Ledger Creation screen, click F11: Features > F1: Accounts set the option - use advanced parameters below Activate Interest Calculation toYes.

In the Ledger Alteration screen of Canara Bank A/c ledger, set the option - Activate Interest Calculation to Yes and press Enter key. In the Interest Parameters screen, select the Bank/Reco Date as the Date Type in the Calculate Interest Based on field. Provide the other parameters as shown and accept the Interest Parameters and the bank Ledger Creation screen:

Interest Calculatins in Tally.ERP9
[17]

Voucher Entry

Let us record payment voucher on 1-5-2013. Go to Gateway of Tally > Accounting Vouchers > F5: Payment

Recording Payment Voucher in Single Entry Mode

Click F12: Configure and set the option - Use Single Entry mode for Pymt/Rcpt/Contra to Yes and accept the Voucher Configuration screen. Record the payment voucher and provide the bank details.

Interest Calculatins in Tally.ERP9
[18]

Note: To provide bank details with remarks, click F12: Configure in the Payment voucher and set the options as shown:

Interest Calculatins in Tally.ERP9
[19]

The Payment voucher appears as shown:

Interest Calculatins in Tally.ERP9
[20]

Recording payment Voucher in Double Entry Mode

In the Accounting Voucher Creation screen, click F12: Configure and set the option - Use Single Entry mode for Pymt/Rcpt/Contra to No and accept the Voucher Configuration screen. Record the payment voucher and provide bank details.

Interest Calculatins in Tally.ERP9
[21]

The Payment voucher appears as shown:

Interest Calculatins in Tally.ERP9
[22]

Note: To display Dr/Cr instead of To/By in the voucher, click F12: Configure and set the option - Use Cr/Dr instead of To/By during entry to Yes.

Interest Calculation Report

Since the bank ledger is configured to calculate interest based on reconciliation date, interest will be calculated only if the transactions are reconciled.

To view the Interest Calculation report, go to Gateway of Tally > Display > Statement of Accounts > Interest Calculation > Ledger > Canara Bank A/C

Scenario 1: Reconciling the Payment Vouchers and Viewing Interest Calculated on Simple Parameters

To reconcile the payment voucher, go to Gateway of Tally > Banking > Bank Reconciliation > Canara Bank A/c

For the payment vouchers recorded in the previous section, enter the reconciliation dates as shown and accept the Bank Reconciliation screen:

Interest Calculatins in Tally.ERP9
[23]

To view the Interest Calculation report after reconciling the payment vouchers, go to Gateway of Tally > Display > Statement of Accounts >Interest Calculation > Ledger > Canara Bank A/C

Click F2: Period and enter the From and To dates as 1-5-2013 and 31-5-2013 respectively. The Interest Ledger report appears as shown:

Interest Calculatins in Tally.ERP9
[24]

Depending on the dates entered for reconciliation, the interest gets calculated and displayed here.

Scenario 2: Reconciling the Payment Vouchers and Viewing Interest Calculated on Advanced Parameters

In the Interest Calculation report, click F2: Period and enter the From and To dates as 1-5-2013 and 30-6-2013 respectively to view the interest for the period of June as defined in the advanced interest parameters. The Interest Ledger report appears as shown:

Interest Calculatins in Tally.ERP9
[25]

Depending on the dates entered for reconciliation, the interest gets calculated and displayed here.

Bank Reconciled Transactions

To view the Bank Reconciled Transactions report, press Enter on any one of the balances displayed in the Ledger Interest report.

(Go to Gateway of Tally > Display > Statement of Accounts > Interest Calculation > Ledger > Canara Bank A/C > Press Enter on any one of the balances)

Click F2: Period and change the From and To dates as 1-5-2013 to 30-6-2013 respectively. Click F12: Configure and set the options as shown to choose the required sorting option and capture the narration, remarks and favouring name in the Bank Reconciled Transactions report:

Interest Calculatins in Tally.ERP9
[26]

The Bank Reconciled Transactions report appears as shown below:

Interest Calculatins in Tally.ERP9
[27]

The Bank Reconciled Transactions report provides columnar details on reconciled transactions. The description of each column is given below:

Bank Date: The Bank Date provided in the Bank Reconciliation screen is captured here.

Vch Date: The date on which the transaction is recorded is captured here.

Particulars: The remarks and narration entered in the payment/receipt voucher are captured under the name of the ledger:

·         Debited while recording a payment transaction.

·         Credited while recording a receipt voucher.

Favouring Name/Received From: The details entered in the Favouring Name/Received From field in the Bank Allocation screen of payment/receipt voucher is captured here.

Note: To provide details in these field, ensure the relevant information is provided in the Bank Details (displayed on setting the option - Provide Bank Details to Yes) in the party ledger master.

Vch Type: The voucher type used to record transaction is captured here.

Transaction Type: The transaction type selected in the Bank Allocations screen of the payment or receipt voucher is captured here.

Instrument No.: The instrument number entered in the payment or receipt voucher is captured here.

Instrument Date: The instrument date entered in the payment or receipt voucher is captured here.

Debit: The amount debited to the bank ledger in the voucher is captured here.

Credit: The amount credited to the bank ledger in the voucher is captured here.

 
Add
 
 
 

Tally.ERP 9 Reference Manual
www.tallyerp9help.com
Tally.ERP 9 Reference Manual LIBRARY
1.
Installation of Tally.ERP9
2.
Site Licensing of Tally.ERP9
3.
Shortcut Keys in Tally.ERP9
4.
Maintaining Company Data
5.
Creating Masters
5a. Accounts Information [Creating Masters]
5b. Inventory Information [Creating Masters]
6.
Voucher Entry
7.
Reports in Tally.ERP9
8.
Excise for Dealer
9.
Excise for Manufacturer
10.
Reports [ Excise for Manufacturer]
11.
Excise for Importer
12.
Service Tax in Tally.ERP9
13.
Tax Collected at Source (TCS) in Tally.ERP9
14.
Tax Deducted at Source (TDS) in Tally.ERP9
15.
Value Added Tax (VAT) in Tally.ERP9
16.
Central Sales Tax (CST) in Tally.ERP9
17.
18.
19.
20.
21.
22.
23.
24.
25.
26.
27.
Tally.ERP 9 Help LIBRARY
Short Cut Keys Command in Tally.ERP9
Reorder Levels & Reorder Quantity
Price Lists in Tally.ERP 9
Point of Sale (POS) in Tally.ERP 9
Job Costing in Tally.ERP 9
Interest Calculations in Tally.ERP 9
Features (F11) of Tally.ERP 9
Configuratioin (F12) of Tally.ERP 9
Data Migration in Tally.ERP 9
Cost Categories and Cost Centers
Budgets in Tally.ERP 9
Advanced Inventory Features
Advanced Accounting Features
Self-Running Tutorial with Audio
F.A.Q. Knowledgebase in Tally.ERP 9
Sample Reports @ Tally.ERP 9
Tips on Tally.ERP 9
 
Our Portal : www.TallyERP9Book.Com www.IncomeTaxManagement.Com www.Tally9Book.com www.TallyERP9Help.Com
Disclaimer. :
Tally, Tally 9, Tally9, Tally.ERP, Tally.ERP 9, Tally.Server 9, Tally.NET & Power of Simplicity are either registered trademarks or trademarks of Tally Solutions Pvt. Ltd. in India and/or other countries. All other trademarks are properties of their respective owners.
The visitors may click here to visit the web site of Tally Solutions Pvt. Ltd. for resolving their doubts or for clarifications