Bookkeeping · Reconciliation & Close · Brief · Working level
Loan balance reconciliation: matching the books to the lender
Why the loan balance on your books drifts from the lender's statement — usually a bad principal/interest split — and how to true it up at least once a year.
A loan balance is one of the easiest numbers on your balance sheet to verify — the lender publishes it — and one of the most commonly wrong. The culprit is nearly always the payment split: every loan payment is part principal (reducing the debt) and part interest (an expense), in proportions that shift every month. Booked wrong for a year, the ledger balance drifts steadily away from the lender's truth, and interest expense — a tax deduction — is misstated by the same amount in the other direction.
The correct monthly entry
| Account | Debit | Credit |
|---|---|---|
| Loan payable — equipment note | 612.00 | |
| Interest expense | 238.00 | |
| Cash | 850.00 |
Next month the split will differ — perhaps 615.00 / 235.00. Pull each month's figures from the schedule; never repeat one split all year.
Most ledger software can memorize the payment but not the moving split; either update it monthly from the schedule or book the whole payment to the liability and post one interest catch-up entry from the lender's year-end statement — acceptable, if the catch-up actually happens.
The annual tie-out
- Get the lender's statement or online payoff/balance as of your chosen date.
- Compare it to the ledger's loan liability balance on that date.
- If they match (within pennies of rounding), document it and move on.
- If not, the difference is the accumulated split error — fix it with one entry.
Diagnosing the direction of the drift:
| Symptom | Cause | Fix entry |
|---|---|---|
| Book balance below lender's | Too much of each payment booked to principal (interest under-expensed) | Debit interest expense, credit loan payable |
| Book balance above lender's | Too much booked to interest (or payments hit expense entirely) | Debit loan payable, credit interest expense |
| Book balance never moved | Payments expensed in full | Reclassify: debit loan payable for total principal paid, credit the expense account used |
The true-up for the first, most common case:
| Account | Debit | Credit |
|---|---|---|
| Interest expense | 146.00 | |
| Loan payable — equipment note | 146.00 |
Book balance was 146.00 below the lender's because splits favored principal all year. After posting, the book balance equals the lender's statement.
Why it is worth the ten minutes
Interest expense flows to the tax return; the loan balance flows to the balance sheet a lender or buyer will read. A wrong split misstates both at once, silently, in equal and opposite amounts. The annual tie-out belongs on the year-end layer of the close — see year-end close vs. monthly — and the monthly split entry sits at step 9 of the month-end close checklist. Loans against long-lived assets also pair naturally with the depreciation those assets generate; the concepts live at /fundamentals/depreciation-basics.
Frequently asked questions
- Why doesn't my loan balance in the books match the lender's statement?
- Almost always because payments were booked with the wrong principal/interest split — or entirely to one or the other. Each payment should reduce the loan liability by the principal portion and expense only the interest portion, per the amortization schedule. Book whole payments to the liability and the loan pays off impossibly fast; book them to expense and it never shrinks.
- How do I record a loan payment correctly?
- Split it per the amortization schedule: debit the loan liability for that month's principal, debit interest expense for that month's interest, and credit cash for the full payment. The split changes every month — interest shrinks and principal grows — so use the schedule or the lender's statement, not a fixed ratio.
- How often should I reconcile loan balances?
- Tie every loan's book balance to a lender statement or online balance at least annually — year-end is natural, since the accountant needs the interest figure anyway — and quarterly for large or variable-rate loans. The check takes minutes when the splits were right and catches a full year of drift when they were not.