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.
- Convert APR to monthly rate: r = 8 / 12 / 100 = 0.0066667
- Number of payments: n = 5 × 12 = 60
- Payment = 20000 × (0.0066667 × (1.0066667)^60) / ((1.0066667)^60 – 1)
- Compute (1.0066667)^60 ≈ 1.48985
- Payment = 20000 × (0.0066667 × 1.48985) / (1.48985 – 1) = 20000 × 0.0099323 / 0.48985 ≈ 405.53
- 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
- Go to Accounting Vouchers (F7) and select Journal (F7) or use Payment if you are receiving money.
- Debit the bank or cash account with the loan amount received.
- Credit a new ledger named e.g., “Unsecured Loan – [Lender Name]” under Liabilities.
- 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
- Personal Loan Interest Deduction: What’s Tax-Deductible?$4,331.67
- Personal Interest Rate Loan Benefits Explained$405.53
- Personal Interest Rate Loan Options: How to Compare$405.53
- Personal Loan vs Savings: Which to Use?$405.53
- Personal Interest Rate Loan Application: How It Works$405.53
- Open Savings Account Interest Rates: How They Work$5,384.45