QuickBooks Loan Balance Wrong: Fix It to Match Your Lender

Short answer: in almost every case the loan payments were booked entirely to an expense account. The principal portion of a loan payment is not an expense, it is a reduction of the liability, so posting the whole payment to expense leaves the loan balance frozen at its original amount while overstating expenses by the principal you have actually repaid. The fix is a reclassifying journal entry that debits the loan liability for the principal repaid and credits the expense account for the same amount.

This is the single most common broken thing on a small business balance sheet, and it usually stays broken for years because nothing about it looks wrong day to day. The payment cleared. The bank reconciled. The profit and loss has a line called Loan Payment with a sensible number in it. Nothing throws an error. The problem only surfaces when somebody who reads balance sheets for a living asks why the equipment note still says $100,000 three years into a five year term.

Why doesn't my loan balance go down in QuickBooks?

Because QuickBooks does exactly what it was told. It does not know that a payment leaving your checking account is related to a liability account somewhere else on the balance sheet. If the transaction says the money went to an expense account, the money went to an expense account, and the liability sits untouched.

There is a second, subtler version that catches more careful bookkeepers. The payment is split correctly between principal and interest, but the split uses the same fixed amounts every month, copied from the first payment or from a memorized transaction. On an amortizing loan the split changes with every single payment: interest is calculated on a balance that shrinks, so the interest portion falls and the principal portion rises each month. Use January's split all year and the balance drifts a little further off every month, which is why the difference so often looks like a few hundred dollars rather than the whole loan.

Is a loan payment an expense in QuickBooks?

Only partly. One payment is two different things stapled together. The interest is an expense and belongs on the profit and loss. The principal is a repayment of borrowed money and belongs on the balance sheet, reducing what you owe. Booking principal as an expense both understates your profit and overstates your debt, so it is wrong in two directions at once, which is a large part of why lenders check it.

Concretely, take a $100,000 note at 5.5 percent with a $1,500 monthly payment. The first month's interest is the balance times the annual rate divided by twelve, so $100,000 times 0.055 divided by 12, which is $458.33. The remaining $1,041.67 is principal. Only that $458.33 is an expense. The other $1,041.67 should reduce the note from $100,000 to $98,958.33. Book the full $1,500 to an expense account and you have claimed $1,041.67 of deduction you are not entitled to and left $1,041.67 of debt on your books that you no longer owe.

How do I fix loan payments that were recorded as expenses?

You do not need to open and re-edit every payment, and on a reconciled or closed period you should not. One summarizing journal entry per period does the same job and leaves the bank reconciliation alone, because it touches the liability and expense accounts only, never the bank account.

1. Get the amortization schedule from your lender, or ask for a payment history showing principal and interest by payment. This is the source of truth and it is free; every lender will send one. Do not estimate it.

2. Confirm the correct starting balance. Run a Balance Sheet as of the day the loan was funded and check that the liability account shows the original loan amount. If the loan was never set up at all, that is a different fix and it comes first.

3. Total the principal column of the amortization schedule for the period you are correcting, and total the interest column for the same period. Those two figures must add up to the total payments you actually made in that period. If they do not, you have missed a payment, double counted one, or the period boundaries do not line up.

4. Run a QuickReport on the expense account where the payments were posted, for the same date range, and confirm the total matches the payments. Now you know exactly how much sits in the wrong place.

5. Create the journal entry, dated the last day of the period you are fixing. Debit the loan liability account for the total principal repaid. Credit the expense account that received the payments for the same amount. Leave the interest alone if the expense account you used is a reasonable place for interest; if it is not, add a second line pair moving the interest total to Interest Expense.

6. Re-run the Balance Sheet as of the period end date and compare the liability balance to the lender's statement for the same date. They should now agree to the cent.

If the years involved are already filed, talk to whoever prepares the return before dating the entry. Moving principal out of expense reduces deductions in a closed year, and the usual answer is to book the whole correction in the current open year rather than amend, but that is a decision for the preparer, not the bookkeeper.

How do I adjust a loan balance in QuickBooks?

With a journal entry to the liability account and a deliberate choice of offset account, never by typing over the balance. The liability account has no editable balance field for a good reason: every change to it has to come from somewhere, and the offset account is where the accounting actually happens.

Choosing that offset is the whole decision. If the difference is unrecorded principal, the offset is the expense account that wrongly absorbed it. If it is unrecorded interest that was capitalized into the balance, the offset is Interest Expense. If it is a loan fee the lender added, the offset is a bank fee or loan cost account. If you genuinely cannot identify the cause, the offset is not Opening Balance Equity and it is not a plug to Miscellaneous. Find the cause first, because an unexplained adjustment to debt is exactly the kind of thing that makes a lender or a reviewer stop trusting the rest of the file.

Does QuickBooks have a loan amortization schedule?

Not usefully, and this surprises people. QuickBooks Online has no amortization feature at all, so principal and interest splits have to be entered manually on each payment. QuickBooks Desktop had Loan Manager, which built a schedule and could record payments with the split calculated for you, but Intuit discontinued Loan Manager in QuickBooks Desktop 2022. It still runs in earlier supported versions, and nothing replaced it.

So for any current version, the amortization schedule lives outside QuickBooks. Use the lender's schedule, which is authoritative and matches what they will tell you the payoff is. A spreadsheet you built yourself will be close and will not agree exactly, because lenders differ on day count conventions, on how they handle a payment that arrives early or late, and on how they apply an extra principal payment. Chasing your own spreadsheet instead of theirs is how a reconciled loan drifts back out.

How do I set up a loan in QuickBooks so this does not happen?

Create the liability account with the right type before the first payment posts. Use Long Term Liability if the loan runs more than twelve months, and Other Current Liability if it does not. A line of credit that revolves is Other Current Liability. Give the account a name that includes the lender and the collateral, because a file with three accounts called Loan is a file where payments end up in the wrong one.

Record the funding as it happened: the deposit into the bank account with the offset to the new liability, not to income. Loan proceeds are not revenue. If the lender paid a vendor directly instead of depositing to you, as commonly happens with equipment, there is no bank transaction to categorize and you need a journal entry debiting the asset and crediting the liability, otherwise both the equipment and the debt are missing from the balance sheet entirely.

Then set the recurring payment up as a split with two lines from day one: principal to the liability, interest to Interest Expense. Update the two amounts from the amortization schedule each month. It takes fifteen seconds and it is the entire difference between a loan account that ties and one that needs this article.

What if the difference is only a few dollars?

Small differences usually have boring, findable causes rather than structural ones. The common ones are a payment posted on the wrong side of a month end, so it lands in a different period than the lender's schedule; a rounding difference from splitting payments by hand over many months; escrow or insurance bundled into the payment that is neither principal nor interest; and a late fee the lender added to the balance that never made it into your file.

Work it the way you would a bank reconciliation. Start from the lender's balance, add back anything they have recorded that you have not, subtract anything you have recorded that they have not, and see whether you land on your number. A difference you can explain in one line is fine to adjust. A difference you cannot explain is telling you something else is wrong.

What if a paid off loan still shows a balance?

This is the same problem at the end of its life, and it is common enough to expect. The loan was paid off, the lender released the lien, and QuickBooks still carries a balance because the principal was never being applied to it. The remaining balance in the account is, almost always, exactly the total principal that went to expense over the life of the loan.

Confirm that before you clear it. Pull the payoff letter or final statement, confirm the lender shows zero on a specific date, then zero the account with a journal entry dated that day, offsetting to the expense account that absorbed the principal. If the loan spans closed years and the amounts are material, hand the numbers to the tax preparer and let them decide where the correction lands. What you should not do is delete the account or force it to zero against equity, because that erases the evidence of what happened without recording it.

How do I keep loan balances from drifting again?

Treat every loan as an account that gets reconciled, not just the bank. Once a month, or once a quarter for small notes, compare each liability balance in QuickBooks to the lender's statement for the same date and note the difference. Catching a $40 discrepancy in the month it appears takes minutes. Finding the same problem three years later means rebuilding thirty six payments from an amortization schedule.

The same monthly habit is what keeps the rest of the balance sheet honest. Undeposited funds, credit card accounts, payroll liabilities and loans all drift for the same reason, which is that nobody ever ties them to an outside document. If you are formalizing that routine across a lot of accounts, purpose built account reconciliation software will tie balances to outside statements automatically, though for a handful of loans a calendar reminder and the lender's schedule do the job perfectly well.

Getting the underlying transactions into QuickBooks cleanly makes all of this easier, and that is where a lot of small business files fall down first. If your lender or bank only offers a CSV or Excel download, convert it to a Web Connect file with the CSV to QBO converter and import it properly rather than keying payments in by hand, since hand keyed payments are where the wrong split creeps in. QuickBooks Desktop in particular cannot import a bank CSV in any version, so a .qbo file is the only route.

Related reading: a balance sheet that will not balance covers the structural version of this problem, Opening Balance Equity cleanup covers the account that wrong loan setups tend to dump into, bank reconciliation discrepancies covers the monthly tie out, the month end close checklist puts loan reconciliation in a routine, and the best CSV to QBO converter comparison covers getting the transactions in cleanly in the first place.