A loan account journal entry records money borrowed, principal repaid, and interest incurred or paid. This calculator works out the monthly payment and total interest for a fixed-rate, fully amortizing loan; enter the loan amount, annual APR, and term to see the estimated results.
Formula
The calculator first finds the fixed monthly payment for a loan repaid in equal monthly installments, then subtracts the original principal from all scheduled payments to estimate total interest.
- Monthly payment: M = round[P × r / (1 − (1 + r)−n), 2]
- Total interest: I = M × n − P
- Monthly rate: r = APR / 1,200
- Number of payments: n = years × 12
P is the loan principal in dollars, APR is the annual percentage rate expressed as a percentage, r is the monthly rate as a decimal, n is the number of monthly payments, M is the payment in dollars, and I is total interest in dollars. The payment is rounded to cents before total interest is calculated.
Worked Example
Using the calculator’s defaults: P = $20,000, APR = 8%, and a five-year term:
- Convert the annual rate to a monthly decimal: r = 8 / 1,200 = 0.0066667.
- Find the number of payments: n = 5 × 12 = 60.
- Apply the payment formula: M = round[$20,000 × 0.0066667 / (1 − (1.0066667)−60), 2] = $405.53 per month.
- Calculate total interest using the rounded payment: I = $405.53 × 60 − $20,000 = $4,331.80.
Assumptions
- The interest rate stays fixed for the full term.
- Payments are equal, monthly, and made at the end of each monthly period.
- Interest compounds monthly at APR divided by 12.
- The estimate excludes fees, taxes, insurance, PMI, and escrow; none of these are calculator inputs.
- The calculation assumes the loan is fully repaid by the scheduled final payment and does not model a changing balance from extra payments or missed payments.
What a Loan Account Journal Entry Records
A journal entry is the accounting record of a transaction, not a payment schedule. A loan is generally a liability for the borrower: it represents an amount owed. When a borrower receives loan proceeds in cash, the basic entry is a debit to Cash and a credit to Loan Payable for the principal received. Debits and credits must balance.
For example, if a business receives $20,000 directly into its bank account, the initial entry is:
- Debit Cash: $20,000
- Credit Loan Payable: $20,000
The entry reflects two simultaneous effects: the business has more cash, and it has an obligation to repay the lender. If the lender pays a vendor directly instead, the debit may be to the asset or expense acquired rather than Cash. The appropriate account depends on what the proceeds purchased and the entity’s accounting framework.
Recording Principal and Interest Payments
A combined loan payment usually contains principal and interest. Principal reduces the loan liability; interest is ordinarily recorded separately as an expense for a borrower. A simplified payment entry is:
- Debit Loan Payable for the principal portion
- Debit Interest Expense for the interest portion
- Credit Cash for the total payment
In the example, the first month’s interest under the calculator’s assumptions is approximately $20,000 × 8% / 12 = $133.33. With a $405.53 payment, about $272.20 reduces principal. A simplified entry would debit Interest Expense $133.33, debit Loan Payable $272.20, and credit Cash $405.53. Later payments have a different split because interest is calculated on the remaining balance. The lender’s statement or amortization schedule provides the actual allocation and any rounding adjustments.
If interest has accumulated but has not yet been paid at a reporting date, an entity may need to record accrued interest. A simplified accrual is a debit to Interest Expense and a credit to Interest Payable. When the interest is later paid, Interest Payable is debited and Cash is credited for that accrued amount. The exact timing and account names depend on the accounting method and applicable requirements.
Using the Calculator Alongside Journal Entries
The calculator estimates an installment payment and total interest for a standard fixed-rate loan. It helps illustrate why each payment is split between principal and interest, but its output is not itself a journal entry. To record a real transaction, use the amount actually disbursed, the lender’s payment breakdown, and the relevant account balances.
Use the figures as follows:
- Enter the principal actually borrowed, not the total of all scheduled payments.
- Enter APR as a percentage per year, such as 8 for 8%, and enter the term in years.
- Compare the calculated payment with a lender-provided schedule; differences can arise from fees, payment dates, rate conventions, or rounding.
- For each accounting period, separate the actual interest amount from the principal reduction before posting the payment.
APR and the interest rate used in an accounting schedule are not always interchangeable in every loan contract. This calculator treats the entered APR as a nominal annual rate divided by 12 and does not separately model financed charges or other pricing details. Obtain the applicable rate and payment allocation from the lender’s disclosures and records.
Common Mistakes and Limits
A frequent mistake is to debit Loan Payable for the entire cash payment. That overstates the principal reduction when part of the payment is interest. Another is crediting Loan Payable when the borrower makes a repayment; for a liability, a debit reduces the balance. The lender’s perspective is the reverse: a loan receivable is an asset, and receiving principal generally credits that receivable.
Do not confuse the original loan amount, remaining principal, and total repayment. The principal is the amount borrowed; the balance falls as principal is repaid; total scheduled payments include interest. The calculator’s total interest is an estimate based on rounded monthly payments and the stated assumptions. Actual final amounts may differ because of payment timing, fees, variable rates, irregular installments, or lender-specific rounding. This standard formula also does not calculate journal entries for loan origination costs, discounts, penalties, or non-monthly repayment arrangements.
Frequently Asked Questions
What is the journal entry when a loan is received?
Typically, debit Cash (or the asset acquired) and credit Loan Payable for the principal recognized. The entry must reflect where the loan proceeds went.
How do you record a loan repayment?
Debit Loan Payable for the principal portion, debit Interest Expense for the interest portion, and credit Cash for the payment total. Use the lender’s breakdown rather than assuming the whole payment is principal.
Is a loan a debit or a credit?
For a borrower, a loan payable is a liability, and an increase in that liability is recorded as a credit. Repaying principal reduces the liability with a debit.
How do I calculate the principal portion of a payment?
Subtract that period’s interest from the total payment. For a standard monthly schedule, interest is generally based on the opening balance and the applicable monthly rate; verify the lender’s method.
Does this calculator create accounting entries?
No. It estimates a level monthly payment and total interest. A journal entry requires the actual transaction amounts and the loan’s documented principal-and-interest allocation.
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 | $ | round(p * (apr / 1200) / (1 - (1 + apr / 1200) ^ -(yrs * 12)), 2) | 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
- United Test and Balance: What It Means in Finance
- Up-to-Date Loan Balance Calculator$16,611.20
- Trade Date Balance: Meaning and How It Works
- UBS Trade Date Balance: Meaning and How It Works
- Time Left on Loan Calculator: Estimate Payoff Time60 months
- The Balance in Journaling: Finding a Sustainable Practice