Recording a spec home sale from the closing statement in QuickBooks Online
Turn the seller side of the settlement statement into clean entries, line by line.
Short answer: Record a spec home sale at the gross sale price, not the wire you receive. Use the seller side of the settlement statement to post revenue, the construction loan payoff, commissions, closing costs and prorations, so the entry nets to the cash that hit the bank. Then move the house's accumulated cost from inventory to cost of sales.
Why the wire amount is the wrong number
When a spec home closes, the title or escrow company pays off your construction loan, pays the agents, collects its own fees and wires you what is left. If you book that wire as income, three things go wrong at once. Revenue is understated by the loan payoff and every cost taken out at the table. The construction loan stays on the balance sheet even though the bank has been paid. And the house's cost sits in inventory forever, so the margin on the house is never visible. The fix is to record the whole settlement statement, not just the deposit.
This guide builds on our spec home accounting overview, which covers how cost builds up in inventory during construction. Here we focus on the day the house sells.
Get the right document
Ask the settlement agent for the final seller statement, not an estimate. Two forms are common. The CFPB Closing Disclosure has a Seller's Transaction section that lists what is due to the seller (sale price and reimbursements for items you prepaid) and what is due from the seller (closing costs, loan payoffs, credits and amounts you still owe). Many title companies also issue an ALTA Settlement Statement. ALTA publishes a seller version that itemizes the sale price, prorations, title and settlement charges, commissions, recording and transfer charges and payoffs, and ALTA notes it is used alongside the Closing Disclosure rather than replacing it. Use whichever is final and keep a copy attached to the entry.
Selling a spec house soon? We handle the closing entries. Request a Relationship Assessment.
Map each line on the statement
Work down the seller column. Every line lands in one of a few places:
- Sale price. Credit your home sales income account for the full contract price, tagged to the house.
- Construction loan payoff (principal). Debit the construction loan liability for that house. After closing, that loan account should read zero. If it does not, compare the payoff letter to your loan balance; a missing draw or an unrecorded interest charge is the usual cause.
- Payoff interest and lender fees. The payoff usually includes interest to the payoff date and fees such as a reconveyance or wire fee. Post interest where your policy puts loan interest. Whether interest on a spec home is capitalized into the house or expensed is a tax and accounting policy question for your CPA. See construction loan interest reserves for how the monthly interest entries work.
- Real estate commissions. Debit a selling expense account, such as commissions on home sales, tagged to the house.
- Seller-paid closing costs. Title insurance, settlement fees, recording and transfer charges. Many builders group these as cost of selling the house. Keep them separate from construction cost so the build margin stays clean.
- Seller credits and concessions. Closing cost help you gave the buyer. Some builders treat these as a reduction of the sale price, others as a selling expense. Pick one with your CPA and use it every time so house margins compare.
- Prorations. Property taxes and HOA dues split to the closing date. A credit to you reimburses something you prepaid; a charge to you covers time you owned the house but had not paid yet. Post them against the property tax or HOA accounts you used while carrying the house. See spec home carrying costs.
- Earnest money. If escrow held the buyer's deposit, it only changes what the buyer brings; it does not change your entry. If you held the deposit yourself and booked it as a customer deposit liability, clear that liability as part of the sale.
- Net proceeds. Debit the bank account for the amount actually wired. This is the line that has to match your bank feed to the penny.
Entering it in QuickBooks Online
The cleanest way to post a settlement statement is one journal entry dated the closing or disbursement date. In QuickBooks Online, go to + Create, then Journal entry, add one line per settlement item and confirm total debits equal total credits before you save. Put the property address and the settlement file number in the memo. Tag the income and expense lines to the house's project or customer so they show on that house's reports.
Then match the bank feed deposit to the journal entry instead of adding it again. If the deposit is categorized as income from the feed, you will count the sale twice.
Move the house cost to cost of sales
The second entry is the one most often missed. During construction, land, hard costs and any capitalized carrying costs built up in a spec inventory or construction in progress asset for this house. On the sale date, credit that asset for the house's full balance and debit cost of homes sold. Run a balance sheet by house, or the inventory account detail filtered to the house, first. The house's balance in that asset should be zero after this entry.
If late bills are still coming in, accrue the known amounts to the house before you move the cost, or you will have a small cost of sales entry trickling in for weeks. Our closeout guide covers chasing those last bills.
A SAMPLE entry (made-up numbers)
SAMPLE only. A spec home sells for $650,000. The seller statement shows a construction loan payoff of $470,000 principal plus $2,400 interest, commissions of $26,000, title and settlement charges of $3,100, a transfer tax of $1,950, a seller credit of $5,000 and a property tax proration charge of $1,600. Net proceeds wired: $139,950.
- Debit bank $139,950
- Debit construction loan, 14 Oak Lane, $470,000
- Debit interest (per your policy) $2,400
- Debit commissions on home sales $26,000
- Debit closing costs on home sales $5,050 (title, settlement and transfer tax)
- Debit seller concessions $5,000
- Debit property taxes $1,600
- Credit home sales $650,000
Debits and credits each total $650,000. A second entry moves the house's inventory balance, say $548,000, to cost of homes sold. The house now shows its real margin before and after selling costs.
Checks before you call it done
- The bank deposit matches net proceeds exactly.
- The construction loan for this house reads zero, and the lender's payoff letter agrees.
- The house's inventory balance reads zero.
- Commissions and closing costs sit in selling accounts, not in construction cost codes.
- The final settlement statement is attached to the journal entry.
- Final margin is compared to the original pro forma, both before and after selling costs.
How we help
Our team records each spec closing from the final settlement statement, ties out the loan payoff and inventory, and reports margin by house in the monthly close. Our founder reviews every close. We quote a flat monthly price for each builder, starting at $1,500 a month, with typical engagements between $2,500 and $8,500 a month. Start with a $1,500 Margin Review for written findings. See construction bookkeeping, job costing, pricing or request a Relationship Assessment.
Sources
- CFPB, Closing Disclosure explainer
- CFPB, Sample Closing Disclosure, separate seller version (PDF)
- ALTA, ALTA Settlement Statements
- Intuit, Create journal entries in QuickBooks Online
- Intuit, Set up a loan in QuickBooks Online
Common questions
Should I record a spec home sale at the sale price or the net proceeds?
At the gross sale price. Record the loan payoff, commissions, closing costs and prorations as their own lines so the entry nets to the cash you received.
Which closing document should I use?
The final seller statement from the settlement agent, either the seller side of the Closing Disclosure or the ALTA seller settlement statement. Do not use an estimate.
Where do commissions and closing costs go?
Into selling expense accounts tagged to the house, kept separate from construction cost codes so the build margin stays clean.
Why does my construction loan still show a balance after closing?
Usually because the payoff was never recorded, or a draw or interest charge is missing. Compare the lender's payoff letter to your loan account.
What is the second entry after the sale?
Move the house's accumulated cost from spec inventory or construction in progress to cost of homes sold, so the inventory balance for that house goes to zero.
Can you record our spec closings?
Yes. Our team records each closing from the settlement statement as part of the monthly close, and our founder reviews it.
Related
- Spec home accounting
- Spec home carrying costs
- Construction loan interest reserves
- Closing out a custom home
- Construction bookkeeping
- Glossary: Spec home
- Glossary: Take-out loan
- Glossary: Construction in progress
- Request a Relationship Assessment
- Spec home inventory and capitalized costs
- Spec home pro forma calculator (free)
By John Mos, Founder. Updated . We do not give tax or legal advice. Please ask your CPA or attorney.
See where your margin goes, house by house.
Tell us about your homes and your books. If we are a fit, we start with a $1,500 Margin Review: written findings and a fixed quote in 10 business days, credited to your onboarding fee if you sign up.