To record an interest payment in Tally, go to Accounting Vouchers (F5 for Payment), select the interest expense account as the debit, and the bank or cash account as the credit, then enter the amount and save. This article explains the exact steps, the underlying accounting entries, how to handle TDS on interest, and common mistakes to avoid.
Formula
The calculator above computes the monthly payment and total interest for a fixed-rate loan. The monthly payment formula is:
PMT = P × (r / (1 – (1 + r)^-n))
Where:
- P = loan amount (principal) in dollars
- r = monthly interest rate = annual APR ÷ 12 ÷ 100 (e.g., 8% APR → 0.08/12 = 0.006667)
- n = total number of monthly payments = loan term in years × 12
- PMT = monthly payment in dollars
Total interest = PMT × n − P.
Worked Example
Using the default values: P = $20,000, APR = 8%, term = 5 years.
- Monthly rate r = 8 / 1200 = 0.0066667
- Number of payments n = 5 × 12 = 60
- Monthly payment = 20000 × (0.0066667 / (1 – (1.0066667)^-60))
- Calculate (1.0066667)^-60 ≈ 0.67121
- 1 – 0.67121 = 0.32879
- 0.0066667 / 0.32879 ≈ 0.020276
- PMT = 20000 × 0.020276 ≈ $405.53
- Total interest = 405.53 × 60 − 20000 = $4,331.80
The calculator shows the same monthly payment of $405.53 and total interest of $4,331.80.
Assumptions
- Fixed interest rate for the entire term.
- Payments are made at the end of each month (ordinary annuity).
- Interest compounds monthly at APR/12.
- No fees, taxes, insurance, or other charges are included.
This calculator is for educational estimation; the lender’s disclosure provides exact figures.
How to Record Interest Payment in Tally
In Tally, interest payments are recorded as a payment voucher (F5) or journal voucher (F7) depending on the transaction. Here is the standard procedure:
- Open Tally and select the company.
- Go to Accounting Vouchers (shortcut: press F5 for Payment).
- Select the Bank or Cash account as the credit side (the source of payment).
- Select the Interest Expense account as the debit side (the expense account).
- Enter the amount of interest paid.
- Add narration if needed, then press Enter to save.
For interest on a loan, you may also need to record the loan principal separately if you are repaying both. The principal repayment is not an expense; it reduces the liability.
Understanding the Accounting Entry
The double-entry principle requires that every transaction has equal debits and credits. For an interest payment:
- Debit Interest Expense (increases expense)
- Credit Bank/Cash (decreases asset)
If you pay interest on a loan, the journal entry is:
Interest Expense A/c Dr.
To Bank A/c
If you are also paying principal, the entry becomes:
Loan A/c Dr. (principal portion)
Interest Expense A/c Dr. (interest portion)
To Bank A/c (total payment)
This keeps the loan liability accurate and records the expense correctly for profit & loss statements.
Handling TDS on Interest
In many countries, tax is deducted at source (TDS) on interest payments. In Tally, you can record TDS by creating a TDS payable account and splitting the payment:
- Debit Interest Expense with the gross interest amount.
- Credit Bank with the net amount paid.
- Credit TDS Payable with the TDS amount.
For example, if gross interest is $500 and TDS is 10%, the entry is:
Interest Expense Dr. $500
To Bank $450
To TDS Payable $50
Later, when you deposit TDS with the government, you debit TDS Payable and credit Bank.
Common Mistakes and How to Avoid Them
- Mixing principal and interest: Only the interest is an expense; principal reduces a liability. Always split the payment.
- Wrong account selection: Use the correct expense account (e.g., “Interest on Loan” not “Bank Charges”).
- Forgetting TDS: If applicable, record TDS separately to avoid compliance issues.
- Rounding errors: Enter exact amounts, especially when interest is calculated daily.
- Not using narration: Add a note like “Interest payment for loan #123” for audit trails.
Using Tally’s Interest Calculation Feature
Tally can automatically compute interest on outstanding balances using the Interest Calculation feature. Go to Display → Statement of Accounts → Interest to configure rates and periods. This is useful for tracking interest on receivables or payables without manual computation.
To enable automatic interest:
- Go to F11: Features → Accounting Features.
- Set “Activate Interest Calculation” to Yes.
- Define interest rates and parameters in Company Info.
Then Tally will show interest amounts in statements, and you can pass the entry directly from there.
Frequently Asked Questions
Q: How do I record interest received in Tally?
Interest received is the opposite: debit Bank/Cash, credit Interest Income (or Interest Received) account. Use a receipt voucher (F6).
Q: Can I use a journal voucher for interest payment?
Yes, if the payment is not immediate or you want to record the liability first. For cash/bank payments, the payment voucher is simpler.
Q: What if I pay interest monthly but the loan statement shows annual?
You should record each monthly payment as it occurs. The loan statement will reconcile with your entries.
Q: How do I handle interest on a credit card in Tally?
Treat it like any interest expense: debit Interest Expense, credit Bank/Cash. The credit card bill itself is a liability, but the interest portion is an expense.
Q: Is interest on a loan a business expense?
For business purposes, yes, it is typically an operating expense that reduces taxable profit, but tax rules vary by jurisdiction. Consult a tax professional.
This guide provides the general accounting method; always verify with your accountant or tax advisor for specific compliance.
The result from the calculator is an estimate; the lender’s disclosure gives the exact figures.
Related
Formula used
in p | Loan amount | $ | 20000 | 1 | 100000000 in apr | Interest rate (APR) | % | 8 | 0.01 | 100 in yrs | Loan term | years | 5 | 0.0833 | 50 out pmt | Monthly payment | $ | p * (apr / 1200) / (1 - (1 + apr / 1200) ^ -(yrs * 12)) | 2 out int | Total interest | $ | pmt * yrs * 12 - p | 2
Each line is one input (in, sel, list) or one result (out: label, unit, formula, decimals). How the calculators work
Method: the standard loan formula for this calculation, fixed rate and monthly compounding unless stated, rounded as each result states. Not financial advice; no lender, rate or product is recommended. See formulas and assumptions, the disclaimer or report an error.
More in this section
- QNB Car Loan Payment Calculator and Guide$405.53
- Car Loan Payment Calculator and Formula$405.53
- VA Down Payment Assistance Calculator and Guide$15,000.00
- Low Down Payment Home Loans: Costs and Trade-Offs$405.53
- Down Payment vs Advance Payment: Key Differences
- DIB Bank Car Loan Calculator and Payment Guide$405.53