Planning tool
Settlement statement reconciliation
Check that a settlement statement’s numbers agree with each other
This worksheet checks a settlement statement’s arithmetic against itself. You type totals from the statement. It works out the buyer’s cash to close and the seller’s proceeds, compares each with the statement, and checks that money received equals money paid out. Nothing you enter is saved or sent.
In short: Type totals from a settlement statement and this worksheet checks the buyer’s cash, the seller’s proceeds and that money in equals money out. It audits nothing and saves nothing.
Arithmetic on your numbers, not a quote, offer or advice.
Type your numbers
Results
Results need JavaScript. Without it, use the fields as a printable list.
How should you use this worksheet?
- Have the settlement statement open, either a Closing Disclosure or a settlement agent’s statement.
- Type the totals as they appear. Enter credits as positive numbers in their own fields.
- Look for any difference that is not zero and trace it line by line.
- Ask the settlement agent about any difference. This worksheet cannot say which number is wrong.
More tools are on the planning tools page. This worksheet is general information, not legal, tax, lending, insurance or investment advice.
Settlement statement reconciliation: frequently asked questions
Does a difference of zero mean the statement is right?
No. It means the numbers you typed agree with each other. It does not show that every charge is correct or follows any rule.
Who is this for?
Buyers, sellers, agents and closing staff who want a second look at the totals. Lenders, title companies and attorneys have their own review steps, which this does not replace.
Why does a seller credit show on both sides?
A credit from the seller reduces what the buyer pays and also reduces what the seller receives, so the sheet counts it once on each side.
Is anything I type saved or sent to ABODE?
No. The worksheet runs in your browser. Numbers are not saved, sent or logged, and closing the page clears them. Use Copy as text or Print to keep your own copy.
Ask an advisor about your situation
An ABODE advisor replies privately. We aim to reply within one business day.
