QuickBooks Online Has No Built-In Loan Amortization Schedule
QuickBooks Online does not include a built-in amortization schedule, so loan payments must be split into principal and interest by hand.
The question arrives from QuickBooks Online users with a new loan on the books: where is the amortization schedule? The accepted answer in the vendor’s help library is blunt. There is no schedule, and the software will not build one for you. Amortization of debts and assets has to be recorded through manual transactions, such as checks, expenses, and journal entries.
A gap rather than a bug
Nothing is broken here, and no error code appears. The software simply does not treat a loan as anything more than a liability account. It will record payments against that account all day, but it will not calculate how much of each payment is principal and how much is interest. That split has to come from somewhere else, usually the lender’s monthly statement or a spreadsheet you keep beside the books.
The limitation covers assets as well as debts. Writing down an intangible asset over its useful life is a journal entry exercise, and the table behind those entries lives outside the program too. Loans draw most of the confusion, so that is where this report concentrates.
Recording a loan payment with a check
A check is the main route in the accepted answer, and we read its full checklist so you do not have to. Open the create menu and choose Check. Select the bank account the payment draws on, set the payee to the lender, and enter the payment date. A mailing address and a check number can be filled in if you still write paper checks. Optional tracking fields, such as class, location, or project, appear only when those features are turned on.
All the real work happens on the category lines. On the first line, select the loan account and enter the principal portion under Amount. On the second line, select the interest expense account and enter the interest portion. One rule matters more than the rest: the check total must equal the two lines combined. If the totals disagree, the payment will not post cleanly against the loan.
The checklist also includes fields that rarely apply to debt service. Marking a line billable, adding a markup percentage, and attaching a customer or project all serve invoicing, not loan repayment. You can leave them alone. A short memo is worth the seconds it takes, since it makes the payment easy to find later.
Which accounts to use is an accounting question rather than a software question. The accepted answer says as much, and your accountant or bookkeeper can confirm the right loan and interest accounts for your situation.
The expense and journal entry routes
Payments that never involve a paper check follow the same shape. An expense form records the payment from a bank account or card, with the loan account on one line and interest expense on the other. The total still has to match what actually left the account. A journal entry works for accruals or catch-up months: debit the loan and the interest expense account, and credit the account the money came from.
What happens when the split is skipped?
The failure mode is easy to picture. A user records the whole monthly payment against interest expense, because that is how the bank labels it. Interest ends up overstated, and the loan balance never comes down. The opposite mistake, posting everything to the loan, hides interest from the books entirely. Either way the liability drifts away from the lender’s statement, and the drift surfaces during reconciliation or at year end.
Fixing it looks the same in both cases. Edit the payment so principal and interest sit on their own lines, then compare the loan balance in your books with the balance on the lender’s statement. A recurring check with the split pre-filled can cut the monthly typing, though the amounts still need adjusting as the interest share shrinks over the life of the loan.
Where does the amortization math come from?
Nowhere inside the product, and that is the practical takeaway. The month by month table of principal and interest belongs to the lender or to your own spreadsheet. QuickBooks Online records the result of that math; it does not perform it. Accept that division of labor early and loan balances stay clean. Expect a loan calculator instead, and you will be correcting entries months later.
The affected product is QuickBooks Online, and the accepted answer does not narrow it further by plan. Desktop editions work differently, and this guidance speaks only to the web product. The practical routine stands: keep the schedule outside the books, split every payment by hand, and check the loan balance against the lender’s figure each month.