The standard journal entry for an auto loan payment debits the loan payable for the principal repaid and debits interest expense for the interest charged, then credits cash for the total payment. Use this calculator to estimate a fixed monthly payment and total interest from the loan amount, APR, and term; the bookkeeping example below shows how to split an actual payment between principal and interest.
Formula
The fixed monthly payment is the loan principal multiplied by the monthly interest rate, divided by one minus the quantity one plus that rate raised to the negative number of monthly payments:
Payment = P × r / [1 − (1 + r)−n]
- P is the amount borrowed, in dollars.
- r is the monthly interest rate, calculated as APR ÷ 1,200 when APR is entered as a percentage per year.
- n is the number of monthly payments, calculated as years × 12.
The calculator rounds the payment to cents. Its total-interest estimate is rounded monthly payment × number of payments − original principal. Because the payment is rounded, the estimate can differ slightly from a lender’s exact amortization schedule or final payment.
Worked Example
Using the calculator’s defaults—$20,000 principal, 8% APR, and a five-year term:
- Convert APR to a monthly rate: 8 ÷ 1,200 = 0.0066667.
- Calculate the number of monthly payments: 5 × 12 = 60.
- Substitute into the payment formula: $20,000 × 0.0066667 ÷ [1 − (1.0066667)−60] ≈ $405.53 per month.
- Estimate total interest using the rounded payment: ($405.53 × 60) − $20,000 = $4,331.80.
The estimate is therefore a $405.53 monthly payment and $4,331.80 in total interest over 60 payments, assuming the stated terms and no additional charges.
Assumptions
- The interest rate remains fixed for the full term.
- Payments are equal monthly installments made at the end of each monthly period.
- Interest compounds monthly using APR divided by 12.
- The estimate excludes fees, taxes, insurance, and other charges; these are not calculator inputs.
How to Record an Auto Loan Payment
The calculator estimates the payment amount, but it does not determine the exact accounting split for a particular payment. In double-entry bookkeeping, the payment reduces cash. The principal portion reduces the loan liability, while the interest portion is recorded as interest expense.
For example, suppose an actual payment is $405.53, of which the lender’s statement identifies $272.20 as principal and $133.33 as interest. The entry is:
- Debit Auto Loan Payable: $272.20
- Debit Interest Expense: $133.33
- Credit Cash: $405.53
The debits total $405.53, matching the cash credit. These example split amounts illustrate the bookkeeping format; they are not the calculator’s calculated split for a particular payment. Obtain the principal and interest figures from the lender’s payment detail or amortization schedule.
For the first payment, a common calculation under a monthly-rate model is beginning loan balance × monthly interest rate = interest for the period. Subtract that interest from the payment to find principal paid. The next period’s interest is based on the reduced balance. Actual lender schedules can use contractual conventions or rounding that affect the precise figures.
Recording the Vehicle and Loan at Purchase
If a business buys a vehicle with borrowed funds, its opening entry commonly records the vehicle as an asset and the loan as a liability. For example, if the vehicle’s recorded cost is $20,000 and the entire amount is financed, a simplified entry is a $20,000 debit to a vehicle asset account and a $20,000 credit to auto loan payable. If a down payment is made, cash is also part of the purchase entry. The transaction documents and the organization’s accounting policies determine the amounts and accounts used.
Do not expense the full loan payment as though it were one operating cost: the principal portion pays down debt, while interest is a separate expense in this simplified treatment. Recording the purchase and recording each later payment are distinct events. A payment entry should not debit the vehicle asset again for principal already represented in the original purchase entry.
Common Recording Errors and Limits
- Debiting the full payment to loan payable: this understates interest expense when the payment includes interest.
- Debiting the full payment to interest: this fails to reduce the loan liability by the principal repaid.
- Using the original loan amount for every split: interest generally changes as the balance declines; use the schedule for that payment period.
- Confusing APR with a monthly rate: the calculator converts annual percentage APR to a monthly decimal by dividing by 1,200.
- Ignoring the final payment adjustment: cent rounding or lender-specific calculations can make the last payment differ from the estimate.
This calculator assumes a level-payment loan with a fixed APR and monthly periods. It does not model a variable rate, a balloon payment, skipped or late payments, extra principal payments, fees, or a different payment frequency. It also cannot replace the lender’s transaction-level breakdown. If the vehicle is partly used for business or the accounting situation is more complex, the appropriate account treatment depends on the records and accounting policies involved.
Frequently Asked Questions
What is the journal entry for a car loan payment?
Debit loan payable for principal, debit interest expense for interest, and credit cash for the full payment. The debits should equal the cash credit.
Is an auto loan payment an expense?
Not entirely in the basic entry shown here. Principal reduces the loan liability; the interest portion is recorded separately as interest expense.
How do I know how much of my payment is principal?
Use the lender’s payment breakdown or amortization schedule. In a basic monthly calculation, subtract that period’s interest from the payment to find principal.
How do I record an auto loan when buying a vehicle?
A simplified entry debits the vehicle asset and credits the loan liability for the financed amount. Record any down payment separately as a reduction of cash, following the transaction records and applicable accounting policies.
Can I use this calculator to determine the exact journal entry?
No. It estimates a level monthly payment and aggregate interest from the inputs. Use the lender’s actual payment detail to determine the principal and interest amounts for each entry.
This result is an estimate for educational arithmetic; 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
- Total Cost of Ownership Cloud Model Calculator$41,000.00
- Total Cost of Ownership Calculator: What It Includes$43,500.00
- Total Cost of Ownership Calculator in Excel$28,500.00
- Total Cost of Ownership Benefits Calculator$31,500.00
- Total Cost of Ownership Calculation: Formula and Example$33,000.00
- Total Cost of Home Ownership Calculator