How to Enable Interest Calculation in TallyPrime: Receivables & Payables
How to Enable Interest Calculation in TallyPrime: Receivables & Payables
Learn how to enable, configure, and calculate simple and compound interest in TallyPrime for outstanding ledger balances and invoices. Detailed setup guide.
Who is this for: Step-by-Step Tutorial
Tracking interest on outstanding customer accounts and supplier bills helps businesses enforce credit terms, recover lost interest revenue, and manage financial costs. TallyPrime includes a built-in interest utility that calculates simple and compound interest automatically based on ledger balances and specific transaction dates. Let's walk through configuring the system, setting parameters, and managing legal compliance liabilities.
Key Takeaway (BLUF)
To calculate interest in TallyPrime: Enable interest calculation in F11 Features, enable Activate Interest Calculation in the ledger settings of your Debtors/Creditors, and configure the interest rate (e.g. 12% per year) and calculation style (e.g. 365-day year or Calendar year). Use the Interest Receivable report to track outstanding amounts.
TallyPrime Interest Calculation Settings Matrix
When setting up ledger parameters, select the correct interest styling based on your commercial agreements:
| Calculation Style | Compounding Frequency | Day Basis | Use Case |
|---|---|---|---|
| 30-Day Month | None (Simple Interest) | 30 Days Flat per Month | Standard retail credit sales. |
| 365-Day Year | None (Simple Interest) | 365 Days per Year | Bank loans and finance credits. |
| Calendar Month / Year | Monthly Compounding | Actual Days in Calendar Month | MSME outstanding bills (compounded monthly). |
Step 1: Enable Interest Calculation Feature
Activate the interest calculation utility in TallyPrime's F11 Features list:
- From the Gateway of Tally screen, press F11 to open the Company Features panel.
- Locate the Enable Interest Calculation setting under the Accounting section and set it to Yes.
- Press Ctrl+A to save and apply the company features configuration.
Step 2: Configure Interest in Party Ledgers
Define the interest rate and calculation rules on a ledger-by-ledger basis:
Select Target Ledger
Go to Gateway of Tally > Alter > Ledger and select your customer (Sundry Debtor) or vendor (Sundry Creditor) ledger.
Enable Interest Parameters
Set the option Activate Interest Calculation to Yes to display the interest setup dialog.
Configure Rate and Calculation Basis
Enter the annual interest rate (e.g. 18%). Choose 365-day year or Calendar Year for the interest style. Define the calculation start point (e.g. from the invoice due date or the transaction date). Save.
Legal Compliance: MSMED Act Section 16 Calculator
Under **Section 16 of the MSMED Act 2006**, if your business is registered as an MSME and a buyer delays payments beyond the 45-day statutory limit, they are legally liable to pay compound interest at **three times the RBI Bank Rate** compounded monthly. Use the interactive calculator below to check the legal interest penalty for outstanding invoices:
MSME Delayed Payment Interest Calculator
Section 16, MSMED Act 2006 compliance checker
Calculation Output
Legal Penal Interest Due
₹3,356
Total Receivable Amount
₹1,03,356
Under **Section 16 of the MSMED Act**, the buyer is legally liable to pay compounding interest on delayed payments exceeding 45 days at **three times the Bank Rate** notified by the RBI.
How to View Interest Reports in TallyPrime
Once interest parameters are active and vouchers are entered, TallyPrime calculates the outstanding balances in the background. To view interest reports:
- Navigate to Gateway of Tally > Display More Reports (D) > Statements of Accounts > Interest Calculations.
- Select Interest Receivable (to view interest owed by customers) or Interest Payable (to view interest owed to suppliers).
- Press Alt+F2 to set the date range. TallyPrime calculates the interest dynamically for the selected window.
Troubleshooting Common Interest Calculation Discrepancies
- Bill-by-Bill Feature Disabled: If you do not enable the "Maintain Bill-by-Bill" setting on your party ledgers, Tally cannot track specific invoice due dates and will default to calculating interest on the ledger's total balance.
- Voucher Dates Outside Report Range: If the transaction date falls outside the reporting period specified in your reports screen, the calculations will display as ₹0. Check the date range using Alt+F2.
- Interest Ledgers Missing: Remember to create separate "Interest Received" and "Interest Paid" ledgers under Indirect Income and Expenses to record interest adjustments via Journal Vouchers.
Automating Outstanding Invoices with TrulyInvoice
TrulyInvoice makes tracking accounts receivable simple. The dashboard tracks unpaid customer bills, highlights payment delays, and helps CA firms and businesses prevent cash flow leakage by monitoring outstanding balances in real-time.
Chartered Accountant & Accounting Automation Specialist