Closing letters: by hand or software?

Published 17 October 2026. Updated 17 October 2026.

The job, as it really is

Before a residential closing funds, a closer collects letters from other parties. A lender sends a payoff letter. The association sends an estoppel letter. A municipality or another office sends a lien letter. Each arrives in its own layout, often as a PDF, sometimes with the one figure that matters in a paragraph rather than a table.

Then the closer has to answer the same few questions on every file:

• Does each amount on the settlement statement equal the amount in the letter behind it?
• For a payoff, is the good-through date on or after the day the money will actually reach the lender, and has the per-diem been added for the right number of days?
• Do an estoppel letter's itemised charges add up to the total it states?
• Do the wire instructions match what you already have for that payee?
• Does the letter attach a condition that can change the amount?

None of these is difficult. The difficulty is doing all of them, on every file, in a week with a dozen closings, with the lender's letter open in one window and the settlement worksheet in another. This guide compares the usual ways of doing that and says honestly when each one is enough. For the detail of each letter, see how to verify a payoff letter, the HOA estoppel checklist and the municipal lien letter checklist.

Approach 1: by hand, with a worksheet

Many agencies work this way. The closer opens each letter, finds the figures, types them into a worksheet or a spreadsheet such as Excel or Google Sheets, adds the per-diem, and compares the result with the settlement statement.

Where it works well. The closer knows the lenders and associations in the local market, notices when a letter looks unlike the last one from the same source, and can pick up the phone. Nothing is uploaded anywhere. There is no new tool to learn and no cost beyond time.

Where it breaks down.

• Retyping. Every figure is keyed a second time. A transposed digit gives a wrong comparison that looks like a right one.
• Counting days. Per-diem is easy to get wrong by one day, and the right count depends on the funding date and on how the lender counts. If the funding date moves, the arithmetic has to be redone.
• A page that was never read. A long letter has conditions on page three. Under time pressure the closer reads the table and skips the paragraphs.
• Nobody checking the second time. The closer who typed the figures is the one who compares them. A worksheet holds the numbers but does not tell you which ones were looked at.
• Wire changes. Noticing that routing or account details differ from last time depends on remembering to look.
• Version confusion. When a lender sends an updated letter, the old figures can survive in the worksheet.

None of this makes by-hand checking wrong. It means the quality depends on how busy the day is.

Approach 2: a general AI chat assistant

Some closers paste a letter into a general AI chat assistant, such as ChatGPT, and ask whether the numbers add up. This can be useful, and a separate guide goes through it in detail: can ChatGPT check a payoff letter. In short, it suits a single odd letter or a plain-language summary. As a routine check on every file it leaves the closer to supply the context, check the arithmetic and decide what to trust, every time.

Approach 3: software built for this check

Software built for the task takes the settlement statement and the returned letters as input and returns a list of what matches and what does not. What matters in any such tool, whichever one you consider, is the following.

Whichever tool you look at, ours included, ask two things: can it show where each figure came from, and who does the arithmetic. A tool that cannot cite the page, or that leaves the sums to the AI model, hands the checking back to you.

When by hand is enough

Stay with your worksheet if most of these are true:

• You close a handful of files a month.
• The same lenders and associations return letters in familiar layouts.
• The person who prepares the file is experienced and has time to read every page.
• You already have a routine for wire changes, such as always calling a known number.

If so, the best improvement is not software. It is a one-page checklist that every file gets, with the funding date written at the top and each figure ticked off against the page it came from.

When software helps

It starts to earn its place when:

• Volume is high enough that the checking competes with everything else the closer does.
• Letters arrive in many layouts, so there is no routine to rely on.
• Files regularly slip, so the funding date moves and the per-diem has to be recomputed.
• You want the same checks, written down, on every file, so an owner can see what was looked at.
• You want every letter's figures in one table to work from when you fill in the settlement worksheet.

A checklist that works whichever method you use

1. Write the expected funding date at the top of the file and say where it came from.
2. For each payoff: good-through date on or after the funding date; per-diem added for the right days; the total equals the settlement statement line.
3. For each estoppel: itemised charges added up and compared with the stated total, then with the settlement statement.
4. For each lien letter: the amount matches the file, and the letter says what office and what date it covers.
5. For each letter: any condition that can change the amount is read and written down.
6. For wires: compare with an independent record or confirm by calling a number you already trust. Never use a number printed on the letter itself.
7. Note anything you could not read, such as a scanned page, so it is not mistaken for something that was checked.

How LetterAuditor does this step

LetterAuditor takes the settlement statement and the returned payoff, HOA estoppel and lien letters for one closing file as text PDFs, Word, text or Markdown files, up to 8 files and 80 pages in total. An AI model reads each document and reports every value with a quote and a page. Plain code then verifies that each quote is on the page it names, parses every amount and date, and runs the comparisons: the good-through date against the date funds reach the payee, quoted payoff plus per-diem against the settlement line, an estoppel's charges against its stated total, and each letter's amount against its settlement line.

It compares wire instructions only when you upload an earlier record of that payee's wire with the file; without one, it says there was nothing to compare and does not call the wire clear. It lists any condition a letter states, and it lists a page with no text layer as not read. You get a PDF report with the items to check first, a CSV figures table for the settlement worksheet and a JSON result.

A second, stronger AI model reviews every result and lists what is left for you to decide; the drafting model corrects the serious problems the review finds, and code checks every correction. Results are not verified by a person.

LetterAuditor does not contact the lender, the association or the county, does not connect to a closing system and does not read scanned pages yet. It does not clear a payoff or a wire; you decide every disbursement. One closing file costs 12 credits however many letters it holds, with no subscription. You can create an account at /signup and try it on one file.

Questions

Is checking payoff and HOA letters by hand still reasonable?

Yes, for a small volume of clean files. A closer who reads every letter against the settlement statement and keeps a worksheet can do this well. The risk grows with volume, with rushed closings and with letters in unfamiliar layouts.

What is the most common mistake when keying letter figures into a worksheet?

Re-keying. A transposed digit, a per-diem counted over the wrong number of days or a figure taken from the wrong line of a letter all come from typing a number a second time. Any method that avoids retyping, or checks the typed number against the page, reduces that class of error.

Does software replace the closer's judgment on a payoff or a wire?

No. Software can compare figures and dates and point at what looks wrong. Whether to release funds, ask the lender for a new letter or call a known number about a wire is still the closer's decision.

Does the same method work for every kind of letter?

The arithmetic differs by letter. A payoff letter needs a good-through date and per-diem check, an HOA estoppel needs its charges added up, and a lien letter needs its amount matched to the file. Whatever method you use, give each kind its own steps.