Connect with ...

How to calculate Interest for Ledger with default Credit Period? @ Tally.ERP9

Query

How to calculate Interest for Ledger with default Credit Period?

Or

How to calculate Interest without effecting the outstanding of a Bill?

Answer

To calculate interest for Ledger with default Credit Period/without effecting the outstanding of a bill follow the steps:

Step 1: Enable Interest Calculation Feature

From Gateway of Tally > F11: Features > Accounting Features (F1)

  • Set the options Activate Interest Calculation and use advanced parameters to Yes.
Tally.ERP9

Step 2: Create the Customer Ledger by enabling Interest Calculation option

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

Create the Customer ledger under the primary group sundry debtor; activate the option Maintain balances bill-by-bill. Enable the option Activate Interest Calculation to Yes

learn tally erp 9

In Interest Parameter screen

  • Enable the option Calculate interest Transaction-by-Transaction.
Tally.ERP9 Book

 Note: Tally.ERP 9 provides the flexibility to the user to override the parameters specified in the masters.

  • Provide the Rate of interest and the Calculation Period. The interest styles available are  30 day Month,   365 day Year, Calendar Month and     Calendar Year)
tds in tally erp 9

Here, in our example we are calculating interest @ 10% per annum on the bills from Mega Traders which exceeds due date by 10 days. This due date can be defined during voucher entry and also in the customer ledger master.

  • Accept the Interest Parameters screen and Ledger Creation screen.
 

Step 3: Record the Sales Transaction

In the Sales Voucher,

  • Ensure that in F12: Configuration the option Use Defaults for Bill Allocations is set to No (disabled).
vat in tally erp 9

Now observe the Bill-wise details screen, you will see that under the heading Due Date, or Credit Days the number of credit period allowed is blank. The customer may fill any value or date to specify the due date. 

Note: The interest calculation will start after 10 days from the due date specified here as we have specified the applicability as “Past due date by 10 days” in the customer ledger master

payroll in tally erp 9

In our example we will leave the field Due Date, or Credit Days blank so the interest calculation should from the 10th day after the voucher has been passed i.e. from 15th April 2011

Step 4: Check Interest Calculation Report

To see how Interest is getting calculated, navigate to Interest Calculation Report

From Gateway of Tally > Display > Statements of Accounts > Interest Calculations > Interest Receivable.

  • Press F2 and change the period to 30th April 2011 and press enter.
  • You can see the Interest amount as Rs. 6.16.
tally erp 9 software download
The report can be further drill-down to Ledger Interest report to see the period for which Tally has calculated interest. Click on F1: Detailed button, from this screen we understand that the interest has been calculated for a period of 15 days (15-4-2011 to 30-4-2011) @ 10% p.a. If we calculate the amount of interest = 1500 x (15/365) x 10% = Rs. 6.1644 or Rs. 6.16 (rounded off to two decimal places)
tally 9 erp free download
 
 
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

 
 
 
 
SWAYAM EDUCATION
Mandal Bagicha, Hemkapada,
Sunhat, Balasore-756002 ( Odisha )-India
eMail ID : tallyerp9book@gmail.com
Web : www.tallyerp9book.com
Mob : 09437264738
Get Updated ...
Website Designed, Hosted, Owned by : www.BalasoreCity.Com