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
| Line | Amount |
|---|---|
| Balance at last check | 84,000 |
| Plus interest charged since | 2,100 |
| Plus fees charged | 150 |
| Minus payments received | –9,000 × 2 = –18,000 |
| Expected balance | 68,250 |
| Lender’s stated balance | 68,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
- A payment made close to the statement date that had not been credited yet
- A fee you did not know about
- A change in the interest rate or the way interest is calculated
- A part-payment that was applied to the next instalment rather than the principal
- 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.
Useful ideas start with a clearer picture of your own spending.
Explore your reports
