A loan EMI payment entry in Tally records the instalment as separate principal and interest amounts, rather than treating the whole payment as an expense. This page’s calculator estimates the monthly EMI from the loan amount, annual interest rate and term; enter those figures to see the payment and estimated total interest.
Formula
The calculator uses the standard fixed-payment loan formula. The monthly EMI is the principal multiplied by the monthly interest rate, divided by one minus the monthly-rate growth factor over the payment term:
EMI = P × r ÷ [1 − (1 + r)−n]
- P is the original loan principal, in your currency.
- r is the monthly interest rate as a decimal: annual APR ÷ 12 ÷ 100.
- n is the number of monthly payments: years × 12.
- EMI is the level monthly payment, rounded to two decimal places for the calculation.
Estimated total interest is the rounded EMI multiplied by the number of payments, minus the original principal. The result assumes a fixed rate and regular monthly payments. Tally itself does not determine a lender’s EMI; use the amount, rate and term shown in the loan documents for an estimate that reflects that loan.
Worked Example
Using the calculator’s default values—loan principal 20,000 in your currency, annual APR 8%, and a five-year term:
- Convert the APR to a monthly decimal rate: 8 ÷ 1,200 = 0.0066667.
- Convert the term to months: 5 × 12 = 60.
- Apply the EMI formula: 20,000 × 0.0066667 ÷ [1 − (1.0066667)−60].
- Round the monthly payment to two decimal places: 405.53 in your currency.
- Calculate estimated interest using the rounded payment: 405.53 × 60 − 20,000 = 4,331.80 in your currency.
This is a mathematical illustration, not a Tally posting amount for a particular loan. The actual instalment can differ if the lender uses different dates, rates, fees, payment amounts or rounding.
How to Record a Loan EMI Payment in Tally
In a typical double-entry bookkeeping setup, the EMI voucher has a debit to the loan liability for the principal repaid, a debit to interest expense for the interest charged, and a credit to the bank account for the amount paid. The principal reduces the outstanding loan; interest is a financing cost. Do not debit the full EMI to interest expense if the loan statement separates principal and interest.
Before posting, set up the relevant ledgers in the company’s chart of accounts: a loan liability ledger, an interest expense ledger and the bank ledger used for payment. Names and exact menu paths can vary by Tally product and configuration. A common workflow is:
- Open the voucher-entry screen and choose a payment voucher.
- Enter the payment date and select the bank ledger being credited.
- Enter the principal portion against the loan liability ledger and the interest portion against interest expense.
- Check that the two debits add up to the bank payment, add the lender’s reference or narration, and save the voucher.
For example, if a lender statement shows a payment of 405.53, with 272.20 applied to principal and 133.33 to interest, the entry is: debit loan liability 272.20; debit interest expense 133.33; credit bank 405.53. The split must come from the lender’s repayment schedule or statement, not from an assumed equal division.
Understanding the Principal and Interest Split
For a standard amortising loan, interest for a period is generally calculated on the outstanding balance under the loan’s stated terms. Early payments therefore often contain a larger interest portion than later ones, while the principal portion grows as the balance falls. The total EMI can remain level even though its accounting components change each month.
A useful check is to compare the opening balance, principal reduction and closing balance. If the opening loan balance is 20,000 and the statement assigns 272.20 of a payment to principal, the balance after posting that principal is 19,727.80, before considering any other adjustments. Interest does not reduce the liability; it is recorded separately as an expense. Confirm the lender’s exact allocation and account for any charges separately according to the supporting documents and your bookkeeping policy.
Reconcile the Voucher and Avoid Common Errors
- Posting the whole instalment to the loan: this overstates the reduction in the liability when part of the payment is interest.
- Posting the whole instalment to interest: this leaves the loan balance unreduced and misclassifies principal repayment.
- Using an estimated split: EMI calculators estimate payment amounts, but do not replace the lender’s period-by-period allocation.
- Mixing up payment date and period: use the date and reference supported by the bank record and lender statement.
- Ignoring differences: if the voucher does not match the bank debit, check rounding, a changed instalment, fees, a missed or extra payment, or a rate reset before saving a correction.
After entry, compare the voucher total with the bank statement and compare the loan ledger balance with the lender’s statement for the same date. If there are separate processing charges, penalties or other items, do not silently fold them into principal or interest; identify them from the statement and record them using the appropriate ledger.
What the Calculator Does Not Include
This estimate assumes a fixed annual APR converted to a monthly rate, equal monthly payments, and a term expressed in whole months as years × 12. It does not model changing rates, irregular payment dates, daily interest calculations, balloon payments, payment holidays, extra principal payments, fees or charges. It also does not calculate the actual outstanding balance on a specific date or create a Tally voucher.
Enter the lender’s disclosed principal, rate and contractual term, and use the repayment schedule for the actual principal-interest split. The rate and other loan figures are inputs, not market guidance; obtain the applicable figures from the lender’s documents. The result is an estimate, and the lender’s disclosure gives the exact figures.
Frequently Asked Questions
What is the journal entry for an EMI payment in Tally?
Debit the loan liability for the principal portion, debit interest expense for the interest portion, and credit the bank ledger for the full payment. The two debits should equal the bank credit.
Should the full EMI be recorded as an expense?
No. In a standard loan repayment entry, principal reduces the loan liability; only the interest portion is recorded as interest expense. Use the lender’s statement to identify each portion.
How do I find the principal and interest portions?
Check the repayment schedule or statement supplied by the lender for that instalment. A basic EMI calculator gives a payment estimate but may not reproduce the lender’s calculations, dates, rounding or charges.
Can I enter an EMI through a payment voucher?
A payment voucher is commonly used to record an amount paid from a bank account. The precise voucher setup and navigation depend on the Tally version and company configuration.
Why does my Tally loan balance differ from the lender’s balance?
Check that each payment’s principal portion was posted correctly, and compare dates and statement periods. Also investigate missing or duplicate payments, rate changes, additional charges and rounding differences.
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 EMI | - | 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
- Closing Costs on a House Loan: What to Expect$405.53
- Secured Loan for Home Refinancing: Payment Calculator$405.53
- Closing Cost House Estimate Calculator
- Closing Cost House Calculator: Estimate Buyer Costs$8,500.00
- Loan Repayment Extension Request Letter: What to Include$405.53
- Refinance Calculator With PMI and Loan Term