A loan reconciliation compares the loan balance in your ledger with the principal balance on the lender's statement at the same date, then explains any difference. Most gaps come from payments booked entirely against the loan instead of being split into principal and interest, or from fees and escrow amounts the books never recorded.
Tying the loan balance to the lender statement
The lender statement is the outside evidence for a loan, and the figure to compare is the principal balance on it, dated the same day as your ledger balance. If the statement closes on the 15th and your books close at month end, ask the lender for the principal balance as of your month-end date.
Use principal, not the payoff amount. A payoff quote usually adds interest accrued since the last payment and any fees for closing the loan, so it will always exceed the book balance. Accrued interest belongs in a separate interest payable account, which you can reconcile to the same statement.
A short reconciliation block does the job:
- Principal per lender statement at the balance date.
- Less payments made but not yet shown by the lender.
- Plus or minus any identified errors in the books, each with its correcting entry.
- Equals principal per ledger.
Long-term debt is one of the accounts that has true outside support, which makes it among the easier ones to prove. How that differs from accounts tied to another ledger is explained in account reconciliation meaning, with examples by account.
Splitting each loan payment into principal and interest
Each loan payment usually covers the interest that built up since the previous payment, with the rest reducing principal. The lender statement shows that split for every payment. Book the interest to interest expense and the principal to the loan account, using the lender's figures rather than an estimate.
For an amortizing loan with a fixed payment, the interest share falls and the principal share rises each month. An amortization schedule from the lender, or one you build from the rate and term, gives the split in advance. When the statement arrives, compare it with the schedule. A difference usually means the rate changed, a payment was late, or an extra principal payment was applied.
Lines of credit work differently. Interest is charged on the daily balance, draws and repayments can happen any day, and there may be no fixed payment. Reconcile those accounts to the statement each month and treat the interest charge on the statement as the expense. A line of credit tied to a borrowing base often depends on inventory figures, so a lender may also expect the inventory reconciliation from count to general ledger to be current.
Why is the book loan balance lower than the lender's?
A book loan balance lower than the lender's almost always means payments were recorded entirely against the loan. The interest portion reduced the liability in the books, while the lender applied it to interest. The book balance falls faster than the real one, and interest expense is understated by the same amount.
Here is a worked example with example values. The loan starts the month with 120,000.00 of principal at an annual rate of 7.2 percent, so monthly interest is 0.6 percent. The payment is 2,500.00.
| Lender statement | Books (wrong) | Books (corrected) | |
|---|---|---|---|
| Opening principal | 120,000.00 | 120,000.00 | 120,000.00 |
| Payment applied to interest | 720.00 | 0.00 | 720.00 |
| Payment applied to principal | 1,780.00 | 2,500.00 | 1,780.00 |
| Closing principal | 118,220.00 | 117,500.00 | 118,220.00 |
The 720.00 difference equals the month's interest. The correcting entry debits interest expense 720.00 and credits the loan 720.00. If the error has run for many months, total the interest from the lender's statements for each month and correct them together, noting the periods affected.
Loan escrow, fees and payments in transit
Some loan differences are not errors in the books but items the books have not yet caught up with. Escrow deposits, late fees, rate adjustments and payments in transit all make a correct ledger disagree with the lender. Each needs a line on the reconciliation and, where it is a real cost, an entry.
- Escrow. Mortgage-style loans often collect property tax and insurance with each payment. That portion is neither principal nor interest. Book it to an escrow asset, and reconcile the escrow balance to the statement separately.
- Fees. Late charges, servicing fees and annual fees appear only on the statement. Record them as expense when you see them.
- Payments in transit. A payment sent on the 30th may reach the lender on the 2nd. List it as a reconciling item and confirm it on the next statement.
- Taxes. A liability that is reconciled to a filed return rather than a lender works the same way; the sales tax reconciliation against returns, ledger and sales handles its own timing gaps.
Who should approve loan draws and payoffs?
Loan draws and payoffs should be approved by someone other than the person who records them, and the approver should see the lender's confirmation. A draw puts cash in the bank and a liability on the books, so an unapproved draw can hide a shortage elsewhere for months.
Written approval limits work better than relying on signatures alone, because most loan movements happen electronically. The dual signature on checks guide explains why that control often fails with electronic payments and what replaces it. Loan payments and draws also appear on the operating bank statement, and PreciseBankFlow matches those statement lines to your ledger so a draw nobody recorded shows up as an unmatched deposit. It is opening to firms in small groups, and the review stays with you.