Debt

Reconciling a loan: matching the outstanding balance in your books

Your own record of what you owe and the lender’s record can drift apart. A quarterly comparison keeps both honest and catches errors while they are small.

Editorial illustration for Reconciling a loan: matching the outstanding balance in your books

Two sets of books

The lender keeps a record of your loan: the balance, the interest, the payments received. You keep your own. In a perfect world they agree. In practice, differences arise from timing of payments, fees applied, rate changes, rounding and occasional mistakes. Without a periodic comparison, small differences can grow into confusion.

What to collect

  • The lender’s latest statement or online balance
  • Your list of payments made since the last check
  • Your last agreed balance
  • Any notices of rate or term changes

A calm quarterly check is enough for most loans. For more complex ones, such as those with variable rates, monthly may be better.

A simple reconciliation

LineAmount
Balance at last check84,000
Plus interest charged since2,100
Plus fees charged150
Minus payments received–9,000 × 2 = –18,000
Expected balance68,250
Lender’s stated balance68,250

The numbers are invented. When the expected balance and the lender’s balance agree, you are done. If they differ, find the gap.

Common causes of a gap

  1. A payment made close to the statement date that had not been credited yet
  2. A fee you did not know about
  3. A change in the interest rate or the way interest is calculated
  4. A part-payment that was applied to the next instalment rather than the principal
  5. A genuine error by the lender or by you

Work through them in order. The first and second are most frequent and the easiest to resolve.

Raising a query

If the gap cannot be explained, write to the lender with the dates and amounts of your payments, and ask for a statement of account showing each transaction. A line-by-line statement settles most questions. Keep the reply and note the date.

Use the loan account in SpendixAI

Record each instalment against the liability account, split into interest and principal where the schedule allows. The balance in the app should track the lender’s balance. When you enter the lender’s figure at the quarterly check, any difference is a signal, and the details of payments you recorded help you find where the gap arose.

Reconciling a loan gives you more than accuracy. It builds a habit of paying attention to what you owe, and that attention is the first requirement of managing debt well.

What a clean reconciliation gives you

A loan that reconciles quarterly is a loan you understand. You know the balance, you know the pace, and you can predict the end date. When the lender sends a notice of change, you can judge it against what you know. Compare that with the experience of having only a vague idea of what remains, and the benefit is clear.

The habit also supports good decisions. If you consider prepaying, the true outstanding balance is in your hands. If you consider refinancing, you know what you owe. Without a reconciled figure, those choices rest on guesswork.

Keeping the routine short

Put the check in the calendar for the week after each quarter ends, and keep the steps few: download the statement, compare the balance, note any gap, file the statement. If everything agrees, the whole exercise is five minutes. If not, you will be glad of the early warning. Attach the statement to the loan’s note in your records so that the evidence of each check stays with the account.

If you manage several loans, stagger the checks so that one or two are done each month, rather than all in the same week. The routine stays light, and each loan gets regular attention across the year. Over time, you will recognise how each lender’s statements are laid out and the checks become quicker.

SPENDIXAI JOURNAL

Useful ideas start with a clearer picture of your own spending.

Explore your reports