Tracking Loans in QuickBooks Desktop After Loan Manager Was Removed
Loan Manager disappeared from QuickBooks Desktop in 2022, leaving loan amortization untracked; this guide keeps your loan balances accurate.
QuickBooks Desktop 2022 and later ship without Loan Manager. Intuit removed the tool from that release onward. Your liability accounts and every recorded payment survived in the company file, but the amortization schedules did not. Our engineers rebuild this tracking by hand, and the full setup fits on one page.
The job Loan Manager used to do
Loan Manager kept three things in one place: the loan terms, the amortization schedule, and a monthly payment routine. It computed how much of each payment was interest and how much reduced the balance. It then wrote the check with the split already posted to the right accounts.
When the feature went away, the schedules went with it. The liability account and its transaction history stayed in your file. That history is enough to rebuild from, as long as the balance was correct before the change.
The accounts you need first
Open Lists, then Chart of Accounts. For each loan you need a long-term liability account, named for the lender. Add an interest expense account if one is missing. If the payment bundles property taxes or insurance into escrow, add an other-current-asset account for that portion as well.
Loans that were already tracked have their accounts in place. Confirm the balance against the most recent lender statement before you go further. A wrong starting balance will throw off every split that follows. Loans never tracked before need an opening balance dated to the statement you build from.
Recording a payment by hand
Go to Banking, then Write Checks. Choose the lender as the payee and enter the total payment amount. On the Expenses tab, post one line per piece: principal to the loan liability, interest to interest expense, and any escrow amount to the escrow asset. If the lender drafts the account directly, use the same form and clear the print flag.
The numbers come from outside QuickBooks, because nothing in the program computes them anymore. Use the monthly statement from the lender, or an amortization schedule you build once in a spreadsheet. To build it, take the principal, the interest rate, and the payment amount from the note. Interest for the month equals the running balance times the annual rate divided by twelve. Principal for the month is the payment minus that interest.
Can a memorized payment carry a changing split?
Not by itself, and this is the constraint to plan around. A memorized check repeats the same amounts each time it posts. Interest declines a little with every payment, so the split drifts if the memorized entry is left alone.
The workable habit is to memorize the payment and adjust it each month. With the check open, press Ctrl+M, choose to be reminded, and set a monthly frequency with the next due date. Each month, open the memorized transaction list from the Edit menu, bring the check in, and correct the two lines before saving.
Checking the loan against the lender statement
Once a year, prove the loan from outside the program. Right-click the liability account in the Chart of Accounts and run a QuickReport for the year. Compare the ending balance to the year-end statement from the lender. Then run the same report on the interest expense account and compare its total to the interest the lender reports.
Differences usually have ordinary causes. A payment posted twice, an escrow increase coded to principal, or a late fee buried in the payment total will all surface here. Fix the transaction once you find it, not the account. We fold this check into the same routine as your bank reconciliations and month-end close, where it belongs.
If the balance will not tie
When the liability refuses to match the statement, work payment by payment. Pull the QuickReport for the full life of the loan and set it beside the lender's payment history. Find the first month where the two diverge. The error sits in that payment or the one before it.
Most files carry one of three faults: an opening balance dated wrong, escrow posted to the liability, or a payment skipped in a busy month. Each is a small repair. A balance that still will not tie after those checks points deeper, and a damaged QuickBooks company file has to be repaired first. Once the file is sound, the loan will reconcile with the rest of the books.