In Tally, record a loan EMI by splitting it between the loan liability ledger and an interest expense ledger: the principal portion reduces the liability, while the interest portion is an expense. There is no single universal “EMI head”; the correct ledgers depend on the loan and your chart of accounts.
What an EMI contains
An equated monthly instalment (EMI) is a combined payment made toward a loan. It generally includes interest for the period and repayment of some principal. The lender’s repayment schedule or statement shows how much of each instalment belongs to each component.
In Tally, these parts have different accounting effects:
- Principal repayment: reduces the outstanding loan, recorded against the relevant loan liability ledger.
- Interest: records the borrowing cost, normally under an Interest on Loan or Loan Interest expense ledger.
- Bank payment: credits the bank ledger for the full amount paid.
For example, if an instalment is 10,000 in your currency, made up of 8,200 principal and 1,800 interest, do not book the entire 10,000 as interest or as a reduction of the loan. Split it according to the lender’s breakdown.
Which ledger groups to use
Create or select a ledger for the specific loan under the appropriate liability group in your chart of accounts. The exact group depends on the loan’s nature and repayment horizon; businesses commonly distinguish borrowings due within a short period from longer-term borrowings. Follow the accounting policy and chart structure used for the entity, and check the loan agreement and accountant’s instructions if classification is unclear.
Create the interest ledger as an expense, typically grouped under indirect expenses in a conventional Tally chart. The bank account ledger should already be set up under bank accounts. Use clear names, such as “Term Loan—Lender/Account” and “Interest on Term Loan,” so reports can be traced to the correct borrowing.
A loan received is not income: it creates a liability that must be repaid. Likewise, repayment of principal is not an operating expense. The interest portion is the expense component. These distinctions help keep the profit and loss statement and balance sheet meaningful.
How to calculate the split
Use the instalment schedule supplied by the lender rather than estimating the split from the total EMI. For a standard reducing-balance loan, the interest charged for a period is generally based on the outstanding principal and the applicable periodic rate; the rest of the payment reduces principal. Actual schedules can differ because of dates, fees, rate changes, rounding, or loan-specific terms.
- Locate the payment date and amount in the lender’s statement or amortization schedule.
- Identify the interest charged for that period, including any separately stated charges that your accounting policy treats as expenses.
- Calculate principal repaid as the instalment amount less the interest and any separately accounted-for charges, matching the lender’s figures.
- Check that the principal movement agrees with the lender’s closing balance, allowing for any timing or rounding differences shown on the statement.
Do not assume every instalment has the same interest amount. With a reducing balance, the principal and interest proportions usually change across the schedule. If the rate changes, a payment is overdue, or the lender applies fees, the statement is the reliable source for that period’s actual allocation.
Recording an EMI in Tally
For a payment from a bank account, use a payment voucher and enter a split between the loan liability, interest expense, and bank. Voucher labels and menu paths can differ by Tally version and configuration, but the accounting logic is the same.
- Debit the loan liability ledger for the principal repaid.
- Debit the interest expense ledger for interest charged.
- Credit the bank ledger for the total amount paid.
Using the example above, the entry is: debit the loan liability 8,200; debit loan interest expense 1,800; credit bank 10,000. The debits and credit balance. Use the actual currency and values from the lender’s record.
If the lender deducts a separate processing charge or other amount, avoid hiding it inside principal or interest without support. Record it in the suitable ledger according to the underlying transaction and the entity’s accounting policy. Retain the lender’s statement and payment evidence as voucher support.
Common errors and reconciliation
- Posting the full EMI to interest: this overstates expenses and leaves the loan liability unreduced.
- Posting the full EMI to the loan: this understates interest expense when the payment includes interest.
- Using the wrong loan ledger: payments may appear against another borrowing, making balances difficult to reconcile.
- Entering only the bank amount: a bank transaction alone does not explain the principal and interest components.
- Ignoring dates or charges: lender balances may not match if a payment is late, fees are included, or the statement period differs.
After posting, compare the loan ledger balance with the lender’s closing principal balance for the same date. Investigate differences rather than forcing a journal entry to make figures agree. Check opening balances, missed or duplicated payments, interest allocation, fees, and whether a payment has cleared the bank. Reconcile bank transactions separately to confirm that the cash movement is recorded.
Frequently Asked Questions
Under which head should EMI be entered in Tally?
Split it: principal goes to the relevant loan liability ledger, interest goes to an interest expense ledger, and the bank ledger is credited for the total payment.
Is the full EMI an expense?
No. Only the interest component is generally recorded as an expense. The principal component reduces the outstanding liability.
Is a loan received treated as income in Tally?
No. The receipt is recorded against a loan liability ledger because it represents an amount owed, not revenue from sales or services.
What if the lender statement does not show the principal and interest split?
Request the repayment schedule or transaction statement from the lender. Do not guess the allocation when the actual breakdown can be obtained.
Should processing fees be included in the EMI interest ledger?
Not automatically. Record separately stated charges according to their nature and the entity’s accounting policy, and preserve the lender’s supporting document.
Keep the entry supported
A clear ledger structure and a period-by-period split make loan balances and expenses easier to review. Use the lender’s schedule for each payment, keep the payment evidence with the voucher, and reconcile the Tally liability balance to the lender’s statement regularly. Where classification or accounting treatment is uncertain, confirm it with the entity’s accountant.
Related
General steps for current mainstream versions; menus can differ by device and version. See the disclaimer or report an error.
More in this section
- Secured Loan for Home Refinancing: Payment Calculator$405.53
- Closing Costs on a House Loan: What to Expect$405.53
- Closing Cost House Calculator: Estimate Buyer Costs$8,500.00
- Closing Cost House Estimate Calculator
- Loan Repayment Extension Request Letter: What to Include$405.53
- Refinance Calculator With PMI and Loan Term