A secured loan is recorded in Tally as a liability, while the asset pledged as security usually remains recorded separately in the books. Enter the loan proceeds as a receipt or journal transaction, crediting the appropriate loan account and debiting the bank or cash account; record interest and principal repayments separately.
Formula
This calculator estimates the monthly payment on a fixed-rate loan and the total interest paid over the stated term. It is a general arithmetic illustration related to loan bookkeeping, not a feature of Tally and not a substitute for the lender’s repayment schedule.
- Monthly payment: P × r ÷ [1 − (1 + r)−n]
- Total interest: monthly payment × n − P
- P is the original loan principal in dollars.
- r is the monthly interest rate, calculated as APR ÷ 1,200.
- n is the number of monthly payments, calculated as years × 12.
The payment output is rounded to cents by the calculator display. The interest output uses the displayed payment multiplied by the stated number of payments, less the original principal. Actual lender schedules can differ due to rounding, fees, payment dates, or other contract terms.
Worked Example
Using the calculator’s default values: principal P = $20,000, APR = 8%, and term = 5 years.
- Convert APR to a monthly rate: r = 8 ÷ 1,200 = 0.0066667.
- Convert the term to payments: n = 5 × 12 = 60.
- Apply the payment formula: $20,000 × 0.0066667 ÷ [1 − (1.0066667)−60] = approximately $405.53 per month.
- Calculate the displayed total interest: ($405.53 × 60) − $20,000 = $4,331.80.
The payment is rounded to cents for display. The formula expression itself retains full precision before the display rounding, so small differences can occur between the worked arithmetic using rounded intermediate values and the calculator’s underlying result.
Assumptions
- The interest rate remains fixed throughout the full term.
- Payments are level monthly payments made at the end of each monthly period.
- Interest compounds monthly at APR divided by 12.
- Fees, taxes, insurance, late charges, and any collateral-related costs are not included.
How to Enter a Secured Loan in Tally
In Tally, the accounting entry depends on what happened in the transaction. Receiving the loan proceeds increases cash or the bank balance and creates a liability to the lender. The asset pledged as collateral is not automatically removed from the books: it generally remains in its existing asset account unless a separate transaction changes its ownership or accounting treatment.
First create or identify a ledger for the borrowing, such as “Secured Term Loan,” under the appropriate loan liability group available in your Tally version. Give it a clear name that distinguishes it from other facilities. Then record the disbursement using the voucher type that matches the transaction and your organization’s bookkeeping setup.
- Loan received into bank: Debit the bank ledger; credit the secured loan liability ledger.
- Loan received in cash: Debit cash; credit the loan liability ledger.
- Principal repaid: Debit the loan liability ledger; credit bank or cash.
- Interest paid: Debit the relevant interest expense ledger; credit bank or cash.
For example, if a lender disburses $20,000 directly to the business bank account, the basic receipt entry is debit Bank $20,000 and credit Secured Term Loan $20,000. This records the money received and the obligation owed. It does not by itself record the collateral, interest expense, or future instalments.
Recording Instalments and the Collateral
An instalment may include both principal and interest. If a $405.53 payment contains $300 of principal and $105.53 of interest according to the lender’s schedule, record the principal portion against the loan liability and the interest portion as an expense, with the total credited to the bank. Do not treat the entire instalment as interest or reduce the loan balance by the whole payment.
Use the lender’s repayment statement or amortization schedule to identify each split. The exact allocation changes over time for most amortizing loans: the interest portion is calculated on the outstanding balance, while the principal portion reduces it. If the lender charges a fee or collects another amount with a payment, record that separately using the supporting documentation and your accountant’s chart-of-accounts guidance.
The collateral—such as a vehicle, equipment, or property—normally remains in its asset ledger if the business still owns it. A loan’s security arrangement is not the same as a purchase, sale, or transfer entry. Maintain the loan agreement and security documentation, and avoid creating a second asset entry merely because an asset is pledged.
Choosing the Right Voucher and Checking the Entry
Tally’s menus and voucher names can vary by product edition, version, and configuration. A receipt voucher is commonly used to record money received, while a payment voucher records money paid. A journal voucher may be used for an adjustment or a combined accounting entry when appropriate. The key is that the voucher must produce the correct debit and credit balances, not that one particular screen is used in every installation.
- Check the loan account is classified as a liability rather than income.
- Match the receipt to the bank statement and the lender’s disbursement advice.
- Reconcile principal outstanding in the books with the lender’s statement.
- Keep principal repayment and interest expense distinct.
- Review dates, voucher narration, reference numbers, and supporting documents.
If the lender disburses funds directly to a supplier instead of depositing them in the business bank account, the entry will depend on the underlying purchase and how the asset or expense is recorded. Do not force the transaction through a bank account that never received the money; use the documented transaction flow and obtain accounting guidance when the purchase and borrowing are linked.
Common Errors and Practical Limits
A frequent mistake is crediting the loan to income. Borrowed funds create a repayment obligation and are not sales revenue. Another is recording the entire monthly instalment as principal, which understates interest expense and overstates the remaining loan balance. A third is reducing the collateral asset when the loan is received, even though the business may still own and use that asset.
Also distinguish the original principal from the current balance. A lender statement may show accrued interest, fees, or other movements that mean its payoff amount is not identical to the principal balance in the ledger. Compare like with like, and investigate differences rather than posting a balancing figure without evidence.
The calculator above assumes a fixed APR and equal end-of-month payments. It does not calculate the exact lender schedule, identify a loan’s accounting classification, or determine the correct ledger group for every business. Tally data-entry details depend on the installed version and company setup; verify entries against original documents and applicable accounting policies.
Frequently Asked Questions
Is a secured loan an asset or a liability in Tally?
A loan the business must repay is recorded as a liability. Money received is recorded in bank or cash, and the loan balance is credited to the liability ledger.
Which voucher should I use for a loan received?
A receipt voucher is commonly used when funds arrive in bank or cash. The exact voucher workflow may differ by Tally version and transaction details, so check that the resulting ledgers are correctly debited and credited.
How do I record a loan EMI in Tally?
Split the instalment using the lender’s schedule: debit the loan liability for principal, debit interest expense for interest, and credit bank for the total payment. Record any separately documented charges appropriately.
Do I record the pledged asset again when taking the loan?
No, not simply because it is pledged. If the business already records the asset and continues to own it, the loan entry does not itself create another asset entry.
Can the calculator’s payment be entered as the exact EMI?
Use it only as a mathematical estimate. Check the actual instalment and principal-interest split in the lender’s schedule, which may reflect fees, different dates, rounding, or other contract terms.
This result is an estimate for educational purposes; the lender’s disclosure gives 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
- Plan 2 Repayment Amount? Calculate Your Monthly Payment243.45 £
- Plan 2 Repayment Calculator: Estimate Monthly Deductions20.29 £
- New Standard Repayment Plan: Estimate Monthly Payments$405.53
- Pay As You Earn Repayment Calculator and Guide$405.53
- Federal Loan Repayment Plan Calculator$405.53
- Loan Repayment Comparison Calculator: Compare Payments$405.53