One Version of the Truth: How to Reconcile a Note’s Ledger, Statements and Escrow Records

Updated November 5, 2026: corrected for accuracy.

A lender keeps a note’s records in agreement by reconciling them on a set schedule. Each cycle, match bank deposits to posted payments, confirm each payment landed in the right cycle, tie escrow balances to actual disbursements, and log every correspondence item. Resolve each mismatch and document the fix. Statement and escrow duties vary by loan type, state and loan purpose.

Key Takeaways

• A note has four records that should tell the same story: the ledger, the borrower statements, the escrow records and the correspondence log.
• The bank deposit is the anchor. Every posted payment should trace back to money that actually arrived.
• A payment posted to the wrong cycle can make a current borrower look late, or a late borrower look current.
• Escrow balances should tie to the payments collected and the bills paid, item by item.
• Every mismatch needs a written resolution that shows what was wrong, what changed and who approved it.

Related Topics

• Step by Step: Top 7 Servicing Mistakes That Cost Lenders Money
• How to Set Up a Servicing Process That Avoids the Top 7 Mistakes That Cost Lenders Money
• 10 Signs You Need to Fix These Top 7 Servicing Mistakes That Cost Lenders Money
• Manual vs. Automated: Top 7 Servicing Mistakes That Cost Lenders Money
• In-House vs. Outsourced: Top 7 Servicing Mistakes That Cost Lenders Money

Why Do a Note’s Records Drift Apart?

Each record on a note changes for a different reason. The ledger changes when someone posts a payment or a charge. The borrower statement changes when someone generates it from the ledger. The escrow record changes when money comes in for taxes or insurance and when bills go out. The correspondence log changes when someone sends or receives a letter, email or call.

These updates happen at different times. Different people or tools can make them. A small gap in one record does not fix itself. It carries forward into the next statement and the next escrow entry.

A reconciliation routine closes those gaps on a schedule. It treats the four records as one file that has to agree. If you are building a process from scratch, setting up a servicing process covers the groundwork.

What Should a Recurring Reconciliation Routine Include?

Pick a fixed point in each payment cycle and run the same checks in the same order. A steady order makes a missed step easy to spot. A useful sequence looks like this:

1. Deposits to payments. Match each bank deposit to a posted payment on the ledger.
2. Payments to cycles. Confirm each payment sits in the cycle it was meant to cover.
3. Ledger to statement. Check that the borrower statement shows the same balance, due date and payment breakdown as the ledger.
4. Escrow to disbursements. Tie the escrow balance to the money collected and the bills paid.
5. Correspondence to events. Confirm the log shows each notice, borrower contact and dispute tied to the account.
6. Exceptions log. Record each mismatch, its fix and the sign-off.

A written checklist keeps the routine the same from cycle to cycle. Whether you run it by hand or with software, the manual vs. automated comparison lays out the tradeoffs.

How Do You Match Deposits to Posted Payments?

Start with the bank. Pull the deposit detail for the period and list every item that relates to the note. Then pull every payment posted to the ledger for the same period.

Each deposit should match one posted payment, or a clear group of them. Check the amount, the date received and the payor. Watch for three common gaps. A deposit has no matching ledger entry. A ledger entry has no matching deposit. Or the amounts differ.

Returned items need special care. If a payment is reversed by the bank, the ledger needs a matching reversal. Without it, the ledger shows money the lender does not have.

How Do You Catch Payments Posted to the Wrong Cycle?

A payment can match the bank perfectly and still sit in the wrong place. This error is easy to miss because the totals look right.

Compare each payment’s received date with the due date it was applied to. Look for a payment applied to a later cycle while an earlier one shows unpaid. Look for two payments stacked in one cycle while the next cycle shows a gap. Check that the split between principal, interest and other items follows the note’s terms.

A misplaced payment affects more than the ledger. It changes the borrower statement, the delinquency status and any notice sent based on that status. Fix the posting first, then check what else relied on it. Warning signs of servicing errors include borrower calls asking why a paid cycle shows as due.

How Do You Tie Escrow Balances to Disbursements?

If the note has an escrow account, its balance should equal what came in minus what went out. Build that tie-out from the records, not from memory.

List the escrow portion of each posted payment. List each tax and insurance disbursement with its date, payee and proof of payment. Add the starting balance and the deposits, subtract the disbursements, and compare the result with the recorded escrow balance.

A difference points to a missing deposit, a missing disbursement or a disbursement charged to the wrong account. Check the bill against the payment record before you adjust anything. Rules on how escrow funds are handled and reported depend on loan type, state and loan purpose. Consult qualified legal counsel about your own obligations.

How Should Mismatches Be Resolved and Documented?

Treat every mismatch as an open item until it is closed in writing. For each one, record the date found, the records involved, what did not agree and the correction made.

Make corrections with new entries that reverse or adjust the original. Do not overwrite the old entry. A visible correction trail shows a reviewer exactly what changed.

Add a note to the correspondence log when a fix affects the borrower. If a corrected statement goes out, log it. If the borrower raised the issue, log their contact and your response. Requirements for borrower notices and error responses vary by loan type, state and loan purpose, so consult qualified legal counsel. For more on working through recurring problems, see how to troubleshoot servicing errors.

Frequently Asked Questions

What does it mean to reconcile a note’s records?

It means checking that the ledger, borrower statements, escrow records and correspondence log agree with each other and with the bank. Any difference gets found, fixed and written down.

How often should a lender reconcile?

Once per payment cycle is a common rhythm, since each cycle adds new payments and statements. The right schedule depends on how many notes you hold and how often money moves.

Why start with bank deposits?

The bank shows what money actually arrived. Starting there keeps the ledger tied to real funds rather than to what someone expected to receive.

Should I delete an incorrect ledger entry?

No. Post a reversing or adjusting entry instead. That keeps a visible trail of what happened and when it was corrected.

What belongs in the correspondence log?

Every notice, statement, borrower contact and dispute tied to the account, with dates. Log corrected statements and responses to borrower questions too.

Does a servicer handle reconciliation?

A third-party servicer can run this work as part of servicing a note. To compare options, see in-house vs. outsourced servicing. For cost, use the online price quote.

Sources

• Requirements for borrower statements, escrow handling, error resolution and record retention vary by loan type, state and loan purpose (business or consumer). Consult qualified legal counsel about your own obligations.

Next Steps

If you want to talk about how a third-party servicer keeps a note’s ledger, statements, escrow records and correspondence in agreement, we can help. Contact Note Servicing Center to start a conversation about your servicing needs.