FlipDraw Tracker — House Flip Rehab Draw Schedule & Lien Waiver Tracker — product cover

Category: Spreadsheets · Tracking Dashboards

About this product

Name: FlipDraw Tracker — House Flip Rehab Draw Schedule & Lien Waiver Tracker Price: $29 (v1 had no lien-waiver log, charts or cash-needed view — consider $39 once you have a few reviews) Summary (under the title): Schedule every lender draw against your rehab budget. Guards flag category overdraws and loan overruns before the money goes out, and a lien-waiver log shows which funded draws are still missing paperwork. Excel + Google Sheets, no macros.

Cover: cover-1280x720.png Thumbnail: thumbnail-600x600.png

---

## Description

House flips go wrong in the draws. FlipDraw Tracker is a no-macro Excel / Google Sheets workbook for flippers using hard-money or construction loans. It tracks the rehab budget by line item, schedules each draw against lender inspections, and warns you when a draw would overspend a category or push you past your loan — before the request goes in.

HOW THE GUARDS WORK

  • Category Guard: adds every draw in a category, top to bottom, and compares the running total with that category's budget.
  • Loan Guard: adds the amount funded at closing plus all draws logged and compares it with your loan commitment (requested draws count, so you see it before funding).

DISCLOSURES (please read)

  • ARV, budgets and profits are arithmetic on YOUR inputs — not appraisals, and not lending, tax or legal advice. Verify every number with your lender, contractor and CPA.
  • Interest is approximate; your lender may accrue differently. Pick the interest basis that matches your loan.
  • Lien-waiver tracking is an organizer, not legal protection. Confirm requirements with counsel.
  • Guards only check what you log. This tracker organizes your numbers; it never predicts or guarantees profit.
  • Different from our Landlord Finance OS (buy-and-hold rentals) and BRRRR Deal Analyzer — FlipDraw is about CONSTRUCTION DRAWS on a flip.

FORMAT: XLSX + PDF (workbook + 4-page guide + license) · INSTANT DOWNLOAD

--- ## Suggested tags house flipping, fix and flip, rehab budget, draw schedule, hard money, construction loan, lien waiver, real estate spreadsheet, excel template, google sheets

## Product-update message for v1 buyers FlipDraw Tracker v2.0 is ready: new Lien Waiver Log, redesigned dashboard with charts, corrected loan and category calculations, hold-period carrying costs and an interest-basis switch. Re-download from your library.

What's included

  • FlipDraw-Tracker.xlsx — 7 sheets, native formulas, zero macros:
  • START HERE — setup walkthrough, color key, clear-sample-data steps, disclosures
  • FLIP DASHBOARD — projected profit at YOUR ARV, total invested, break-even sale price, estimated cash you bring, loan position, six "attention items" that turn red, and two charts
  • PROJECT SETUP — property, purchase, loan terms (rate, points, fees, term), interest basis (drawn balance or full loan), hold period, monthly costs, contingency % and selling-cost %
  • REHAB BUDGET — 45 starter line items in 12 categories plus 5 spare rows; budget vs actual vs remaining, % complete, status (Not started / In progress / Complete / OVER), category roll-up, forecast at completion
  • DRAW SCHEDULE — 12 draw rows with Category Guard, Loan Guard, inspection status, lien-waiver roll-up, lender fees, cumulative funded and a draws-by-category table
  • LIEN WAIVERS — 20-row log by payee and draw: waiver type, requested / received dates, and a red WAIVER MISSING flag once a draw is funded
  • HOLDING COSTS — 12-month interest, taxes, insurance, utilities and other, limited to your planned hold period
  • Quick-Start-Guide.pdf — 4 pages: 5-minute setup, a worked guard example, reading the dashboard, clearing the sample data, a weekly routine
  • README-license.txt — single-buyer license
  • COMPATIBILITY: Built with standard formulas (no macros, add-ins or XLOOKUP). Verified in LibreOffice; designed for Microsoft Excel and Google Sheets.
  • SAMPLE DATA: The workbook opens with a fictional sample property (an amber SAMPLE banner shows on every sheet) including a planted overdraw so you can watch the Category Guard fire. Replace the sample address and the banner disappears.

Key features

  • 45 line items, 12 categories → budget vs actual vs remaining per line, % complete, status flags and a forecast at completion, with contingency % as your own input
  • Category Guard → compares each category's running draw total against its budget and flags overdraws before the money goes out, showing the dollars left
  • Loan Guard → counts the amount funded at closing plus all draws logged, and flags you before the total passes your loan commitment
  • Real lien-waiver log → 20 rows by payee and draw, with a red WAIVER MISSING flag once a draw is funded
  • Holding costs that respect your timeline → interest, taxes, insurance and utilities counted only for your planned hold period, with an interest-basis switch (drawn balance or full loan)
  • Flip dashboard → projected profit at YOUR ARV, total invested including lender draw fees, break-even sale price, estimated cash you bring, loan position, attention items and two charts
  • Universal formulas only → no macros, no add-ins, no XLOOKUP; works in Microsoft Excel, Google Sheets, and LibreOffice

Frequently asked questions

Does the workbook work in Google Sheets and LibreOffice?

Yes — 100% native formulas, zero macros, no add-ins, and no XLOOKUP (universal formulas only), compatible with Microsoft Excel, Google Sheets, and LibreOffice.

How do the overdraw guards work?

The Category Guard adds every draw in a category, top to bottom, and compares the running total with that category's budget; the Loan Guard adds the amount funded at closing plus all draws logged and compares it with your loan commitment (requested draws count, so you see it before funding). Both are arithmetic checks on your inputs — they flag overdraws, they cannot block them, and they cannot see money you forgot to log, so reconcile actuals weekly.

Is the ARV an appraisal?

No — ARV, budgets, and profits shown are arithmetic on YOUR inputs, entered as your own estimate; they are not appraisals, and not lending, tax, or legal advice. Verify every number with your lender, contractor, and CPA.

How is interest calculated?

Interest uses an approximate drawn-balance method; your lender may accrue differently — adjust to your loan terms.

Is the sample data real?

No — the workbook ships with a fictional sample property (labeled SAMPLE) so you can see every formula working, including a planted overdraw that fires the Category Guard. Delete the yellow input values to start fresh.

Does the lien-waiver tracking protect me legally?

No — lien-waiver tracking is an organizer, not legal protection; confirm requirements with counsel.

FlipDraw Tracker — House Flip Rehab Draw Schedule & Lien Waiver Tracker — product image

FlipDraw Tracker — House Flip Rehab Draw Schedule & Lien Waiver Tracker

A no-macros Excel / Google Sheets system for flippers using hard-money or construction loans: a 45-line-item rehab budget in 12 categories, a 12-row draw schedule with category and loan guards that flag overdraws before the money goes out, a 20-row lien-waiver log, a holding-cost engine limited to your planned hold period, and a dashboard with projected profit, break-even price and attention flags.

$29

Buy Now on Gumroad

Related products

More Spreadsheets
Small Business KPI Dashboard — product image
Spreadsheets

Small Business KPI Dashboard

Know your numbers in 15 minutes a month. A formula-driven spreadsheet tracking the 9 KPIs that matter — revenue, margins, CAC, conversion, cash runway — with trend charts and a target scorecard. Sample data preloaded.