Popular

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.

Worksheet

Type your numbers

Buyer’s side

Type it as it appears on the statement.

Lender, title, recording, tax, insurance, prorations and other lines charged to the buyer. Type it as it appears on the statement.

Earnest money and any other deposit credited to the buyer.

Leave blank for a cash purchase.

Closing cost help and repair credits. Counted once on each side.

Prorations credited to the buyer and any other credit.

The amount the statement says the buyer must bring.

Seller’s side

Mortgage and lien payoffs paid at closing.

Agent compensation, title, transfer and recording taxes, prorations and other lines charged to the seller, not counting the credits above.

Prorations credited to the seller and any other credit.

The amount the statement says the seller receives.

Money received by the settlement agent

Wired or delivered at closing.

Earnest money held by this agent.

Money paid out

Payment 1

Payment 2

Payment 3

Payment 4

Payment 5

Payment 6

Payment 7

Payment 8

Payment 9

Payment 10

Payment 11

Payment 12

Results

Results need JavaScript. Without it, use the fields as a printable list.

Using it well

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.

Questions

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.

Private consultation

Ask an advisor about your situation

An ABODE advisor replies privately. We aim to reply within one business day.