Loan Amortization in QuickBooks Online Explained

Loan amortization in QuickBooks Online is the process of recording each loan payment as separate principal and interest amounts so the loan balance falls correctly over time. This calculator estimates a fixed-payment loan’s monthly payment and total interest from its principal, annual APR, and term; enter those figures to see the results.

Formula

The monthly payment is calculated using the standard level-payment loan formula:

PMT = P × r ÷ [1 − (1 + r)⁻ⁿ]

• P is the amount borrowed, in dollars.
• r is the monthly interest rate, calculated as APR ÷ 1,200. APR is entered as a percentage per year.
• n is the number of monthly payments, calculated as loan term in years × 12.
• PMT is the monthly payment, in dollars. The calculator displays it rounded to cents.

Total interest is calculated as PMT × n − P, using the displayed monthly payment rounded to cents. The formula assumes equal payments made monthly at a fixed rate. A real lender’s payment schedule can differ if the loan has fees, a different payment frequency, variable rates, or other terms.

Worked Example

Using the calculator’s default inputs—$20,000 principal, 8% APR, and a five-year term:

1. Convert the APR to a monthly rate: 8 ÷ 1,200 = 0.0066667.
2. Convert the term to months: 5 × 12 = 60 payments.
3. Apply the payment formula: $20,000 × 0.0066667 ÷ [1 − (1.0066667)⁻⁶⁰] = $405.53 per month, rounded to cents.
4. Calculate interest using that rounded payment: $405.53 × 60 − $20,000 = $4,331.80.

The calculator therefore returns a monthly payment of $405.53 and total interest of $4,331.80. The last payment on an actual amortization schedule may need a small adjustment because payment amounts are rounded.

Assumptions

• The interest rate stays fixed for the entire term.
• Payments are equal, monthly, and made at the end of each monthly period.
• Interest is compounded monthly using APR ÷ 12.
• The calculation excludes fees, taxes, insurance, PMI, escrow, and any other charges not entered as inputs.

What Loan Amortization Means in QuickBooks Online

QuickBooks Online is accounting software, not a loan-underwriting or amortization calculator. For bookkeeping, amortization means splitting a payment between interest expense and a reduction of the loan liability. The lender’s statement or a separate amortization schedule provides the split for each payment; the calculator above estimates a schedule only under its stated assumptions.

For example, in the first month of the example loan, estimated interest is $20,000 × 0.08 ÷ 12, or about $133.33. If the payment is $405.53, the remaining $272.20 reduces principal. The balance after that payment is approximately $19,727.80. In later months, interest is calculated on the lower balance, so the interest portion generally declines while the principal portion rises.

That pattern is different from recording the full payment as an expense. The principal portion repays an amount already recorded as a liability; it is not interest expense. The interest portion is recorded separately as an expense, using the appropriate account setup and the lender’s actual figures.

Recording Loan Payments in QuickBooks Online

Account names and screen labels can vary with product version and setup, but the accounting entry generally debits the loan liability for principal and interest expense for interest, then credits the bank account for the total payment. A split transaction can represent these parts within one payment entry.

1. Confirm that the loan liability account exists and that its opening balance matches the books or lender records.
2. Use the lender’s statement or amortization schedule to identify the payment’s principal and interest amounts.
3. Record the full payment from the correct bank account, allocating principal to the loan liability and interest to the interest expense account.
4. Reconcile the bank account and compare the recorded loan balance with the lender’s statement.

For the example’s first payment, the estimated split would be $272.20 to principal and $133.33 to interest, totaling $405.53. Use the lender’s actual figures for bookkeeping rather than relying on this estimate. If a payment includes separate fees or escrow amounts, those need their own treatment based on the statement and accounting setup.

Common Errors and Limits

• Posting the whole payment to interest: This overstates interest expense and leaves the loan liability too high.
• Using the original loan amount for every interest calculation: Amortizing interest is based on the outstanding balance for the period, not always the original principal.
• Mixing APR and monthly rates: This calculator takes APR as a yearly percentage and converts it to a monthly rate. Do not enter a monthly percentage as though it were APR.
• Ignoring payment timing or fees: A variable rate, irregular payment date, deferred payment, extra principal payment, or lender fee can change the statement’s allocation.
• Forcing a reconciliation with an estimate: Small differences can come from rounding or schedule details. Investigate against lender records instead of changing entries merely to make the estimate match.

The calculator does not connect to QuickBooks Online, create transactions, import a lender schedule, or determine tax treatment. It models a conventional fixed-rate loan with monthly equal payments, and it cannot reproduce every contract’s conventions. Obtain the exact payment breakdown and balance from the lender’s disclosure or account records.

Frequently Asked Questions

Does QuickBooks Online automatically amortize a loan payment?
QuickBooks Online can record a payment split between principal and interest, but the split must come from the lender’s schedule or another reliable calculation. Do not assume the software knows the loan’s terms automatically.

How do I split a loan payment in QuickBooks Online?
Record the payment from the bank account and allocate its principal portion to the loan liability account and its interest portion to an interest expense account. Follow the lender’s statement for the amounts and reconcile the transaction.

Is loan principal an expense?
No. Principal repays the loan liability. Interest is generally recorded separately as an expense in the books; the precise account treatment depends on the accounting setup and applicable requirements.

Can this calculator produce a QuickBooks amortization schedule?
It estimates payment and total interest for a fixed-rate loan. It does not create or upload a schedule in QuickBooks Online, and the estimates may differ from a lender’s detailed schedule.

Why does my QuickBooks loan balance differ from the lender’s?
Check the opening balance, payment dates, principal and interest split, fees, extra payments, and rounding. Compare transactions with the lender’s records before making an adjustment.

This result is an estimate for educational purposes; the lender’s disclosure gives the exact figures.

Related

• Term Loan Journal Entry: Record Borrowing and Payments
• Short-Term Personal Loan Payment Calculator
• Term Loan EMI Calculator in Excel: Formula and Example

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