Listing-appointment guide
How to calculate seller net proceeds
The math behind the listing-appointment conversation: every line item from sale price to net check, with worked examples and the line items most likely to bite you.
30-second calculation. State-aware. No signup required.
- Sale price
- $475,000
- Mortgage payoff
- −$210,000
- Closing costs
- −$38,250
The seller doesn't decide on price — they decide on net
Sellers care about the bottom-line check. Every other number on the listing agreement — the asking price, the commission rate, the estimated closing costs — exists to support that one figure. If you can't produce it accurately at the listing appointment, you've lost the room before pricing ever comes up.
This guide walks every line item that goes into the net calculation — from obvious (commission, mortgage payoff) to easy to get wrong (state-specific transfer taxes, prorations that shift with the close date). Two worked examples follow.
Every line item, in order
The order matters — sale price first, then deductions in roughly the sequence a settlement statement lists them.
1. Sale price
The number you start from. At a listing appointment, this is your suggested list price; at offer-evaluation, it's the actual offer. Most agents run the calculation twice — at the asking price and at a realistic-sale price — so the seller sees the range, not a single optimistic number.
2. Mortgage payoff
First mortgage balance plus any second mortgage, HELOC, or unpaid liens. Pull this from the seller's recent statement — and confirm there's no prepayment penalty hiding in the loan terms. Add interest accrued through the projected close date if you want to be precise.
3. Real estate commission
Listing-side and buyer-side. After the NAR settlement (effective August 2024), buyer-side compensation is no longer pre-negotiated in the MLS — it's a separately negotiated line item between seller, listing agent, and buyer. Model the scenario both with and without buyer-side concessions so the seller sees the impact.
4. Transfer tax / deed stamps
This is the biggest source of error in spreadsheet net sheets. Transfer taxes vary wildly by state and often by county: Pennsylvania charges 2% combined state and local; Texas charges nothing; New York layers state, county, and city. Always pull the rate from a state-aware source — the NETSheet auto-fills from ZIP.
5. Title insurance and settlement fees
Owner's policy, settlement-attorney or escrow fees, recording fees, courier fees, wire fees. Customary splits vary by region — in some states the seller pays owner's title insurance, in others the buyer does. Use regional defaults and confirm with the title company assigned to the transaction.
6. Property tax proration
What the seller owes for the days they owned the property in the current tax cycle. Most calculations run day by day from the last paid period through the close date. If taxes are paid in arrears, the seller credits the buyer; if paid in advance, the buyer credits the seller. Easy to miscalculate; cleaner to let software handle it.
7. HOA dues and transfer fees
Prorated dues through the close date, plus any one-time HOA transfer fee or capital contribution required by the association. Get these from the HOA management company, not the seller's memory — fees often exceed seller expectations.
8. Repair credits and concessions
Anything negotiated post-inspection or in the offer itself. Model concessions as a separate line so the seller sees the marginal impact — useful when an offer is structured as full-price-with-concessions vs. lower-price-no-concessions.
9. Other adjustments
Home warranty (if the seller offered one), staging or marketing costs the listing agent advanced, pest treatment, septic certification — anything specific to this property.
10. Estimated net proceeds
Sale price minus everything above. This is the conversation. Sellers don't decide based on list price — they decide based on what they walk away with. Lead with the bottom-line number.
Worked examples
Same sale price, same loan balance, two different states. Watch where the numbers diverge.
Example A — Pennsylvania, $475,000 sale
- Sale price
- $475,000
- Mortgage payoff (incl. payoff interest)
- −$210,400
- Commission (5.5% total)
- −$26,125
- Transfer tax (PA, 2%)
- −$9,500
- Title + settlement fees
- −$2,150
- Property tax proration (seller owes)
- −$1,420
- HOA proration + transfer fee
- −$680
- Estimated net proceeds
- $224,725
Example B — Texas, $475,000 sale
- Sale price
- $475,000
- Mortgage payoff (incl. payoff interest)
- −$210,400
- Commission (5.5% total)
- −$26,125
- Transfer tax (TX, $0 state)
- $0
- Title + settlement fees (TX customary)
- −$1,890
- Property tax proration (seller owes)
- −$2,140
- Estimated net proceeds
- $234,445
Same headline price, ~$10,000 difference in net proceeds — driven almost entirely by transfer tax. State-aware calculation matters.
Why most spreadsheets miss
Generic net sheet spreadsheets fail in three predictable ways: transfer-tax rates that haven't been updated since the template was downloaded, proration formulas that don't adjust when the close date moves, and no clear handling of post-settlement commission structures.
The DashLoops NETSheet handles the parts that move: ZIP-based state and local transfer tax, property tax and HOA prorations calculated from the actual close date, and modeled separately so concessions don't hide the marginal impact of an offer.
What the tool does
- Auto-fills transfer tax from ZIP — every state, every county that adds a layer.
- Property tax and HOA prorations calculated from the close date — recalculates if the close moves.
- Models commission and concessions as separate line items, so the seller can see scenarios side-by-side.
- Runs in a phone browser at the kitchen table. No app, no install, no signup wall.
Frequently asked
What's a seller's net sheet?
A seller's net sheet is an estimated breakdown of what a home seller will walk away with after closing. It starts from the sale price and subtracts every cost the seller owes — mortgage payoff, commission, title fees, transfer taxes, prorations, concessions — to arrive at estimated net proceeds.
How do I calculate seller net proceeds?
Take the sale price (or offer price), then subtract: existing mortgage payoff, listing and buyer-side commission, transfer taxes (state and local), title insurance and settlement fees, property tax and HOA prorations, and any negotiated concessions or repair credits. The remaining figure is estimated net proceeds. A state-aware calculator handles the transfer-tax math automatically — that's the line item most likely to be wrong in a manual spreadsheet.
When should a listing agent present a net sheet?
Most experienced listing agents present one at the first listing appointment — immediately after the pricing conversation — so the seller sees the math behind the asking price. The second presentation is at offer-stage, where the actual offer terms (price, concessions, closing date) replace the estimates. Many agents now run it live on a phone when an offer comes in so the seller can compare offers side-by-side in real time.
How accurate is a seller's net sheet?
It's an estimate, not a guarantee. The line items most likely to vary between the net sheet and the final closing disclosure are concessions, repair credits, and prorations (which shift if the close date slips). State-aware tools handle the harder math (transfer tax, property tax proration) accurately. The remaining variance is in negotiated terms that change between contract and close.
What's the difference between a net sheet and a closing disclosure?
A net sheet is an estimate prepared by the listing agent before or during the transaction. A closing disclosure is a regulated, lender-prepared document delivered to all parties 3 business days before close, showing actual settled figures. The closing disclosure is binding; the net sheet is for planning.
Does a net sheet include the buyer's costs?
No — a seller's net sheet focuses on the seller's side of the ledger. Buyer-side closing costs (loan origination, appraisal, inspection, lender title insurance, prepaid escrows) vary widely by lender and loan type and aren't on the seller's calculation. The exception: any seller concessions to the buyer (e.g., closing-cost credits) appear on the seller's net sheet as a reduction.
Do I need a tool, or can I use a spreadsheet?
A spreadsheet works if your transfer-tax math is correct and you remember to update it whenever a state changes its rate (Florida, Pennsylvania, and several others have moved recently). The risk is presenting a net number that's wrong — sellers remember, and so does the listing competition you lost to. A state-aware tool like the DashLoops NETSheet auto-fills the right rate by ZIP, calculates prorations from the actual close date, and produces a clean output an agent can hand to a client.
Run a NETSheet on your next listing
Punch in the sale price, mortgage payoff, ZIP, and close date. The tool fills the rest. Free, no signup, works on a phone.
Looking for the in-depth tool details? See the NETSheet feature page.