calculate-loan

01 Loan payments

Unsecured Loan Entry in Tally Prime

Calculator No. 01-26973 · Updated · Formula and assumptions shown below

Monthly payment $405.53
Total interest
$4,331.67
= Monthly payment × loan term × 12 − loan amount
Loan amount
$20,000
Input
Interest rate (APR)
8 %
Input
You enter
Loan amount ($), Interest rate (APR) (%), Loan term (years)
You get
Monthly payment ($), Total interest ($)
Rounding
2 dp

Estimate for education, not financial advice. The result follows from the numbers you enter and the formula shown. It is not a quote or an offer, and it does not include fees, taxes or insurance unless the calculator asks for them. Ask your lender for the exact figures.

To record an unsecured loan in Tally Prime, you create a loan liability account and pass a journal entry debiting your bank or cash account and crediting the loan account for the amount received. This article explains the exact steps, the accounting treatment, and common issues you may face when entering unsecured loans in Tally Prime.

Formula

The calculator uses the standard amortizing loan payment formula:

PMT = P × (r × (1 + r)^n) / ((1 + r)^n – 1)

Where:

  • PMT = monthly payment (in $)
  • P = principal loan amount (in $)
  • r = monthly interest rate = APR / 12 / 100
  • n = total number of monthly payments = loan term in years × 12

Total interest = PMT × n – P.

Worked Example

Using the default values: P = $20,000, APR = 8%, term = 5 years.

  1. Convert APR to monthly rate: r = 8 / 12 / 100 = 0.0066667
  2. Number of payments: n = 5 × 12 = 60
  3. Payment = 20000 × (0.0066667 × (1.0066667)^60) / ((1.0066667)^60 – 1)
  4. Compute (1.0066667)^60 ≈ 1.48985
  5. Payment = 20000 × (0.0066667 × 1.48985) / (1.48985 – 1) = 20000 × 0.0099323 / 0.48985 ≈ 405.53
  6. Total interest = 405.53 × 60 – 20000 = 24331.80 – 20000 = 4331.80

The calculator shows a 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.
  • Interest compounds monthly at APR/12.
  • No fees, taxes, insurance, or other charges are included.

Understanding Unsecured Loans in Tally Prime

An unsecured loan is a loan not backed by collateral, such as a personal loan or a credit card balance. In Tally Prime, you record it as a liability. The key is to distinguish between the loan principal and the interest expense. When you receive the loan, you increase cash and create a loan liability. When you pay interest, you debit interest expense and credit cash. When you repay principal, you debit the loan liability and credit cash.

Step-by-Step: Recording the Loan Receipt

  1. Go to Accounting Vouchers (F7) and select Journal (F7) or use Payment if you are receiving money.
  2. Debit the bank or cash account with the loan amount received.
  3. Credit a new ledger named e.g., “Unsecured Loan – [Lender Name]” under Liabilities.
  4. Save the voucher.

Example: You receive $10,000 from a personal loan. Debit Bank $10,000, Credit Unsecured Loan $10,000.

Recording Interest Payments

Interest is an expense. When you pay interest, create a journal or payment voucher:

  • Debit Interest Expense (create a ledger under Indirect Expenses if needed)
  • Credit Bank/Cash

Do not debit the loan principal for interest payments—that would reduce the liability incorrectly.

Recording Principal Repayments

When you repay part of the principal, debit the loan liability account and credit cash/bank. This reduces the outstanding liability.

Common Mistakes and How to Avoid Them

  • Mixing interest and principal: Always separate the two transactions.
  • Using a single ledger for both loan and interest: Create separate ledgers.
  • Forgetting to set up the loan ledger correctly: Ensure it is under Liabilities, not Assets.
  • Not using the correct voucher type: Use Journal for loan receipt, Payment for repayments.

Using Tally Prime’s Loan Management Features

Tally Prime also offers a built-in Loan Management feature under Banking. You can define loan accounts, set interest rates, and generate amortization schedules. This automates interest calculations and repayment tracking. To use it, go to Banking > Loan Management and create a new loan account.

Frequently Asked Questions

How do I create a loan ledger in Tally Prime?

Go to Accounts Info > Ledgers > Create. Enter a name like “Loan from ABC Bank”, select Group: Loans and Advances (Liabilities), and save.

Can I record an unsecured loan without using a journal voucher?

Yes, you can use a Receipt voucher if you are receiving cash. Debit cash, credit the loan ledger. But a journal is more direct for non-cash transactions.

How do I show interest accrued but not yet paid?

Pass an adjusting entry at period end: Debit Interest Expense, Credit Interest Payable (a liability ledger).

What if I take a loan in foreign currency?

Record the loan in the foreign currency using a Foreign Currency ledger. Tally Prime will handle exchange rate differences if you set it up correctly.

Can I link the loan to a bank account for automatic reconciliation?

Yes, when you create the loan ledger, you can link it to a bank account under Bank Details. This helps in bank reconciliation.

The result from the calculator is an estimate; your lender’s disclosure statement provides 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

The whole Loan payments section →