# Settlement Reconciliation | ABODE International Realty

Canonical page: https://abodeintlrealty.com/tools/settlement-statement-reconciliation/
Last updated: 2026-10-18
Publisher: ABODE International Realty LLC (Real Estate Firm TN 263936; FL Corporation CQ1070640)

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.

## Type your numbers

This worksheet needs JavaScript to add up your numbers. The fields below still work as a fill-in list you can print.

**Nothing you type is saved or sent.** The worksheet runs in your browser and ABODE supplies no rates, prices or costs: every figure is yours. Results are arithmetic on those figures, not a quote, a loan offer, an appraisal or advice. October 18, 2026.

Copy as text

Print

Clear all numbers

[Go to results](#ws-rh)

Buyer’s side

Contract price

\$

Type it as it appears on the statement.

Total of all other buyer charges

\$

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

Deposit already paid

\$

Earnest money and any other deposit credited to the buyer.

New loan amount

\$

Leave blank for a cash purchase.

Credits from the seller to the buyer

\$

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

Other credits to the buyer

\$

Prorations credited to the buyer and any other credit.

Cash to close shown on the statement

\$

The amount the statement says the buyer must bring.

Seller’s side

Payoffs

\$

Mortgage and lien payoffs paid at closing.

Total of all other seller charges

\$

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

Credits to the seller

\$

Prorations credited to the seller and any other credit.

Cash to the seller shown on the statement

\$

The amount the statement says the seller receives.

Money received by the settlement agent

Funds from the buyer

\$

Wired or delivered at closing.

Funds from the lender

\$

Deposit held

\$

Earnest money held by this agent.

Other funds received

\$

Money paid out

Payment 1

Payee or line

Amount

\$

Payment 2

Payee or line

Amount

\$

Payment 3

Payee or line

Amount

\$

Payment 4

Payee or line

Amount

\$

Payment 5

Payee or line

Amount

\$

Payment 6

Payee or line

Amount

\$

Payment 7

Payee or line

Amount

\$

Payment 8

Payee or line

Amount

\$

Payment 9

Payee or line

Amount

\$

Payment 10

Payee or line

Amount

\$

Payment 11

Payee or line

Amount

\$

Payment 12

Payee or line

Amount

\$

## 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](https://abodeintlrealty.com/tools/). 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.
