QuickBooks Online Amortization Schedule Calculator

This calculator creates a fixed-payment loan amortization schedule from the loan amount, annual APR, and term, showing the monthly payment and total interest. QuickBooks Online does not provide a general-purpose loan amortization schedule calculator; use the figures here to understand the loan math, then record transactions in QuickBooks using the accounts and workflow appropriate to your books.

Formula

The calculator uses the standard level-payment formula for a fully amortizing loan with a fixed rate and monthly payments:

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

• P is the starting loan principal, 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 the term in years × 12.
• Total interest is the rounded monthly payment × number of payments − original principal.

The monthly payment is rounded to cents before total interest is calculated. This mirrors the calculator’s stated convention, though a lender’s payment allocation and final installment can differ because of its actual dates, rounding, and loan terms.

Worked Example

Using the default inputs—$20,000 principal, 8% APR, and a 5-year term:

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

Assumptions

• The interest rate stays fixed for the full term.
• Payments are level, made monthly, and occur at the end of each monthly period.
• Interest compounds monthly at APR ÷ 12.
• The estimate excludes fees, taxes, insurance, PMI, escrow, late charges, and any extra or missed payments.

Using the Schedule With QuickBooks Online

An amortization schedule divides each payment into interest and principal. Early in a typical amortizing loan, the outstanding balance is larger, so more of a payment goes toward interest. As principal falls, the interest portion usually declines and the principal portion rises. The schedule is a calculation aid; QuickBooks Online is the accounting system where transactions are entered and reports are maintained.

For bookkeeping, a common general approach is to track the loan balance in a liability account and record the interest portion separately as interest expense. A payment that includes both principal and interest should not normally be treated as if the entire amount reduced the loan principal: principal lowers the liability, while interest is an expense. Exact account setup depends on the entity’s chart of accounts and accounting circumstances, so confirm the treatment with a qualified bookkeeper or accountant if unsure.

To make a schedule usable for entries, you need more than the monthly payment. For each due date, obtain the lender’s actual breakdown between principal, interest, and any other charges. Enter the transaction with the correct date and split the amount between the relevant accounts. Compare the resulting liability balance with the lender’s statement regularly, and investigate differences rather than forcing the books to match a simplified calculator.

What the Calculator Does Not Model

The result is not an official lender schedule and does not connect to QuickBooks Online or import a loan. It assumes one constant APR, a regular monthly payment, and an unchanged schedule. Actual loan documents may use a different day-count method, variable interest, payment dates that do not fall at monthly intervals, a final adjusted payment, or charges that are financed or collected separately.

It also assumes the payment fully amortizes the principal within the selected term. It is not appropriate as-is for interest-only periods, balloon payments, revolving credit, irregular payment plans, or loans with changing rates. For those cases, use the lender’s amortization table or a calculation that matches the contract. The APR input should reflect the rate relevant to the loan calculation; fees or other costs may affect a disclosed APR without being represented as monthly interest in this formula.

Common Errors and Reconciliation

• Posting the whole payment to the loan: Separate principal from interest so the liability and expense are represented distinctly.
• Using the original balance every month: Interest is based on the outstanding balance under the lender’s method, not the starting principal for every period.
• Confusing APR and a monthly rate: Enter an annual percentage such as 8, not 0.08 as a monthly percentage. The formula converts APR to a monthly decimal.
• Expecting every statement to match exactly: Payment dates, rounding, fees, and lender-specific interest calculations can create small differences from a textbook estimate.
• Leaving out charges or extra payments: These change the balance or cash paid, but are not included in this calculator’s inputs.

When reconciling, compare the period, payment date, principal reduction, interest charged, and remaining balance. If the lender’s statement differs materially, review the note or ask the lender for its payment history and schedule; do not assume the calculator reveals an accounting error.

Frequently Asked Questions

Does QuickBooks Online create a loan amortization schedule?
QuickBooks Online is used to record and report financial transactions, but it does not provide a general-purpose loan amortization calculator in this page’s sense. Use the lender’s schedule or calculate one separately, then record the appropriate transaction details in the books.

How do I record a loan payment in QuickBooks Online?
Record the payment as a transaction split between principal applied to the loan liability and interest charged as an expense, with any other components handled according to their nature. Account names and setup vary, so verify the split against the lender’s statement and your bookkeeping method.

Why does my QuickBooks loan balance not match the lender’s balance?
Possible causes include an incorrect principal-versus-interest split, a missed or duplicated payment, different dates, fees, rounding, or a variable rate. Compare each period with the lender’s statement and correct the underlying transaction rather than relying on this estimate alone.

Can I use this for a variable-rate loan?
Not as a complete schedule. The calculation holds APR constant throughout the term. A variable-rate loan needs the applicable rate and payment rules for each period, so use the lender’s current schedule or calculate each rate period separately.

Does the calculator include extra payments or fees?
No. It assumes regular level payments and excludes extra principal, fees, taxes, insurance, and other charges. Those items can change the actual balance, payoff timing, or total cash paid.

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

Related

• Amortization Schedule With Daily Interest Calculator
• Amortization Schedule With Annual Totals Calculator
• Amortization Schedule Using Payment Amount

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