Loan Statement Reconciliation: Splitting Principal and Interest Correctly for Every Client
Few accounts sit wrong for longer than a client's loans. The bank feed shows one payment a month, it gets categorized once, and the rule repeats it for years. By the time the tax preparer asks for year-end balances, the books and the lender disagree and nobody remembers why. This post covers what a loan reconciliation ties together, where it breaks, and how a bookkeeping firm can run it for every client every month.
In brief
- A loan payment is not one expense: it splits into interest, which is an expense, principal, which reduces a liability, and sometimes escrow or fees, which go elsewhere.
- The lender statement is the authority on the split and the balance; the client's bank feed only shows the total that left the account.
- A loan account in the general ledger should equal the lender's principal balance at each statement date; any gap is a misbooked payment, a missed draw, a fee or a timing item.
- Extracting every lender statement into one schema lets a firm tie all client loans every month instead of finding the gap at year end, when the tax preparer asks for the balances.
One payment, three or four destinations
A loan payment that leaves the operating account as a single debit is really several transactions. Part of it is interest, which is an expense of the period. Part of it is principal, which is not an expense at all: it reduces the loan liability on the balance sheet. On a mortgage or some equipment financing, part of it may be escrow for property tax or insurance, held by the lender and paid out later. And in any month the lender may add a late charge, an annual fee or a modification fee that is deducted from the payment or added to the balance.
The bank statement only shows the total. The lender statement is the only document that says how the lender actually applied it: how much went to interest for the days since the last payment, how much reduced principal, what was held in escrow and what was charged. That is why a loan reconciliation always starts from the lender statement, not from the bank feed or the original amortization schedule.
When the general ledger follows the statement, the loan account equals the lender's principal balance at every statement date. When it does not, the difference compounds: each month the ledger drifts by the gap between the booked split and the real one, and the error lands in interest expense, which affects the client's taxable income.
3
parts of a typical payment: interest, principal, escrow or fees
1
document that states the split: the lender statement
4
checks in the example tie-out below
Why the split changes every month
On an amortizing loan, the payment stays the same while its composition changes. Interest is charged on the outstanding balance, so early payments are mostly interest and later ones mostly principal. Take a hypothetical equipment loan of 48,000 at 7.2 percent a year over 48 months: the fixed payment is 1,153.88. The first payment carries 288.00 of interest (48,000 times 0.6 percent) and 865.88 of principal; the last carries under 7 of interest.
This is why a bank rule that books a fixed amount to interest every month is wrong from the second payment on, and why splitting from a schedule built at origination is only an estimate. Most lenders compute interest on the actual days between payments and the date the payment posted. A payment made five days late carries more interest and less principal than the schedule says; an extra principal payment shortens everything after it. Over a year the differences are small per month and material in total.
Where loan accounts stop tying out
Across a portfolio of small-business clients, the same handful of causes explain almost every gap between the ledger and the lender.
The full payment booked to expense
The most common and the most expensive. A bank rule categorizes the monthly debit as loan payments or interest expense, the liability never moves, and expenses are overstated by every dollar of principal repaid. The balance sheet keeps showing the original loan amount years after much of it was paid.
A split from the schedule, not the statement
Better, but still drifting. Late or early payments, rate changes on a variable loan and lender fees all make the real split differ from the schedule. The ledger ends each year a few hundred off, and the correction becomes an unexplained adjusting entry.
Fees, draws and extra payments
Late charges and annual fees are deducted or capitalized by the lender and appear only on its statement. Draws on a line of credit land in the operating account as deposits and are sometimes categorized as revenue. Extra principal payments made by the owner from a personal account never reach the books at all.
Full payment booked to expense
Split from schedule, not statement
Lender fee or late charge unbooked
Line of credit draw misbooked
Extra principal payment
Payment across statement date
Other
The tie-out, step by step
For one client with one loan, this is a five-minute check. For a firm with a hundred clients, some with three or four loans each from different lenders, the hard part is the input: lender statements arrive as PDFs in each lender's own layout, sometimes monthly, sometimes only on request. The approach that scales is the same one used for receipt-to-bank matching and quarterly payroll reconciliation: turn every document into the same structured fields, then let rules do the comparing.
1. Build a loan register per client
List every debt the client carries: term loans, equipment and vehicle financing, lines of credit, shareholder loans, credit card balances that function as financing. For each, record the lender, the reference, the ledger account and where the statements come from. Many reconciliation gaps start with a loan that was never set up in the books because nobody knew it existed.
2. Extract each lender statement into one schema
Each statement becomes statement date, beginning principal, payments received with their dates, the amount applied to interest, principal, escrow and fees, any advances or draws, and the ending principal. One schema across lenders lets one set of checks run for every loan; the post on extraction schema design covers typing money and date fields so they come back as numbers and ISO dates rather than text. When a client sends a year of statements in one file, split it by statement first, as described in the post on splitting and classifying mixed PDF batches.
3. Run the checks
Ending principal on the statement against the loan account balance at the same date. Interest on the statement against interest expense posted for that loan. Fees and escrow on the statement against their entries. Each payment on the statement against a debit in the bank, by amount and a date window. Each draw on a line of credit against a deposit, and that deposit against a liability entry rather than income. A statement that does not foot on its own (beginning balance, minus principal applied, plus draws and capitalized fees, should equal the ending balance) is flagged before anything is compared.
{ "client_id": "client-0217", "loan_ref": "equipment-loan-4471", "statement_date": "2026-09-30", "statement": { "beginning_principal": 47134.12, "payment_received": 1153.88, "payment_date": "2026-09-19", "applied_to_interest": 317.80, "applied_to_principal": 836.08, "fees_assessed": 25.00, "ending_principal": 46298.04, "interest_rate": 0.072 }, "ledger": { "loan_account_balance": 46263.04, "interest_expense_posted": 282.80, "payment_entries": 1 }, "checks": [ { "check": "principal_balance_vs_ledger", "statement": 46298.04, "ledger": 46263.04, "difference": -35.00, "status": "break", "hint": "Statement split 317.80 interest / 836.08 principal; ledger posted the schedule split 282.80 / 871.08" }, { "check": "interest_vs_ledger", "statement": 317.80, "ledger": 282.80, "difference": -35.00, "status": "break" }, { "check": "fees_booked", "statement": 25.00, "ledger": 0.00, "status": "break", "hint": "Late fee assessed and billed separately; no entry in the ledger" }, { "check": "payment_vs_bank", "statement": 1153.88, "bank_debit": 1153.88, "status": "ties" } ], "open_items": 2}In this example, the payment cleared the bank for the right amount but four days after its due date. The lender charged interest for the extra days, so 35.00 more went to interest and 35.00 less to principal than the schedule says, and it assessed a 25.00 late fee. The ledger followed the schedule: the loan account sits 35.00 below the lender's balance and interest expense is 35.00 short. One correcting entry fixes both; the unbooked fee is a second, and worth a note to the client about payment timing.
The lender statement wins
Year end: payoff letters and the tax preparer
The year-end close is where unreconciled loans get expensive. The tax preparer needs interest paid for the year, which should match the lender's annual interest statement where one is issued, and the principal balance at year end for the balance sheet. A loan that has been reconciled every month answers both questions from data already in hand. One that has not turns into a request to the client for twelve statements in January, followed by a large adjusting entry that changes reported income for the year.
For a loan paid off or refinanced during the year, the payoff letter is the document to extract: it states principal, accrued interest to the payoff date and any prepayment or closing fees. Without it, the last few hundred dollars of a retired loan tend to sit in the liability account indefinitely.
Keep the numbers honest
Treat extracted figures as a draft until the checks pass. A statement that foots and a payment that ties to the bank are strong evidence the extraction was right, because independent documents rarely agree by accident. A break is a prompt to look at the source page before posting a correction. Keep a labelled set of statements from the lenders that appear most often across clients and score field accuracy when a lender changes its layout; the post on building a field-level eval set explains how. And never let a rule post a correcting entry on its own: a reviewer should confirm each one.
Monthly loan reconciliation: a checklist
- Keep a loan register for each client: lender, reference, ledger account and statement source.
- Collect every lender statement for the month, plus payoff letters for loans closed or refinanced.
- Extract statements into one schema: dates, beginning and ending principal, payments, and the interest, principal, escrow and fee split.
- Confirm each statement foots before comparing it to anything.
- Tie ending principal to the loan account and interest to interest expense for the same date.
- Match each payment to a bank debit and each line of credit draw to a deposit booked as a liability.
- Book fees and escrow as the lender charged them, and record one reviewed correcting entry per break.
Where extraction fits
The accounting for a loan is simple and every bookkeeper knows it. What makes loan reconciliation slip across a portfolio is reading: statements from dozens of lenders, in different layouts, that have to become comparable rows before a rule can run. Parser turns each statement into structured JSON against an extraction template you define, so the monthly loan tie-out starts from data and the team's time goes to the breaks.