Guide

Recording a lot purchase in QuickBooks Online from the settlement statement

Turn the buyer side of the settlement statement into one clean entry, so the lot, the loan and the earnest money are all right on day one.

Short answer: Record a lot purchase with one journal entry dated the closing day, built from the final buyer settlement statement, not the wire. Debit land for the price plus the closing costs your CPA wants in the lot, debit loan costs separately, and credit the lot loan, the earnest money already paid, any seller tax credit and cash for the wire.

This is the buying side. For the day the finished house sells, see recording a spec home sale.

Buying lots for spec homes? Our team books the closing and ties it to the lender. Request a Relationship Assessment.

Why the wire is the wrong number

When you close on a lot, the money comes from three places: the earnest money you paid weeks ago, the lender's loan proceeds and the wire you send on closing day. If you only record the wire, the lot shows up at a fraction of its cost, the loan never appears on the balance sheet and the earnest money sits as an open deposit forever. Every number that depends on that house, from carrying costs to the margin at sale, starts out wrong.

The fix is to record the whole statement in one entry and then match the bank download to it.

Set up before closing day

  • A project or class for the house. One per lot, created before the first cost. See the new home start checklist.
  • A land account. For a spec builder the lot is inventory, not a fixed asset, because you are going to sell it with the house. Use a balance sheet account such as "Land, spec homes" next to your construction in progress account. See spec home inventory and capitalized costs.
  • A loan account for the lot or construction loan. Intuit's steps for a loan used to buy an asset start with a liability account, current or long term depending on when it is due, with no opening balance.
  • An earnest money account. When you paid the deposit, it should have gone to an asset such as "Earnest money deposits," not to an expense.
  • Pre-closing costs. Surveys, soil tests and feasibility work done before you own the lot. Under ASC 970-340-25-3, as quoted by EY, costs tied to a specific property are capitalized only if they would be capitalized after purchase and the purchase is probable. Otherwise they are expensed. Hold the qualifying ones in an asset for that lot until closing, and expense them if the deal dies.

Get the right document

Ask the title or escrow company for the final buyer statement, not the estimate. ALTA publishes a Borrower/Buyer version of its settlement statement for title and settlement companies to itemize every fee and charge. Its sections run from the sale price, deposits and loan amount through prorations, loan charges, title charges, recording and transfer charges, down to the amount due from the buyer. Work down the buyer column and attach the statement to the entry.

Map each line

Statement lineWhere it goesNote
Sales price of the lotDebit land, tagged to the houseThe starting cost of the house
Owner's title policy, settlement fee, recording and transfer chargesUsually debit landCosts to acquire the lot are generally added to its cost. Confirm with your CPA.
Deposit including earnest moneyCredit earnest money depositsClears the asset you set up when you paid it
Loan amountCredit the lot or construction loanShould match the lender's first statement
Loan charges: points, origination, appraisal, lender's title policyDebit a separate loan costs accountA cost of the money, not the land. Your CPA decides how it is presented and spread over the loan.
Seller credit for unpaid property taxesCredit property taxes payableYou will pay the full bill later. Taxes paid in arrears produce this credit.
Reimbursement to seller for taxes they prepaidDebit prepaid property taxesTaxes paid in advance produce this debit instead
Other seller creditsUsually reduce landAgree the treatment with your CPA
Due from buyerCredit checkingMust equal the wire to the penny

REA's write-up on settlement statement accounting describes the same pattern: acquisition costs added to the property, lender fees kept with the loan, a seller tax credit set up as a liability and one balanced entry. LegalClarity's guide to the ALTA form explains the debit and credit columns and why a proration credits one side and debits the other, depending on whether taxes were paid in advance or in arrears.

A worked example (made-up numbers)

A builder buys a lot for $120,000. It paid $5,000 earnest money last month. The lender funds $84,000. The statement shows $1,450 for the owner's title policy and settlement fee, $350 for recording and transfer, $1,300 for origination and appraisal, and a $620 seller credit for county taxes that have not been billed yet.

AccountDebitCredit
Land, spec homes (lot 7)$121,800
Loan costs, lot 7 loan$1,300
Earnest money deposits$5,000
Lot loan, lot 7$84,000
Property taxes payable$620
Checking (the wire)$33,480
Total$123,100$123,100

The math checks: land is $120,000 plus $1,450 plus $350, or $121,800. Total charges of $123,100 less the $5,000 deposit, the $84,000 loan and the $620 tax credit leave $33,480 due from the buyer, which is the wire.

Enter it in QuickBooks Online

  1. Select + Create, then Journal entry, and date it the closing date from the statement.
  2. Enter one line per row above and tag the land and loan cost lines to the house with your project or class.
  3. Attach the final statement and put the property address in the memo.
  4. When the wire downloads from the bank, match it to the journal entry instead of adding it again. Intuit's bank feed help notes that when a transaction already exists in QuickBooks you can match it, which avoids counting the money twice.
  5. Check the lot loan balance against the lender's first statement and the earnest money account for a zero balance on this lot.

Keep in mind that the project profitability report only shows income and costs. The lot sits on the balance sheet until the house sells, when its land and construction cost move to cost of sales together.

After closing

  • Property taxes and interest. ASC 970-340-25-8, as quoted by EY, capitalizes property taxes and insurance only while work to get the property ready is in progress, with the same meaning as for interest. A lot that sits idle before you break ground may not qualify. This is a policy call for your CPA. See spec home carrying costs.
  • Several lots on one statement. Split the price and shared costs across the lots before you post. See how land and common costs are allocated.
  • Draws. Construction loan draws add to the same loan account. See the construction loan draw process.

Mistakes we see

  • Coding the wire to a single expense or to land, with no loan and no earnest money.
  • Putting the lot in fixed assets and depreciating it.
  • Mixing lender fees into the land cost.
  • Dropping the seller tax credit, then expensing the full tax bill when it arrives.
  • Working from the estimated statement, which often changes before signing.

For the full flow of a spec house through the books, start with spec home accounting.

How we help

Our team books lot closings from the final statement, sets up the loan and land by house and ties both to the lender every month. 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 job costing, construction bookkeeping, pricing or request a Relationship Assessment.

Sources

Common questions

How do I record a land purchase in QuickBooks Online?

Use one journal entry dated the closing day from the final buyer settlement statement. Debit land for the price and acquisition costs, debit loan costs separately, and credit the loan, the earnest money, any seller tax credit and cash for the wire.

Is a spec lot a fixed asset?

No. A lot you plan to sell with a house is inventory. Keep it in a land account next to construction in progress, and do not depreciate it.

Do closing costs go into the cost of the lot?

Costs to acquire the lot, such as the owner's title policy, settlement and recording fees, are generally added to its cost. Lender fees are kept separately as loan costs. Confirm both with your CPA.

How do I handle the earnest money at closing?

Credit the earnest money deposits account for the amount shown on the statement. That clears the asset you set up when you paid the deposit.

What about the property tax proration?

If taxes are paid in arrears, the seller credits you and you record a tax liability. If the seller prepaid, you reimburse them and record a prepaid asset.

Can you book our lot closings?

Yes. We record each closing from the final statement and tie the land, loan and earnest money to the lender and the house.

Related

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.