Spreadsheets & Trackers

Closing-Cost Tracker (Google Sheets Template + CSV)

Your cash to close is more than just down payment — it includes lender fees, title/settlement charges, prepaids, and potential credits. This Google Sheets template helps you track Estimate vs Final costs by category, apply seller/lender credits, and monitor your true bottom line. Use the CSV below to import the template into Sheets or Excel.

What this tracker covers

  • Lender charges: Origination, points, credit report, rate-lock fees.
  • Appraisal & inspections: Appraisal, reinspects where applicable.
  • Title & settlement: Title insurance, closing/settlement or attorney fees, courier.
  • Government fees: Recording, transfer taxes (if applicable).
  • Prepaids & escrows: Property taxes, homeowners insurance, interest, HOA dues.
  • Credits & adjustments: Lender credits, seller credits, earnest money deposit (EMD) applied.
Pro Tip: Keep columns for Estimate (from your Loan Estimate) and Final (from your Closing Disclosure). The variance column will show where numbers moved — and where to ask questions.

How to use the template

  1. Import the CSV into Google Sheets (File → Import → Upload) or open in Excel.
  2. Enter estimate values using your most recent Loan Estimate (LE).
  3. Update final numbers when you receive the Closing Disclosure (CD).
  4. Apply credits (lender/seller) and EMD so your cash to close is accurate.
  5. Review variances and request explanations for large changes.

Understanding estimates vs finals

Some fees can change between the LE and CD (e.g., prepaid items or third-party services you choose). Others are subject to tolerance rules and should not increase beyond allowed limits. Seeing both numbers side-by-side protects your budget.

Common questions

Do seller credits reduce my down payment?

No. Credits typically offset allowable costs and prepaids; they don’t replace minimum down payment funds required by your loan program.

What if my “Final” total is higher than expected?

Check which category changed. Prepaids often shift due to closing date timing. For fees that shouldn’t exceed certain tolerances, ask your lender for a written explanation.

Where do I put my earnest money deposit (EMD)?

List EMD under Credits/Adjustments. It reduces cash due at closing once it’s deposited with escrow/attorney.

⚠️ Heads up: Large credits that exceed allowable costs may be partially unused. Confirm your maximum allowable credit with your lender before finalizing negotiations.

Disclaimer: This spreadsheet is for educational use only and does not constitute legal or financial advice. Always verify fees and cash-to-close with your lender, title/settlement company, and agent.