calculate-loan

01 Loan payments

Unsecured Loan Under Which Head in Tally? Explained

Calculator No. 01-27051 · 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.

In Tally, an unsecured loan is recorded under the head “Loans and Advances” (or more specifically, “Secured/Unsecured Loans” within that head) on the liabilities side of the balance sheet. This article explains how to classify, record, and report unsecured loans in Tally, including the relevant accounting heads, journal entries, and common pitfalls.

Formula

The monthly payment for a fixed-rate loan is calculated using the standard amortization formula:

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

Where:

  • P = principal loan amount (in $)
  • r = monthly interest rate (APR divided by 12, expressed as a decimal; e.g., 8% APR → r = 0.08/12 = 0.006666…)
  • n = total number of monthly payments (loan term in years × 12)

The total interest is simply the total of all payments minus the principal: Total Interest = PMT × n – P.

Worked Example

Using the default values from the calculator: P = $20,000, APR = 8%, term = 5 years (n = 60 months).

  1. Monthly rate: r = 8 / 1200 = 0.0066666667
  2. Plug into formula: PMT = 20000 × (0.0066666667 × (1.0066666667)^60) / ((1.0066666667)^60 – 1)
  3. Calculate (1.0066666667)^60 ≈ 1.4898457
  4. Numerator: 20000 × (0.0066666667 × 1.4898457) = 20000 × 0.0099323 = 198.646
  5. Denominator: 1.4898457 – 1 = 0.4898457
  6. PMT = 198.646 / 0.4898457 ≈ 405.53

So the monthly payment is $405.53 (rounded to the cent). Total paid over 60 months = 405.53 × 60 = $24,331.80. Total interest = 24,331.80 – 20,000 = $4,331.80. (The calculator rounds the payment first, so the displayed total interest matches this exactly.)

Assumptions

  • Fixed interest rate for the entire loan term (no rate changes).
  • Payments are made at the end of each month (ordinary annuity).
  • Interest is compounded monthly at the rate APR/12.
  • No fees, taxes, insurance, or other charges are included; the calculator only covers principal and interest.

How to Record an Unsecured Loan in Tally

In Tally, the correct way to record an unsecured loan depends on whether you are using the standard accounting features or the newer TallyPrime interface. The fundamental principle is that a loan is a liability, so it appears on the balance sheet under a liability head. For unsecured loans (loans not backed by collateral), the typical head is “Loans and Advances” or a sub-head like “Unsecured Loans”.

Here is the step-by-step process for recording an unsecured loan in Tally:

  1. Create the loan head: Go to Accounts Info → Ledgers → Create. Create a ledger named e.g., “Unsecured Loan – ABC Bank” and under Group, select Loans and Advances (or Secured/Unsecured Loans if available).
  2. Record the loan receipt: Go to Accounting Vouchers → F6 (Receipt). Debit the bank/cash account and credit the loan ledger with the loan amount.
  3. Record interest payments: When you pay interest, use a Payment voucher (F5). Debit the Interest Expense ledger (under Indirect Expenses) and credit the bank/cash account.
  4. Record principal repayments: For principal repayment, use a Payment voucher. Debit the loan ledger (reducing the liability) and credit the bank/cash account.

If you are using Tally with GST or other features, ensure that the loan receipt is not treated as income—it is a liability, so it should not affect your profit and loss statement.

Common Mistakes When Classifying Unsecured Loans

One frequent error is classifying an unsecured loan as a current liability when it is actually a long-term liability. The classification depends on the repayment period: if the loan is due within 12 months, it is a current liability; otherwise, it is a non-current liability. In Tally, you may need to create separate heads for current and non-current portions if your financial reporting requires it.

Another mistake is recording the loan as income. A loan is not revenue; it is a liability. When you receive the loan, your cash increases, but so does your liability. Recording it as income will inflate your profits and misstate your balance sheet.

Also, many users forget to record interest accruals. If interest is due but not yet paid, you should pass an adjusting entry at the end of the period: debit Interest Expense and credit Interest Payable (a current liability). This ensures your financial statements reflect the true cost of borrowing.

How to Choose the Right Head in Tally for Different Loan Types

Tally’s default chart of accounts includes a group called “Loans and Advances” which is broad. For more clarity, you can create sub-groups:

  • Secured Loans: Loans backed by collateral (e.g., mortgage, car loan).
  • Unsecured Loans: Loans without collateral (e.g., personal loans, credit card debt, loans from friends/family).
  • Loans from Directors/Partners: Often kept separate for reporting.

In the balance sheet, these appear under the “Liabilities” section. If you are using Tally’s predefined groups, you can simply select “Loans and Advances” and then create a sub-ledger for each lender. For internal management, you might also want to track the interest rate and repayment schedule, but that is not part of the accounting head itself.

Reporting and Analyzing Unsecured Loans in Tally

Once recorded, you can view the loan balance in the Balance Sheet under the relevant head. To see the breakup of all loans, go to Balance Sheet → Loans and Advances and drill down. Tally also allows you to generate a loan ledger report to see all transactions (receipts, interest, principal repayments) for a specific loan.

For better financial analysis, you can compare the loan balance over time using Tally’s Ratio Analysis or by exporting data to a spreadsheet. Remember that an unsecured loan typically carries a higher interest rate than a secured loan because the lender has no collateral, but that is a market condition, not an accounting rule.

Frequently Asked Questions

Is an unsecured loan a current liability or a non-current liability?

It depends on the repayment term. If the loan is due within 12 months from the balance sheet date, it is a current liability; otherwise, it is a non-current liability. In Tally, you can create separate heads for each portion, or use a single head and disclose the split in notes.

Can I record an unsecured loan as income in Tally?

No. An unsecured loan is a liability, not income. Recording it as income would overstate profits and misrepresent the company’s financial position. Always credit a loan ledger, not an income account.

What if I take a loan from a friend or relative? Does it still go under “Loans and Advances”?

Yes, any borrowing, regardless of the lender, should be recorded as a liability. You can create a separate ledger under “Loans and Advances” for each lender, even if it is an individual.

How do I record interest on an unsecured loan in Tally?

When you pay interest, debit the Interest Expense ledger and credit the bank/cash. If interest is accrued but not paid, pass an adjusting entry: debit Interest Expense and credit Interest Payable (a liability).

Does Tally automatically show the loan in the balance sheet?

Yes, if you have correctly assigned the loan ledger to the “Loans and Advances” group, it will appear in the balance sheet under Liabilities. You may need to refresh or re-generate the balance sheet report.

This calculator provides an estimate of the monthly payment and total interest for a fixed-rate unsecured loan. The actual figures from your lender’s disclosure may differ due to fees, charges, or rate changes.

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 →