New Construction Buyer Tracker for Homebuyers | Selections, Allowances, Contract Payments or Draws & a Walkthrough Punch List (Excel, Google Sheets + Printables)
A buyer worksheet for a newly built home — selections against the allowances in your contract, a payments or draws page you fill from that contract, and a walkthrough punch list. You fill in figures from the documents you were given. The sheet adds what you type. It does not invent an allowance, it does not approve a draw, and it does not calculate a loan payment.
The spreadsheet (Excel and Google Sheets, no macros)
Start Here and Settings: your name, an as-of date, the property or lot, the builder, the contract date, and the estimated completion date you were told. There is no interest-rate field and no loan-payment field.
Selections: category, item, allowance, quoted or invoiced cost, and status. Overage is actual minus allowance, from the two numbers you typed.
Allowances: a category rollup of those rows.
Draws & Payments: type the dates and amounts from YOUR builder contract or from your lender’s draw list, if you have one. Still unpaid is scheduled minus paid. The sheet does not approve a draw, does not calculate construction-loan interest, and does not quote a rate.
Walkthrough: items from a pre-drywall, pre-close, or final walk. This is your punch list, not a code inspection and not an official report.
Dashboard: items installed vs. still open, allowance totals, amounts paid vs. still unpaid, and open walkthrough items.
Yellow cells are where you type. Formula cells are locked (no password).
Works in Excel 2016 or newer and Google Sheets (upload, then File > Save as Google Sheets). An example file with a made-up buyer (Maya Chen, Lot 14 at Willow Creek Estates, as of March 15, 2027) is included. The numbers in it are illustrations, not a quote, and not a recommended draw schedule.
The printable PDF (9 US Letter pages)
How to use the worksheet, a selections log, an allowance worksheet, a draws and payments page, pre-drywall and pre-close / final walk memory aids, a punch-list page, and a questions page.
Educational only. Not a loan offer, a pre-approval, a commitment to lend, or a rate quote. Not legal, tax, insurance, or construction advice, and not a property or code inspection. Only a loan officer working from your actual application can tell you what you may qualify for.
Aaron Clark NMLS #1770738 | Responsive Mortgage - A Division of PRMG NMLS #75243 | Equal Housing Opportunity
Instant digital download. Nothing ships.