Home Page : TallyERP9Book.Com Click...Order Now ! Click...Order Now ! Click....Book Contents !
Connect with ...

Banking: Calculate interest based on bank reconciliation date

The interest calculation feature is enhanced with the facility to calculate interest based on reconciliation date.

Scenario 1: Interest Calculation on Bank/Reconciliation Date using Simple Parameters

Master Creation

Ensure the option - use advanced parameters below Activate Interest Calculation of F11Features > F1Accounts is set to No.

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

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

·         In the Interest Parameters screen, select the Bank/Reco Date as the Date Type in the Calculate Interest Based on field and accept the Interest Parameters screen.

·         Accept the bank Ledger Creation screen.

Scenario 2: Interest Calculation on Bank/Reconciliation Date using Advanced Parameters

Click F11Features > F1Accounts and set the option - use advanced parameters below Activate Interest Calculation to Yes.

In the Ledger Alteration screen of Canara Bank A/c ledger, set the option - Activate Interest Calculation to Yes and press Enter. 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 bankLedger Creation screen:

Voucher Entry

Record two payment vouchers – one on 1-5-2013 for Rs. 10,000 and the other on 10-5-2013 for Rs. 20,000.

Go to Gateway of Tally > Accounting Vouchers > F5Payment

Note: To record the transaction in single entry mode, click F12Configure and set the option - Use Single Entry mode for Pymt/Rcpt/Contra to Yes. To record it in double entry mode, set the same option to No.

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 1Reconciling 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

Enter the reconciliation dates as shown and accept the Bank Reconciliation screen.

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 F2Period and enter the From and To dates as 1-5-2013 and 31-5-2013 respectively. The Ledger Interest report appears as shown below:

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

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

In the Interest Calculation report, click F2Period 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 below:

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.

Click F2Period and change the From and To dates as 1-5-2013 to 30-6-2013 respectively. Click F12Configure and set the options as per requirement.

The Bank Reconciled Transactions report appears as shown below:

 
 
 
 
Company Information @ Tally.ERP9
Group & Ledger

Introduction
1. THE GROUP
2. THE LEDGER
3. VOUCHERS TYPES

Advanced Inventory / Stock
Meaning
Order Processing
Re-Order Levels
Tracking Numbers
Batch-wise Details
Additional Cost Details
Bill of Materials (BOM)
Price Lists and Price Levels
Stock Valuation
Zero Valued Entries
Inventory Ageing Report
Actual and Billed Quantities
Advanced Usage of Vouchers
Maintain Bill-wise Details
Cost Center and Cost Category
Interest Calculation
Reversing Journals
Post-Dated Voucher
Memo (Memorandum) Voucher
Optional Voucher
Using Tracking Number
Tally.ERP9 Report
  1. Unit Objectives
  2. Modifying Reports (Options)
  3. Balance Sheet
  4. Profit & Loss Account
  5. Stock Summary
  6. Trial Balance
  7. Day Book
  8. Books of Accounts
  9. Statement of Accounts
  10. Inventory Books
  11. Statutory Reports
  12. List of Accounts ( Chart of Accounts)
  13. Exception Reports
  14. Printing Reports
 
Tally.ERP9 MIS and Other Reports
 
Statutory & Taxation
Utilities & Others @ Tally.ERP9
Credit Limits
Knowledge Base @ Tally.ERP9
Stock Items
Stock Groups
Inventory Masters
Inventory Vouchers
Inventory Report Statements
Balance Sheet
Accounting Reports
Accounting Vouchers
Interest Calculation
VAT-Value Added Tax
Service Tax
TDS (Tax Deducted at Source)
 

Enter your email address:
[ Get Tally.ERP 9 Questions & Knowledge Base Feed delivered by eMail ]

Delivered by FeedBurner

 
 
Disclaimer :

The names of Companies and persons used in this Website have been used for illustrative purposes only.
The visitors may visit www.tallysolutions.com , the web site of Tally Solutions Pvt. Ltd. for resolving their doubts or for clarifications

Trademark :

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. This Website is not associated with any product or vendor mentioned in this Website.

GETTINGS STARTED @ Tally.ERP 9
QUESTIONS BASE @ Tally.ERP 9
REPORT GENERATES @ Tally.ERP 9
TIPS & TRICKS @ Tally.ERP9 GST for Tally.ERP9
1 > Financial Statement Report 1 > Tips & Tricks @ Tally.ERP 9 1 >Introduction to GST ( IGST . CGST, SGST )
2 > Accounts Book & Register Report 2 > FAQ's @ Tally.ERP 9 2 >Calculation of GST ( IGST, CGST & SGST)
3 > Stock Register / Reports 3 > Short Cut Keys @ Tally.ERP 9 3 > GST on Tally.ERP 9 ( With Practical Assignment )
4 > Job Costing Reports 4 > Tips-Weekly Refresher @ Tally.ERP9 4 > Generate GSTR-1 Returns / Reports under Tally.ERP9
5 > Pay Roll Register Reports   5> Status Reconciliation (GSTR-1)
6 > Point of Sale Register Reports   6 > Challan Reconciliation Report for GST Payments
     
  8 > Excise - Manufacturer      
  9 > Technology / Utilities      
 
SWAYAM EDUCATION
Mandal Bagicha, Hemkapada,
Sunhat, Balasore-756002 ( Odisha )-India
eMail ID : tallyerp9bookorder@gmail.com
Web : www.tallyerp9book.com
Mob : 09437264738
Get Updated ...
Website Designed, Hosted, Owned by : www.BalasoreCity.Com